Hacker News new | ask | show | jobs
by sheetjs 4405 days ago
On a side note, Excel is infuriatingly inconsistent: some operations work in a way that .1 + .2 == .3 (for example, try `=0.1+0.2=0.3`) but others fall apart (displayed as a fraction with one digit, 0.3 -> 2/7 but 0.1+0.2 -> 1/3)
1 comments

floating point is hard. backwards compatibility is even harder
For a modern spreadsheet it would not be unreasonable for a user to expect symbolic arithmetic rather than floating point error soup.