To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107144 Issue #|107144 Summary|Undo/Redo might fail for formulas. Component|Spreadsheet Version|OOo 3.1.1 Platform|Unknown URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|gsommer
------- Additional comments from gsom...@openoffice.org Mon Nov 23 15:44:47 +0000 2009 ------- When using the Undo/Redo functions, formulas might fail if they're created using the SUM icon. Steps: 1: Start a new spreadsheet in Calc. 2: Put this data in: A1: 1 A2: 2 A3: 3 * Click on B1. * Click on SUM icon. (A blue border will appear on A1) * Drag the blue bar to mark A1 to A3. * Press Enter (B1 now contains the result 6) * Click Undo. (B1 is now empty) * Click Redo. (B1 now contains the text "=SUM(A1:A3)") Expected result: Then clicking Redo, B1 should display the result "6", and not display the formula as text. Workaround: 1: Go to B1. 2: Remove the = 3: Add the = again 4: Press enter Now Calc again knows it's a formula, and correctly displays the result. Notice: This bug ONLY occurs of you're using the SUM icon as described in the steps above. Writing the formula by hand does NOT tricker this bug. Tested on OOo 3.1.0 and 3.1.1. Tested on the Linux platform only. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
