On mer, 2009-01-07 at 14:33 +0800, Zhu Lihua wrote: > Hi Ambrogio, > > I guess you input number first, and then set it to boolean, because if you > set format to boolean first and then input a number, the format of the cell > will change to numeric automatically. ;-) > > For the first one, IMHO, False is Zero, and you ordered don't display zero, > so false will not show. I think this is OK. If you want it shows up, you can > check the "Display zero" in the options settings. I'm a bit confused. I think that as cells can be empty, or with zero, or with a formula which value is zero, one can chose to not show zero values. But boolean can be FALSE or TRUE, and in the case above, FALSE will never be displayed, we have to treat BOOLEAN format different from numeric format, and in this case we will display the FALSE value. I searched on issue and I think to open one, as enhancement, to discuss in the QA and with developers this behavior.
> For the 2nd one, I tested in OOo300m9 and DEV300m37, the number can be > restored after I set the cell back to numeric format. I will check on DEV300m37 too Many tnx Ambrogio --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
