This worked for me. Leading zero will display is the excel column. e.g. 01234 <cfset SpreadSheetSetCellValue(sheetName, variables.Query.ColumnName, Rowcount, Columncount, "string")> ... View more

There is an other way to fixed complex object types error. If you have few multi-select options and try to submit multiple values then this code covert the array back to list. <cfif isDefined("form.projectCode") and isArray(form.projectCode)>         <cfset form.projectCode = arrayToList(form.projectCode,",") /> </cfif> ... View more

Thanks Charlie. ... View more

I am using Windows Server 2016 OS and ColdFusion Build 2018.0.11.326016. ... View more

Charlie, I am agree with you this issue is not related with structkeyexists. After Coldfusion recent updates posted form values show in an array rather than in a list. This is the real cause of this issue.  Build - 2018,0,11,326016     ... View more

This is just an example, sorry i missed the closing bracket > . In my real code there are 8 different multiple select options and those were working fine before we applied recent Coldfusion 18 patch and suddenly all of them error out at structKeyExists when we applied new patch. Our administrator revert the new patch and everything start working again. <select name="user" id="user" size="7" multiple="true"> <cfloop query="#variables.users#"> <cfoutput> <option value="#user_id#" <cfif structKeyExists(form, "user")> selected</cfif>>#variables.users.user#</option> </cfoutput> </cfloop> </select> ... View more

Hello Charlie, When submitting multiple select values, it through exception at structKeyExists function, it works fine when passing a single select option value but produce error when passing more than one value to structKeyExists funtion. <select name="user" id="user" size="7" multiple="true"> <cfloop query="#variables.users#"> <cfoutput> <option value="#user_id#" <cfif structKeyExists(form, "user") selected</cfif>>#variables.users.user#</option> </cfoutput> </cfloop> </select> ... View more