Status/Resolution/Reason: To Fix/Fixed/Fixed
Reporter/Name(from Bugbase): Jürgen Wittsiepe / ()
Created: 09/14/2018
Components: Document Management, Office Integration
Versions: 2016
Failure Type: Incorrectly functioning
Found In Build/Fixed In Build: 2016.0.07.311392 / 311561
Priority/Frequency: Normal / Some users will encounter
Locale/System: / Win 2008 Server R2 64 bit
Vote Count: 0
Problem Description: I want to export a file structure to an excel file
Steps to Reproduce:
<cfdirectory name="Folderlisting" action="list" directory="#dirname#" recurse="true" sort="asc" >
<cfscript>
xlsExport = SpreadsheetNew("Listing",true);
spreadsheetSetActiveSheet(xlsExport,"Listing");
spreadsheetAddrows(xlsExport,folderlisting,1,1,true,["STRING:1,3,5,6,7,8; NUMERIC:2; DATE:4"],true);
</cfscript>
<cfspreadsheet
action="write"
filename = #fileLocation#
name="xlsExport"
overwrite="true">
Actual Result: The year of the date is not correct: 14.09.2000 08:42:03
Expected Result: It should be 14.09.2018 08:42:03
Any Workarounds: If I set it as string I see: Fri Sep 14 08:42:03 CEST 2018Attachments:
Comments: