Bug 146671 - : SORT changes data rounding
Summary: : SORT changes data rounding
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium trivial
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-01-09 19:55 UTC by rossnixon
Modified: 2022-01-09 23:59 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 rossnixon 2022-01-09 19:55:19 UTC 
In my spreadsheet I have a column which calculates my running pace as mm:ss.
Today's run had an average pace of 6:20.625
The formula correctly rounds this to 6:21.
When I sort the column, it shows 6:20 instead.

My formula is time (HH:MM:SS) / distance (0.00) + 0.00.5 (M:SS.0)
Comment 1 rossnixon 2022-01-09 20:12:32 UTC 
I think I've solved it.
The extra 0:00.5 is from a cell $N$4.
When I sort the column, this cell position becomes empty. I'll have to figure out a better way of adding the 0.00.5