https://bugs.documentfoundation.org/show_bug.cgi?id=137577
Bug ID: 137577
Summary: UI: resolve ambiguity for 'named ranges' with
identical name and different scope
Product: LibreOffice
Version: 3.5.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: newbie...@gmx.de
Description:
@erAck solved a problem with the 'name box' not showing a name when selecting a
range with a name with scope 'local' in tdf#67007, there are some shortcomings,
left ones and new,
consider a sheet 'sheet1' with two named ranges, both named test, one with
scope 'global', one with scope 'sheet1' (regardlees if it's a good idea from a
user to use such, it's possible and will occur),
- selecting either of theese ranges will display 'test' in the name box (since
ver. 7.1), without hint which of them it is, users may be irritated checking
the 'global' range being 'test', and the formula '=sum(test)' producing 'wrong'
results, as it calculates the sum of 'test(sheet1)',
- clicking the name box will offer two ranges, 'test' and 'test(sheet1)',
clicking either of theese names will select the local range which is wrong for
te global range, users may get the impression that the local range has the name
of the local range,
- the 'global range' test is not 'addressable' while in an sheet which has a
local named range with identical name,
- copying parts of a sheet which completely covers a named range doesn't carry
that name to the new destination, neither for local nor global names,
- moving parts of a sheet which completely covers a named range doesn't carry
that name to the new destination, neither for local nor global names,
- the range adressed by the former name is changed to the new destination, but
selecting the covered range on the new sheet doesn't show a name in the name
box,
- references in formulas pointing to that range are changed
'old-sheet-name.test', and do work,
- undo of such actions sometimes doesn't bring the name back,
- copying such sheet with 'move or copy sheet' runs into a conflict that it
normally stays with the name for the global range and converts it to scope
local , that would result in two identical names with identical scope on one
sheet,
- instead names like test(sheet1_2) are created when copying to 'sheet2', and
selecting that name from the name box results in an error 'you must select a
valid name ...',
- after above copy the 'global range' on the new sheet has no name,
solution? i don't know,
- show name with 'scope' in named box when a named range is selected,
- make global ranges select- / addressable by the label 'name(global)',
- forbid the use of identical names for local and global ranges? at least for
being on the same sheet,
i'm unsure if this description covers all curiosities,
to stay calm, ex$el (tested '2010') is confused with such nonsense too, it
offers names as 'book1.test' for the global range and changes it in formulas to
'sheet1.test', then calculating the local range ...
Steps to Reproduce:
see description above, try to handele two ranges test(sheet1) and test(global)
on the same sheet, and copying that sheet,
Actual Results:
shortcomings as in description
Expected Results:
consistent handling, avoiding constructions which can't be handeled, or
meaningful warnings and error message,
Reproducible: Always
User Profile Reset: Yes
Additional Info:
tested ver. 3.5.1.2, 6.1.6.3, 7.1.0.0.a0+
--
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
