LibXL : how to force formulas to recalculate when MS excel file is opened?

Question

In MS excel file user has set that formulas are manually recalculated. I would like to force auto recalculate with LibXL, after I write data to the file. Is this possible somehow ?

I have searched documentation, and I couldn't find anything related. LibreOffice is recalculating formulas automatically, after I open the file created with LibXL, but Microsoft Office does not.

There is no point in showing my code. Either LibXL has flag / a way to do this or not.

After I am done with creating file with LibXL, and I open the file in MS Office, I would expect that formulas are automatically executed.

Note: I am using PHP

Answer 1

If the user opens the file for the first time and no windows open on user's computer, calculation mode is set to "Auto" by defualt on MS excel. But prior to opening your workbook if somehow user activated manual calculation mode on his other workbooks, your file will be opened in manual mode as well.

I am not sure how PHP involved in this. But to force auto calculation you can add a simple open event macro to your file.

Sub Workbook_Open()
 Calculate
End Sub

Copy this into workbook object in visual basic window. This macro will be executed every time the file is opened.

Hope this helps