Symptom
- Unable to add/modify any formatting in the embedded Excel sheet in Xcelsius
Environment
- Microsoft Office 2003 / 2007
- Xcelsius 2008
Reproducing the Issue
- Launch Xcelsius
- Open a dashboard
- Make some layout, formatting changes in the embedded excel file (ex: Highlight a cell)
- Save the Excel file
- Save the dashboard
- 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:
- Open the Excel file
- File > Save As > Excel Workbook
- The file will be saved as .xlsx
- Launch Xcelsius
- 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 , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem