Bug 82047

Summary: Delete row - Undo change range of cell name
Product: LibreOffice Reporter: ign_christian <ign_christian>
Component: CalcAssignee: Kohei Yoshida <kohei>
Status: RESOLVED FIXED    
Severity: major Keywords: regression
Priority: high    
Version: 4.2.0.0.beta1   
Hardware: x86 (IA32)   
OS: All   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=85304
Whiteboard: target:4.4.0 target:4.3.4
Crash report or crash signature: Regression By:

Description ign_christian 2014-08-02 08:35:03 UTC 
Not sure if it's been reported before, but I didn't find any.

Steps to reproduce:
1. In new spreadsheet, select cells A1:A2
2. Insert > Names > Define
3. Type: TEST in 'Name' > Add
4. Select row 2 > Right-click > Delete Selected Rows
5. Undo

Actual result: range for TEST changed to $Sheet1.$A$1:$A$3

Expected result: cell name TEST should keep $Sheet1.$A$1:$A$2 in range

Reproduced with: 4.2.0.0.beta1, 4.3.1.0.0+ Time: 2014-07-30_10:54:10

Not reproduced with: 4.1.6.2

*) Bug not occured if we delete row 1 in step 4

Tested on Ubuntu 12.04 32bit
Comment 1 A (Andy) 2014-08-02 10:34:48 UTC 
reproducible with LO 4.3.0.4 (Win 8.1)
Comment 2 ign_christian 2014-08-03 07:50:59 UTC 
(In reply to comment #0)
> 4. Select row 2 > Right-click > Delete Selected Rows

I guess the main problem is after doing step 4 above, range still in $Sheet1.$A$1:$A$2.

It should be $Sheet1.$A$1:$A$1
Comment 3 raal 2014-10-12 19:35:00 UTC 
problem with bibisect because in LO 4.2alpha manage names dialog doesn't show range. Lots of skiped commits.
Comment 4 Kohei Yoshida 2014-10-19 00:23:46 UTC 
I got this.
Comment 6 Kohei Yoshida 2014-10-19 00:27:47 UTC 
Basically what is said in Comment 2 was the problem.
Comment 7 ign_christian 2014-10-19 01:45:06 UTC 
Thanks Kohei.. You're the man :)
I'll test later with 4.3