Bug 81128

Summary: Unusual time handling in TEXT call
Product: LibreOffice Reporter: Michael Meeks <michael.meeks>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: CLOSED NOTABUG    
Severity: minor    
Priority: medium    
Version: 4.4.0.0.alpha0+ Master   
Hardware: Other   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108827    
Attachments: some time calculations

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..