https://bugs.documentfoundation.org/show_bug.cgi?id=156673
Bug ID: 156673
Summary: calc: Connect cell differs in version 7.x to previous
versions!
Product: LibreOffice
Version: 7.4.4.2 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: noss.oli...@gmail.com
Description:
Different behavior of versions 6.x to version 7.x for merged cells.
Names are no longer displayed in the upper left corner.
Alternative use of arrays leads to further problems.
Steps to Reproduce:
- use calc version 6.4.7.2 or earlier
- connect A1 with B1
- give the connection from A1:B1 the name: "_merge6".
- enter in cell D1: "=_merge6" + Enter
- 0" will be output
- enter "Text" in the connected cell
- "Text" will be output in D1
- save calc file (example.ods)
- open example.ods with version 7.x (7.5.4.2)
- put cursor on merged cell A1:B1
- you will see in the upper left corner not the name of the merged cells
("_merge6")
- now merge cells A4:B4
- assign names of merged cells ("_merge7")
- type in D4 "=_merge7" + Enter
- see error message #VALUE!
- you can see names of connected cells A4:B4 = _merge7, top left!
Hint:
- Range is stored with LO 6.x as $A$1 for "_merge6".
- Range is stored with LO 7.x as $A$4:$B$4 for "_merge7
See also here:
https://ask.libreoffice.org/t/lo-7-x-calc-name-von-verbundenen-zellen-matrixformel-ggf-bug/93852/10
Actual Results:
#VALUE!
Expected Results:
content of the variable
Reproducible: Always
User Profile Reset: Yes
Additional Info:
calc should still work as in version 6.x!
--
You are receiving this mail because:
You are the assignee for the bug.
