Jeff, I have never used any of that functionality, but since you say you are on CF9, have you applied any/all updates? There may be bugs that were long-since fixed, but I find that many people (or their server admin's) never bother to update CF, especially 9 and earlier since it was often quite a bear to do.
If you want to know what version you have (9.0, 9.0.1, or 9.0.2) and what updates you have, I have a blog entry helping with that: http://www.carehart.org/blog/client/index.cfm/2012/6/18/what_hotfixes_have_b een_applied And if you may decide to proceed with some update(s), do proceed with caution. I share some warnings here: http://www.carehart.org/blog/client/index.cfm/2011/10/21/why_chfs_may_break Note as well that if you think that downloading an installer from Adobe should mean it has all the updates already applied, that's not so, as I discuss here: http://www.carehart.org/blog/client/index.cfm/2010/12/11/cfmyths_latest_inst aller_includes_all_updates And if you may wonder how to find available hotfixes, I provide links to them in that last blog entry. Finally, if you may be tempted to go to 9.0.2 (not saying that's your solution necessarily), consider the info I share here: http://www.carehart.org/blog/client/index.cfm/2013/8/19/understanding_ColdFu sion_9.0.2_a_FAQ But I appreciate that none of this may help solve your problem. Maybe there's something obvious you're doing or not that someone more familiar with the spreadsheet features may help with. I just wanted to offer this as something to consider in the meantime. /charlie From: [email protected] [mailto:[email protected]] On Behalf Of Jeff Howard Sent: Friday, March 14, 2014 1:15 AM To: [email protected] Subject: [ACFUG Discuss] does SPREADSHEETREMOVESHEET not work? I copied the code straight from Adobe's site and rewrote it using cfscript, cfset, cfset temp =, cfset obj = and all of them threw the same error. Variable SPREADSHEETREMOVESHEET is undefined. Here is the various code I tried in CF 9: <cfset spreadsheetRemoveSheet(Patient_Output,"newCalc_P1")> <cfset temp = spreadsheetRemoveSheet(Patient_Output,"newCalc_P1")> <cfset Patient_Output = spreadsheetRemoveSheet(Patient_Output,"newCalc_P1")> <cfscript> Patient_Output = spreadsheetRemoveSheet(Patient_Output,"newCalc_P1"); </cfscript> I thought that with all the spreadsheet functionality that this project would be fairly quick and need it tomorrow. I was trying to find a work around for the duplicate sheet error in the last message I posted so thought maybe if I deleted the sheet first and then saved it I would have a work around and instead I just got another error message. Help!!! Thanks in advance for any and all help, Jeff ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
