Issue 64166 - Recalculation can not be disabled in macros
Summary: Recalculation can not be disabled in macros
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.0.2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2006-04-09 14:51 UTC by eduardojrobledo
Modified: 2006-11-20 10:18 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description eduardojrobledo 2006-04-09 14:51:38 UTC 
In a macro, disabling the recalculation does not work, so the spreadsheet 
recalculates every time a new entry is posted to a cell, taking a lot of time 
in large spreadsheets.
Comment 1 gercokees 2006-09-18 15:17:30 UTC 
Hi,
I am not very familiar with the macrolanguage in OOo (i need to learn still)
but: when i recorded a macro while turning automatic calculation off i got this
as a result...

dim args16(0) as new com.sun.star.beans.PropertyValue
args16(0).Name = "AutomaticCalculation"
args16(0).Value = false
dispatcher.executeDispatch(document, ".uno:AutomaticCalculation", "", 0, args16())

It looks to me that it should work somehow... Can you please provide the steps
you took in order to confirm this issue? Thanks in advance...
Comment 2 gercokees 2006-11-20 09:58:14 UTC 
Closing this issue because works for me...
Comment 3 frank 2006-11-20 10:18:39 UTC 
...and closed