Skip to content
IFERROR does not catch errors. IFERROR(1/0,"n/a") shows #DIV/0! instead of n/a.- The
TEXT function does not support scientific notation. For TEXT(ABS(A1),"0.00E+00") with 123456789, Excel shows 1.23E+08, but Calc Macro Pro shows 123456789 and Calc Macro Classic shows +123456789.00000. Other formats, such as TEXT(A1,"#,##0.00"), work as expected.
- A percentage written as a Custom format, such as
0.0%, is not multiplied by 100 (0.256 is shown as 0.3%). Use the predefined Percentage format instead, which shows 25.60%.
- A formula can refer only to its own table. Sheet references such as
0!B2 are not supported.
- A formula cannot use the result of another macro. A cell that holds another macro is read as that macro’s formula text, so the result is wrong (for example
#VALUE!). Write the calculation in one formula instead, for example MAX(B1:B4)-MIN(B1:B4), or use Calc Macro Pro.
- 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.