Apache OpenOffice (AOO) Bugzilla – Issue 103046
[ODF] elapsed time formatting
Last modified: 2017-05-20 11:33:10 UTC
Enter =PI()*100 in both A1 and A2 Format A1 to [MM]:SS and format A2 to SS:[MM] as expected cell A1 shows 452389:21 and A2 shows 21:452389 now save the file, close the application, restart the appication and reopen the file: A1 still shows 452389:21 and has the format [MM]:SS attached to it. A2 incorrectly shows [21]:11 and has the format [SS]:MM attached to it.
can confirm it
First hand, why would anyone use a format SS:[MM] ? Anyway, in ODF it is possible to have <number:time-style number:truncate-on-overflow='false' style:name='N117'> <number:seconds number:style='long' /> <number:text>:</number:text> <number:minutes number:style='long' /> </number:time-style> so we may have to cope with this.
Reset assigne to the default "issues@openoffice.apache.org".