[Libreoffice-bugs] [Bug 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

Mike Kaganski  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |mikekagan...@hotmail.com
   |desktop.org |

--- Comment #22 from Mike Kaganski  ---
A patch is submitted for review: https://gerrit.libreoffice.org/39018

This patch *only* targets Excel crashing on pivot table update.

-- 
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 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

Aron Budea  changed:

   What|Removed |Added

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

-- 
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 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

--- Comment #21 from Gerhard Schaber  ---
I see the same crash when updating the Pivot table in MS Office (16) after
repairing 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 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

--- Comment #20 from superu...@gmail.com ---
The Attached file, once resaved with LO 5.3.1.1 x64 (win7 pro) and then
reopened with MS Office 2013 makes MS Office crash when trying to Update the
PivotTable.

When reopener with MS Office it asks me to repair the file, which I 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 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

Yousuf Philips (jay)  changed:

   What|Removed |Added

 Blocks||103381


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=103381
[Bug 103381] [META] Pivot table (aka Data Pilot) 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 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

Joel Madero  changed:

   What|Removed |Added

   Keywords|bibisectRequest |
 CC||jmadero@gmail.com
 Whiteboard||interoperability

--- Comment #19 from Joel Madero  ---
I don't see any evidence that this is a regression. Removing bibisectRequest.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

Robinson Tryon (qubit)  changed:

   What|Removed |Added

   Keywords||filter:xlsx

--- Comment #18 from Robinson Tryon (qubit)  ---
(In reply to Eike Rathke from comment #16)
> Pretty-printing and comparing both files'
> xl/pivotCache/pivotCacheDefinition1.xml streams shows they are quite
> different [...]

What's the next step here? Is there any testing that an interested volunteer
could perform, or does this bug just need dedicated dev time?

Keywords -> filter:xlsx

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

Robinson Tryon (qubit)  changed:

   What|Removed |Added

   Keywords||bibisectRequest
 Whiteboard|bibisectRequest |

--- Comment #17 from Robinson Tryon (qubit)  ---
Migrating Whiteboard tags to Keywords: (bibisectRequest)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|NEEDINFO|NEW

--- Comment #16 from Eike Rathke  ---
Actually it is sufficient to open the original Excel file in LO and save it
under a different name.xlsx and open that in Excel2010 to reproduce. (LO 5.2
master)

Pretty-printing and comparing both files'
xl/pivotCache/pivotCacheDefinition1.xml streams shows they are quite different,
additionally to different  attributes the LO-saved one contains
single values in  elements which the Excel-saved one does not.
Plus, the original contains one further  element with an 
and , though adding that manually to the LO-saved
stream didn't help.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 CC||mwmis...@o2.pl

--- Comment #15 from Eike Rathke  ---
*** Bug 78614 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

tommy27  changed:

   What|Removed |Added

 Blocks|75025   |

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

Michael Meeks  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO
  Component|filters and storage |Calc

--- Comment #14 from Michael Meeks  ---
Marina - an interesting one =) this really belongs in Calc.

I guess we are just screwing up the XML in that stream in some (perhaps
trivial) way - any chance you can dig out the XML fragments involved ? could
you try perturbing the XML ordering (attributes & elements), and pasting more
details here ? would also be worth comparing what MS Office produces for an
identical PivotTable - so that we can iterate towards that.

Thanks ! =)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

