https://bz.apache.org/bugzilla/show_bug.cgi?id=58418
Bug ID: 58418
Summary: Applying Auto Filter on SXSSFSheet leads to corrupt
excel
Product: POI
Version: 3.9-FINAL
Hardware: PC
Status: NEW
Severity: critical
Priority: P2
Component: SXSSF
Assignee: dev@poi.apache.org
Reporter: pal.ratika...@gmail.com
Hi,
I am trying to using auto filter of SXSSFSheet.
sheet.setAutoFilter(new CellRangeAddress(gFilterStartRow,
gFilterEndRow, 1, visibleColumn.size()));
but my file leads to corrupt.Than I am repairing the excel after that the only
difference I can see is workbook.xml
------------POI
<?xml version="1.0" encoding="UTF-8"?>
<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main";
xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships";>
<workbookPr date1904="false" />
<bookViews>
<workbookView activeTab="0" />
</bookViews>
<sheets>
<sheet name="COVER PAGE" r:id="rId3" sheetId="1" />
<sheet name="C04T03R05" r:id="rId4" sheetId="2" />
<sheet name="DISCLAIMER" r:id="rId5" sheetId="3" />
</sheets>
<definedNames>
<definedName name="_xlnm._FilterDatabase" localSheetId="1"
hidden="true">C04T03R05!$B$1:$F$68</definedName>
</definedNames>
</workbook>
-----------Repaired Excel
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main";
xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships";>
<fileVersion appName="xl" lastEdited="4" lowestEdited="4"
rupBuild="4505" />
<workbookPr defaultThemeVersion="124226" />
<bookViews>
<workbookView xWindow="240" yWindow="525" windowWidth="15015"
windowHeight="7365" activeTab="1" />
</bookViews>
<sheets>
<sheet name="COVER PAGE" sheetId="1" r:id="rId1" />
<sheet name="C04T03R05" sheetId="2" r:id="rId2" />
<sheet name="DISCLAIMER" sheetId="3" r:id="rId3" />
</sheets>
<definedNames>
<definedName name="_xlnm._FilterDatabase" localSheetId="1"
hidden="1">'C04T03R05'!$B$1:$F$68</definedName>
</definedNames>
<calcPr calcId="124519" />
<fileRecoveryPr repairLoad="1" />
</workbook>
------------------------------------------------------------------
Excel POI Version:
-------------------------
<definedNames>
<definedName name="_xlnm._FilterDatabase" localSheetId="1"
hidden="true">C04T03R05!$B$1:$F$68</definedName>
</definedNames>
Excel repaired Version:
-------------------------
<definedNames>
<definedName name="_xlnm._FilterDatabase" localSheetId="1"
hidden="1">'C04T03R05'!$B$1:$F$68</definedName>
</definedNames>
quotes missing in sheet name.Thats leads to corrupt .I have try to put quotes
in the sheet name and file is opening fine.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
