[Libreoffice-bugs] [Bug 81435] Names lose reference information when copying cell ranges

[bugzilla-daemon at bugs.documentfoundation.org]

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

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |newbie-02 at gmx.de

--- Comment #16 from b. <newbie-02 at gmx.de> ---
Created attachment 157283
  --> https://bugs.documentfoundation.org/attachment.cgi?id=157283&action=edit
a_map/sheet_with_name_reference_fails

hi, 

while reviewing this thread i saw something left from the problem, 

i produced a simplified testsheet to recheck, see attachement, 

the issue is 'inspired' by the fail from comment #10: 

"There is an additional strange effect: Move the cells in Sheet2_2.A3:C7 to
Sheet2_1.A1:C14 using CTRL+X and CTRL+V. Then cell C14 shows a zero value. ...
" 

problem: the name-reference is changed on move, but not rechanged on undo. 

it's two issues, one for moving into one sheet, another for moving to another
sheet, the steps to reproduce the issue are noted in the sheet, copied here: 

A) name references messed up by moving of content into the sheet and undo       
steps to reproduce              
1.      check name reference 'testfield_1' to sheet1.B2 (hit ctrl-F3), scope of
reference: sheet1       
2.      move sheet1.B2:sheet1.B3 to sheet1.C2:sheet1.C3 (ctrl-X, ctrl-V)        
3.      check new name reference 'testfield_1' with target C2 and scope sheet1, 
                in the lower part of the box 'ctrl-F3' the scope is announced
as global!
4.      undo move – ctrl-Z – ctrl-Z     
5.      check result in sheet1.B3: '=#NAME?'    
                despite 'testfield_1' still defined, but pointing to $C$2
                imho the change by the move should be undone by undo
(if you undo the move by another move with exchanged source-target references
are handeled correctly)           

B) name references messed up by moving of content to another sheet and undo     
steps to reproduce              
1.      check name reference 'testfield_1' to sheet1.B2 (hit ctrl-F3), scope of
reference: sheet1       
2.      move sheet1.B2:sheet1.B3 to sheet2.B2:sheet2.B3 (ctrl-X, ctrl-V)        
3.      check new name reference 'testfield_1' with scope sheet2,       
3a.     check old reference with scope sheet1 remains, but now points to new
location (on sheet2)       
4.      check result in sheet2.B3: '=#NAME?'    
5.      undo move – ctrl-Z – ctrl-Z     
6.      check sheet1.B3 result now '0', it still references to testfield_1 on
sheet2    
                test by input number to sheet2.B2
7.      remove name reference testfield_1 from sheet2   
8.      observe result in sheet1.B3 unaffected,         
9.      change value in sheet2.B2       
10.     observe sheet1.B3 still calculating with the removed reference  

(if you undo the move by another move with exchanged source-target references
are NOT handeled correctly)               

would be nice if someone rechecks, and if confirmed finds somebody to correct
the fault, 

if - in this case - an experienced forum member would prefer a new case instead
of poking around in old stuff ... feel free to re-close this and open a new
one. 

reg. 

b.

-- 
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/20200120/f898ba24/attachment.htm>