Bug 107203 - Name box: copied named expressions not updated after renaming sheet
Summary: Name box: copied named expressions not updated after renaming sheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Sheet
  Show dependency treegraph
 
Reported: 2017-04-16 11:31 UTC by Oliver Brinzing
Modified: 2023-09-06 03:13 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
test case (7.86 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-04-16 17:22 UTC, Oliver Brinzing
Details
screenshoot after sheet2 is renamed (56.67 KB, image/jpeg)
2017-04-16 17:23 UTC, Oliver Brinzing
Details
different sheet names in pulldown "name field" and "insert name" dialog (70.57 KB, image/png)
2017-04-18 19:30 UTC, Sven
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Oliver Brinzing 2017-04-16 11:31:22 UTC
renaming a copied Sheet later does not update the "Name box" list.
a save & reload cycle will fix the problem.

steps to reproduce:
- add a global named range "Test" ($Sheet1.$A$1)
- copy Sheet1 to Sheet2
- Name box will show "Test" and "Test (Sheet2)"
- rename Sheet2 To SheetX
- Name box will still show "Test" and "Test (Sheet2)"
- Selecting "Test (Sheet2)" causes an error
- save and reload spreadsheet
- Name box will show "Test" and "TestX (Sheet2)"

btw: also noticed, selecting cell $Sheet1.$A$1 will show 
corresponding global named range "Test" in Name box, but 
selecting a local named range will not.
Comment 1 m_a_riosv 2017-04-16 15:58:03 UTC
I can't reproduce the error.
Version: 5.3.2.2 (x64)
Build ID: 6cd4f1ef626f15116896b1d8e1398b56da0d0ee1
CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; Layout Engine: new; 
Locale: es-ES (es_ES); Calc: group
Comment 2 Oliver Brinzing 2017-04-16 17:22:27 UTC
Created attachment 132611 [details]
test case

test case, after sheet1 is copied
Comment 3 Oliver Brinzing 2017-04-16 17:23:31 UTC
Created attachment 132612 [details]
screenshoot after sheet2 is renamed

screenshoot after sheet2 is renamed
Comment 4 Oliver Brinzing 2017-04-16 17:24:13 UTC
@m.a.riosv: are you sure?, i added a test case and a picture to show the problem
Comment 5 Sven 2017-04-18 19:30:54 UTC
Created attachment 132659 [details]
different sheet names in pulldown "name field" and "insert name" dialog

I can confirm this behaviour with LO Version: 5.3.0.1 and the attached document from Oliver
Build-ID: 3b800451b1d0c48045de03b5b3c7bbbac87f20d9
CPU-Threads: 4; BS-Version: Windows 6.2; UI-Render: Standard; Layout-Engine: neu; 
Gebietsschema: de-DE (de_DE); Calc: group

When I open the name field pulldown menu and select "Test (Sheet2)" the error message occurs.
Comment 6 Oliver Brinzing 2018-08-23 13:55:56 UTC
this bug is still reproducible with 
lo 6.1.0.3 and Version: 6.2.0.0.alpha0+ (x64)
Build ID: 991ff3d6205d8b594701c9df537cf8f0a629a92d
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: de-DE (de_DE); Calc: threaded

- add a global named range "Test" ($Sheet1.$A$1)
- copy "Sheet1" to "Sheet2"
- name box will only show "Test" (-> an update is missing)
- switch to print preview and back
- name box will now show "Test" and "Test (Sheet2)"
- goto "Sheet2" and select "Test" from Navigator/Name Box
- cursor will wrongly select A1 from "Sheet2" instead of Sheet1
Comment 7 QA Administrators 2019-09-02 09:22:46 UTC Comment hidden (obsolete)
Comment 8 Oliver Brinzing 2019-09-02 17:15:24 UTC
reproducible with:

Version: 6.4.0.0.alpha0+ (x64)
Build ID: 1c7fdf561bc924741a121439a6cb42f96f285b58
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: threaded
Comment 9 QA Administrators 2021-09-02 03:51:48 UTC Comment hidden (obsolete)
Comment 10 Oliver Brinzing 2021-09-05 10:43:00 UTC
Version: 7.1.5.2 (x64) / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded

- add a global named range "Test" ($Sheet1.$A$1)
- copy "Sheet1" to "Sheet2"
- name box will show "Test" and "Test (Sheet2)"
- goto "Sheet2" and select "Test" from Navigator/Name Box
- cursor will wrongly select A1 from "Sheet2" instead of Sheet1
Comment 11 QA Administrators 2023-09-06 03:13:58 UTC
Dear Oliver Brinzing,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug