Override default XlsxWriter behavior to not recalculate all cells upon opening

Question

According to the documentation:

XlsxWriter doesn’t calculate the result of a formula and instead stores the value 0 as the formula result. It then sets a global flag in the XLSX file to say that all formulas and functions should be recalculated when the file is opened.

This negates the benefit from using the value parameter when using write_formula().

Is there a way to override this behavior so that only cells I haven't given a value for gets recalculated?

Thank you!

Answer 1

Is there a way to override this behavior so that only cells I haven't given a value for gets recalculated?

I don't think Excel has an option like that.

You can however, use the XlsxWriter set_calc_mode() method to turn on Excel's manual calculation option for the workbook.