Bug 82047 - Delete row - Undo change range of cell name
Summary: Delete row - Undo change range of cell name
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: x86 (IA32) All
: high major
Assignee: Kohei Yoshida
Whiteboard: target:4.4.0 target:4.3.4
Keywords: regression
Depends on:
Reported: 2014-08-02 08:35 UTC by ign_christian
Modified: 2014-10-23 02:17 UTC (History)
0 users

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
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:, Time: 2014-07-30_10:54:10

Not reproduced with:

*) 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 (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