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