Variable SRUCTNEW is undefined?!?
Hello, we recently upgraded to CF9. One of the new features I want to play with is CFSPREADSHEET.
In working with the sample code I have found (here and elsewhere), most work fine. But certain functions return a "Variable XXXX is undefined" error.
I am pretty sure this may be an install issue or a settings issue, but I can't find any resource on the web. Here is a basic code snipet that simply errors out on the STRUCNEW line:
<cfscript>
///Set the file name
theFile="#BaseRoot#files\FailureReportingAudit.xls";
//Create a new Excel spreadsheet object and add test data.
theSheet = SpreadsheetNew("CourseData");
SpreadsheetAddRow(theSheet,"test, test1",1);
// Define a format for the column.
format1=SructNew() ;
format1.font="Courier";
format1.fontsize="10";
format1.color="dark_blue;";
format1.italic="true";
format1.bold="true";
format1.alignment="left";
SpreadsheetFormatCellRange(theSheet,format1, 3,4,30,10);
</cfscript>
You can see the error for itself at: https://www.calcerts.com/_WTF_cfscript.cfm
If I comment out the code starting at StructNew all the way to the end of the cfscript, I receive no error and the XLS file is created, no problem. But when I try and create a structure so I can format it I get an error.
Another interesting note, if I try to do the "SpreadsheetFormatCellRange" function manually (no format1 structure), I get a "Variable SPREADSHEETFORMATCELLRANGE is undefined"
So basically some (not all or even most) functions are not "defined"....
