1829780 - Ignore Blank Spaces option not working as expected in Spreadsheet component.

SAP Knowledge Base Article - Public

1829780 - Ignore Blank Spaces option not working as expected in Spreadsheet component.

Symptom

Ignore Blank spaces option should Ignore trailing spaces within Spreadsheet component.

Environment

  • Dashboard 4.0 Service Pack 04 (SP04)

Reproducing the Issue

  1. Created a dashboard with spreadsheet component and use the data below to bind to spreadsheet.
  2. Score
    1
    2
    3
    0
    0
    0
  3. Turn on Ignore Blank Spaces (Rows) by going to the properties of Spreadsheet component, under behavior tab.
  4. Blanks as well as zeros are suppressed/ignored.

Cause

The issue has been identified and logged under Problem Report ID ADAPT01678367.

Resolution

This issue has been resolved by Dashboard 4.0 Service Pack 05 Patch 4.

Keywords

KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0