Bug 39916 - There is no way to rename a defined name range (EDITING)
Summary: There is no way to rename a defined name range (EDITING)
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.2 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Whiteboard: target:3.5
Keywords: regression
Depends on:
Reported: 2011-08-07 21:26 UTC by James
Modified: 2011-09-23 09:59 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description James 2011-08-07 21:26:12 UTC
If you go to the Insert->Names->Define menu, you will see that you cannot rename a named range. You can only delete the old one and enter a new one. This gets very, very annoying if that range is used in many places on a spreadsheet, because you have no choice but to manually edit each and every cell that used the old name. Note that LO already keeps track of each cell that uses a named range, just in case the range's value has changed.
Comment 1 domi 2011-09-15 06:12:34 UTC
impossible in 3.4.3 too

REGRESSION from 3.3.4
works fine with 3.3.4 where you can rename without error

maybe linked with https://bugs.freedesktop.org/show_bug.cgi?id=40909
crash when updating name's range
Comment 2 Markus Mohrhard 2011-09-23 09:59:28 UTC
Will be solved in 3-5 with new range name dialog concept