How can i hide a value of a numeric cell?

[rosegede]

I create a big table including numeric cells with the UIR-Library. Some cells should have a BLANK " " instead of ZERO "0". The table should be able to sort and scroll.
I try to solve the problem in changing the format to "String", but the sort procedure give a different result for a string than for a numeric!

[RobertoBozzolo]

You could try to write the text in this cell with the same color as the background: this will "hide" the value of the cell. This could be a problem while sorting 'cause the attributes may not be moved together with the cell values (I don't know if this happens but can be tested easily). In case, you will have to adjust the individual cell attributes after sorting the table.

In order to skip the "hided" cells while editing the table (if necessary) you must set those cells as Indicator, so that the cursor doesn't remains on them.

[rosegede]

Thank you Roberto,
I test your idea and the attributes moved together while sorting!
A additional problem is while the user is checking a cell or a column cause in visibility of the hidden value.

The cells are set as Indicator. It is not necessary to edit the values.

Georg