Issue 88456 - user defined number format does not survive closing and reopening spreadsheet
Summary: user defined number format does not survive closing and reopening spreadsheet
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.4.0
Hardware: PC Windows, all
: P4 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2008-04-18 22:36 UTC by quenett
Modified: 2013-01-29 21:51 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description quenett 2008-04-18 22:36:09 UTC

A user defined number format does not survive closing and reopening spreadsheet.  Observed using both windows 2000 pro
( calc 2.4.0) and debian linux (calc 2.4.0) I have not found a
combination of meta-characters or format characters that can be used to avoid
this problem.  This problem has been present in calc (for me) for at least
several years.  I have seen bug reports and support requests which describe
similar behaviour but I have been unable to find where a bug report
acknowledging this behavior has been resolved or a support response has provided
a useful workaround if this is in fact a bug.

Problem description:

A user defined number format can be defined and used in a spreadsheet with
expected results.  If calc is closed and reloaded the user defined format is
corrupted and cells where it was used no longer display as expected.

Expected behavior:

cell formatting and user defined number formats do not change as a result of
closing and re-opening the spreadsheet.

Steps to reproduce:

1. open a new spreadsheet.
2. in cell c6 enter the number 12.34
3. do Format|Cells
4. the format cells dialog appears with focus on the Numbers tab
5. change decimal places to 2
6. the format code shown in the format code box changes to 0.00
7. change the format code to 0"_".00
8. the format cells dialog changes as expected in various places.
9. click the green arrow and ok.
10. observe that cell c6 displays 12_.34
11. enter 98769.88 in cell d10, apply the above user defined format and observe
that cell d10 displays 98769_.88.
12. do File|Close and save the changes
13. using the quickstarter, reload calc and the above spreadsheet.
13. observe that cell c6 displays as 12.34_
and cell d10 displays as 98769.88_.
14. select cell c6 and do Format|Cells
15. observe that in both the Number and User-defined categories on the numbers
tab of the format cells dialog the above user defined format now dispays as
0.00"_" and not as entered per 7. above.
Comment 1 Rainer Bielefeld 2008-04-19 08:16:41 UTC
I checked with "3.0.0 Beta Multilingual version English UI WIN XP: [Dev-300m7
(Build9293)]"  and can confirm the reported effect, same result with "2.4.0 
Multilingual version German UI WIN XP: [680m12(Build9286)]". It's not a load /
save problem: If you open the document with 3.0-Dev (after you saved it with
2.4.0 without closing it), the write protected document in 3.0 will show the
complained formatting. 

P3 -> to P4, because currently that effect is only known for formattings with
small general interest (IMHO).
Comment 2 quenett 2008-04-25 23:56:57 UTC
In view of the comment from rainerbielefeld, would it be appropriate to set the
status of this to CONFIRMED?  If yes, could someone please do so?  P4 seems
appropriate.  Thanks.
Comment 3 amy2008 2008-08-25 04:02:17 UTC
Confirmed in OOo-Dev_OOO300_m3_en-US on WinXP.