[Bug 58294] New: File crashes while opening XLSX after writing new pivot table to the workBook.

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Bug 58294] New: File crashes while opening XLSX after writing new pivot table to the workBook.

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=58294

            Bug ID: 58294
           Summary: File crashes while opening XLSX after writing new
                    pivot table to the workBook.
           Product: POI
           Version: 3.12-FINAL
          Hardware: PC
            Status: NEW
          Severity: critical
          Priority: P2
         Component: XSSF
          Assignee: [hidden email]
          Reporter: [hidden email]

Created attachment 33045
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=33045&action=edit
Code and generated file. test1.xlsx and test2.xlsx are original file without
saving test1.xlsx form excel.

My Environment is windows and this is not tested on unix.
I am generating a xlsx file using jasper report and save it to locally
(test1.xlsx). This file is fine and open without error or crash.
When i am trying trying to add the pivot table and saving it as new file
test2.xlsx (Can also do in the same file but same result) the code works fine.
But when i open test2.xlsx, this crashes with the following error in Excel.
"Removed Feature: PivotTable report from
/xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part
(PivotTable view)
Removed Records: Workbook properties from /xl/workbook.xml part (Workbook)
Repaired Records: Cell information from /xl/worksheets/sheet2.xml part
"

Now if i Open the test1.xlsx and save it again without any modification and run
my code again, the test2.xlsx file generates fine and opening properly.

i am attaching test1.xlsx, test2.xlsx and my code for the reference.

--
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Bug 58294] File crashes while opening XLSX after writing new pivot table to the workBook.

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=58294

Amit <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]
                 OS|                            |All

--
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Bug 58294] Pivot Table corrupted when saving an xlsx workbook

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=58294

Javen O'Neal <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|critical                    |normal
            Summary|File crashes while opening  |Pivot Table corrupted when
                   |XLSX after writing new      |saving an xlsx workbook
                   |pivot table to the          |
                   |workBook.                   |

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Loading...