Issue 99239 - Spreadsheet with BASIC macros only fully recalculates when opened
Summary: Spreadsheet with BASIC macros only fully recalculates when opened
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.0.1
Hardware: PC Windows Vista
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-02-15 12:51 UTC by timpratt32
Modified: 2013-01-29 21:44 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Fractal spreadsheet which demonstrates problem (25.29 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-02-15 12:51 UTC, timpratt32
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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 
Comment 3 kpalagin 2009-05-22 14:34:12 UTC
Might be related to