Formula doesn't work in protected view

[Meowfficer]

is there a way to show the formulas in protected view

and if i click the cell, it show the formula

and, it's in protected view, if i enable editing, the formula worked, but i want the formula still working even in protected view

[patrickbrouwers]

Hello, I think you can better ask on Stackoverflow, this isn't really related to this package. Possibly to PhpSpreadsheet, but more likely a generic Excel thing.