Recent

Author Topic: How to get the value of a cell that have a formula?  (Read 842 times)

Jvan

  • Full Member
  • ***
  • Posts: 181
How to get the value of a cell that have a formula?
« on: April 17, 2021, 01:08:37 am »
How to get the value of a cell that have a formula?

Thanks.

wp

  • Hero Member
  • *****
  • Posts: 8716
Re: How to get the value of a cell that have a formula?
« Reply #1 on: April 17, 2021, 01:15:19 am »
You mean the calculated result? Add the workbook option boAutoCalc to calculate all formulas when a cell changes. Or call Workbook.CalcFormulas if you want to do it manually.
Mainly Lazarus trunk / fpc 3.2.0 / all 32-bit on Win-10, but many more...

 

TinyPortal © 2005-2018