https://bugs.documentfoundation.org/show_bug.cgi?id=172349
Bug ID: 172349
Summary: Formula pointing to cell of merged cell area has not
the value of merged cell
Product: LibreOffice
Version: 25.8.6.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 207348
--> https://bugs.documentfoundation.org/attachment.cgi?id=207348&action=edit
spreadsheet with two examples of the behaviour that will derive of this bug.
Steps to reproduce:
1. create a area of merged cells (vertically) and set a value on that merged
cell (example merge A10:15)
2. create a formula in the vertically topmost cell next to the merged cell area
(example Value in B10 '=A10')
3. copy the formula in B10 down to cells from B11:B15 with dragging in lower
right edge
4. The vertically topmost formula will correctly solve to value of merged cell
area, the cells below (B11:B15) will not solve to value of merged cell.
see also attached spreadsheet with example.
In my opinion this is a major problem when working with formulas in
spreadsheets that has merged cells. I expected that when i set the reference to
a merged cell, all of the merged cells (in example A10:A15) will have the value
that is showed for the merged cell.
Currently the behaviour is that only the topmost cell has the value that is
entered for the merged cell area and other cells will, depending on the way
what the state of the merged cells is before they where merged (with values or
without) and what type of merge is used. If values was previously present in
cells of the merged cell area and are preserved during merging, the values
wouldn't be showed but used for calculation. I think this is very problematic
approach.
I think (i'm not familiar with the data structure of ods files) a solution
wouldn't be very expensive. During merge with not preserving present data, all
of the merged cells will get a value (possibly a formula) that is like a
pointer to the first cell of the merged cell area that hold the value that is
showed for the whole merged cell area.
--
You are receiving this mail because:
You are the assignee for the bug.
