Hi Zhu Lihua,
because of the complexity of number recognition I would like to turn
your attention to the corresponding specification
http://specs.openoffice.org/calc/ease-of-use/enhance_number_recognition.sxw
Especially the table in chapter 6.3 will give more light on this area.
Best regards,
Oliver
zhulihua wrote:
Hi, all,
Usually, we set a format to a cell, then type in datas, the data will be
converted to the format we set.
For example, we format a cell to Currency, then input a number into this cell,
the number will be converted to Currency format.
But if we set Date format to a cell, then type in a number, the cell format
will be converted to number automatically, I think this maybe a feature,
because it almost imposible for us to type a number to input a date, if we
input a number, we will.
And there is another case, if we set Logical value to a cell, the type in a
number, the cell format will convert to number too, if we want it to be a
logical value, we must set Logical value to this cell again. Does this work as
designed?
Thank you!
Best regards,
Zhu Lihua
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
