Created attachment 202194 [details] Example file from Calc In the attached file the cells B1:C1 are formatted as text, B2:C2 are formatted as number. When two cells with different formats are selected and in the sidebar the number format is set to General, there is no format change. Changing the format from the Format Cells dialog or with the toolbar command "Format as General" works. 1. Open attached file 2. Select B1:B2 cells 3. Press Ctrl+1 to open the Format Cells dialog 4. Select the Numbers tab -> Category: All -> Format: Standard ; press OK -> The cells format changes to General, values are shown as 12000 and 34000 5. Select C1:C2 cells 6. In the Properties sidebar, Number Format pane select the General option from the dropdown menu -> The cells format does not change, C1 is still Text, C2 is still a number shown as 34 000,00 Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 7f4868348c14b305fcd75744e1e3544d0d3a5d61 CPU threads: 14; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: threaded and all the way back to 4.2 when the sidebar feature was addded to Calc. The behavior of the Format Cells dialog was similar until 25.2 commit: https://cgit.freedesktop.org/libreoffice/core/commit/?id=f58d07397bd90c16c7b4d576ec9b4e6ee7ee367e author Mike Kaganski <mike.kaganski@collabora.com> 2024-12-23 11:13:26 +0500 committer Adolfo Jayme Barrientos <fitojb@ubuntu.com> 2024-12-24 12:18:24 +0100 commit f58d07397bd90c16c7b4d576ec9b4e6ee7ee367e (patch) tdf#42989: don't set fake ATTR_VALUE_FORMAT for multi-format selection --- Something similar would be needed for the sidebar as well.
Created attachment 202195 [details] The example file before changing cell formats
Created attachment 202196 [details] The example file after changing the formats Changing format of B1:B2 worked from the Format Cells dialog, C1:C2 did not from the sidebar.
Created attachment 202199 [details] Screenshot selecting currency on the sidebat.
Version: 25.2.5.2 (X86_64) / LibreOffice Community Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Not reproducible also with Version: 25.8.1.0.0+ (X86_64) / LibreOffice Community Build ID: cf39db5b97e665c47271a5679518a2fa9941be74 CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded NEITHER Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 7f4868348c14b305fcd75744e1e3544d0d3a5d61 CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded