To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99239 Issue #|99239 Summary|Spreadsheet with BASIC macros only recalculates when o |pened Component|Spreadsheet Version|OOo 3.0.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|timpratt32
------- Additional comments from timprat...@openoffice.org Sun Feb 15 12:51:01 +0000 2009 ------- Calc does not recalculate the spreadsheet completely unless it is closed and opened. F9 and Ctrl-Shift-F9 do not update the spreadsheet completely. I have to close and open the spreadsheet for it to recalculate correctly. I will attach the spreadsheet later since there appears to be no option to add it at this stage. I know it is not very elegant, but it reproduces the problem. Note that there are two bits of BASIC code. Here are the steps to reproduce the issue: 1. Open 'Julia - Small Version.ods'. The spreadsheet will recalculate correctly and draw the fractal. 2. Select cells C6 to AG36 and set the background color to black in order to clear the fractal. 3. Try to recalculate using F9 or Ctrl-Shift-F9. The fractal is not redrawn. Changing a cell in the spreadsheet also does not cause the fractal to re-draw. 4. Save, close and open the spreadsheet. It is then recalculated correctly and the fractal redrawn. Thanks for your support - OOo 3 is looking good and working well! --------------------------------------------------------------------- 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