Bug 124085 - Cells formatted in Date/Time don't keep the wright time
Summary: Cells formatted in Date/Time don't keep the wright time
Status: RESOLVED DUPLICATE of bug 122991
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.3 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-03-14 18:27 UTC by Yann Zimmermann
Modified: 2019-03-14 18:49 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
The .xlsx with the bug (10.16 KB, application/xml)
2019-03-14 18:36 UTC, Yann Zimmermann 		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 Yann Zimmermann 2019-03-14 18:27:18 UTC 
Description:
When i format a cell with [U]:MM;@ and i put 0:30 in it, it always displays 0:29 and does the calculation with this. So i'm always 1 min short. In the command line it displays 0:30:00 but in the cell it's always 0:29.

Steps to Reproduce:
1.select a cell
2.format with [U]:MM;@
3.type 0:30 in the cell

Actual Results:
displays 0:29 in the cell

Expected Results:
to display 0:30


Reproducible: Always


User Profile Reset: No



Additional Info:
Versie: 6.2.0.3 (x64)
Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
CPU-threads: 8; Besturingssysteem: Windows 10.0; UI-render: standaard; VCL: win; 
Locale: nl-BE (nl_BE); UI-taal: nl-NL
Calc: CL
Comment 1 Yann Zimmermann 2019-03-14 18:36:35 UTC 
Created attachment 149976 [details]
The .xlsx with the bug
Comment 2 Xisco Faulí 2019-03-14 18:49:46 UTC 
Hello,
Thanks for reporting this issue. This is a duplicate of bug 122991.
Please try again with LibreOffice 6.2.1.2

*** This bug has been marked as a duplicate of bug 122991 ***