[Libreoffice-bugs] [Bug 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

Aron Budea  changed:

   What|Removed |Added

 Blocks||127300


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=127300
[Bug 127300] [META] Issues with import/export/display of Excel built-in defined
names
-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

Aron Budea  changed:

   What|Removed |Added

 Whiteboard|target:6.1.0 target:6.0.0.1 |target:6.1.0 target:6.0.0.1
   |target:5.4.5 target:5.4.4   |target:5.4.4

-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

--- Comment #11 from Commit Notification 
 ---
Aron Budea committed a patch related to this issue.
It has been pushed to "libreoffice-5-4-4":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=3f50e9ccde342259fd6f24c40599d820f21eba7b=libreoffice-5-4-4

tdf#109240, tdf#112571: don't export dupe built-in named ranges

It will be available in 5.4.4.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

Commit Notification  changed:

   What|Removed |Added

 Whiteboard|target:6.1.0 target:6.0.0.1 |target:6.1.0 target:6.0.0.1
   |target:5.4.5|target:5.4.5 target:5.4.4

-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

--- Comment #10 from Commit Notification 
 ---
Aron Budea committed a patch related to this issue.
It has been pushed to "libreoffice-5-4":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=d0f5f2bbd2bc6fee5ad4c4031f69c04e1c8fd3fb=libreoffice-5-4

tdf#109240, tdf#112571: don't export dupe built-in named ranges

It will be available in 5.4.5.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

--- Comment #9 from Commit Notification 
 ---
Aron Budea committed a patch related to this issue.
It has been pushed to "libreoffice-6-0":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=1f5d7c8b986d4839788e3e2f4ac24ab2df25af9c=libreoffice-6-0

tdf#109240, tdf#112571: don't export dupe built-in named ranges

It will be available in 6.0.0.1.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

Commit Notification  changed:

   What|Removed |Added

 Whiteboard|target:6.1.0 target:6.0.0.1 |target:6.1.0 target:6.0.0.1
   ||target:5.4.5

-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

Commit Notification  changed:

   What|Removed |Added

 Whiteboard|target:6.1.0|target:6.1.0 target:6.0.0.1

-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

Aron Budea  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Blocks||103512
 Resolution|--- |FIXED

--- Comment #8 from Aron Budea  ---
If you don't mind sending it to me, I can take a quick look at it (can't
guarantee anything). What would definitely be helpful is reproduction steps on
how to get to a bad file.

In the meantime, the posted fix will prevent creation of duplicate built-in
named ranges and remove existing ones upon save. Closing as fixed, backports
are in gerrit.

If you manage to reproduce the name conflict with this patch included, please
open a new bug report, and add it to the See Also field and/or CC me.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=103512
[Bug 103512] [META] AutoFilter-related bugs and enhancements
-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:6.1.0

-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

--- Comment #7 from Commit Notification 
 ---
Aron Budea committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=f8b9d0fb0767d8bbe8477f92abaf6b8e0ff65546

tdf#109240, tdf#112571: don't export dupe built-in named ranges

It will be available in 6.1.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

--- Comment #6 from Richard Léger  ---
(In reply to Aron Budea from comment #4)
> I can reproduce the multiplication of named ranges, but not the corruption.
> Can you or anyone share a simple file that was created with these steps in
> Calc (or similar steps involving autofilter), and Excel complains about it?

Strangely I don't seem to be able to reproduce the corruption... but I no
longer have access to original machines where it appeared at the time. The
duplicate range still appears.

Though I may have another production file that crash Excel and that LO complain
about range when opening. I may provide it in a private msg if that is possible
for testing purpouse as I don't want to publish it on a public forum.

Would that do?

-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

Kevin Suo  changed:

   What|Removed |Added

 CC||suokunl...@126.com
   Hardware|x86-64 (AMD64)  |All
 OS|Windows (All)   |All

--- Comment #5 from Kevin Suo  ---
Set platform to ALL.Xlsx files produced this way have the same problem when
open with MSO in Win. I have encountered this issue many times.

-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

--- Comment #4 from Aron Budea  ---
I can reproduce the multiplication of named ranges, but not the corruption. Can
you or anyone share a simple file that was created with these steps in Calc (or
similar steps involving autofilter), and Excel complains about it?

-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

Aron Budea  changed:

   What|Removed |Added

 CC||ba...@caesar.elte.hu
   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=90
   ||484

-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

Aron Budea  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=11
   ||2571

-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

--- Comment #3 from Richard Léger  ---

FYI it seems Excel also prefix such named range names with '_xlnm.' (without
quotes)... while LO does not use that prefix when saving in .xlsx format.

Dupicate named range names seems recreated(or loaded) when file is opened...
clicking Save button does not recreate the range (at least not apearing in LO
interface) until the file is closed/reopened.

Hope that help.

-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

m.a.riosv  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||miguelangelrv@libreoffice.o
   ||rg
 Ever confirmed|0   |1

--- Comment #2 from m.a.riosv  ---
Reproducible.
Version: 6.0.0.0.alpha0+
Build ID: 403ddd6cb1c0d6a0e0db105e68f58fe40057cb42
CPU threads: 4; OS: Windows 6.19; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2017-07-14_23:37:46
Locale: es-ES (es_ES); Calc: group

It is the filter range that is recreated even if it exist.

-- 
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 109240] FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing com

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=109240

--- Comment #1 from Richard Léger  ---
FYI, if you delete all defined Names... (named ranges) and save, they are
recreated automatically at next opening of the file, one by one... duplicate of
each others... after consecutive save/opening...

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