Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Adam Cameron / Adam Cameron (Adam Cameron)
Created: 09/08/2015
Components: Document Management, Office Integration
Versions: 11.0
Failure Type:
Found In Build/Fixed In Build: CF11_Final /
Priority/Frequency: Major / Some users will encounter
Locale/System: ALL / Platforms All
Vote Count: 1
Repro:
<cfscript>
spreadsheet = spreadsheetNew();
data = [
["tahi"],
["rua"],
["toru,wha"], // this is one data value
["rima,ono"] // so is this
];
filePath= expandPath("./withArray.xls");
spreadsheet.addRows(data,1,1);
spreadsheet.write(filePath, true);
</cfscript>
I was guessing as to the syntax as the docs don't explain how to use an array with this function, so I naturally assumed it took an array (rows) of arrays (column data). I was wrong as it turns out, but the error message is missing any useful detail:
An exception occurred while calling the function addRows.
The error occurred in C:/apps/adobe/ColdFusion/11/express/cfusion/wwwroot/shared/cfml/language/functions/spreadsheet/spreadsheetAddRows/withArray.cfm: line 11
9 : filePath= expandPath("./withArray.xls");
10 :
11 : spreadsheet.addRows(data,1,1);
12 : spreadsheet.write(filePath, true);
13 : </cfscript>
It needs to explain WHY I got the exception (just like any other CF error would)
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4051606
External Customer Info:
External Company:
External Customer Name: Adam Cameron
External Customer Email:
External Test Config: My Hardware and Environment details:Attachments:
Comments: