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 2012/03/06 05:27:53 UTC
DO NOT REPLY [Bug 52835] New: bug in paring shared string table
https://issues.apache.org/bugzilla/show_bug.cgi?id=52835
Bug #: 52835
Summary: bug in paring shared string table
Product: POI
Version: unspecified
Platform: PC
OS/Version: Windows Server 2003
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: dev@poi.apache.org
ReportedBy: zjuwufan@gmail.com
Classification: Unclassified
Given following shared string table,
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"/>
XSSF won't work.
It seems that we assumed that there would be 'count' and 'uniqCount' in the
xml.
However if there is no 'count' and 'uniqCount', the excel file cannot be
handled successfully.
File attached.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 52835] bug in paring shared string table
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52835
--- Comment #2 from Wu, Fan <zj...@gmail.com> 2012-03-06 12:18:40 UTC ---
The file is about 5MB in size, I failed to upload it. Any other way to share it
with you?
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 52835] bug in paring shared string table
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52835
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution| |FIXED
--- Comment #9 from Yegor Kozlov <ye...@dinom.ru> 2012-03-11 07:21:39 UTC ---
I relaxed this constraint in r1299338.
With this fix POI's eventusermodel supports parsing SST with missing Count and
UniqueCount attributes. Please try the latest build from trunk.
Yegor
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 52835] bug in paring shared string table
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52835
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #1 from Yegor Kozlov <ye...@dinom.ru> 2012-03-06 11:02:11 UTC ---
You forgot to attach the file.
Yegor
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 52835] bug in paring shared string table
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52835
--- Comment #8 from Wu, Fan <zj...@gmail.com> 2012-03-07 02:26:32 UTC ---
Callstack looks like this,
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at
org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable.startElement(ReadOnlySharedStringsTable.java:190)
at
com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(Unknown
Source)
at
com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(Unknown
Source)
at
com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.emptyElement(Unknown
Source)
at
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown
Source)
at
com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$ContentDriver.scanRootElementHook(Unknown
Source)
at
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown
Source)
at
com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(Unknown
Source)
at
com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown
Source)
at
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
Source)
at
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown
Source)
at
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown
Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown
Source)
at
com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown
Source)
at
com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown
Source)
at
org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable.readFrom(ReadOnlySharedStringsTable.java:141)
at
org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable.<init>(ReadOnlySharedStringsTable.java:110)
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 52835] bug in paring shared string table
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52835
--- Comment #5 from Wu, Fan <zj...@gmail.com> 2012-03-06 15:54:35 UTC ---
We are building product based on POI. Our user is trying to using the attached
file, but failed.
The source is unknown. Do you think it's an issue?
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 52835] bug in paring shared string table
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52835
--- Comment #6 from Yegor Kozlov <ye...@dinom.ru> 2012-03-06 18:19:50 UTC ---
(In reply to comment #0)
> Given following shared string table,
>
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"/>
>
> XSSF won't work.
>
Please explain what is wrong with XSSF: does it throw an exception or returns
wrong data or what?
The latest build from trunk can read the referenced file, navigate over data
and save it back to file. I don't see anything wrong on the POI side.
Yegor
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 52835] bug in paring shared string table
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52835
--- Comment #7 from Wu, Fan <zj...@gmail.com> 2012-03-07 02:21:38 UTC ---
An exception was thrown with following code.
import java.io.IOException;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.openxml4j.opc.OPCPackage;
import org.apache.poi.openxml4j.opc.PackageAccess;
import org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable;
import org.xml.sax.SAXException;
public class Test {
public static void main(String[] args)
{
try {
OPCPackage pkg = OPCPackage.open("cant_upload.xlsx",
PackageAccess.READ);
ReadOnlySharedStringsTable table = new
ReadOnlySharedStringsTable(pkg);
} catch (InvalidFormatException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SAXException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 52835] bug in paring shared string table
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52835
--- Comment #3 from Wu, Fan <zj...@gmail.com> 2012-03-06 12:26:14 UTC ---
Please got the link by following link.
http://dl.dropbox.com/u/29681633/cant_upload.xlsx
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 52835] bug in paring shared string table
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52835
--- Comment #4 from Nick Burch <ni...@alfresco.com> 2012-03-06 15:30:38 UTC ---
How was this file generated?
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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