Bug 70284 - EDITING: "Assigned to" of Names change to "$#REF!"
Summary: EDITING: "Assigned to" of Names change to "$#REF!"
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.6.1 rc
Hardware: Other All
: highest normal
Assignee: Not Assigned
URL:
Whiteboard: BSA target:4.2.0
Keywords:
Depends on:
Blocks: mab4.0
  Show dependency tree / graph
 
Reported: 2013-10-08 14:22 UTC by yachiyo621
Modified: 2014-02-07 14:56 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Before (7.93 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-10-09 14:49 UTC, yachiyo621 		Details
After file (6.59 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-10-09 14:49 UTC, yachiyo621 		Details
attachment-30985-0.html (3.71 KB, text/html)
2013-10-09 14:53 UTC, yachiyo621 		Details
attachment-30985-1.dat (1 bytes, multipart/alternative)
2013-10-09 14:53 UTC, yachiyo621 		Details
After.ods (6.59 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-10-09 14:53 UTC, yachiyo621 		Details
Before.ods (7.93 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-10-09 14:53 UTC, yachiyo621 		Details
a before file with Define window capture (57.03 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-10-12 03:45 UTC, yachiyo621 		Details
a file with Sheet copy. (49.85 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-10-12 03:46 UTC, yachiyo621 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description yachiyo621 2013-10-08 14:22:59 UTC 
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
Comment 1 m_a_riosv 2013-10-08 21:07:51 UTC 
Please attach a sample file, where to verify the issue.
Comment 2 yachiyo621 2013-10-09 14:49:28 UTC 
Created attachment 87342 [details]
Before
Comment 3 yachiyo621 2013-10-09 14:49:56 UTC 
Created attachment 87343 [details]
After file
Comment 4 yachiyo621 2013-10-09 14:51:01 UTC 
Please check two files, Before.ods and After.ods
Comment 5 yachiyo621 2013-10-09 14:53:18 UTC 
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.
>
>
Comment 6 yachiyo621 2013-10-09 14:53:19 UTC 
Created attachment 87345 [details]
attachment-30985-1.dat
Comment 7 yachiyo621 2013-10-09 14:53:19 UTC 
Created attachment 87346 [details]
After.ods
Comment 8 yachiyo621 2013-10-09 14:53:19 UTC 
Created attachment 87347 [details]
Before.ods
Comment 9 m_a_riosv 2013-10-09 20:53:12 UTC 
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
Comment 10 yachiyo621 2013-10-12 03:45:52 UTC 
Created attachment 87499 [details]
a before file with Define window capture

This is a before file with Define window capture
Comment 11 yachiyo621 2013-10-12 03:46:33 UTC 
Created attachment 87500 [details]
a file with Sheet copy.

I upload a file with Sheet copy.
Comment 12 yachiyo621 2013-10-12 03:52:51 UTC 
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.
Comment 13 tommy27 2013-12-31 12:07:19 UTC 
fixed typo in summary notes
Comment 14 Björn Michaelsen 2014-01-17 09:58:26 UTC 
(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.
Comment 15 Kohei Yoshida 2014-02-07 14:40:22 UTC 
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.