fraction formatting result different to ms excel [closed]

asked 2016-05-11 17:10:35 +0200

Michal gravatar image

updated 2020-07-24 00:28:52 +0200

Alex Kemp gravatar image

Hello everyone! For particular situation of value 0.09 being displayed as a fraction ms excell shows '1/11' while libre office calc shows '8/89' with formatting '#?/??'. Is there any way to ensure file displays always the same fraction value regardless of whether it's opened in LOC or MSE?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-07-24 00:29:01.899499


It seems that LibreOffice calculate this more precisely. 1/11 is 0,090909 while 8/89 is 0,8988. The difference between actual value (0,9) and the LibreOffice is far less than difference between MS Excel and actual value. I guess this is algorithm which can be change a little bit in Format -> Cells. There are two types of Fraction format which result in different fraction result. Try to play with this to see if it is possible to get similar result.

Ljiljan gravatar imageLjiljan ( 2016-05-11 18:36:44 +0200 )edit

Thank you for your reply. I've tried multiple different formatting patterns for fraction and failed to get the same result as ms excell. The only one that would be interpreted the same is '#?/???' but that's an exact value and I need an approximation with two digits in denominator. I also need a confidence that all values are always displayed in the same way in both programs.

Michal gravatar imageMichal ( 2016-05-12 09:34:36 +0200 )edit