On Wed, 17 Jul 2013, Eric Peters wrote:
Based upon http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java
Two other good event based examples to view are: https://svn.apache.org/repos/asf/poi/trunk/src/java/org/apache/poi/hssf/extractor/EventBasedExcelExtractor.java https://svn.apache.org/repos/asf/tika/trunk/tika-parsers/src/main/java/org/apache/tika/parser/microsoft/ExcelExtractor.java
I was expecting to be able to get the result of a formula (One example I have a CONCATENATE() statement, but I end up getting a value like "0.00" or in another column I expect an error message like: #DIV/0! but instead get "0"Thoughts on how I can get this to match up with the XSSF?
Can you try reading that cell via the usermodel, to check if a cached value was actually saved to the file?
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
