https://bugs.documentfoundation.org/show_bug.cgi?id=156673
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|calc: Connect cell differs |Merged cells defined name |in version 7.x to previous |display and creation |versions! |differs in version 7.x to | |previous versions Status|UNCONFIRMED |NEW Hardware|x86-64 (AMD64) |All Severity|normal |enhancement Ever confirmed|0 |1 --- Comment #2 from Eike Rathke <[email protected]> --- What's happening when the merged cell A4:B4 is active when assigning a name in the Name Box is that the name then references the cell range $Sheet1.$A$4:$B$4. That is correct. If such range reference (name or not) is used anywhere but in column A or B then there is no implicit intersection of the formula cell position and the range referenced, which leads to a #VALUE! error. That is also correct. The change to older versions was that the active cell cursor actually selects the merged cell range, not just the top left cell. Hence also for the selected A1:B1 range, which a previous version did not, and for that range is no name defined thus no name displayed. We could display an already existing top left cell name for such merged cell. We could but probably should not create a named single cell reference when a merged cell is active, as a selection of A4:B4 creating a name just for A4 would be unexpected. Defining a name for a single cell is still possible through the Name Manager. Bear in mind that hidden cells of a merged range still exist and could have content, and also could have other names defined. -- You are receiving this mail because: You are the assignee for the bug.
