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.