Bug 107783 - Incorrect results - Auto Sum
Summary: Incorrect results - Auto Sum
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.2.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-05-11 20:56 UTC by Fernando Moreira
Modified: 2017-05-11 22:19 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
AutoSum incorrect result (32.15 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-05-11 20:56 UTC, Fernando Moreira 		Details
Corrected file (32.12 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-05-11 22:19 UTC, Jacques Guilleron 		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 Fernando Moreira 2017-05-11 20:56:36 UTC 
Created attachment 133245 [details]
AutoSum incorrect result

Incorrect result after aplly autosum on column.

File attached
Comment 1 Jacques Guilleron 2017-05-11 22:16:21 UTC 
Hi Fernando,

What happens?
In the range H2:H26, there is a simple quotation mark before each number.
This means they are considered as texts, not as values.
To transform them as values, select H2:H26 and, in Data menu, select
Text to Columns...
Remains one similar error in I13.
This time, delete the simple quotation mark before the number,
and all will be correct.

I join the corrected sheet.

Jacques
Comment 2 Jacques Guilleron 2017-05-11 22:19:56 UTC 
Created attachment 133247 [details]
Corrected file