SAP Knowledge Base Article - Public

1236917 - Formatting is not updated in Xcelsius dashboard after changes made to source XLS document in Live Office

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:

  1. 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

  2. In the Excel XLS, format the numeric column as Format Cell/Number

  3. In the Format Cells/Number tab tick the box Use 1000 Separator (,) , Negative Numbers -1,234.10 Red

  4. Preview the Xcelsius model, the numeric column shows negative values in Red

  5. 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

Enhancement Request ADAPT01085854 has been created

Keywords

Xcelsius 4.5Xcelsius 2008Xcelsius 5Dynamic formattingExcelQAWWS , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.5