Fun with Excel
Frankly, this is starting to look like a bug but I didn't want to jump the gun. I'm using a spreadsheet that has input and expected outputs in their respective columns. I'm taking the results ...
Forum Discussion
Yeah - I'm looking at the method he posted now. At the least, this will help me troubleshoot, but your suggestion looks like the best solution.
I'm keeping in mind that "empty" doesn't necessarily mean "Null". We are using the string "Null" as a value in some of these expected result cells. That's what the If statement is checking for. But the entire script stops running when it gets to the "var numOne" point.
I'll also need to look at what .ClearContents leaves. Looks like those cells have data type of "9" when I log:
Log.Message( i + ", " + j + " = " + GetVarType(Excel.Cells(i, j+24))) ;
What does it mean when the cell is typed "VarDispatch"?
For my own edification - how are you making those code blocks?? ;-p
I'm keeping in mind that "empty" doesn't necessarily mean "Null". We are using the string "Null" as a value in some of these expected result cells. That's what the If statement is checking for. But the entire script stops running when it gets to the "var numOne" point.
I'll also need to look at what .ClearContents leaves. Looks like those cells have data type of "9" when I log:
Log.Message( i + ", " + j + " = " + GetVarType(Excel.Cells(i, j+24))) ;
What does it mean when the cell is typed "VarDispatch"?
For my own edification - how are you making those code blocks?? ;-p
