Symptom
While having different formats under one column in the List View component, the values sort properly when clicking on the header. However, the cell formatting remains fixed in each row and does not move with the metric value, therefore mixing up the format of each value once sorted.
Reproducing the Issue
Environment
- Xcelsius 2008 Service Pack 1, Fixpack 2 (also applies to fixpack 3 and Service Pack 2)
- Microsoft Office 2007
- Windows XP Professional
- Open Xcelsius 2008 SP1 FP3
- In Excel, enter the following information into column A1:A5 with the same Excel format:
Actual Value
$100.00
9.00%
$500.00
3.75% - Insert a list view component and link display data to A1:A5
- Preview
- Click the column header to sort
- Notice the format is fixed to that row, but is the incorrect format for some of the metric values
Cause
The issue has been identified and logged under Problem Report ID ADAPT01226724
Resolution
This is resolved in Service Pack 2, Fixpack 1 (SP 2.1)
See Also
ADAPT01226724
Keywords
list view; sorting; format; Xcelsius , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Bug Filed
Product
SAP BusinessObjects Xcelsius Enterprise 2008