https://bugs.documentfoundation.org/show_bug.cgi?id=158859
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from [email protected] --- Created attachment 191794 --> https://bugs.documentfoundation.org/attachment.cgi?id=191794&action=edit Example define name with discontinue ranges Select the ranges A2:A3 and C3:C4 Write a name for it, the error is: "The selection needs to be rectangular in order to name it." Use the menu Sheet - Named Ranges and Expressions - Define Name: joined Range or formula expression: $Sheet1.$A$2:$A$3~$Sheet1.$C$3:$C$4 Push button OK. We expect that by giving a name to a discontinuous range the Calc program will create the name and join the different ranges with the combine sign: ~ -- You are receiving this mail because: You are the assignee for the bug.
