Description: Hello, when you add a custom number format to the "Format Cells..." menu in Calc and instead of putting the unit in "" you escape the characters, the format's description is empty after it has been added. Write it like this: '#,##### "GW/h"' Description: '-1234,56789 GW/h' Write it like this: '#,##### \GW\/\h' Description: '' The formatting of the cells works as it should in both cases. I understand that one should put "" around the unit that is used after reading the docs, but w/o reading the docs, escaping the special characters seemed to be the "natural solution" to me. Maybe this isn't a bug but a feature request. Let's see... Thanks anyway! KR, G. P.S.: I switched the UI to english for this bug report, it's usually running in German. Steps to Reproduce: 1. Open Calc 2. Right click on cell 3. Select "Format Cells..." 4. In the opened window in the "Category" column select "User-Defined" 5. At the bottom in the "Format Code" text field enter "#,##### \GW\/\h" (without the "") 6. Click on the green tick in the lower right 7. Watch the "Category" colum change to "Number" and the "Format" column point to an entry w/o a name. Actual Results: No name/description for the entry added. Expected Results: Name/description for the entry added. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333 CPU threads: 24; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: CL threaded
Reproducible with Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: e9374f74385d7dfe77d1902d3d82af20143bc775 CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Also in Version: 7.1.0.0.alpha0+ Build ID: 63bf8f042abe3c0f6989f6763d13f5389182b816 CPU threads: 16; OS: Linux 6.2; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded