Mailing-List: contact dev-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Developers List" <dev@poi.apache.org>
From: bugzilla@apache.org
To: dev@poi.apache.org
Subject: [Bug 58294] New: File crashes while opening XLSX after writing new
 pivot table to the workBook.
Date: Fri, 28 Aug 2015 07:37:51 +0000
Message-ID: <bug-58294-47293@https.bz.apache.org/bugzilla/>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit
Auto-Submitted: auto-generated
MIME-Version: 1.0

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