Hi, I am using XLS2CSVmra to parse a very simple XLS file, but I am getting some weird results. It seems the FormulaRecord case is not recognising string formulas.
case FormulaRecord.sid:
// Cast record
FormulaRecord frec = (FormulaRecord) record;
thisRow = frec.getRow();
thisColumn = frec.getColumn();
if(outputFormulaValues) {
if(Double.isNaN( frec.getValue() )) {
// Formula result is a string
:
Produces 0.0 instead of NaN
The content of the file is
A; B; =CONCATENATE(A,B); C
Result:
Sheet1 [1]:
"A","B",0
,,,"C"
Sheet2 [2]:
Sheet3 [3]:
--
Thanks
Des Hartman
testCON.xls
Description: MS-Excel spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
