Symptom
Results are inconsistent between Preview mode and Canvas mode when blank cell is included in the formula
Environment
- Xcelsius 2008 SP1
Reproducing the Issue
- Create a Xcelsius file using the following values in spreadsheet.
A1=””
B1=A1<>""
C1=A1<>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. - 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.
Cause
The issue doesn’t occur in Xcelsius 2008 SP2, however there is no ADAPT number to address the issue.
Resolution
Update Xcelsius 2008 version to SP2.
Keywords
incorrect, different, discrepant, null , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem
Product
SAP BusinessObjects Xcelsius Enterprise 2008