https://bugs.documentfoundation.org/show_bug.cgi?id=98990
raal <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW CC| |[email protected] Summary|Defining a named range for |Defining a named range for |complete column or row |complete column or row |results in broken |results in broken |expression |expression (Formula syntax | |= ExcelR1C1) Ever confirmed|0 |1 OS|Mac OS X (All) |All --- Comment #1 from raal <[email protected]> --- It's excel syntax. Tools > options > Calc > Formula > Formula syntax = ExcelR1C1 I can confirm with Version: 5.2.0.0.alpha0+; win7 select row53 > menu Insert > Name expression > Define create range Budget!R53 This name doesn't work, when I change range to Budget!R53>R53 then name works. Formula syntax =excel A1 : Budget!$53:$53 -> correct -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
