tracker issue : CF-3698462

Problem Description:  Read a single worksheet from an Excel 97-2003 spreadsheet (XLS) that has multiple worksheets.  Make modifications and write to a new file.  Instead of having the single worksheet that read, all worksheets from the original file are included.

Steps to Reproduce:
<cfscript>
Workfile = SpreadSheetRead("C:\test.xls", 1);  // any spreadsheet with multiple worksheets)
SpreadsheetSetCellValue(Workfile, "Hello World", 1, 1);
</cfscript>
<!--- Switch to CFSpreadsheet becase spreadsheetwrite can't specific a sheet name. Probably a bug/oversight. --->
<cfspreadsheet action="write" filename="c:\test_out.xls" name="Workfile" sheetname="Modified" overwrite="true">


Actual Result:
The modified first worksheet plus all subsequent spreadsheets from the initial file (even though only the first spreadsheet was supposedly read.)

Expected Result:
A single worksheet.  The one that was specified in SpreadSheetRead().

Any Workarounds:
Ignore ColdFusion documentation and only use known spreadsheets with single worksheets.  If worksheet has manual worksheets that need to be used, manually extract them into their own spreadsheet files to be read individually by ColdFusion. Write additional code to deal with multiple files.

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

Watson Bug ID:	3698462

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

ColdFusion 10,0,13,287689 

Tomcat 7.0.23.0

Windows Server 2008 R2

Update Level :chf10000013.jar

(There should be an easier way to get this information so that Adobe gets all the required info instead of typing random specs.)

Attachments:

Comments: