3 ms·
I see empty cells are treated as zero by SUM and the + operator: http://sheets.alhur.es/c8045lb http://sheets.alhur.es/c8045lb This reminds me of http://www.ha
by wffurr 12y ago
I see empty cells are treated as zero by SUM and the + operator: http://sheets.alhur.es/c8045lb http://sheets.alhur.es/c8045lb
This reminds me of http://www.haskell.org/pipermail/haskell-cafe/2014-August/115586.html http://www.haskell.org/pipermail/haskell-cafe/2014-August/11...
>> There is no excuse for a
spreadsheet quietly taking a never-assigned cell as zero,
but indeed it does. WHAT THE HELL WERE THESE PEOPLE SMOKING?
HN link: https://news.ycombinator.com/item?id=8284939 https://news.ycombinator.com/item?id=8284939
- fiatjaf 12y agoAre you saying this is bad, or just quoting the blog post for fun and information? I don't think it is bad. Spreadsheets are not meant as programming engines, just as practical editable tables. As for "the wrong sum" he complais about in the link, people would know it was meant to be the eternally correct sum, because they will see the empty cells waiting to be filled (either by data or by imagination).