[Libreoffice-bugs] [Bug 144446] New: FORMATTING: Fully Implement User-Defined Numeric Format Codes in CALC Styles

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144446

            Bug ID: 144446
           Summary: FORMATTING: Fully Implement User-Defined Numeric
                    Format Codes in CALC Styles
           Product: LibreOffice
           Version: 7.3.0.0 alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: robelsman0453 at gmail.com

Description:
Currently, saving and reopening a CALC file in CALC 7.2.0 causes the loss of
user-defined numeric formats in styles.  The user-defined numeric formats are
converted to a pre-defined format code.  User-defined numeric formats cannot be
chosen in the styles property window.

I recommend an enhancement to fully implement the use of user-defined numeric
formats in CALC styles.  The styles property settings should be enhanced to
include user-defined numberic formats, and user-defined numeric formats should
be retained and retrieved when the CALC file is saved and reopened.

Steps to Reproduce:
1. Format a cell with a user-defined numeric format
2. Create a new style from the cell with the user-defined numeric format
3. Save the file
4. Open the file
5. Open the Styles sidebar
6. Choose the previously created style
7. Open the properties settings for the created style
8. Notice that the user-defined numeric format code is not the format code
being used for the style.
9. Select a completely empty, unused cell
10. Apply the style to the cell
11. Enter a number in the cell
12. Notice that the user-defined numeric format is not used to format the cell

Actual Results:
User-defined numeric formats in newly created styles are not saved and
retrieved when a file is saved and reopened.  The user-defined numeric format
is converted to a predefined format.

Expected Results:
Were it enhanced, I would expect the user-defined numeric format to be
retained, saved, and retrieved when a CALC file was saved and reopened. 
User-defined numeric formats would be available to choose and edit when the
styles properties settings was opened.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.2.0.4 / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 2; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

x64_DEB download

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210911/31f7e8ab/attachment-0001.htm>