https://bugs.documentfoundation.org/show_bug.cgi?id=98990
Bug ID: 98990 Summary: Defining a named range for complete column or row results in broken expression Product: LibreOffice Version: 5.1.1.3 release Hardware: x86-64 (AMD64) OS: Mac OS X (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: brad...@bradleysepos.com Created attachment 123963 --> https://bugs.documentfoundation.org/attachment.cgi?id=123963&action=edit named-expression-bugs.ods In the attached Calc spreadsheet, I can no longer define a name for a row or column. Steps to reproduce (tested LO 5.1.1.3 on OS X 10.10.5 Yosemite): 1. Select row 53 in its entirety by clicking its row number. In the Name Box, attempt to define a new name by typing "NonTaxableIncome". The name will be defined improperly as budget!r53 instead of Budget!R53 and will not function. Modifying the definition to Budget!R53:R53 works (per https://bugs.documentfoundation.org/show_bug.cgi?id=98970#c2). 2. Attempt to define a column name similarly. Same issue. Other issues with the document are likely related to fdo#93894/fdo#98970 -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs