36 ms·

IFERROR was introduced in Excel 2007, and is not compatible with the old-school .xls files. I haven't had to worry about 2003 in the wild in a few years, but so

by lmkg 12y ago

IFERROR was introduced in Excel 2007, and is not compatible with the old-school .xls files. I haven't had to worry about 2003 in the wild in a few years, but some tools may not have migrated to the new file format.

sheetjs 12y ago
> is not compatible with the old-school .xls files You can save as XLS (97-2003) files and Excel serializes the formula using the name `_xlfn.IFERROR`. The file obviously doesn't work in older versions of Excel but will work in 2007+ The mapping for new function names is defined in section 2.2.3 of [MS-XLSX] https://github.com/SheetJS/js-xls/blob/master/bits/69_formtab.js#L983 https://github.com/SheetJS/js-xls/blob/master/bits/69_formta...