Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 04 Feb 2018 02:01:35 +0100Why calc fraction returns wrong answer.https://ask.libreoffice.org/en/question/145094/why-calc-fraction-returns-wrong-answer/When I put .75 in a1 and put =a1 in a2 and format a2 as fraction, I get the number 1 instead of 3/4. I tried all of the present formats(??/??) but none gives me 3/4. Tried this in excel and WPS office and it work correctly, but not in Libre Office Calc. Try it for yourself
Thanks:
Rich.
Here is a screenshot of calc.
[C:\fakepath\Libre Office Calc fractions.png](/upfiles/15177503489830624.png)
Here is an image if screenshot above doesn't work for you.
![image description](/upfiles/15177510784875088.png)
Other fractions work fine, just some fractions returns 1 in the cell. Can't remember which ones malfunctions. I'll try and find out for you and try to make a list. May take some time to do.
Here are fractions in 1/32 in increments. I have Libre Office Ver 5.4.4.2
![image description](/upfiles/15177521785014274.png)
Here if a file with the fraction format ??\/?? I hope I did this up load correctly.
[C:\fakepath\LO Fraction1.ods](/upfiles/1517757664433235.ods)
Here is anoter attachment I'll send you. I just formatted to fractions.
[C:\fakepath\LO Fraction2.ods](/upfiles/15177647718792041.ods)
Here are two more files to look at. one ODS the other XLSX
[C:\fakepath\Decimal to Fraction.xlsx](/upfiles/15177996694072694.xlsx)
[C:\fakepath\Decimal to Fraction.ods](/upfiles/15177998594499064.ods)
If the files I"m uploading to you do work on your Libre Office calc and don't work on mine that probably means that there is something wrong with my installation. That"s why I sent you screenshots of the the files in question. Is that possible? Should I try and uninstall and reinstall Libre Office?
Thanks:
Rich
Here is Decimals to Fractions.ods.
[C:\fakepath\Decimal to Fraction.ods](/upfiles/15179330407936656.ods)RichlibSun, 04 Feb 2018 02:01:35 +0100https://ask.libreoffice.org/en/question/145094/