possible to add unsupported formulas by skipping formula parsing? #3958
Replies: 4 comments 2 replies
-
The Writer will attempt to autocalculate before saving unless you disable that option using the Writer's |
Beta Was this translation helpful? Give feedback.
-
PhpSpreadsheet will not change the formula that you set, it's Excel itself doing that |
Beta Was this translation helpful? Give feedback.
-
Even when I do something simple like this I still get the @ symbol. I know choosecols/chooserows is unsupported, but doesn't that mean I can still use unsupported formulas, it just won't precalculate the values for me?
Extracting two sheets where one works and one doesn't, I get this (edited for clarity so may not be 100% accurate) generated by Excel native (works):
generated by PhpSpreadsheet (gets the @ sign)
|
Beta Was this translation helpful? Give feedback.
-
Based on the work I'm doing in PR #3962, you need to tell Excel in the XML the range of output cells to which an array formula like CHOOSECOLS will be applied in order to avoid the at sign. So, unfortunately it isn't possible to add unsupported formula support in this way. However, if I get that PR to a state where it can be implemented (possibly not far off), the good news is that it should then be relatively easy to implement CHOOSECOLS and CHOOSEROWS. |
Beta Was this translation helpful? Give feedback.
-
I saw chooserows/cols isn't supported but is there a way to enter unsupported formulas without them being interpreted by PhpSpreadsheet that I could later manually calculate by opening the spreadsheet in Excel?
Beta Was this translation helpful? Give feedback.
All reactions