This is truly bizzare behavior.
In general, this is behavior I see:
When it runs across a formula, it appears to generate one of those
"Dummy Records" and then generate EXTRA records up to thisColumn = n where
n is the column in which the formula appeared, i.e, if the formula is in
column 27, it will generate 28 extra columns for which "thisColumn" returns
a value from 0 to n.
At this point, I'm usually able to see the CSV record I want to see if I:
Ignore the LastCellofRowDummyRecord if the PREVIOUS (n-1) record was a
formula
AND
I skip n records where n was set when from thisColumn when I encountered the
FormulaRecord.
if(thisStr != null) {
if (thisColumn >= formColumn) {
if(thisColumn > 0 ) {
output.print(',');
}
output.print(thisStr);
}
}
Note that I'm not at this point attempting to see the output of the formula.
-----Original Message-----
From: Dave Madole [mailto:[EMAIL PROTECTED]
Sent: Sat 10/4/2008 12:57 AM
To: [email protected]
Subject: Formula always seems generate "LastCellofRowDummyRecord in XLS2CSVmra
When I get a formula in the XLS2CSVmra app, it always seems
to be parsed as the end of a row (and I fall into the block
specified in the subject), so I get two csv rows broken at the formula.
If I try turning off outputFormulaValues, I get:
"Coding Error: Expected ExpPtg to be converted from Shared to Non-Shared
Formula"
Using 3.2 build 22.
Thanks,
Dave
