Skip to content

[BUG] Sometimes ExcelJS puts the "Implicit intersection operator: @" where it doesn't work #2006

@verlok

Description

@verlok

🐛 Bug Report

Sometimes ExcelJS puts the "Implicit intersection operator: @" where it doesn't work

Lib version: 4.3.0

Steps To Reproduce

I'm using the following code to create a shared formula in the excel file I'm generating

 worksheet.fillFormula(
    `J2:J${lastRowNumber}`,
    'IFS(I2<0.9, "POOR! (--)", I2<1, "(-)", I2=1, "OK", I2>1.2, "BIG (++)", I2>1, "(+)")'
  );

But then, in the resulting excel, I get the formula with an at @ character in front of it.
And so I get a #NAME error in the cell.

See screenshot here

Screenshot 2022-03-14 at 16 14 47

The expected behaviour:

I'm expecting the formula to appear in the excel file without the @ character.

Additional notes

I initially created this bug as a discussion, but then I saw others have the same problem and they worked around it, so I guess it's a bug.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions