swf file data displaying differently than xlf and excel file

[Former Member]

Hi.....I'm using a grid component to display data. Not all the cells in the excel file have data. In this case, I want to display TBD for "to be determined". I set up a formula in excel, and the blank cells in excel and the xlf file grid component show correctly as TBD. However, when I do a preview and create the swf file the blank cells display as 0. Any ideas on what's causing this? Thanks

[Former Member · Accepted solution]

Hi Jim,

Itu2019s a known bug with <> operator; it is fixed in the release candidate version for the next fix pack. As a workaround, you can use = instead of <>. I sent you the modified file. I am sorry about the bug.

Best regards,

Margaret

[Former Member]

Hi Jim,

what formula are you using? Please e-mail your xlf file to me if you can.

Margaret