Bug 35553

Summary:	Calc doesn't calculate fractions correctly
Product:	LibreOffice	Reporter:	parafine
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	CLOSED INVALID
Severity:	major	CC:	duchess1946, rb.henschel
Priority:	medium
Version:	3.3.2 RC2
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description parafine 2011-03-22 11:32:56 UTC

Calc can't make fractions calculation correctly.
I changed the cell format to "fraction". I tried adding 1/5 + 1/8 and calc gave me 1/3, that is an aproximaton but fraction calculation must be exact.
When I multiply 1/5 * 1/8 I get 0.
Is there something that I'm missing?
Thanks.

Comment 1 Regina Henschel 2011-03-24 15:09:10 UTC

Calc is not able to calculate with fractions, but all calculation are done in internal format "double". 'Fraction' is only a way to display the number.

Calc takes the fraction which has the specified denominator and is nearest to the decimal value. In your case you have to use a fraction with more figures in the denominator. You can set up to three figures in the format. Use a question mark for each figure.

Comment 2 Eike Rathke 2011-08-05 12:11:50 UTC

As Regina said, choose or define a fraction format with more digits in the denominator. Not a bug, closing.

Comment 3 Roman Eisele 2012-05-04 00:35:42 UTC

This is a Calc issue, therefore changed 'Component' accordingly.

Comment 4 Patricia 2016-10-29 05:31:01 UTC

I did a check book/bill pay spreadsheet in Libre Office.  Worked well until about four months ago.  Then I lost two months of spreadsheets.  Started another, turned off Windows updates and seemed to work well for another two months.  Then the latest update for Libre Office came out.  After downloading I noticed the amounts are not adding/subtracting correctly.  There is no negative sign when switching from positive to negative amounts.  IE - (25.00).  This is a pain so please let me know if this is going to be fixed.