3 ms·
Yes, display long numbers. Exactly why this is not a sheet of paper - I can resize the columns all I need. Just tested in LibreOffice calc: 3093793050301076923
by justsomehnguy 4y ago
Yes, display long numbers. Exactly why this is not a sheet of paper - I can resize the columns all I need.
Just tested in LibreOffice calc: 30937930503010769238 is mangled to scientific notation: 3,09379305030108E+19 . If I change the format to anything (but it's already a generic number) than it becomes 30 937 930 503 010 800 000.00 or something. And if I change the format of the cell to the text it becomes... 3,09379305030108E+19 again.
And yes it's a number, though it doesn't get used as such in my case. If it was really used for anything of value - I would be really pissed for the 30k inaccuracy.
- zamadatix 4y agoYou may be (genuinely) surprised to know that's not because of display notation cut anything off it's because IEEE double floats are being used once it gets interpreted as a number and that's as far as the smaller digits in such a large number are accurately encoded for. https://www.microsoft.com/en-us/microsoft-365/blog/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers/ https://www.microsoft.com/en-us/microsoft-365/blog/2008/04/1... https://ask.libreoffice.org/t/decimal-precision-how-to-have-18-decimals/33491 https://ask.libreoffice.org/t/decimal-precision-how-to-have-...
- justsomehnguy 4y agoI know and I don't care. Just leave my numbers as is.