SAP Knowledge Base Article - Public

1391415 - Format inconsistent during List View column sort

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
  1. Open Xcelsius 2008 SP1 FP3
  2. 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%
  3. Insert a list view component and link display data to A1:A5
  4. Preview
  5. Click the column header to sort
  6. 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