Recent

« previous next »
Pages: [1]

Author Topic: Formulas in virtual mode  (Read 1223 times)

gii

  • Jr. Member
  • **
  • Posts: 53
Formulas in virtual mode
« 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.
Logged

wp

  • Hero Member
  • *****
  • Posts: 11912
Re: Formulas in virtual mode
« Reply #1 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.
Logged
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018