https://bugs.freedesktop.org/show_bug.cgi?id=87474
Bug ID: 87474
Summary: EDITING: Changing the name of a named range breaks
references to it in formula
Product: LibreOffice
Version: 4.3.4.1 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
I have the following formula in a sheet:
=INDEX(MonthNumbers;MATCH($E$3;MonthNames;0);1)
If I change the named range MonthNames to MonthName, the formula breaks, does
not get updated, and becomes:
=INDEX(MonthNumbers;MATCH($E$3;monthnames;0);1)
Cell E3 has a text value of "November".
In other contexts, like when using cell range validation, the reference to
named range is updated correctly.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
