To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115440 Issue #|115440 Summary|Matrix formula update fails Component|Spreadsheet Version|OOo 3.2.1 Platform|Unknown URL| OS/Version|Windows 7 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|thinkfree
------- Additional comments from [email protected] Sat Nov 6 13:40:22 +0000 2010 ------- The spreadsheet contains a cell which was not entered as a matrix formula (one pressed only Return instead of Shift+Crtl+Return) and the cell displays correctly "#VALUE!" So the user tries to fix his mistake: 1) F2 and return in the cell => still error (which is ok, one forgot again the Shift+Crtl+Return) 2) F2 and Crtl+Shift+Return in Cell A2 => now the matrix formula was correctly entered, but the error ("#VALUE!") did not disappear! 3) WORKARROUND: F2 and cursor left and Crtl+Shift+Return in the cell => Now "#VALUE!" disappears, an the calculation is correct. Conclusion: That one needs "cursor left" in step 3 makes no sence and is a reproducable bug. --------------------------------------------------------------------- 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]
