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@lists.freedesktop.org Reporter: robelsman0...@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.