hello @Haagen,
[i deleted my first answer as @erAck’s comment opened more capa]
[‘delete’ an answer in ‘ask’ is funny, you are offered a ‘edit’ box, and after saving that edit it’s gone … ]
the question remians me about a jewish joke / wisdom: for a celebrity every jewish woman is supposed to light two candles, a poor woman asks the rabbi if it is enough if she stands in front of a mirror with one candle … Answer: ‘no, it would be two candles … but also two Jewish women’,
calc has at least four sorts of ranges, ‘defined database ranges’ [data - define range], named ranges (global), named ranges ‘per sheet’ (property ‘scope’ in ‘manage names’, ctrl-F3) and automatically created “anonymous_db’s”, they are all somewhat different,
it is! possible to have multiple named ranges with identical names but different scopes, and a ‘defined range’ with identical name to a ‘named range’, and it becomes difficult to decide which of them is referenced in a formula (if found on sheet then that, else global), and it is! one of the entrances to the hell of confusion,
as it’s ambigous to have identical names with identical scope (global) for different areas, calc ‘shrinks’ the scope to ‘sheet’ when copying a sheet, and formulas will use that reference as it has precedence over global definitions,
thus calc manages a survive of referencing by ‘named ranges’ over the copying of sheets …
leftover from the question is why the names of ranges don’t automatically appear in the ‘name box’ anymore, that even happens if you manually change the scope of a range from global to sheet, it looks as if names with ‘sheet scope’ are excluded from that … enhancement request?
hidden anonymous DB areas - "__Anonymous_Sheet_DB__0"
- of which one per sheet is created by calc in the background when needed, are handled by creating e.g. "__Anonymous_Sheet_DB__1"
on the new sheet, they also survive,
no survival concept exists - afaik - for areas defined by [data - define range], they are omitted when copying sheets, thus e.g. filters defined for them are shown but do not work in the copied sheet, and are gone after save-load - enhancement request?
thus it’s possible to make nearly! identical copies, calc handeles it to a very far extent,
[/edit]
reg.
b.