I'm trying to construct a simulation in Calc. I have two
tables (Model and Data) as well as a macro.
The model takes input values, performs transformations and
provided results. The model has no circular references and is
MODEL INPUTS ---> Transformation ---> MODEL OUTPUTS
The Data table is organised as rows of records for each
simulation step. Each Simulation Record is divided into Input
Data and Result Data.
I/P Data 1I/P Data 2Result Data 1Result Data
Needless to say the data table is very simplified here.
The Macro is relatively simple (in pseudo code for clarity):
1. clear results
2.1 for each sim_step do:
2.2 copy input_data to model_inputs
2.3 trigger re-calculation.
2.4 copy model_results to result_data
3.0 save all
Now for the issue: The model calculations at
2.3 are relatively fast but not instantaneous. At step 2.4 data
is being retrieved when calculations are incomplete.
So my question is:is there a way to perform
re-calculation in a way that blocks further macro processing or
for re-calculation to flag it is complete?
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
- [libreoffice-users] Re-calculation Blocking or Flag · Greg Saunders
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy