https://bugs.documentfoundation.org/show_bug.cgi?id=100602
--- Comment #8 from royerjy <[email protected]> ---
(In reply to m.a.riosv from comment #7)
> (In reply to Eike Rathke from comment #5)
> > (In reply to m.a.riosv from comment #0)
> > > 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.
> >
> > Note that a global name is only copied to a local name if it references the
> > same sheet that you are copying. This is because you're duplicating also the
> > data it references.
>
> I think I understand how it does, but if I want that behavior I can set the
> NamExp as local, so local is copied as local. But global copied as local,
> sorry I can't agree.
>
> >
> > > I don't think it's fine allowing global and local expressions with the
> > > same
> > > name
> >
> > That's perfectly fine and also allowed in other spreadsheet applications.
>
> IMHO only a source of mistakes.
I agree with all m.a.riosv remarks. How can we use names in macros with this
behaviour ?
May be is it necessary to adopt new rules, like : never, never, create global
and local names in a sheet witch has to be copied ? Is that already explain
somewhere ? In this case, an alert would be helpful when copying a global name.
Global names must be created only in special sheets or directly in names.
--
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