--- Comment #10 from Marina Latini mar...@studiostorti.com ---
(In reply to Robinson Tryon (qubit) from comment #9)
 
 What's the trouble with older versions?
 
 TESTING with 3.5.7.2 + Ubuntu 14.04

Same problem. The file is corrupted for MS Office. :( 

 
 I don't have MS-Office on this machine, but we should definitely try opening
 the result of this process w/MS-Office.

MS Office shows a dataloss message and the pivot table is gone :(

tested with Office 365
* Version: 15.0.4675.1003
* Locale: it_IT
* OS: Windows 7 Home Premium SP1 x86

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

--- Comment #11 from Marina Latini mar...@studiostorti.com ---
Created attachment 114004
  -- https://bugs.documentfoundation.org/attachment.cgi?id=114004action=edit
office error (italian)

translation from It to En:
-
removed : /xl/pivotTables/pivotTable18.xml
recovered: /xl/worksheets/sheet16.xml with XML error. Not recoverable error row
2, column 0.
recovered: /xl/worksheets/sheet17.xml
Removed records: named range /xl/workbook.xml
-

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

Marina Latini mar...@studiostorti.com changed:

   What|Removed |Added

Version|4.2.8.2 release |3.5.7.2 release

--- Comment #6 from Marina Latini mar...@studiostorti.com ---
(In reply to Robinson Tryon (qubit) from comment #5)

 
 Blocks - mab4.3
 Priority - highest
 
 Marina: is this a regression?

Retested with: 

* Version: 3.6.7.2 
* Build ID: e183d5b
* Locale: it_IT
* OS: Windows 7 Home Premium SP1 x86
* OS: Ubuntu 14.04.2 LTS x86_64

I can confirm the bug.

Set new version - 3.6.7.2
I can't test with versions older than 3.6.7.2

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

Marina Latini mar...@studiostorti.com changed:

   What|Removed |Added

Version|3.5.7.2 release |3.6.7.2 release

--- Comment #7 from Marina Latini mar...@studiostorti.com ---
I'm sorry for the wrong version.
Affected version changed from 3.5.7.2 to 3.6.7.2

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

--- Comment #9 from Robinson Tryon (qubit) qu...@runcibility.com ---
(In reply to Marina Latini from comment #6)
  Marina: is this a regression?
 
 Retested [and confirmed] with: 
 * Version: 3.6.7.2 

 I can't test with versions older than 3.6.7.2

What's the trouble with older versions?

TESTING with 3.5.7.2 + Ubuntu 14.04

(In reply to Marina Latini from comment #0)
 The attached file is corrupted after saving with LibreOffice.

REPRO Steps
 1) Open attachment 113150 (created with MS Office)
 2) Go on Tools - Options - LibreOffice Calc - Formula
 3) Set Formula syntax as Excel A1

Ok

 4) open the sheet pivot (it's the last one)

(was already the open sheet)

 5) Rx click - Refresh (the Pivot Table is ok)
 6) Save the file with the same file format (xlsx)
 7) Close the file

LibreOffice freezes for a while (my machine isn't the fastest ;-), but it does
save the file eventually.

The size explodes 10x from 349K - 3.6MB (attachment 114002).

 8) Re open with MS Office. MS Office shows a dataloss message.

I don't have MS-Office on this machine, but we should definitely try opening
the result of this process w/MS-Office.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

--- Comment #8 from Robinson Tryon (qubit) qu...@runcibility.com ---
Created attachment 114002
  -- https://bugs.documentfoundation.org/attachment.cgi?id=114002action=edit
Affected file (saved with LO 3.5.7.2)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

Robinson Tryon (qubit) qu...@runcibility.com changed:

   What|Removed |Added

 CC||qu...@runcibility.com
 Blocks||75025
 Whiteboard||bibisectRequest

--- Comment #5 from Robinson Tryon (qubit) qu...@runcibility.com ---
(In reply to Marina Latini from comment #0)
 The attached file is corrupted after saving with LibreOffice.
 ..
 8) Re open with MS Office. MS Office shows a dataloss message.

Data loss sucks. This bug just earned a MAB Badge.

 * Version: 4.3.6.1
 * Build ID: 9629686a67dd1f357477c13325e45a66f3452bb9
 * Locale: it_IT
 * OS: Ubuntu 14.04.1 x86_64

Blocks - mab4.3
Priority - highest

Marina: is this a regression?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

Marina Latini mar...@studiostorti.com changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|DUPLICATE   |---
Summary|DATALOSS FILESAVE: native   |DATALOSS FILESAVE: xlsx
   |xlsx pivot table corrupted  |pivot table corrupted after
   |after save with LO and  |save with LO and re-open
   |re-open with MS Office  |with MS Office
 Ever confirmed|0   |1

--- Comment #4 from Marina Latini mar...@studiostorti.com ---
This isn't a dupe.

If you try to open the file with LibreOffice the Pivot Table works fine. If you
try to open the file with Microsoft Office the file is corrupted.

Please, follow all the steps to reproduce the bug.
The Pivot Table works fine ONLY with LibreOffice. The problem could be related
to  bug 78614 but I'm not sure is the same.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 89139] DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office

[bugzilla-daemon]

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

Beluga todven...@suomi24.fi changed:

   What|Removed |Added

 Status|REOPENED|NEW

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs