[Libreoffice-bugs] [Bug 130371] New: calc: editing: ui: weakness with named ranges, copying of cell to another sheet creates name reference not in dropdown, and not 'undone' with undo of copy,

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=130371

            Bug ID: 130371
           Summary: calc: editing: ui: weakness with named ranges, copying
                    of cell to another sheet creates name reference not in
                    dropdown, and not 'undone' with undo of copy,
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: newbie-02 at gmx.de

Description:
@Xisco: sorry, i was asked bei Eike to open a new bug, pls. do not! close as
dup of #81330. 

the sheet attached to #81330: 

https://bugs.documentfoundation.org/attachment.cgi?id=102780

shows more weaknesses, no. 2: 

copying of sheet2.A3:B3 creates a name reference 'value' to $sheet4.$B$2, with
the 'scope' sheet4, that is – sometimes – not shown in the name reference
select box below the font type box, but on 'editing named ranges' by ctrl-F3, 

no. 2a: 

this name reference is not 'undone' with ctrl-Z if you undo the step which
produced it. 

additional amendments: 

in the comments at #81330 and in the procedure described in the sheet are some
errors? the description given into the attachement suggests copying of B2, imho
it was intendedto refer to B1, it's advised to 'copy' B2, imho it was intended
to move B1?

if above problems are covered elsewhere feel free to ad a comment pointing
there and close this bug,

reg. 

b. 

Steps to Reproduce:
see comments above

Actual Results:
name reference 'value' on sheet4 not shown in 'name-select-dropdown-box', name
reference 'value' on sheet4 not reverted by undo, 

Expected Results:
name reference 'value' on sheet4 should be shown in 'name-select-dropdown-box',
name reference 'value' on sheet4 should be deleted on undo of the step which
produced it, 


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.4.0.3 (x64)
Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200202/462b815d/attachment-0001.htm>