https://bugs.documentfoundation.org/show_bug.cgi?id=100602
Bug ID: 100602
Summary: EDITING: Expressions with global scope shouldn't be
copied to a local scope, when a sheet is copied.
Released notes 5.2
Product: LibreOffice
Version: 5.2.0.0.beta2
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 125898
--> https://bugs.documentfoundation.org/attachment.cgi?id=125898&action=edit
Tes file to copy global local named expressions
https://wiki.documentfoundation.org/ReleaseNotes/5.2#Copying_named_expressions_and_ranges_while_copying_sheets
IMO when a sheet is copied to a new one, shouldn't create a copy of named
expressions having global scope to one with local scope.
Name Expression Scope
global $Sheet1.$A$1 Document (Global)
global $NewSheet.$A$1 NewSheet XXXXXXXXXXXX -> not create
global_global global*100 Document (Global)
global_global global*100 NewSheet XXXXXXXXXXXX -> not create
global_local Sheet1.local*1000 Document (Global)
global_local local*1000 NewSheet XXXXXXXXXXXX -> not create
local $Sheet1.$A$2 Sheet1
local $NewSheet.$A$2 NewSheet
local_global global*10000 Sheet1
local_global global*10000 NewSheet
local_local Sheet1.local*100000 Sheet1
local_local local*100000 NewSheet
global $NewSheet.$A$1 NewSheet
global_global global*100 NewSheet
global_local local*1000 NewSheet
Having a formula that has a named expression with global scope, what I expect
when the cell is copied, is the references to the named expression (global)
remaining without change, like happens doing an ordinary copy of cells between
sheets.
I don't think it's fine allowing global and local expressions with the same
name
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
