To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=23348
------- Additional comments from [email protected] Fri Aug 20 16:53:19 +0000 2010 ------- Though it makes sense for the strong typing point of view, it is confusing for the user. I have a recurring case where I insert a line into a spreadsheet and a cell which I use as number becomes text. Then, if I type a number there, and then find out it's not a number, I'll change its format. But then the number is rendered useless by the apostrophe. Plus: since the apostrophe isn't shown, I won't tell what's wrong until I click on the cell. Even more: searching apostrophes doesn't work as an end user expects (one should know about the '.*' and '&' thing, and this is another issue). That is, a regular user would get lost (as I got). Pls see my last attachment. Cell B2 is number and cell B1 is text. If you insert a line over line 2, cell B2 will become text. It's reasonable, since Calc has to copy format from either the upper or the lower line, but the user doesn't have a clue yet. So, when the user tries to use cell B2 as a number, the battle begins. If the user inserts multiple lines, it gets worse - which is my case. So, IMHO, Calc should either accept a number in a number-formatted cell as a number or tell the user it'll do otherwise and offer an easy way out. In the current way, it only makes sense to geeks :) . Pls help normal users. Best regards --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
