Issue 103046 - [ODF] elapsed time formatting
Summary: [ODF] elapsed time formatting
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.1
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-06-23 19:44 UTC by aguelzow
Modified: 2017-05-20 11:33 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description aguelzow 2009-06-23 19:44:12 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.
Comment 1 wope 2009-06-24 01:38:57 UTC
can confirm it
Comment 2 ooo 2010-06-18 11:04:58 UTC
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.
Comment 3 ooo 2010-06-18 11:15:02 UTC
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.
Comment 4 Marcus 2017-05-20 11:33:10 UTC
Reset assigne to the default "issues@openoffice.apache.org".