troubleshooting Question

CFSPREADSHEET CF2016 overwrites single sheet

Avatar of digitalwise
digitalwise asked on
ColdFusion Language
21 Comments2 Solutions338 ViewsLast Modified:
We have some code that writes some new data to a multi-sheet workbook.   We just upgraded to CF2016 and now during the write, it deletes the other worksheets.

<cfspreadsheet action="read"
        src="#application.loadpath#\#Session.NewWorking#"
        name="sObj"
        SHEET="2" />

<cfscript>
spreadsheetSetCellValue(sObj,#val(RA)#,2,2);
spreadsheetSetCellValue(sObj,#val(AP)#,3,2);
spreadsheetSetCellValue(sObj,#val(GetCHAP.showvalue)#,4,2);
spreadsheetSetCellValue(sObj,#val(GetFP.showvalue)#,5,2);
spreadsheetSetCellValue(sObj,#val(getrad.showvalue)#,6,2);
spreadsheetSetCellValue(sObj,#val(GetClosed.showvalue)#,7,2);
</cfscript>

<cfspreadsheet action="write" overwrite="true"
        filename="#application.loadpath#\#Session.NewWorking#"
        name="sObj" />
       

We end up with JUST the 2nd sheet - it deletes the rest of them.   This has been working for a long time so it is quite distressing to find the CF2016 fundamentally changes the way a tag works.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 21 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 21 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros