Re:Show HN: Instantly Understand Any Spreadsheet
by sheetjs on Tuesday August 05, 2014 @02:08PM
(#8138386)
> 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+
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_formta...