🐛 Bug Report

I'm encountering an issue with ExcelJS version 4.3 where the FILTER formula is not retained when opening the generated Excel file in Excel 365. The formula in question is:

=FILTER(ZoneSettingsSheet!$A$1:$DM$1,ZoneSettingsSheet!$A$2:$DM$2 = N382)

Lib version: 4.3.0

Steps To Reproduce

1. Generate an Excel file using ExcelJS version 4.3 with the above FILTER formula.​
2. Open the generated file in Excel 365.​
3. Observe that the FILTER formula is removed or not functioning as expected.

The expected behaviour:

The FILTER formula should be preserved and function correctly when the Excel file is opened in Excel 365.

Additional Information:

I have verified that manually entering the same FILTER formula directly into Excel 365 works as intended. This suggests that the issue may be related to how ExcelJS handles the serialization or compatibility of dynamic array formulas.​

Any guidance or fixes for this issue would be greatly appreciated.