[Libreoffice-bugs] [Bug 112571] FILESAVE XLSX New named range is created every time an Excel made spreadsheet that contains print ranges is saved as XLSX
https://bugs.documentfoundation.org/show_bug.cgi?id=112571 Aron Budea changed: What|Removed |Added Status|NEW |ASSIGNED Assignee|libreoffice-b...@lists.free |ba...@caesar.elte.hu |desktop.org | -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 112571] FILESAVE XLSX New named range is created every time an Excel made spreadsheet that contains print ranges is saved as XLSX
https://bugs.documentfoundation.org/show_bug.cgi?id=112571 --- Comment #8 from Aron Budea --- The main issue is that eg. print area is exported once as a built-in name: void XclExpNameManagerImpl::CreateBuiltInNames() https://opengrok.libreoffice.org/xref/core/sc/source/filter/excel/xename.cxx#575 ...and then as a user name as well (as many as there were). This is why after each save there's one extra range. A set of "_0"-s are added during import to avoid clash. This is what the named range in xl\worksheets.xml looks like after one save (different sample than the attachment, the range is different), at this point the names are still clashing: Sheet1!$A$1:$E$5 Sheet1!$A$1:$E$5 Note how in XclExpNameManagerImpl::CreateBuiltInNames() other built-in names are created as well. The quick fix seems to be to skip adding the user-created names separately if they match a built-in name. Maybe they shouldn't even be listed among the user-created names, if it's possible? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 112571] FILESAVE XLSX New named range is created every time an Excel made spreadsheet that contains print ranges is saved as XLSX
https://bugs.documentfoundation.org/show_bug.cgi?id=112571 Aron Budea changed: What|Removed |Added See Also|https://bugs.documentfounda |https://bugs.documentfounda |tion.org/show_bug.cgi?id=90 |tion.org/show_bug.cgi?id=10 |484 |9240 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 112571] FILESAVE XLSX New named range is created every time an Excel made spreadsheet that contains print ranges is saved as XLSX
https://bugs.documentfoundation.org/show_bug.cgi?id=112571 --- Comment #7 from Gabor Kelemen --- (In reply to Aron Budea from comment #6) > Same thing happens if there is is a filter on a column. Named ranges are used for a lot of things apparently. Print ranges, autofilters, even pivot tables contain them. It's a versatile tool :). -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 112571] FILESAVE XLSX New named range is created every time an Excel made spreadsheet that contains print ranges is saved as XLSX
https://bugs.documentfoundation.org/show_bug.cgi?id=112571 Aron Budea changed: What|Removed |Added CC||ba...@caesar.elte.hu See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=90 ||484 Blocks||108897, 103512, 108815 --- Comment #6 from Aron Budea --- Same thing happens if there is is a filter on a column. It seems to be the same case that results in bug 90484 (not sure how that got closed as NOTABUG). Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=103512 [Bug 103512] [META] AutoFilter-related bugs and enhancements https://bugs.documentfoundation.org/show_bug.cgi?id=108815 [Bug 108815] [META] Print range/area bugs and enhancements https://bugs.documentfoundation.org/show_bug.cgi?id=108897 [Bug 108897] [META] XLSX (OOXML) bug tracker -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 112571] FILESAVE XLSX New named range is created every time an Excel made spreadsheet that contains print ranges is saved as XLSX
https://bugs.documentfoundation.org/show_bug.cgi?id=112571 raal changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||r...@post.cz Version|5.4.1.2 release |4.1 all versions Ever confirmed|0 |1 --- Comment #5 from raal --- I can confirm with Version 4.1.0.0.alpha0+ and Version: 6.0.0.0.alpha0+ Build ID: afeff9102c2935139de4efd40fd2286dce396706 CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk2; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-09-17_23:32:41 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 112571] FILESAVE XLSX New named range is created every time an Excel made spreadsheet that contains print ranges is saved as XLSX
https://bugs.documentfoundation.org/show_bug.cgi?id=112571 --- Comment #4 from Gabor Kelemen --- Created attachment 136473 --> https://bugs.documentfoundation.org/attachment.cgi?id=136473&action=edit A screenshot showcasing the issue. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 112571] FILESAVE XLSX New named range is created every time an Excel made spreadsheet that contains print ranges is saved as XLSX
https://bugs.documentfoundation.org/show_bug.cgi?id=112571 --- Comment #3 from Gabor Kelemen --- Created attachment 136472 --> https://bugs.documentfoundation.org/attachment.cgi?id=136472&action=edit The spreadsheet after the third save from LO -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 112571] FILESAVE XLSX New named range is created every time an Excel made spreadsheet that contains print ranges is saved as XLSX
https://bugs.documentfoundation.org/show_bug.cgi?id=112571 --- Comment #2 from Gabor Kelemen --- Created attachment 136471 --> https://bugs.documentfoundation.org/attachment.cgi?id=136471&action=edit The spreadsheet after the second save from LO -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 112571] FILESAVE XLSX New named range is created every time an Excel made spreadsheet that contains print ranges is saved as XLSX
https://bugs.documentfoundation.org/show_bug.cgi?id=112571 --- Comment #1 from Gabor Kelemen --- Created attachment 136470 --> https://bugs.documentfoundation.org/attachment.cgi?id=136470&action=edit The spreadsheet after the first save from LO -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs