tracker issue : CF-4203340

select a category, or use search below
(searches all categories and all time range)
Title:

CFDIRECTORY to EXCEL

| View in Tracker

Status/Resolution/Reason: To Fix//BugVerified

Reporter/Name(from Bugbase): Jürgen Wittsiepe / ()

Created: 09/14/2018

Components: Tags

Versions: 2016,13.0

Failure Type: Incorrectly functioning

Found In Build/Fixed In Build: 2016.0.07.311392 /

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 2018

Attachments:

Comments: