Sheet contains sheet-local references to named ranges. If that sheet is copied and placed at the very beginning *and* deleted again, the references in original sheet become corrupt.
The same happens if the copied sheet is placed at the end and the original sheet is deleted. In that case the references in copied sheet become corrupt.
I will upload a minimal example spreadsheet.
The bug seems to be related to #87153 (already fixed). At least I am able to reproduce the very same issue with the example contained in that bug report.
Let me know if you need more information.
Steps to Reproduce:
1. Copy current sheet and insert it at the very beginning.
2. Delete the newly created sheet again.
3. The yellow cell (containing a sheet-local named range) will become corrupt.
Reference to named range become corrupt.
Reference is still valid.
User Profile Reset: No
Created attachment 149605 [details]
Version: 126.96.36.199 (x64)
Build ID: 90f8dcf33c87b3705e78202e3df5142b201bd805
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: de-DE (de_DE); Calc:
Version: 188.8.131.52.alpha0+ (x64)
Build ID: ca8eef6be3e45b934879780e847d6ef4faba857a
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win;
Locale: de-DE (de_DE); UI-Language: en-US
formula in cell "Sheet1.G3" changes
already reproducible with
Version: 184.108.40.206 (x64)
CPU-Threads: 4; BS: Windows 6.19; UI-Render: Standard;
Gebietsschema: de-DE (de_DE); Calc: single
Ran into this also at 220.127.116.11 with a larger spreadsheet, but narrowed it down to:
Steps to recreate:
1. Open Calc and create a new spreadsheet (Sheet1). Update 3 cells:
B1: "text data numbers"
Name B1 via the Named Box to "TestData".
Select Manage Names and change scope from Global to Sheet1
2. Right click Sheet1 > Insert Sheet
3. Right click Sheet2 > Delete Sheet > Yes
Label text data numbers
text data numbers
Label text data numbers
I was able to repeat this. In addition, if I delete Sheet1 (rather than Sheet2, as above), the named cell becomes orphaned.
1 & 2. Same as above.
3. Delete Sheet1 rather than Sheet2
The named cell "TestData" is visible in the dropdown.
If you select it in the Name Box, an informational dialog pops-up,
"You must enter a valid reference or type a valid name for the
selected range.". If you click Managed Names, there are no names in the list.
The name appears to be orphaned.
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://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
I tested both instructions to reproduce, mine and that from russel. The issue does not exist anymore.
Build ID: 00(Build:2)
CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: x11
Locale: de-DE (en_US.utf8); UI: en-US
Debian package version: 1:7.0.4-3
Version: 18.104.22.168.alpha1+ (x64) / LibreOffice Community
Build ID: aa9cb8e14749e7fb7a83b55a2bb095501f731a18
CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU