Date: prev next · Thread: first prev next last
2022 Archives by date, by thread · List index

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.

Sim Step
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?

Thanks all

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.