Issue 54377 - table user defined number format not saved correctly
Summary: table user defined number format not saved correctly
Alias: None
Product: General
Classification: Code
Component: code (show other issues)
Version: OOO 2.0 Beta2
Hardware: All All
: P3 Trivial with 16 votes (vote)
Target Milestone: AOO Later
Assignee: AOO issues mailing list
QA Contact:
: 67605 72549 (view as issue list)
Depends on:
Reported: 2005-09-09 00:15 UTC by crosetto
Modified: 2017-05-20 11:29 UTC (History)
3 users (show)

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

3rd column has be formatted. Created with OOo 1.9.125. (6.51 KB, application/vnd.oasis.opendocument.text)
2005-09-09 00:20 UTC, crosetto
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description crosetto 2005-09-09 00:15:38 UTC
When creating a user defined number format for a column of cells in a table, it
is not saved correctly after exiting openoffice and restarting openoffice and
reopening the file. I created the following custom number format:


This will stay saved correctly during the current openoffice session. After
closing openoffice and then restarting it and reopening the file, the number
format is changed to:


Steps to reproduce:

1. Create a new openoffice writer document
2. Insert a table
3. Select column of the table
4. Table -> Number Format
5. Create user defined format, #,##0.00#
6. Click "Add" button and assign this format to the cells
7. Save the document and quit openoffice.
8. Reopen the document and check the number format of the cells. It will have
been changed to #,##0.000

I have noticed that it will replace #s with 0s for all #s if a 0 appears to the
right of the decimal place, *except* it will replace 0s with #s if a # appears
to the decimal point's immediate right. This last behavior might be desirable. 

I believe #,##0.00# should be a valid format.
Comment 1 crosetto 2005-09-09 00:20:44 UTC
Created attachment 29409 [details]
3rd column has be formatted. Created with OOo 1.9.125.
Comment 2 eric.savary 2005-09-13 12:15:01 UTC
ES->ER: same behavior in Calc. Please have a look.
Comment 3 ooo 2005-09-13 13:06:57 UTC

One for the file format. A trailing # for decimals shouldn't add to
number:decimal-places as a 0 does. Looks like we'd need an additional
number:optional-decimal-places or so..

Comment 4 ooo 2006-08-31 20:01:24 UTC
*** Issue 67605 has been marked as a duplicate of this issue. ***
Comment 5 terrynorth 2006-11-07 04:42:14 UTC
I have voted for this issue although I really want to vote for issue 67065 which
has been marked as a duplicate of this issue although it relates to Calc, where
the issue is, if anything, more pertinent.

Another user has reported a similar problem with a date format lost on reopening
the file.
Comment 6 delorea 2006-12-14 18:30:05 UTC
*** Issue 72549 has been marked as a duplicate of this issue. ***
Comment 7 2009-01-10 04:42:36 UTC
There was a report through Korean community forum that user defined format for
number such as '0.0#' is not saved correctly in Calc. The format works OK when
editing documents, but after saving and reopening them, the format is changed
into '0.00'.

This problem happens when saving Calc document with ods format, but does not
happen when saving the document with xls format.
Comment 8 jimavera 2009-02-26 20:04:51 UTC
This problem is still here in oo3.0.1.

Formats like 0.0#### are changed to 0.00000 by (save,exit,restart,open) in oocalc.
Comment 9 cadryc 2010-02-10 13:20:15 UTC
Confirmed in 3.2rc5
Comment 10 Jim 2013-02-15 22:44:18 UTC
Still here in 3.4.1
Comment 11 Marcus 2017-05-20 11:29:53 UTC
Reset assigne to the default "".