Bug 94432 - Same surface to calculate, 2 different ways and 2 different results.
Summary: Same surface to calculate, 2 different ways and 2 different results.
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.1.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-09-22 08:08 UTC by maguz
Modified: 2015-09-22 09:51 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Screenshot (275.76 KB, image/jpeg)
2015-09-22 08:08 UTC, maguz 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description maguz 2015-09-22 08:08:05 UTC 
Created attachment 118924 [details]
Screenshot

I tried to make a calculation of a flat square meters following 2 different ways and i got 2 different results. According to the CAD the right one is 42,94 sq.
Comment 1 Julien Nabet 2015-09-22 09:47:32 UTC 
The operation is different.
In Excel, copying the exact first line, I've got the same result as LibreOffice 

=(1,14+1,5)*4,23+1,68*1,03+9,63*3,25+0,35*3,6-0,34*1,54
44,9315 so it may correspond to your result if you formatted the cell with 2 decimals.