Lazarus

Programming => Packages and Libraries => FPSpreadsheet => Topic started by: gii on November 22, 2020, 04:12:01 am

Title: Formulas in virtual mode
Post by: gii on November 22, 2020, 04:12:01 am
Is it possible to use formulas in virtual mode?

I have a template line.

In the next lines, the reference columns must be adjusted (exactly as in CopyFormula).

This would be used in reading mode.
Title: Re: Formulas in virtual mode
Post by: wp on November 22, 2020, 11:23:12 am
I am rather sure that formulas cannot be used in virtual mode. This mode is intended to avoid loading the entire worksheet into memory for some data extraction work. As a consequence only a single cell is available at any time during reading, and no cell is available any more after reading when formulas are calculated. So, you only can use virtual mode with workbooks having precalculated formulas.
TinyPortal © 2005-2018