[Bug 62815] Incorrect "0" value for largish integers in xlsb files

[bu...@apache.org]

https://bz.apache.org/bugzilla/show_bug.cgi?id=62815

--- Comment #2 from marcelo <ma...@everis.com> ---
To solve the problem on convert xlsb to csv or text ("0" error fix):

Use: 

poi-ooxml / version: 4.0.1
xmlbeans / version 3.0.1

POM:
<dependency>
<groupId>org.apache.poi</groupId>
 <artifactId>poi-ooxml</artifactId>
<version>4.0.1</version>
</dependency>

<dependency>
<groupId>org.apache.xmlbeans</groupId>
 <artifactId>xmlbeans</artifactId>
<version>3.0.1</version>
</dependency>

Example:

import org.apache.poi.xssf.extractor.XSSFBEventBasedExcelExtractor;

OPCPackage pkg = OPCPackage.open("\\file.xlsb", PackageAccess.READ);
POIXMLTextExtractor ext = new XSSFBEventBasedExcelExtractor(pkg);

System.out.println(ext.getText());

-------------
PAZ

-- 
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