Limitations
Calc Macro Pro
Section titled “Calc Macro Pro”- Only the functions listed under Supported Formulas are available. For anything else, use Calc Macro Classic.
Calc Macro Classic
Section titled “Calc Macro Classic”-
When the page is exported to PDF, the calculated value is rendered, but it is displayed in a font that does not match the surrounding text. Use Calc Macro Pro if the appearance of the exported PDF matters.
-
IFERRORdoesn’t work correctly when being evaluated with false- Display the error message such as ‘#DIV/0!’
-
The
TEXTfunction doesn’t work correctly-
difference:
TEXT(ABS(A1),"0.00E+00")- Excel →
1.23E+08 - The app →
+123456789.00000
- Excel →
-