https://bugs.documentfoundation.org/show_bug.cgi?id=163888
Bug ID: 163888
Summary: When replacing cell styles, the target address of the
active sheet is also applied to other sheets
Product: LibreOffice
Version: 3.5.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
In Calc, when you try to use the "Find and Replace" dialog to search for a
"Cell Style" in all sheets and replace it with another style, the style is
mistakenly applied to the corresponding cell addresses in the active sheet of
sheets that contain the searched style, in addition to the corresponding cells
in the active sheet.
Steps to Reproduce:
1.Enter ”AAA” in Sheet1.A1
2.Apply style “Heading 1”
3.Copy Sheet (-> sheet1_2)
4.Insert a row above.(sheet1_2.A2 is AAA)
5.Activate Sheet1 & Ctrl + H
6.Check "Cell styles" and "All sheets".
7.Find: “Heading 1”, Replace: “Accent 1”
8.[Replace All] 2 times.(tdf#112321)
If the button is grayed out, you can enable it by checking/unchecking
"Formatted display".
Actual Results:
The "Accent 1" style is applied to sheet1.A1 (correct)
The "Accent 1" style is applied to sheet1_2.A1 (incorrect)
The "Heading 1" style remains on sheet1_2.A2
Expected Results:
The "Accent 1" style will be applied to sheet1.A1 and sheet1_2.A2.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 24.2.7.2 (X86_64) / LibreOffice Community
Build ID: ee3885777aa7032db5a9b65deec9457448a91162
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: CL threaded
good
LibreOffice 3.4.5
OOO340m1 (Build:502)
bad
LibreOffice 3.5.0rc3
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735
--
You are receiving this mail because:
You are the assignee for the bug.
