Issue 99239

Summary: Spreadsheet with BASIC macros only fully recalculates when opened
Product: Calc Reporter: timpratt32 <timpratt32>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kpalagin
Version: OOo 3.0.1   
Target Milestone: ---   
Hardware: PC   
OS: Windows Vista   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Fractal spreadsheet which demonstrates problem none

Description timpratt32 2009-02-15 12:51:01 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!
Comment 1 timpratt32 2009-02-15 12:51:54 UTC
Created attachment 60170 [details]
Fractal spreadsheet which demonstrates problem
Comment 2 kpalagin 2009-05-22 14:27:28 UTC
Confirming with m47 on WinXP - as described. Even File-Reload would not cause 
recalculation.
Comment 3 kpalagin 2009-05-22 14:34:12 UTC
Might be related to http://qa.openoffice.org/issues/show_bug.cgi?id=96928.