Bug 128014 - Cloning a merged cell formatting to a range then unmerging the target range resets some cells in the range to default format
Summary: Cloning a merged cell formatting to a range then unmerging the target range r...
Status: RESOLVED DUPLICATE of bug 43958
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.2.2 release
Hardware: All All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-10-08 09:36 UTC by Mike Kaganski
Modified: 2022-06-03 11:30 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2019-10-08 09:36:27 UTC
1. In a new spreadsheet, select all (Ctrl+A) then change font name and size (e.g., to Arial 14, direct formatting)
2. Select A1:A2, and merge them (Merge and Center Cells, e.g. on toolbar)
3. Keeping the selection, set cell background to e.g. red;
4. Keeping the selection, double-click (to make it repeated) Clone Formatting (Paintbrush) tool
5. Click B1 -> B1 and B2 are now merged and red
6. Click-and-drag C1:C2 -> C1 and C2 are now merged and red
7. Unmerge B1:B2
8. Unmerge C1:C2
9. Compare formatting of B2 and C2.

B2 now has the formatting it had before step 5, i.e., the one applied at step 1 (Arial, 14).
C2 now has default formatting (the one before step 1).

So the results of application of the Clone tool are inconsistent and depend on if it was applied "across the merge direction", clearing direct formatting of hidden cells.

Tested with Version: 6.3.2.2 (x64)
Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c
CPU threads: 12; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded
Comment 1 m_a_riosv 2019-10-08 18:32:30 UTC
I think a dup of https://bugs.documentfoundation.org/show_bug.cgi?id=86143, the same problem with dragging.
Comment 2 Mike Kaganski 2019-10-08 20:35:17 UTC
(In reply to m.a.riosv from comment #1)

I cannot actually be sure that the underlying issue is not the same; yet, the manifestations are rather different, so I propose to keep the two distinct for the time being, and just re-test when the other is fixed.
Comment 3 m_a_riosv 2019-10-08 21:07:57 UTC
Reproducible
Version: 6.3.2.2 (x64)
Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US Calc: 

But maybe when dragging with paintbrush C1:C2, not should be C1:C2 unmerged and C2:C3 merged?
Comment 4 QA Administrators 2021-10-08 03:52:22 UTC Comment hidden (obsolete)
Comment 5 Timur 2022-06-03 11:30:19 UTC
Fixed in 7.1 with https://git.libreoffice.org/core/commit/605b4ba57b2daa447af9d43d3759079e15df8148

*** This bug has been marked as a duplicate of bug 43958 ***