To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=58734 Issue #:|58734 Summary:|Inconsistent treatment of +, -, /, and * following a |number in a cell Component:|Spreadsheet Version:|OOo 2.0 Platform:|All URL:| OS/Version:|All Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|formatting Assigned to:|spreadsheet Reported by:|atdsm
------- Additional comments from [EMAIL PROTECTED] Thu Dec 1 06:45:38 -0800 2005 ------- OOo Calc has an inconsistent treatment of signs following a number entered into a cell in Calc. In Calc, enter the following four lines into four seperate cells: 65+ 65- 65* 65/ The results are: 65 (treated as number) -65 (treated as number) 65* (treated as text) 65/ (treated as text) 65- is a shortcut for entering -65, which makes sense. However, 65+ is treated as a number, but should be text to be consistent with the behavior of 65* and 65/. Entering 65+ can't be a "shortcut" for entering +65, because just entering 65 itself would do that. Instead, 65+ should be treated as text. (This is expecially true because often a plus sign following a number is used as a heading to indicate values in the range over a certain number - such as ages 1-17,18-25,26-65,65+. It is much less common to intend to enter a + sign after a number and expect it to turn into the number 65.) This issue was inspired by issue 56568, which delt with both CSV imports and formatting. --------------------------------------------------------------------- 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]