You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Yes, it's a current limitation with formula cells.
ExcelGen parses formulas but doesn't evaluate them, therefore it doesn't know the resulting data type in order to apply the default styling accordingly. I'll document this behaviour for clarification.
I may try to implement a detection algorithm based on the parse-tree root operand/operator, so I'll keep this open as an enhancement.
In the meantime, the obvious workaround is to style formula cells individually, or through ranges, columns etc.
When initialize number mask with ExcelGen.setnumformat aplies to all number cells except formulas
The text was updated successfully, but these errors were encountered: