You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2015/08/28 09:37:51 UTC

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

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: dev@poi.apache.org
          Reporter: thatisamit@gmail.com

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


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

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58294

Amit <th...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |thatisamit@gmail.com
                 OS|                            |All

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

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


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

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=58294

Javen O'Neal <on...@apache.org> 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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org