[Libreoffice-bugs] [Bug 130370] New: calc: editing: ui: weakness with named ranges, move of cell to another sheet destroys referencing to local name reference there

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 130370
           Summary: calc: editing: ui: weakness with named ranges, move of
                    cell to another sheet destroys referencing to local
                    name reference there
           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. 1: 

in the attachement the move of sheet2.B1 to sheet3.B1 destroys the referencing
to 'value' (which points to sheet3.B2) in cell sheet3.B3, after the move of B1
sheet3.B3 shows =#NAME? with ver. 6.4.03. unpar. and ver. 7.0.0.0.alpha1+ 

retyping '=value' in sheet3.B3 helps out, hard recalc doesn't 

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 referenced sheet and comments above

Actual Results:
cell sheet3.B3 switching to =#NAME? on move of sheet2.B1 to sheet3.B1

Expected Results:
cell sheet3.B3 holding it-äs reference to 'value' (cell sheet3.B2)


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/6370d644/attachment.htm>