3 ms·
Hey, I'm very interested in this because LibreOffice annoys me and I can't explain why. It's not the "dated look" that everybody complains about; but I suspect
by ekjhgkejhgk 8mo ago
Hey, I'm very interested in this because LibreOffice annoys me and I can't explain why. It's not the "dated look" that everybody complains about; but I suspect it's related to UX somehow.
Could you articulate why Gnumeric is better than everything else?
- Betelbuddy 8mo agoTo start, your calculations will be correct unlike with Excel https://www.tandfonline.com/doi/abs/10.1198/tas.2011.09076 https://www.tandfonline.com/doi/abs/10.1198/tas.2011.09076 https://exceloffthegrid.com/excel-calculate-wrong-results/ https://exceloffthegrid.com/excel-calculate-wrong-results/
- ekjhgkejhgk 8mo agoFrom your second link > Therefore, the problem is not necessarily with Excel. Equally, the problem is not with the IEEE 754 standard either. It’s just the complex nature of the world of mathematics and computing that we live in.
- Betelbuddy 8mo agoExcel the one who decided to use only 15 digits. It is an Excel problem...
- fweimer 8mo agoThe IEEE 754 standard covers decimal floating point arithmetic, too. Decimal floating point avoids issues like 0.1 + 0.1 + 0.1 not being equal to 0.3 despite usually being displayed as 0.3. Maybe it's reasonable to use that instead? Some earlier spreadsheets such as Multiplan used it (but not in the IEEE variety) because it was all soft-float for most users anyway.