Steps to reproduce:
1. Delete a sheet or copy a sheet to a new location (except last sheet)
2. Menus > Insert > Names > Define
3. The sheet name of reference of the selected area name limited one sheet was change "$#REF!".
And the position of the sheets slips off.
Operating System: Mac OS X
Version: 22.214.171.124 release
Please attach a sample file, where to verify the issue.
Created attachment 87342 [details]
Created attachment 87343 [details]
Please check two files, Before.ods and After.ods
Created attachment 87344 [details]
Please check two files,Before.ods and After.ods
----- Original Message -----
>From: "email@example.com" <firstname.lastname@example.org>
>Date: 2013/10/9, Wed 06:07
>Subject: [Bug 70284] EDITING: "Assinged to" of Names change to "$#REF!"
> mariosv changed bug 70284
>Status UNCONFIRMED NEEDINFO
>Ever confirmed 1
>Comment # 1 on bug 70284 from mariosv
>Please attach a sample file, where to verify the issue.
> You are receiving this mail because:
> * You reported the bug.
Created attachment 87345 [details]
Created attachment 87346 [details]
Created attachment 87347 [details]
Version 126.96.36.199 (Build ID: 7168152d13aa529ba3718c9ae3700216a574137)
Version: 188.8.131.52.0+ Build ID: 952c5fe20d5975c8a2c9f5093d05472ca0fc78f
And a second issue undo delete sheet, doesn't recover the name range address.
Added to MAB 4.0
Created attachment 87499 [details]
a before file with Define window capture
This is a before file with Define window capture
Created attachment 87500 [details]
a file with Sheet copy.
I upload a file with Sheet copy.
I upload a file with Sheet copy. and upload a before file with Define window capture.
When the number of the seats increased and decreased,
I think that the address of the seat slips off by the seat which I add it and deleted.
When I deleted a seat of the end or added a seat to the end, this phenomenon does not occur.
fixed typo in summary notes
(This is an automated message.)
Setting priority to highest as this is a 4.0 MAB. This is part of an effort to make the importance of MAB reflected in priority too.
I just tested this against the latest from the 4.2 branch, and I can no longer reproduce it. I guess I have accidentally fixed this while reworking the handling of formula references during the 4.2 development cycle.