Created attachment 79312 [details] Excel sheet that demonstrates the issue when opened in Libre Problem description: When reading in an Excel file named ranges that have the same name across sheets are corrupted. Seems as if Libre does not allow duplicate names across sheets Steps to reproduce: 1. ....Import attached Excel sheet and see #NA on Summary 2. ....Sheets created by copying sheets with namaed ranges 3. .... Current behavior:As described above Expected behavior: If Named ranges duplicated they will be referenced by the sheetprefix then the name as is done in Excel. Not permitting duplicates is a major limitation on productivity as it limits duplicating sheets to set up new ones. Operating System: Windows XP Version: 4.0.2.2 release
Honestly not sure if this is a bug or an enhancement request so going to cc one of our resident spreadsheet masters :) That being said: I have been able to confirm the issue with the earliest version of bibisect: Version 3.6.0.0.alpha1 Platform: Bodhi Linux 2.2 x64 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + As I've been able to confirm this problem on an earlier release I am changing the version number as version is the earliest version that we can confirm the bug, we use comments to say that the bug exists in newer versions as well. Marking as: New (confirmed) Normal - can prevent high quality/professional work Medium 0- default seems appropriate + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link: https://wiki.documentfoundation.org/QA/BugTriage There are also other ways to get involved including with marketing, UX, documentation, and of course developing - http://www.libreoffice.org/get-help/mailing-lists/. Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material
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.