To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107805 Issue #|107805 Summary|Strange influence of a single quote symbol on a numeri |c cell content Component|Spreadsheet Version|OOo 3.1.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|qqew
------- Additional comments from [email protected] Mon Dec 21 09:12:31 +0000 2009 ------- There are three ways to see a subject: 1. Once typed symbol "'" and any number behind it into some clear cell, it mystically disappears after it entered. But in input line it stays visible. Steps to reproduce: 1) type "'123" (without double quotes) and hit enter 2) visually compare content of entered cell in an input line and in a cell itself. 2. When you try to change format of a cell containing number with leading "'" to text, this symbol disappears from input line too. And visually such a converted cell looks absolutely normal. But if only you change format of a cell back to 'number' or 'date' the symbol "'" returns in a mysterious way. Steps to reproduce: 1) type "'123" (without double quotes) and hit enter 2) visually compare content of entered cell in an input line and in a cell itself. 3) convert format of that cell to text 4) visually compare content of entered cell in an input line and in a cell itself. 5) convert format of that cell back to number (or date) 6) visually compare content of entered cell in an input line and in a cell itself. 3. If it typed two "'" symbols one by one and some number after, first of them disappears forever from everywhere. And then cell becomes normal. Steps to reproduce: 1) double press "'" key with some number after and hit enter 2) see what in fact appears on the screen In addition, this symbol cannot be found by Find & Replace tool when it 'semi- visible'. All these presentations i checked out in OOo Calc v2.4.1 - all of them are the same. /Sorry for my bad English/ --------------------------------------------------------------------- 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]
