To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84973 Issue #|84973 Summary|formulas not calculated in cells when changing format |from "Text" to "Standard" Component|Spreadsheet Version|680m241 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|viewing Assigned to|spreadsheet Reported by|gibi
------- Additional comments from [EMAIL PROTECTED] Fri Jan 4 00:30:29 +0000 2008 ------- Steps to get it: 1) create a new spreadsheet 2) fill A1 with whatever you want (example: abcdef) 3) Let's format a Cell (A2 in my example) in "Text" 4) in this cell, type: =A1 (in the cell or even in the formula bar) -> OOo displays "=A1" in the cell and in the formula bar -> It's correct because my text can begin with an equal sign. 5) change the format of the cell A2: Format -> Cells -> Tab: "Number", Category: select All, Format: Standard 6) You can recalculate, save, close and reopen, double-clic to edit the formula and type enter at the end of it, it will never displays anything else than "=A2" You can get it with any formula (I've choosen an obvious one) Same result with: - 2.2.1 Linux Intel 32 - 2.3.1 Linux Intel 32 - m241 Windows98SE I've made the same test with MSO2000 on Windows98SE (thanks to vmware) Excel displays abcdef (i.e. evaluate the formula) when double-clicking on the cell A2 at step 6 without closing the file. --------------------------------------------------------------------- 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]