I've come across a difficulty that as far as I can tell, looks like I'm bumping up against something in the SLL, although I'm probably doing something dumb. I'm attempting to create a pretty wide spreadsheet (211 columns in all), but get a crash not too far in. Here's relevant code; if the bits between the #IF 0/#ENDIF are added, it runs OK, otherwise it crashes after 50 iterations of the xLoop. The SLL file I'm using is dated 1/17/2014.
local xLoop as long
local xlRow, xlCol as long
local FirstDate as string
For xLoop = 104 To 1 Step -1
#IF 0
If xLoop > 55 Then
xlRow += 2
xlCol = 3
End If
If xLoop > 5 Then
xlRow += 2
xlCol = 3
End If
#endif
FF_StatusBar_SetText HWND_MAINFORM_STATUSBAR, 1, "XLoop: " + Format$(xLoop) + " Row: " + Format$(xlRow) + " Col: " + Format$(XLCol)
FF_DoEvents
Sleep 10
xlCol += 1
iCell = ws.AddCell( xlRow, xlCol, FirstDate)
iCell.AlignCenter = %True
iCell.MergeAcross = 1
iCell.CellColor = fnMakeExcelColor(%RGB_KHAKI)
iCell = ws.AddCell( xlRow+1, xlCol, "Orders")
iCell.AlignRight = %True
iCell.CellColor = fnMakeExcelColor(%RGB_KHAKI)
xlCol += 1
iCell = ws.AddCell( xlRow+1, xlCol, "Qty")
iCell.AlignRight = %True
iCell.CellColor = fnMakeExcelColor(%RGB_KHAKI)
FirstDate = SQLDateMath(FirstDate, 7)
Next xLoop
Any insight appreciated.