[Libreoffice-bugs] [Bug 138082] New: Merged Cells adopt the format of the first cell instead of the cell with contents

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 138082
           Summary: Merged Cells adopt the format of the first cell
                    instead of the cell with contents
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: that.man.colin at gmail.com

Version: 6.4.6.2 (x64)
Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: default; VCL: win; 
Locale: sv-SE (en_GB); UI-Language: en-GB
Calc: threaded

If a small array of say three horizontal cells contains formatted data ONLY in
the centre cell then selecting the two adjacent cells to [Merge & Centre Cells]
with the "filled" cell adopts the format of the first cell in the selected
range and ignores the format implied by the only data contained in the selected
range.

1 Type in any empty cell "Lucida 16pt"
2 Select that cell and change the format to Lucida Handwriting 16pt
3 Select the range including the adjacent cell on either side and [Merge &
Centre Cells]
4 Observe that the format reverts to whatever is the format of the first cell
in the range
5 With the range selected, access the font menu with the down chevron and the
Lucida font will magically identify itself as the cell format and the displayed
format will change to Lucida - but only until the chevron is released
6 Expunge the [Merge & Centre Cells] format and the contents jump into the
first cell of the range and revert to default format.

The same effect is apparent with a vertically adjacent range of cells.
The same effect is apparent if the "filled" cell is at either extremity of the
[Merge & Centre Cells] range
If two cells contain data then the merge rules are handled correctly BUT all
cells will adopt the "first cell" format. This is the Dichotomy - How should
two alternate formats be treated? It's only a conundrum if more than two
formats exist ;)))

-- 
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/20201109/1bb98702/attachment.htm>