Issue 66842 - Saving User-defined Format codes in ods and sdc formats.
Summary: Saving User-defined Format codes in ods and sdc formats.
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0
Hardware: All All
: P4 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-06-29 01:02 UTC by rhubarbpie
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description rhubarbpie 2006-06-29 01:02:17 UTC 
User-defined Format codes aren't saved in ods or sdc formats.  They are saved 
with xls format.

As an example, H:MMa/p displays time as 1:11a or 1:11p as long as the 
spreadsheet is open.  However, if the spreadsheet is saved, closed, and 
reopened the format is lost and the format reverts to HH:MM AM/PM.

Saving, closing, and reopening the file in xls format retains the H:MMa/p 
format.

The requested enhancement would save User-defined Format codes in ods and sdc 
formats.
Comment 1 frank 2006-07-26 15:35:19 UTC 
Hi Eike,

as discussed one for you.

Frank
Comment 2 rhubarbpie 2006-07-26 17:40:36 UTC 
I'm not quite certain how this works, but I'd be thrilled to contribute to 
testing of this enhancement.
Comment 3 ooo 2006-08-02 14:50:34 UTC 
Accepting issue, though it's a rarely used time format. It isn't even
internationalized/localized, contrary to the AM/PM format. Lowering priority to
P4. Storing that in ODF would also need a file format change to add a new
number:time-style element, such as number:a-p
Comment 4 dmcp 2006-08-02 23:46:24 UTC 
Hi Guys,
As I understand the issue it's not about another number format. The enhancement 
is to type in an arbitrary format code and have Calc "remember" the code and 
still treat the data as a number. In that case even something like HH:MM "in 
the morning"/"in the evening" would work.
(I've no idea if this is even practical)
Comment 5 rhubarbpie 2006-08-03 22:56:12 UTC 
dmcp you're correct in your understanding of the issue.  I simply want the 
format code to be saved.

Your "in the morning"/"in the evening" example demonstrates the concept but 
doesn't work.  HH:MMa/p works flawlessly but won't save.  I have to reformat 
cells each time I open the spreadsheet.  It does save in xls format.
Comment 6 drhatch 2006-10-31 22:55:06 UTC 
Here's another example that surprised me more.

Consider
Cell A1: Value: 1, Alignment: left-justified, cell format " " #
Cell A2: value: 1, Alignment: right-justified, cell format # " "
In both cases it is desired to space the number away from the cell edge.

Save and re-open in both .xls and .ods formats

Results: both formats are returned in .xls format; only the A2 format is
returned in .ods format.

Because these two formats are completely symmetrical, would this be considered a
bug?
Comment 7 ooo 2006-11-01 11:00:26 UTC 
@drhatch: losing a leading space would be a separate issue.

Note that for spacing you may as well use Format.Cells.Borders "Spacing to
contents".
Comment 8 Marcus 2017-05-20 11:13:20 UTC 
Reset assigne to the default "issues@openoffice.apache.org".