subject:"\[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"

[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

2017-11-28 Thread bugzilla-daemon

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

2017-11-22 Thread bugzilla-daemon

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

2017-11-22 Thread bugzilla-daemon

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

2017-11-21 Thread bugzilla-daemon

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

2017-11-21 Thread bugzilla-daemon

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

2017-09-23 Thread bugzilla-daemon

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

2017-09-22 Thread bugzilla-daemon

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=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

2017-09-22 Thread bugzilla-daemon

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=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

2017-09-22 Thread bugzilla-daemon

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=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

2017-09-22 Thread bugzilla-daemon

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=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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

10 matches

Site Navigation

Mail list logo

Footer information