Skip to content

[BUG] Using FILTER Function in Formula Not Persisting in ExcelJS #2910

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Open
jorisvo2 opened this issue Mar 28, 2025 · 6 comments
Open

[BUG] Using FILTER Function in Formula Not Persisting in ExcelJS #2910

jorisvo2 opened this issue Mar 28, 2025 · 6 comments

Comments

@jorisvo2
Copy link

🐛 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.
@mutatedplague
Copy link

mutatedplague commented Apr 8, 2025 •
edited
Loading

I have the same issue with different formula. @jorisvo2 have you found a work around?

@jorisvo2
Copy link
Author

jorisvo2 commented Apr 8, 2025 •
edited
Loading

@mutatedplague

I have the same issue with different formula. @jorisvo2 have you found a work around?

No sorry 😞 I ll probably use another package

@mutatedplague
Copy link

@jorisvo2 looks like this one is related as well. #2838 #

@mutatedplague
Copy link

@jorisvo2 This may work for you
.value = {formula: _xlfn.FILTER(ZoneSettingsSheet!$A$1:$DM$1,ZoneSettingsSheet!$A$2:$DM$2 = N382)}

@jorisvo2
Copy link
Author

@mutatedplague

@jorisvo2 This may work for you .value = {formula: _xlfn.FILTER(ZoneSettingsSheet!$A$1:$DM$1,ZoneSettingsSheet!$A$2:$DM$2 = N382)}

I already tried to prefix all function with "_xlfn" but without success :/ I ll try your code just in case !

@mutatedplague
Copy link

mutatedplague commented Apr 10, 2025 •
edited
Loading

Okay my bad, it somewhat works on my end it still adds a damn @ sign you need to remove. But for whatever reason this solution works for XLOOKUP.

It adds an @ in front of xlookup but excel still works?? WTH

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@mutatedplague @jorisvo2