format cell value for display

Sep 29, 2011 at 7:09 PM


I need to have the cell value somthing like 134.556377. This value must be edited with all decimal digits. The value must be maintaind with all decimal digits.

But when the cell is not in edit mode I need to display the value rounded to integer in this case 135

Is that possible, and if so how




Sep 30, 2011 at 11:35 AM

Yes, that should be possible. The view on the cell can use one format, and the editor for the cell can use different one. See examples how to set up different editors

Oct 2, 2011 at 12:00 AM

thank darius,

What example shows this? I couldn't find one.

A short three line example will be enough if you could kindly provide one...