Bug 81128 - Unusual time handling in TEXT call
Summary: Unusual time handling in TEXT call
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) Master
Hardware: Other All
: medium minor
Assignee: Not Assigned
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
Reported: 2014-07-09 20:39 UTC by Michael Meeks
Modified: 2019-02-18 15:29 UTC (History)
0 users

See Also:
Crash report or crash signature:

some time calculations (11.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-07-09 20:39 UTC, Michael Meeks

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Meeks 2014-07-09 20:39:17 UTC
Created attachment 102504 [details]
some time calculations

Not completely sure what the issue is here but a user sent a nice test sheet which I attach.
Comment 1 QA Administrators 2015-07-18 17:44:05 UTC Comment hidden (obsolete)
Comment 2 QA Administrators 2016-09-20 10:18:15 UTC Comment hidden (obsolete)
Comment 3 Eike Rathke 2019-02-18 15:29:35 UTC
The user did not understand formatting and what it means to use [HH] or [MM] on their own (the values are rounded) or that using MM standalone does not format a minute but a month instead..