Symptom
In Xcelsius the "Ignore blank cells" option does not hide blank cells at the end of a range, and the alternating row colors for rows without data are also not hidden.
Environment
Xcelsius 2008
Service Pack 3, Fix Pack 3.1
Reproducing the Issue
1. Insert a Scorecard/List box component in the XLF
2. Map it to a range in Excel spreadsheet that include a blank row at the end
3. Go to the ‘Behaviour’ tab of the Scorecard properties and select the option ‘Ignore blank cells – In Rows’
Note: The blanks at the end of range are still displayed in the scorecard.
Cause
The issue has been identified and logged under Problem Report ID ADAPT01429150.
Resolution
This issue is resolved in Service Pack 4 for Xcelsius 2008.
Keywords
ADAPT01429150
, KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem
SAP Knowledge Base Article - Public