Problem description: 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. Current behavior: Expected behavior: Operating System: Mac OS X Version: 4.1.1.2 release
Please attach a sample file, where to verify the issue.
Created attachment 87342 [details] Before
Created attachment 87343 [details] After file
Please check two files, Before.ods and After.ods
Created attachment 87344 [details] attachment-30985-0.html Please check two files,Before.ods and After.ods ----- Original Message ----- >From: "bugzilla-daemon@freedesktop.org" <bugzilla-daemon@freedesktop.org> >To: yachiyo621@yahoo.co.jp >Date: 2013/10/9, Wed 06:07 >Subject: [Bug 70284] EDITING: "Assinged to" of Names change to "$#REF!" > > > mariosv changed bug 70284 > >What >Removed >Added >Status UNCONFIRMED NEEDINFO >CC mariosv@miguelangel.mobi >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] attachment-30985-1.dat
Created attachment 87346 [details] After.ods
Created attachment 87347 [details] Before.ods
Hi yachiyo621. Reproducible. Win7x64Ultimate. Version 4.0.6.1 (Build ID: 7168152d13aa529ba3718c9ae3700216a574137) Version: 4.1.3.0.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.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.