SAP Knowledge Base Article - Public

1654570 - "Ignore blank cells" option does not hide blank cells at the end of a range

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

Product

SAP BusinessObjects Dashboards all versions