[Libreoffice-bugs] [Bug 134757] New: Text formating is removed on merge when content is not in first cell

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134757

            Bug ID: 134757
           Summary: Text formating is removed on merge when content is not
                    in first cell
           Product: LibreOffice
           Version: 6.1.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: bugs_documentfoundation_org.5.kuru at xoxy.net

Description:
When you enter data in a cell (eg A1), format it and then merge it (eg. with B1
and C1) the formating is kept.
When you enter data in a cell that is not the first cell of the combined ones
(eg. data in B2 and merge is A2 to C2) the formatting is removed.

Steps to Reproduce:
1. enter data in a cell that is not the first one of the merged cells (eg. B1)
and format it
2. select multiple cells (eg. A1 to C1) and merge them

Actual Results:
The formating (in the attached image it's font size 14 and bold font) is
removed when the cell is merged

Expected Results:
The formating is kept when the cell is merged


Reproducible: Always


User Profile Reset: No



Additional Info:
For attached image:
1)
- Data is entered in line 1 AFTER merge in cell A1-C1
- Data is entered in line 3 BEFORE merge in cell A3
- Data is entered in line 5 BEFORE merge in cell B5

2)
- No format loss since the format is set after the merge
- No format loss on merge
- Format is LOST ON MERGE (since the format is kept when the data is entered in
the first column, I would expect to see the same for data in the second column)

----

When you unmerge the cells (eg. A1 to C1, data in B1), the data is moved to the
first cell (here A1), but the cell where the information was originally taken
from (here B1) still has the original formation.

If you have multiple cells with data (eg. A1 with bold text, B1 with red text
and C1 with yellow background) and merge them (mode to combine data in the
first cell), the formating of the first cell is used. When the cell is
unmerged, the content is moved to the first cell (here A1), but the other cells
(here B1 and C1) keep their formating. This makes sense since you may would
have to combine multiple values for the same setting (eg. font size 12 and font
size 14)

If you use the option to delete the content of the hidden cells, the hidden
cells (here B1 and C1) actually keep their formating even though their content
is deleted.

If you combine one cell with data with multiple cells with no data and no
format I would expect calc to copy the format.
If you combine one cell with data with multiple cells with no data but
formating I have no idea what I would expect. Maybe calc asking me what I want
to keep? But it would maybe faster to just set the formating like it was
before.

----

Version: 6.4.4.2 (x64)
Build-ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff
CPU-Threads: 6; BS: Windows 6.1 Service Pack 1 Build 7601; UI-Render: Standard;
VCL: win; 
Gebietsschema: de-AT (de_AT); UI-Sprache: de-DE
Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200712/006ad4fc/attachment-0001.htm>