HFM formula does not work in Automatic Calculation options mode

Hi,

Thanks for your response and the suggestion to use manual mode before saving:
workbook.Settings.FormulaSettings.CalculationMode = CalcModeType.Manual; workbook.Save("output.xlsx");

However, our use case requires the workbook to retain Automatic calculation mode, as this is critical for the expected behavior. Switching to manual mode is not a viable solution for us, as our customers rely on formulas recalculating automatically — and they would not accept a manual calculation setup.

During our investigation, we found that the presence of the ca attribute in the Excel XML is linked to this issue. When we restrict or remove this attribute, the formulas begin to work as expected — even in Automatic mode. This change allows the data to display properly without needing to switch to manual mode.

Our customers are using Excel 2016, so we would like to confirm whether the behavior of the ca attribute is consistent across both Excel 2016 and Office 365.

We’d appreciate your insights on the following:

1. What is the actual significance of the ca attribute in Excel files?
2. If we remove or limit this attribute, could it cause any issues or impact other Excel functionalities?
3. Will the behavior of this attribute be the same in both Excel 2016 and Office 365?

Looking forward to your response.

Thanks,
Indra