tracker issue : CF-4194954

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

CFSpreadsheet With QUERY Attribute Will Not Write to RAM Drive

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/Duplicate

Reporter/Name(from Bugbase): Paul Mascari / Paul Mascari (Paul Mascari)

Created: 10/04/2016

Components: Document Management, Office Integration

Versions: 11.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Major / Few users will encounter

Locale/System: English / Win All

Vote Count: 0

Duplicate ID:	CF-3925916

Problem Description: 
This problem is similar to bug  3178676.  However, as noted in the comments on that bug it was never fixed when using the QUERY attribute.

Trying to write a spreadsheet with the CFSPREADSHEET tag to the RAM drive using the QUERY attribute results in an error.

Steps to Reproduce:
<cfspreadsheet action="write" filename="cc" query="xlsQry" overwrite="yes" sheetname="Sheet1">

Actual Result:
java.lang.ClassCastException: coldfusion.vfs.VFileOutputStream cannot be cast to java.io.FileOutputStream 

Expected Result:
Spreadsheet should be written to the RAM drive.

Any Workarounds: You can write the file to a local drive and move it to RAM.  Not very efficient.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4194954

External Customer Info:
External Company:  
External Customer Name: Paul Mascari
External Customer Email:  
External Test Config: My Hardware and Environment details:



Win 2008

CF 11, 11,0,10,300066

Attachments:

Comments:

bug verified with b.11,0,10,300066 / win 7x64. This is a duplicate of #CF-3925916. This was fixed for CF2016. The fix needs to be merged with CF11 HF branch. Closing this. will target #CF-3925916 for the next update release of CF11. err: java.lang.ClassCastException: coldfusion.vfs.VFileOutputStream cannot be cast to java.io.FileOutputStream at coldfusion.excel.Excel.writeExcel(Excel.java:5429) test code: q = queryNew("id,name", "integer, varchar", [ {id=4,name="quatro"}, {id=5,name="fiver"}, {id=6,name="seis"} ]); output_file = "ram:\\xldata.xls"; cfspreadsheet(action="write", filename="#output_file#", query="q", overwrite=true); cfspreadsheet(action="read", src="#output_file#", query="read_data_qry"); writeDump(read_data_qry);
Comment by Piyush K.
1699 | October 09, 2016 05:49:49 AM GMT