Apache OpenOffice (AOO) Bugzilla – Issue 99239
Spreadsheet with BASIC macros only fully recalculates when opened
Last modified: 2013-01-29 21:44:40 UTC
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!
Created attachment 60170 [details] Fractal spreadsheet which demonstrates problem
Confirming with m47 on WinXP - as described. Even File-Reload would not cause recalculation.
Might be related to http://qa.openoffice.org/issues/show_bug.cgi?id=96928.