To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69067 Issue #|69067 Summary|'Number as Text' with apostrophe does not work when si |ngle quotes replacement option is turned on Component|Spreadsheet Version|OOo 2.0.3 Platform|All URL| OS/Version|Windows XP Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|jeongkyu
------- Additional comments from [EMAIL PROTECTED] Tue Aug 29 08:17:20 -0700 2006 ------- OO.o 2.0 help says "Enter the number as text. The easiest way is to enter the number starting with an apostrophe (for example, '0987). The apostrophe will not appear in the cell, and the number will be formatted as text. Because it is in text format, however, you cannot calculate with this number." in 'Entering a Number with Leading Zeros' section. Unfortunately, this method does not work when single quotes replacement option is turned on in AutoCorrect. The option can not be simply turned off because it is nceessary for writing text document ( The option is shared for all components of OO.o - see Issue 27269 ). I believe that the possible solution is to execute 'number as text' logic before applying AutoCorrect for single quote replacement. How to reproduce, 1. Open Calc. 2. Select Tools > AutoCorrect > Custom Quotes. 3. Make sure that Single Quote Replace option is checked. 4. Click OK to closee the dialog. 5. Select a cell and input '0123. 6. Confirm that the cell shows '0123. 7. Select Tools > AutoCorrect > Custom Quotes. 8. Turn off Single Quote Replace option. 9. Click OK to closee the dialog. 10. Select a cell and input '0123. 11. Confirm that the cell shows 0123. --------------------------------------------------------------------- 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]
