Issue 54377 - table user defined number format not saved correctly
Summary: table user defined number format not saved correctly
Status: CONFIRMED
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:
URL:
Keywords:
: 67605 72549 (view as issue list)
Depends on:
Blocks:
 
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: ---

Attachments
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
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 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:

#,##0.00#

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:

#,##0.000

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 
Niklas,

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..

  Eike
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 jeongkyu.kim 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 "issues@openoffice.apache.org".