Hi, Oliver, Thank you for the answer. It helpful.
Best regards, Zhu Lihua 发件人： Oliver Craemer - Sun Germany - Hamburg 发送时间： 2008-02-15 16:06:56 收件人： [email protected] 抄送： 主题： Re: [qa-dev] A question about Calc, does it work as designed? 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]
