News for hackers. Stuff that matters.

A comment on Show HN: Instantly Understand Any Spreadsheet. Parent comment

Re:Show HN: Instantly Understand Any Spreadsheet by sheetjs on Tuesday August 05, 2014 @11:24AM (#8137389)
> if(iserror(formula), 0, formula)

The IFERROR function was designed for this pattern:

    IFERROR(formula, 0)
[ Parent | on HN ]
Re:Show HN: Instantly Understand Any Spreadsheet by lmkg on Tuesday August 05, 2014 @01:55PM (#8138293)
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.
[ Parent | on HN ]
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+

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...

[ Parent | on HN ]
Re:Show HN: Instantly Understand Any Spreadsheet by roel_v on Tuesday August 05, 2014 @05:38PM (#8139628)
Oh that's very convenient, thanks. As another person replying said, I only migrated from 2003 a few months ago (don't ask) so I still have a lot of new quality of life features to discover :)
[ Parent | on HN ]