Symptom
- Create an Xcelsius dashboard based on an Excel spreadsheet from QAWWS - the initial format applied in the XLS file is retained in the SWF. It is not updated.
- Format is not updated dynamically - when updating a Live Office report & change cell colours, want the updated format to be reflected in Xcelsius at run time.
Reproducing the Issue
Environment:
- Xcelsius 4.5, 5, 2008
- Live Office
Workflow to Reproduce:
Create an Xcelsius dashboard based on an Excel spreadsheet from QAWWS with a table containing at least one numeric column and a Web Service Connector
In the Excel XLS, format the numeric column as Format Cell/Number
In the Format Cells/Number tab tick the box Use 1000 Separator (,) , Negative Numbers -1,234.10 Red
Preview the Xcelsius model, the numeric column shows negative values in Red
If the negative values change to positive in the second preview of the Xcelsius dashboard the values returned are correct but the format is incorrect - it is shown still in Red. The format fro the XLS file is not dynamically updated to the Xcelsius dashboard.
Cause
There is no functionality to provide dynamic cell formatting in Xcelsius
Resolution
Keywords
Xcelsius 4.5Xcelsius 2008Xcelsius 5Dynamic formattingExcelQAWWS , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem