3 ms·
Because perf was super important for a spreadsheet in the 90s, and now back compatibility is super important. You do not want your numbers changing in the next
by jdsully 4y ago
Because perf was super important for a spreadsheet in the 90s, and now back compatibility is super important.
You do not want your numbers changing in the next version of Excel.
- cm2187 4y agoI don't think he meant Excel. You can't use decimals in excel. First you will overflow immediatly (like multiply two numbers in trillons). Then your rounding will kill small amounts (like percentages). There is no alternative to floats in excel.
- jdsully 4y agoThe predecessor to excel (multi plan) used binary coded decimal. But there’s nothing stopping you from doing arbitrary precision decimal in excel except back compatibility (and all the thousands of lines of code looking for a float).