SAP Knowledge Base Article - Public

1585448 - Formatting changes in the embedded Excel file are not retained within Xcelsius

Symptom

  • Unable to add/modify any formatting in the embedded Excel sheet in Xcelsius

Environment

  • Microsoft Office 2003 / 2007
  • Xcelsius 2008

Reproducing the Issue

  1. Launch Xcelsius
  2. Open a dashboard
  3. Make some layout, formatting changes in the embedded excel file (ex: Highlight a cell)
  4. Save the Excel file
  5. Save the dashboard
  6. re-open the dashboard

==> The modifications have not been maintained

Cause

Currently, Xcelsius uses Excel 2003 SDK to manipulate embedded Excel file. When embedding Excel 2007 file (.xlsx) into Xcelsius, Excel is downgraded to Excel 2003 and user may observe some problems (http://office.microsoft.com/en-us/help/worksheet-compatibility-issues-HA010172659.aspx ).  

Resolution

The fix will be expected to considered in BI 4.0 SP8 in ADAPT01696736 as below workaround is not working in BI 4.0 SP6

Workaround:

  1. Open the Excel file
  2. File > Save As > Excel Workbook
  3. The file will be saved as .xlsx
  4. Launch Xcelsius
  5. Import this file in Xcelsius

Keywords

format layout SDK 2003 2007 compatibility issue lost dissapear not available embed xlsx .xlsx maintain modification , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008