Page Index Toggle Pages: 1 Send TopicPrint
Normal Topic How to force a spreadsheet recalculation? (Read 1562 times)
Ale
YaBB Newbies
*
Offline


I Love MindFusion!

Posts: 14
Joined: May 26th, 2023
How to force a spreadsheet recalculation?
Jun 1st, 2023 at 5:26pm
Print Post  
Hello,

I need to recalc the sheet but I cannot find any method to do this.
I also tried with worksheetView1.Worksheet.BeginInit() and worksheetView1.Worksheet.EndInit() (I supposed a recalc was performed when EndInit() was reached but... no).

How can I recalc a worksheet?

(documentation is not very clear...)

UPDATE: I'm writing in a cell using:
Code
Select All
worksheetView1.Worksheet.Cells[aCol, aRow].Data = ....... 



but even if the Data change, the sheet is not automatically recalculated.

Thank you for help!
  
Back to top
 
IP Logged
 
Slavcho
God Member
*****
Offline


tech.support

Posts: 3194
Joined: Oct 19th, 2005
Re: How to force a spreadsheet recalculation?
Reply #1 - Jun 2nd, 2023 at 5:30am
Print Post  
Hi,

Do you mean one of those custom functions of yours refers to the cell, but hard-coded in the implementation instead of passing the cell as argument? If a changed cell is argument of other cell's formula, it should trigger evaluation automatically. Otherwise try calling the Workbook.EvaluateFormulas() method.

Regards,
Slavcho
Mindfusion
  
Back to top
 
IP Logged
 
Ale
YaBB Newbies
*
Offline


I Love MindFusion!

Posts: 14
Joined: May 26th, 2023
Re: How to force a spreadsheet recalculation?
Reply #2 - Jun 3rd, 2023 at 5:10am
Print Post  
Workbook.EvaluateFormulas() works perfectly, so I can recalculate at specific moments, thank you!
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send TopicPrint