Description: Hi, I would like to request a feature to show and calc exact numbers instead of rounding up. I don't want a ballpark number, I want the exact number. If my number is 5461154115994554615, that is what I want in the cell and what I want to be used to do the calculation. Thanks, NRL Actual Results: 5461154115994550000 Expected Results: 5461154115994554615 Reproducible: Always User Profile Reset: No Additional Info: 4615 isn't much in a large number but if you are calculating 50 or 100 or 200 cells, that small amount becomes a very large amount difference in the final total.
For displaying, this can be done by formatting the cell as text before input, or using an apostrophe before the number at input time e.g.: '5461154115994554615 The number can still be used for calculations. But you are right in the precision limitation, which is documented here: https://wiki.documentfoundation.org/Faq/Calc/Accuracy *** This bug has been marked as a duplicate of bug 105819 ***
Created attachment 185092 [details] Difference between a number and text Hi, I still cannot get the number. as a number I get: 5254615415121512155 5461154115994554615 ------------------- (206,538,700,873,042,000.0000000000) as plain text I get: 5254615415121512155 5461154115994554615 ------------------- -2.06538700873042E+17 In plain text I cannot increase the number of decimal places. How do I get the exact number this way? What am I doing wrong? I don't understand? I'm sorry that I'm stupid. Thanks for getting back to me so quickly.
5254615415121512155 - 5461154115994554615 > ------------------- > (206,538,700,873,042,000.0000000000) That's also incorrect (it is at least inaccurate). I'm not sure even using the RAWSUBTRACT() function you would get an accurate result for that subtract operation. There is a workaround using TEXT functions, but it is not _that_ pretty and it depends on the case.