1710501 - Spreadsheet component is not showing 0

For the same input value from combo box, spreadsheet table component shows 0.00% initially. When you change input then change it back to initial value again, spreadsheet component shows blank value.

Xcelsius 2008 SP4

1) Please find the database entry in excel (Test_DB.xlsx)
2) Create a universe and qaaws in top for it.
3) Make CITY_ID as a prompt in qaaws.
4) Get the data in (Sheet1!$B$4:$G$14) from qaaws
5) Before attaching this data to spreadsheet use below functions

=OFFSET(A3,MATCH($J$4,$B$4:$B$14,0),0)
=IF(ISNUMBER($M$4),ROUND(INDEX(B$4:B$14,$M$4),4),"")

6) preview the model and observe the behavior.

 Same as attached (Test.xlf)

1) Preview the data, and check for column four, first time 0.00% percent shown for 10 selected in combo box
2) Change the column data from 10 to 11 some value appears in fourth column.
3) Go back to 10 with combo box and fourth column is blank now.

Go to menu File->Document Properties. On the dialog, uncheck option "Treat Zero as Blank Cell"

ADAPT01632222

0.00%, Blank Value , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem