https://bugs.documentfoundation.org/show_bug.cgi?id=167824
Bug ID: 167824
Summary: SIDEBAR Setting General format for multiple formatted
cells does not work
Product: LibreOffice
Version: 4.2.0.4 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 112631
Created attachment 202194
--> https://bugs.documentfoundation.org/attachment.cgi?id=202194&action=edit
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 <[email protected]> 2024-12-23 11:13:26
+0500
committer Adolfo Jayme Barrientos <[email protected]> 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.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=112631
[Bug 112631] [META] Number format content panel of the Properties deck/tab of
the sidebar
--
You are receiving this mail because:
You are the assignee for the bug.
