Thanks again Charlie. I think you actually provided me with some of those links in response to a prior post in response to a post about another client that is still running MX and security issues involved with that.
I actually suggested to them that I could put them in contact with you but the system is so old and fragile that I think the decided against it. On Fri, Mar 14, 2014 at 9:32 PM, Charlie Arehart <char...@carehart.org>wrote: > I'll say again that it could be that your problem could be fixed by an > update. You are on 9.0. There were several hotfixes, cumulative hotfixes, > and security hotfixes for that. > > And even if you move to 9.0.1, there were several for that as well. > > But if you wonder if CF10 might solve it (indeed, it would include all the > hotfixes that existed for CF9 at the time CF10 was released), maybe just > install the free trial or dev edition on a box somewhere and try your code. > > Or if you have some example of code that stands alone entirely, one of us > running CF10 could run it for you. (Heck, we could run it on an updated CF9 > release and let you know if it runs.) > > Hope that's helpful. > > BTW, I created a blog entry based on the info I shared in the earlier note > (and expanding upon it), in case that info (about updating CF9 and earlier) > may be something anyone would want to share with others: > > > http://www.carehart.org/blog/client/index.cfm/2014/3/14/cf9_and_earlier_hotfix_guide > > > > /charlie > > > > *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Jeff > Howard > *Sent:* Friday, March 14, 2014 12:15 PM > *To:* discussion@acfug.org > *Subject:* Re: [ACFUG Discuss] does SPREADSHEETREMOVESHEET not work? > > > > So looking further into the documentation, SpreadSheetRemoveSheet was > added in 9.01 so that does explain why my version is not recognizing the > function. I should've noticed that but I was in hour 13 of my work day and > it slipped past. > > > > Any ideas on why the "update" isn't working? > > > > Thanks again, > > Jeff > > > > > > > > On Fri, Mar 14, 2014 at 11:22 AM, Jeff Howard <jeh...@gmail.com> wrote: > > Thanks Charlie. > > > > The real solution would be sfspreadsheet = "update" to work as posted in > my post/email just prior to this. The idea to delete the spreadsheet was me > trying to figure out a work around for the update not working. > > > > Any help with that (from anyone in the know) would be greatly appreciated. > > > > The version of CF is 9,0,0,251028. I got an email from the hosting company > (Hostek) about updating my server to a CF10 server this morning. So if this > is an issue with CF 9,0,0,251028 and updating to a CF10 server would solve > the problem then I'll go that route. If there is just something I'm not > seeing in the code that is a quicker fix, I'll do that and the > upgrade/update the server over the weekend. > > > > Once again on this is the error I'm getting: > > > An exception occurred while using action=update. > > > > java.lang.IllegalArgumentException: The workbook already contains a sheet > of this name > > > > When I run this code that is reading a blank xls template, plugging in > data and trying to save it. The problem seems to be that the first > spreadsheet read is reading both sheets and then subsequently saving both > sheets and then when I try to do the update it says that the sheet already > exists. > > > > > <cfspreadsheet action="read" > src="#application.rootDir#assets\C3d\IgG_Single_Template.xlsm" > name="Patient_Output" sheet="1"> > <cfspreadsheet action="read" > src="#application.rootDir#assets\C3d\IgG_Single_Template.xlsm" > name="newCalc_P1" sheet="2"> > > <cfset > SpreadsheetSetCellValue(Patient_Output,patientResults.patientName,7,5)> > <cfset SpreadsheetSetCellValue(Patient_Output,patientResults.clinic,8,5)> > <cfset > SpreadsheetSetCellValue(Patient_Output,DateFormat(patientResults.patientDOB,"mm/dd/yyyy"),9,5)> > <cfset > SpreadsheetSetCellValue(Patient_Output,DateFormat(patientResults.sampleDate,"mm/dd/yyyy"),10,5)> > <cfset > SpreadsheetSetCellValue(Patient_Output,DateFormat(patientResults.reportDate,"mm/dd/yyyy"),11,5)> > <cfset SpreadsheetSetCellValue(Patient_Output,patientResults.doctor,12,5)> > <cfset SpreadsheetSetCellValue(Patient_Output,"link goes here",13,3)> > > <!--- remove columns that should not be displayed in the charts ---> > <cfset assayList = ListDeleteAt(getIgG.columnList, > ListFindNoCase(getIgG.columnList,"IgGID"))> > <cfset assayList = ListDeleteAt(assayList, > ListFindNoCase(assayList,"IgGValuesID"))> > <cfset assayList = ListDeleteAt(assayList, > ListFindNoCase(assayList,"patientID"))> > <cfset writeRow = 1> > <cfset writeColAdd = 0> > <cfloop list="#assayList#" index="curAssay"> > <!--- Determine what row to write the value to. ---> > <cfset writeRow = ++writeRow> > <cfif writeRow eq 46> > <cfset writeRow = 2> > <cfset writeColAdd = writeColAdd + 7> > </cfif> > <cfset curAssayValue = "getIgG.#curAssay#"> > <!--- Determine what column to write the value to. ---> > <cfif Evaluate(curAssayValue) lt 1> > <cfset writeCol = 2 + writeColAdd> > <cfelseif Evaluate(curAssayValue) gte 1 AND Evaluate(curAssayValue) lt > 2> > <cfset writeCol = 3 + writeColAdd> > <cfelseif Evaluate(curAssayValue) gte 2 AND Evaluate(curAssayValue) lt > 3> > <cfset writeCol = 4 + writeColAdd> > <cfelseif Evaluate(curAssayValue) gte 3 AND Evaluate(curAssayValue) lt > 4> > <cfset writeCol = 5 + writeColAdd> > <cfelseif Evaluate(curAssayValue) gte 4> > <cfset writeCol = 6 + writeColAdd> > </cfif> > <!--- Write the value to cell. ---> > <cfset > SpreadsheetSetCellValue(newCalc_P1,Evaluate(curAssayValue),writeRow,writeCol)> > <!--- ---> > <cfset theValue = > SpreadsheetGetCellValue(newCalc_P1,writeRow,writeCol)> > > </cfloop> > <!--- Write both sheets to the new file. ---> > <cfspreadsheet action="write" filename="#theFile#" name="Patient_Output" > overwrite="true"> > <cfspreadsheet action="update" filename="#theFile#" name="newCalc_P1" > sheetname="newCalc_P1"> > <!--- Redirect user to the patient spreadsheet. ---> > <cflocation url="/C3d/individual_results/#patientResults.lname#.xlsm"> > > > > On Fri, Mar 14, 2014 at 9:55 AM, Charlie Arehart <char...@carehart.org> > wrote: > > 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_been_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_installer_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_ColdFusion_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:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Jeff > Howard > *Sent:* Friday, March 14, 2014 1:15 AM > *To:* discussion@acfug.org > *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 FusionLink <http://www.fusionlink.com> > ------------------------------------------------------------- > > > > > > ------------------------------------------------------------- > 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 FusionLink <http://www.fusionlink.com> > ------------------------------------------------------------- >