[Libreoffice-bugs] [Bug 133919] New: Import of Excel format data transfer file rounds time incorrectly

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133919

            Bug ID: 133919
           Summary: Import of Excel format data transfer file rounds time
                    incorrectly
           Product: LibreOffice
           Version: 6.4.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: info at huntsgrove.ie

Description:
I am importing a spread sheet file in Excel format from an Android application,
and on some fields, the time captured by Calc is formatting incorrectly, and it
seems to be a rounding issue with the conversion. As an example, a time of
13:00, which calidates correctly in the Android device is converted by Calc
into 12:59:59, and it would seem that the value in the cell is effectively
15:59:59.9, but I cannot find a way to get it correctly rounded in Calc.
The problem is that if the time is calculated using HH:MM format, the time is
shown as 12:59, and then when used to calculate the elapsed time, it is showing
the correct elapsed time, but due to the rounding error, it appears to be wrong
by 1 minute due to the rounding issue. 

Steps to Reproduce:
1.Open Excel format data file transferred from Android device
2.Review data sent
3.See rounding errors on some fields

Actual Results:
Times imported can vary and cause apparent issues with calculated times shown
in spreadsheet

Expected Results:
Time that should be displayed as (eg) 13:00 is displayed as 12:59, but time
difference calculation has used 13:00, as the raw value appears to be
12:59:59.9, 


Reproducible: Sometimes


User Profile Reset: No



Additional Info:
If needed, can provide a data file that shows this in a number of records, but
I don't have enough information about the internal file structure to be sure of
the diagnosis of the error.

Version: 6.4.4.2 (x64)
Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff
CPU threads: 2; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; 
Locale: en-GB (en_GB); UI-Language: en-GB
Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200611/c801711f/attachment.htm>