[Issue 126973] New: writer table currency number format # suffix saved as 0

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126973

          Issue ID: 126973
        Issue Type: DEFECT
           Summary: writer table currency number format # suffix saved as
                    0
           Product: Writer
           Version: 4.1.2
          Hardware: PC
                OS: Linux 32-bit
            Status: UNCONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: save-export
          Assignee: issues@openoffice.apache.org
          Reporter: gherr375@sbcglobal.net

This problem is repeatable and can be verified in a writer file. To verify the
problem, open a new blank writer file, insert a 2x2 table, right-click in a
table cell and bring up the "Number Format" option. Select the "Currency"
category and "-$1,234.00" (red) format. In the "Format code" field, modify the
number format by appending a # to the $#,##0.00 fields, producing $#,##0.00#.
Click on "Add". This new format is then present in the "User Defined" and
"Currency" number Categories. Click on OK to select the new format in the table
cell. Save this test file and re-open it. Right click on the same table cell
and select "Number format". Note that the format is now $#,##0.000, not the
proper $#,##0.00#. The format has been changed by the save or open functions.

Note that the Help describes an example of this format, using the # suffix in a
decimal fraction field, so this problem behavior is contrary to the help.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126973] writer table currency number format # suffix saved as

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126973

--- Comment #2 from orcmid <or...@apache.org> ---
Created attachment 85543
  --> https://bz.apache.org/ooo/attachment.cgi?id=85543&action=edit
Reloaded File shows replacement of the Custom Formats

On opening AOO 4.1.2 from the saved file, the formatting has been changed to
show three digits after the decimal point always.

The alteration of the Custom Format and of the presented cells is demonstrated
in this screen capture.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126973] writer table currency number format # suffix saved as

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126973

orcmid <or...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
             Latest|---                         |4.1.2
    Confirmation in|                            |
                 OS|Linux 32-bit                |All
     Ever confirmed|0                           |1

--- Comment #3 from orcmid <or...@apache.org> ---
The use of numeric cell formatting in Writer-produced tables is confined to the
provisions of OpenDocument Format (ODF) used for .odt files.  This is the same
formatting that is used for Calc.

ODF has no means for specifying the elimination of trailing zeros, even though
the Writer (and Calc) implementation allow it to happened when the formatting
is applied to an already-open document.  The additional formatting cannot be
preserved in the saved .odt, however.

This is a limitation of the OpenDocument format.  The limitation is the same as
described in Issue 126827.  The Help information is incorrect.  The Help
information is correct only when the table cell is in a Calc sheet and when it
is saved in Excel format.  (It doesn't apply to Writer at all since saving to
Word format turns the fields into text.)

There are two defects in the Writer case.  First, the Help does not apply. 
Secondly, behaving as if the customization is accepted is actually incorrect.

The policy issues around this phenomenon are similar to those for Issue 126827.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126973] writer table currency number format # suffix saved as

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126973

orcmid <or...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |orcmid@apache.org

--- Comment #1 from orcmid <or...@apache.org> ---
Created attachment 85542
  --> https://bz.apache.org/ooo/attachment.cgi?id=85542&action=edit
Saving the File with Custom Formatting

An ODT was created using Apache OpenOffice 4.1.2 on Windows 10 Pro x64.

The Custom formats were created and applied to the table, and values were
presented with only 2 digits past the decimal point and with a non-zero third
digit after the decimal point.

The effect of the formatting codes is apparent.

Also, after the save to a file, the formatting remains as specified for the
open document.

-- 
You are receiving this mail because:
You are the assignee for the issue.