1467212 - Results are inconsistent between Preview mode and Canvas mode when blank cell is included in the formula in Xcelsius 2008 SP1

Results are inconsistent between Preview mode and Canvas mode when blank cell is included in the formula

• Xcelsius 2008 SP1

0. Create a Xcelsius file using the following values in spreadsheet.
   A1=””
   B1=A1<>""
   C1=A1<>0
0. Insert a Spreadsheet Table component to Canvas area, and select a range for Display Data using the following range.
   Sheet1!$A$1:$C$1
   You can observe that cell B1 and C1 display “false” in Canvas mode.
0. Click Preview.
   You can observe that cell B1 and C1 display “true” in Preview mode.

Note: The issue only occurs when the value of cell in formula is blank.

The issue doesn’t occur in Xcelsius 2008 SP2, however there is no ADAPT number to address the issue.

Update Xcelsius 2008 version to SP2.

incorrect, different, discrepant, null , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem