User Guide Cancel

SpreadsheetSetCellFormula

Search
ColdFusion

ColdFusion

Open app
  • CFML Reference User Guide
  • ColdFusion functions
    1. ColdFusion functions by category
      1. Abs
      2. ACos
      3. AddSOAPRequestHeader
      4. AddSOAPResponseHeader
      5. AjaxLink
      6. AjaxOnLoad
      7. ApplicationStop
      8. ArrayAppend
      9. ArrayAvg
      10. ArrayClear
      11. ArrayContains
      12. ArrayContainsNoCase
      13. ArrayDelete
      14. ArrayDeleteAt
      15. ArrayDeleteNoCase
      16. ArrayEach
      17. ArrayFilter
      18. ArrayFind
      19. ArrayFindAll
      20. ArrayFindAllNoCase
      21. ArrayFindNoCase
      22. ArrayInsertAt
      23. ArrayIsDefined
      24. ArrayIsEmpty
      25. ArrayLen
      26. ArrayMap
      27. ArrayMax
      28. ArrayMin
      29. ArrayNew
      30. ArrayPrepend
      31. ArrayReduce
      32. ArrayResize
      33. ArraySet
      34. ArraySetMetadata
      35. ArraySlice
      36. ArraySort
      37. ArraySum
      38. ArraySwap
      39. ArrayToList
      40. Asc
      41. ASin
      42. Atn
      43. AuthenticatedContext
      44. AuthenticatedUser
      45. BinaryDecode
      46. BinaryEncode
      47. BitAnd
      48. BitMaskClear
      49. BitMaskRead
      50. BitMaskSet
      51. BitNot
      52. BitOr
      53. BitSHLN
      54. BitSHRN
      55. BitXor
      56. BooleanFormat
      1. CacheGet
      2. CacheGetAllIds
      3. CacheGetMetadata
      4. CacheGetProperties
      5. CacheGetSession
      6. CacheIdExists
      7. CachePut
      8. CacheRegionExists
      9. CacheRegionNew
      10. CacheRegionRemove
      11. CacheRemove
      12. CacheRemoveAll
      13. CacheSetProperties
      14. CallStackDump
      15. CallStackGet
      16. CanDeSerialize
      17. Canonicalize
      18. CanSerialize
      19. Ceiling
      20. CharsetDecode
      21. CharsetEncode
      22. Chr
      23. CJustify
      24. Compare
      25. CompareNoCase
      26. Cos
      27. CreateDate
      28. CreateDateTime
      29. CreateObject
      30. CreateObject: .NET object
      31. CreateObject: COM object
      32. CreateObject: component object
      33. CreateObject: CORBA object
      34. CreateObject: Java or EJB object
      35. CreateObject: web service object
      36. CreateODBCDate
      37. CreateODBCDateTime
      38. CreateODBCTime
      39. CreateSignedJWT
      40. CreateEncryptedJWT
      41. CreateTime
      42. CreateTimeSpan
      43. CreateUUID
      44. CSRFGenerateToken
      45. CSRFVerifyToken
      46. CSVRead
      47. CSVWrite
      48. CSVProcess
      49. DateAdd
      50. DateCompare
      51. DateConvert
      52. DateDiff
      53. DateFormat
      54. DatePart
      55. DateTimeFormat
      56. Day
      57. DayOfWeek
      58. DayOfWeekAsString
      59. DayOfYear
      60. DaysInMonth
      61. DaysInYear
      62. DE
      63. DecimalFormat
      64. DecodeForHTML
      65. DecodeFromURL
      66. DecrementValue
      67. Decrypt
      68. DecryptBinary
      69. DeleteClientVariable
      70. Deserialize
      71. DeserializeJSON
      72. DeserializeXML
      73. DirectoryCopy
      74. DirectoryCreate
      75. DirectoryDelete
      76. DirectoryExists
      77. DirectoryList
      78. DirectoryRename
      79. DollarFormat
      80. DotNetToCFType
      81. Duplicate
      1. EncodeForCSS
      2. EncodeForDN
      3. EncodeForHTML
      4. EncodeForHTMLAttribute
      5. EncodeForJavaScript
      6. EncodeForLDAP
      7. EncodeForURL
      8. EncodeForXML
      9. EncodeForXMLAttribute
      10. EncodeForXpath
      11. Encrypt
      12. EncryptBinary
      13. EntityDelete
      14. EntityLoad
      15. EntityLoadByExample
      16. EntityLoadByPK
      17. EntityMerge
      18. EntityNew
      19. EntityReload
      20. EntitySave
      21. EntityToQuery
      22. Evaluate
      23. Exp
      24. ExpandPath
      25. FileClose
      26. FileCopy
      27. FileDelete
      28. FileExists
      29. FileGetMimeType
      30. FileIsEOF
      31. FileMove
      32. FileOpen
      33. FileRead
      34. FileReadBinary
      35. FileReadLine
      36. FileSeek
      37. FileSetAccessMode
      38. FileSetAttribute
      39. FileSetLastModified
      40. FileSkipBytes
      41. FileUpload
      42. FileUploadAll
      43. FileWrite
      44. FileWriteLine
      45. Find
      46. FindNoCase
      47. FindOneOf
      48. FirstDayOfMonth
      49. Fix
      50. Floor
      51. FormatBaseN
      52. GeneratePBKDFKey
      53. GenerateSecretKey
      54. GetAuthUser
      55. GetBaseTagData
      56. GetBaseTagList
      57. GetBaseTemplatePath
      58. GetClientVariablesList
      59. GetComponentMetaData
      60. GetContextRoot
      61. GetCPUUsage
      62. GetCurrentTemplatePath
      63. GetCSPNonce
      64. GetDirectoryFromPath
      65. GetEncoding
      66. GetException
      67. GetFileFromPath
      68. GetFileInfo
      69. GetFreeSpace
      70. GetFunctionCalledName
      71. GetFunctionList
      72. GetGatewayHelper
      73. GetHttpRequestData
      74. GetHttpTimeString
      75. GetK2ServerDocCount
      76. GetK2ServerDocCountLimit
      77. GetLocale
      78. GetLocaleDisplayName
      79. GetLocalHostIP
      80. GetMetaData
      81. GetMetricData
      82. GetPageContext
      83. GetPropertyString
      84. GetPropertyFile
      85. GetPrinterInfo
      86. GetPrinterList
      87. GetProfileSections
      88. GetProfileString
      89. GetReadableImageFormats
      90. GetSafeHTML
      91. GetSAMLAuthRequest
      92. GetSAMLLogoutRequest
      93. Generate3DesKey
      94. GenerateSAMLSPMetadata
      95. GetSOAPRequest
      96. GetSOAPRequestHeader
      97. GetSOAPResponse
      98. GetSOAPResponseHeader
      99. GetSystemFreeMemory
      100. GetSystemTotalMemory
      101. GetTempDirectory
      102. GetTempFile
      103. GetTemplatePath
      104. GetTickCount
      105. GetTimeZoneInfo
      106. GetToken
      107. GetTotalSpace
      108. GetUserRoles
      109. GetVFSMetaData
      110. GetWriteableImageFormats
      1. Hash
      2. HMac
      3. Hour
      4. HQLMethods
      5. HTMLCodeFormat
      6. HTMLEditFormat
      7. IIf
      8. ImageAddBorder
      9. ImageBlur
      10. ImageClearRect
      11. ImageCopy
      12. ImageCreateCaptcha
      13. ImageCrop
      14. ImageDrawArc
      15. ImageDrawBeveledRect
      16. ImageDrawCubicCurve
      17. ImageDrawLine
      18. ImageDrawLines
      19. ImageDrawOval
      20. ImageDrawPoint
      21. ImageDrawQuadraticCurve
      22. ImageDrawRect
      23. ImageDrawRoundRect
      24. ImageDrawText
      25. ImageFlip
      26. ImageGetBlob
      27. ImageGetBufferedImage
      28. ImageGetEXIFMetadata
      29. ImageGetEXIFTag
      30. ImageGetHeight
      31. ImageGetIPTCMetadata
      32. ImageGetIPTCTag
      33. ImageGetMetadata
      34. ImageGetWidth
      35. ImageGrayscale
      36. ImageInfo
      37. ImageMakeColorTransparent
      38. ImageMakeTranslucent
      39. ImageNegative
      40. ImageNew
      41. ImageOverlay
      42. ImagePaste
      43. ImageRead
      44. ImageReadBase64
      45. ImageResize
      46. ImageRotate
      47. ImageRotateDrawingAxis
      48. ImageScaleToFit
      49. ImageSetAntialiasing
      50. ImageSetBackgroundColor
      51. ImageSetDrawingColor
      52. ImageSetDrawingStroke
      53. ImageSetDrawingTransparency
      54. ImageSharpen
      55. ImageShear
      56. ImageShearDrawingAxis
      57. ImageTranslate
      58. ImageTranslateDrawingAxis
      59. ImageWrite
      60. ImageWriteBase64
      61. ImageXORDrawingMode
      1. IncrementValue
      2. InputBaseN
      3. Insert
      4. Int
      5. InterruptThread
      6. InvalidateOauthAccesstoken
      7. Invoke
      8. InitSAMLAuthRequest
      9. InitSAMLLogoutRequest
      10. InvokeCFClientFunction
      11. IsArray
      12. IsAuthenticated
      13. IsAuthorized
      14. IsBinary
      15. IsBoolean
      16. IsClosure
      17. IsCustomFunction
      18. IsDate
      19. IsDateObject
      20. IsDDX
      21. IsDebugMode
      22. IsDefined
      23. IsImage
      24. IsImageFile
      25. IsInstanceOf
      26. IsIPv6
      27. IsJSON
      28. IsK2ServerABroker
      29. IsK2ServerDocCountExceeded
      30. IsK2ServerOnline
      31. IsLeapYear
      32. IsLocalHost
      33. IsNull
      34. IsNumeric
      35. IsNumericDate
      36. IsObject
      37. isOnline
      38. IsPDFArchive
      39. IsPDFFile
      40. IsPDFObject
      41. IsProtected
      42. IsQuery
      43. isSamlLogoutResponse
      44. isSafeHTML
      45. IsSimpleValue
      46. IsSOAPRequest
      47. IsSpreadsheetFile
      48. IsSpreadsheetObject
      49. IsStruct
      50. isThreadInterrupted
      51. IsUserInAnyRole
      52. IsUserInRole
      53. IsUserLoggedIn
      54. IsValid
      55. IsValidOauthAccesstoken
      56. IsWDDX
      57. IsXML
      58. IsXmlAttribute
      59. IsXmlDoc
      60. IsXmlElem
      61. IsXmlNode
      62. IsXmlRoot
      63. JavaCast
      64. JSStringFormat
      1. LCase
      2. Left
      3. Len
      4. ListAppend
      5. ListChangeDelims
      6. ListContains
      7. ListContainsNoCase
      8. ListDeleteAt
      9. ListEach
      10. ListFilter
      11. ListFind
      12. ListFindNoCase
      13. ListFirst
      14. ListGetAt
      15. ListGetDuplicates
      16. ListInsertAt
      17. ListLast
      18. ListLen
      19. ListMap
      20. ListPrepend
      21. ListQualify
      22. ListReduce
      23. ListRemoveDuplicates
      24. ListRest
      25. ListSetAt
      26. ListSort
      27. ListToArray
      28. ListValueCount
      29. ListValueCountNoCase
      30. LJustify
      31. Location
      32. Log
      33. Log10
      34. LSCurrencyFormat
      35. LSDateFormat
      36. LSDateTimeFormat
      37. LSEuroCurrencyFormat
      38. LSIsCurrency
      39. LSIsDate
      40. LSIsNumeric
      41. LSNumberFormat
      42. LSParseCurrency
      43. LSParseDateTime
      44. LSParseEuroCurrency
      45. LSParseNumber
      46. LSTimeFormat
      47. LTrim
      1. Max
      2. Mid
      3. Min
      4. Minute
      5. Month
      6. MonthAsString
      7. Now
      8. NumberFormat
      9. ObjectEquals
      10. ObjectLoad
      11. ObjectSave
      12. OnWSAuthenticate
      13. ORMClearSession
      14. ORMCloseAllSessions
      15. ORMCloseSession
      16. ORMEvictCollection
      17. ORMEvictEntity
      18. ORMEvictQueries
      19. ORMExecuteQuery
      20. ORMFlush
      21. ORMFlushall
      22. ORMGetSession
      23. ORMGetSessionFactory
      24. ORMIndex
      25. ORMIndexPurge
      26. ORMReload
      27. ORMSearch
      28. ORMSearchOffline
      29. ParagraphFormat
      30. ParameterExists
      31. ParseDateTime
      32. Pi
      33. PrecisionEvaluate
      34. ProcessSAMLResponse
      35. ProcessSAMLLogoutRequest
      36. Quarter
      37. PreserveSingleQuotes
      38. QueryAddColumn
      39. QueryAddRow
      40. QueryConvertForGrid
      41. QueryExecute
      42. QueryFilter
      43. QueryGetResult
      44. QueryGetRow
      45. QueryKeyExists
      46. QueryMap
      47. QueryNew
      48. QueryReduce
      49. QuerySetCell
      50. QuotedValueList
      51. QueryEach
      52. Rand
      53. Randomize
      54. RandRange
      55. ReEscape
      56. REFind
      57. REFindNoCase
      58. ReleaseComObject
      59. REMatch
      60. REMatchNoCase
      61. RemoveCachedQuery
      62. RemoveChars
      63. RepeatString
      64. Replace
      65. ReplaceList
      66. ReplaceNoCase
      67. REReplace
      68. REReplaceNoCase
      69. RestDeleteApplication
      70. RestSetResponse
      71. RestInitApplication
      72. Reverse
      73. Right
      74. RJustify
      75. Round
      76. RTrim
    9. Functions-s
      1. Second
      2. SendGatewayMessage
      3. SendSAMLLogoutResponse
      4. Serialize
      5. SerializeJSON
      6. SerializeXML
      7. SessionInvalidate
      8. SessionRotate
      9. SessionGetMetaData
      10. SessionInvalidate
      11. SessionRotate
      12. SetDay
      13. SetEncoding
      14. SetHour
      15. SetLocale
      16. SetMonth
      17. SetProfileString
      18. SetPropertyString
      19. SetVariable
      20. SetYear
      21. Sgn
      22. Sin
      23. Sleep
      24. SpanExcluding
      25. SpanIncluding
      26. SpreadsheetAddAutoFilter
      27. SpreadsheetAddColumn
      28. SpreadsheetAddFreezePane
      29. SpreadsheetAddImage
      30. SpreadsheetAddInfo
      31. SpreadsheetAddPageBreaks
      32. SpreadsheetAddRow
      33. SpreadsheetAddRows
      34. SpreadsheetAddSplitPane
      35. SpreadsheetCreateSheet
      36. SpreadsheetDeleteColumn
      37. SpreadsheetDeleteColumns
      38. SpreadsheetDeleteRow
      39. SpreadsheetDeleteRows
      40. SpreadsheetFormatCell
      41. SpreadsheetFormatColumn
      42. SpreadsheetFormatCellRange
      43. SpreadsheetFormatColumn
      44. SpreadsheetFormatColumns
      45. SpreadsheetFormatRow
      46. SpreadsheetFormatRows
      47. SpreadsheetGetCellComment
      48. SpreadsheetGetCellFormula
      49. SpreadsheetGetCellValue
      50. SpreadsheetGetColumnCount
      51. SpreadsheetInfo
      52. SpreadsheetMergeCells
      53. SpreadsheetNew
      54. SpreadsheetRead
      55. SpreadsheetReadBinary
      56. SpreadsheetRemoveSheet
      57. SpreadsheetSetActiveSheet
      58. SpreadsheetSetActiveSheetNumber
      59. SpreadsheetSetCellComment
      60. SpreadsheetSetCellFormula
      61. SpreadsheetSetCellValue
      62. SpreadsheetSetColumnWidth
      63. SpreadsheetSetFooter
      64. SpreadsheetSetHeader
      65. SpreadsheetSetRowHeight
      66. SpreadsheetShiftColumns
      67. SpreadsheetShiftRows
      68. SpreadsheetWrite
      69. StreamingSpreadsheetNew
      70. StreamingSpreadsheetCleanup
      71. StreamingSpreadsheetRead
      72. StreamingSpreadsheetProcess
      73. SpreadsheetSetFooterImage
      74. SpreadsheetSetHeaderImage
      75. SpreadsheetSetFittoPage
      76. SpreadsheetUngroupColumns
      77. SpreadsheetGroupColumns
      78. SpreadsheetUngroupRows
      79. SpreadsheetGroupRows
      80. SpreadsheetRemoveColumnBreak
      81. SpreadsheetSetColumnBreak
      82. SpreadsheetRemoveRowBreak
      83. SpreadsheetSetRowBreak
      84. SpreadsheetRemovePrintGridlines
      85. SpreadsheetAddPrintGridlines
      86. SpreadsheetGetColumnWidth
      87. SpreadsheetSetColumnHidden
      88. SpreadsheetSetRowHidden
      89. SpreadsheetisColumnHidden
      90. SpreadsheetisRowHidden
      91. SpreadsheetisStreamingXmlFormat
      92. SpreadsheetisXmlFormat
      93. SpreadsheetisBinaryFormat
      94. SpreadsheetRenameSheet
      95. SpreadsheetRemoveSheetNumber
      96. SpreadsheetGetLastRowNumber
      97. SpreadsheetGetPrintOrientation
      98. Sqr
      99. StripCR
      100. StructAppend
      101. StructClear
      102. StructCopy
      103. StructCount
      104. StructDelete
      105. StructEach
      106. StructFilter
      107. StructFind
      108. StructFindKey
      109. StructFindValue
      110. StructGet
      111. StructGetMetadata
      112. StructInsert
      113. StructIsEmpty
      114. StructKeyArray
      115. StructKeyExists
      116. StructKeyList
      117. StructMap
      118. StructNew
      119. StructReduce
      120. StructSetMetadata
      121. StructSort
      122. StructToSorted
      123. StructUpdate
      124. StructValueArray
      125. StoreSetMetadata
      126. StoreGetACL
      127. StoreGetMetadata
      128. StoreAddACL
      129. StoreSetACL
      1. Tan
      2. ThreadJoin
      3. ThreadTerminate
      4. Throw
      5. TimeFormat
      6. ToBase64
      7. ToBinary
      8. ToScript
      9. ToString
      10. Trace
      11. Transactionandconcurrency
      12. TransactionCommit
      13. TransactionRollback
      14. TransactionSetSavePoint
      15. Trim
      16. UCase
      17. URLDecode
      18. URLEncodedFormat
      19. URLSessionFormat
      20. Val
      21. ValueList
      22. VerifyClient
      23. Week
      24. Wrap
      25. WriteDump
      26. WriteLog
      27. WriteOutput
      28. WSGetAllChannels
      29. WSGetSubscribers
      30. WSPublish
      31. WSSendMessage
      32. XmlChildPos
      33. XmlElemNew
      34. XmlFormat
      35. XmlGetNodeType
      36. XmlNew
      37. XmlParse
      38. XmlSearch
      39. XmlTransform
      40. XmlValidate
      41. Year
      42. YesNoFormat
    1. ColdFusion tag summary
        1. cfapplication
        2. cfassociate
        3. cferror
        4. cfimport
        5. cfinterface
        6. cflock
        7. cfscript
        8. cfthread
        1. cfexchangecalendar
        2. cfexchangeconnection
        3. cfexchangecontact
        4. cfexchangefilter
        5. cfexchangemail
        6. cfexchangetask
        7. cfexchangefolder
        8. cfexchangeconversation
        9. cffeed
        10. cfmail
        11. cfmailparam
        12. cfmailpart
        13. cfpop
        1. cfdbinfo
        2. cfinsert
        3. cfobjectcache
        4. cfprocparam
        5. cfprocresult
        6. cfquery
        7. cfqueryparam
        8. cfstoredproc
        9. cftransaction
        10. cfupdate
        1. cfchart
        1. cfdump
        2. cftimer
        3. cftrace
        1. cfcatch
        2. cferror
        3. cffinally
        4. cfrethrow
        5. cfthrow
        6. cftry
        1. cfchart
        2. cfchartdata
        3. cfchartseries
        4. cfcollection
        5. cfcomponent
        6. cfexecute
        7. cfftp
        8. function
        9. cfindex
        10. cfinterface
        11. cfinvoke
        12. cfinvokeargument
        13. cfobject
        14. cfproperty
        15. cfreport
        16. cfreportparam
        17. cfreturn
        18. cfsearch
        19. cfsharepoint
        20. cfspreadsheet
        21. cfwddx
        22. cfxml
        1. cfdirectory
        2. cffile
        3. cffileupload
        4. cfftp
        5. cfzip
        6. cfzipparam
        1. cfabort
        2. cfbreak
        3. cfcase
        4. cfcontinue
        5. cfdefaultcase
        6. cfelse
        7. cfelseif
        8. cfexecute
        9. cfexit
        10. cfif
        11. cfinclude
        12. cflocation
        13. cfloop
        14. cfrethrow
        15. cfswitch
        16. cfthrow
        17. cftry
        1. cfapplet
        2. cfcalendar
        3. cffileupload
        4. cfform
        5. cfformgroup
        6. cfformitem
        7. cfgrid
        8. cfgridcolumn
        9. cfgridrow
        10. cfgridupdate
        11. cfinput
        12. cfpdf
        13. cfpdfform
        14. cfpdfformparam
        15. cfpdfparam
        16. cfpdfsubform
        17. cfselect
        18. cfslider
        19. cftextarea
        20. cftree
        21. cftreeitem
        1. cfajaximport
        2. cfajaxproxy
        3. cfftp
        4. cffeed
        5. cfimap
        6. cfhttp
        7. cfhttpparam
        8. cfldap
        9. cfmail
        10. cfmailparam
        11. cfmailpart
        12. cfpop
        13. cfsprydataset
        1. cfcache
        2. cfcontent
        3. cfflush
        4. cfheader
        5. cfhtmlhead
        6. cfinclude
        7. cfprocessingdirective
        8. cfsetting
        9. cfsilent
        1. cflogin
        2. cfloginuser
        3. cflogout
        4. cfNTauthenticate
        1. cfcookie
        2. cfdump
        3. cfparam
        4. cfregistry
        5. cfsavecontent
        6. cfschedule
        7. cfset
        8. cfsetting
        1. cfimage
        2. cflog
        3. cfregistry
      1. cfabort
      2. cfajaximport
      3. cfajaxproxy
      4. cfapplet
      5. cfapplication
      6. cfargument
      7. cfassociate
      8. cfauthenticate
      9. cfbreak
      1. cfcache
      2. cfcalendar
      3. cfcase
      4. cfcatch
        1. cfchart tag in ColdFusion
        2. Get started with cfchart
        3. Customize a chart using cfchart
        4. Advanced cfchart customization options
        5. Create an area chart in ColdFusion
        6. Create line charts in ColdFusion
        7. Create bar charts in ColdFusion
        8. Create floating bar charts in ColdFusion
        9. Create histograms in ColdFusion
        10. Create pie charts in ColdFusion
        11. Create funnel charts in ColdFusion
        12. Create pyramid charts in ColdFusion
        13. Create curve charts in ColdFusion
        14. Create boxplots in ColdFusion
        15. Create donut charts in ColdFusion
        16. Create bubble charts in ColdFusion
        17. Create scatterplots in ColdFusion
        18. Create radar charts in ColdFusion
        19. Other chart types in ColdFusion (Cone, Cylinder, Piano, and Bullet)
          1. Add markers to ColdFusion charts
          2. Add rules to ColdFusion charts
          3. Format numbers in ColdFusion charts
          4. Add animation to ColdFusion charts
          5. Create and apply themes to ColdFusion charts
      6. cfchartdata
      7. cfchartseries
      8. cfchartset
      9. cfclient
      10. cfclientsettings
      11. cfcol
      12. cfcollection
      13. cfcomponent
      14. cfcontent
      15. cfcontinue
      16. cfcookie
      1. cffeed
      2. cffile
      3. cffile action = "append"
      4. cffile action = "copy"
      5. cffile action = "delete"
      6. cffile action = "move"
      7. cffile action = "read"
      8. cffile action = "readBinary"
      9. cffile action = "rename"
      10. cffile action = "upload"
      11. cffile action = "uploadAll"
      12. cffile action = "write"
      13. cffileupload
      14. cffinally
      15. cfflush
      16. cfform
      17. cfformgroup
      18. cfformitem
      19. cfftp
      20. cfftp: Connection: file and directory operations
      21. cfftp: Opening and closing FTP server connections
      22. cfftp : Opening and closing secure FTP server connections
      23. cfftp action = "listDir"
      24. cffunction
      1. cfgraph
      2. cfgraphdata
      3. cfgrid
      4. cfgridcolumn
      5. cfgridrow
      6. cfgridupdate
      7. cfheader
      8. cfhtmlhead
      9. cfhtmltopdf
      10. cfhtmltopdfitem
      11. cfhttp
      12. cfhttpparam
      1. cfif
      2. cfimage
      3. cfimap
      4. cfimapfilter
      5. cfimpersonate
      6. cfimport
      7. cfinclude
      8. cfindex
      9. cfinput
      10. cfinsert
      11. cfinterface
      12. cfinvoke
      13. cfinvokeargument
      1. cfjava
      2. cflayout
      3. cflayoutarea
      4. cfldap
      5. cflocation
      6. cflock
      7. cflog
      8. cflogin
      9. cfloginuser
      10. cflogout
      11. cfloop
      12. cfloop : conditional loop
      13. cfloop : index loop
      14. cfloop : looping over a COM collection or structure
      15. cfloop : looping over a date or time range
      16. cfloop : looping over a list, a file, or an array
      17. cfloop : looping over a query
      1. cfmail
      2. cfmailparam
      3. cfmailpart
      4. cfmap
      5. cfmapitem
      6. cfmediaplayer
      7. cfmenu
      8. cfmenuitem
      9. cfmessagebox
      10. cfmodule
      11. cfNTauthenticate
      12. cfoauth
      13. cfobject
      14. cfobject: .NET object
      15. cfobject: COM object
      16. cfobject: component object
      17. cfobject: CORBA object
      18. cfobject: Java or EJB object
      19. cfobject: web service object
      20. cfobjectcache
      21. cfoutput
      1. cfparam
      2. cfpdf
      3. cfpdfform
      4. cfpdfformparam
      5. cfpdfparam
      6. cfpdfsubform
      7. cfpod
      8. cfpop
      9. cfpresentation
      10. cfpresentationslide
      11. cfpresenter
      12. cfprint
      13. cfprocessingdirective
      14. cfprocparam
      15. cfprocresult
      16. cfprogressbar
      17. cfproperty
      18. cfquery
      19. cfqueryparam
      1. cfregistry
      2. cfreport
      3. cfreportparam
      4. cfrethrow
      5. cfreturn
      6. cfsavecontent
      7. cfschedule
      8. cfscript
      9. cfsearch
      10. cfselect
      11. cfservlet
      12. cfservletparam
      13. cfset
      14. cfsetting
      15. cfsharepoint
      16. cfsilent
      17. cfslider
      18. cfspreadsheet
      19. cfsprydataset
      20. cfstoredproc
      21. cfswitch
      1. cftable
      2. cftextarea
      3. cftextinput
      4. cfthread
      5. cfthrow
      6. cftimer
      7. cftooltip
      8. cftrace
      9. cftransaction
      10. cftree
      11. cftreeitem
      12. cftry
      1. cfupdate
      2. cfwddx
      3. cfwebsocket
      4. cfwindow
      5. cfxml
      6. cfzip
      7. cfzipparam
      1. Reserved words and variables
      2. Reserved words
      3. Scope-specific built-in variables
      4. Custom tag variables
      5. ColdFusion tag-specific variables
      6. CGI environment (CGI Scope) variables
      1. Ajax JavaScript functions
      2. Function summary Ajax
      3. ColdFusion.Ajax.submitForm
      4. ColdFusion.Autosuggest.getAutosuggestObject
      5. ColdFusion.Layout.enableSourceBind
      6. ColdFusion.MessageBox.getMessageBoxObject
      7. ColdFusion.ProgressBar.getProgressBarObject
      8. ColdFusion.MessageBox.isMessageBoxDefined
      9. JavaScriptFunctionsinColdFusion9Update1
      1. ColdFusion ActionScript functions
      2. CF.http
      3. CF.query
      1. ColdFusion Mobile Functions
      2. Accelerometer Functions
      3. Camera Functions
      4. Connection Functions
      5. Contact Functions
      6. Event Functions
      7. File System Functions
      8. Geolocation Functions
      9. Media and Capture Functions
      10. Notification Functions
      11. Splash Screen Functions
      12. Storage Functions
      1. Application.CFC reference
      2. Application variables
      3. Method summary
      4. onAbort
      5. onApplicationEnd
      6. onApplicationStart
      7. onMissingTemplate
      8. onCFCRequest
      9. onError
      10. onRequestEnd
      11. onRequest
      12. onRequestStart
      13. onServerStart
      14. onSessionEnd
      15. onSessionStart
      1. Script Functions Implemented as CFCs
      2. Accessing the functions
      3. Function summary
      4. ftp
      5. http
      6. mail
      7. pdf
      8. query
      9. Script functions implemented as CFCs in ColdFusion 9 Update 1
      10. storedproc
      1. Styles valid for all controls
      2. Styles for cfform
      3. Styles for cfformgroup with horizontal or vertical type attributes
      4. Styles for box-style cfformgroup elements
      5. Styles for cfformgroup with accordion type attribute
      6. Styles for cfformgroup with tabnavigator type attribute
      7. Styles for cfformitem with hrule or vrule type attributes
      8. Styles for cfinput with radio, checkbox, button, image, or submit type attributes
      9. Styles for cftextarea tag and cfinput with text, password, or hidden type attributes
      10. Styles for cfselect with size attribute value of 1
      11. Styles for cfselect with size attribute value greater than 1
      12. Styles for cfcalendar tag and cfinput with dateField type attribute
      13. Styles for the cfgrid tag
      14. Styles for the cftree tag
      15. ColdFusion Flash Form Style Reference
      1. ColdFusion Event Gateway reference
      2. addEvent
      3. CFEvent
      4. CFEventclass
      5. Constructor
      6. Gateway development interfaces and classes
      7. getStatus
      8. setCFCPath
      9. setCFCMethod
      10. getOriginatorID
      11. getLogger
      12. getBuddyList
      13. getBuddyInfo
      14. IM gateway message sending commands
      15. IM Gateway GatewayHelper class methods
      16. onIncomingMessage
      17. onIMServerMessage
      18. onBuddyStatus
      19. onAddBuddyResponse
      20. onAddBuddyRequest
      21. IM Gateway CFC incoming message methods
      22. IM gateway methods and commands
      23. CFML CFEvent structure
      24. warn
      25. info
      26. setOriginatorID
      27. data command
      28. submit Multi command
      29. submit command
      30. setGatewayType
      31. setGatewayID
      32. setData
      33. setCFCListeners
      34. outgoingMessage
      35. getStatusTimeStamp
      36. numberOfMessagesReceived
      37. numberOfMessagesSent
      38. removeBuddy
      39. removeDeny
      40. removePermit
      41. setNickName
      42. setPermitMode
      43. setStatus
      44. SMS Gateway CFEvent structure and commands
      45. SMS Gateway incoming message CFEvent structure
      46. getStatusAsString
      47. getProtocolName
      48. getPermitMode
      49. getPermitList
      50. getNickName
      51. getName
      52. getDenyList
      53. getCustomAwayMessage
      54. getQueueSize
      55. getMaxQueueSize
      56. getHelper
      57. getGatewayType
      58. getGatewayServices
      59. getGatewayID_1
      60. getGatewayID
      61. getData
      62. getCFCTimeout
      63. setCFCTimeout
      64. getCFCPath
      65. getCFCMethod
      66. GatewayServices class
      67. Gateway interface
      68. GatewayHelper interface
      69. addPermit
      70. addDeny
      71. addBuddy
      72. error
      73. debug
      74. Logger class
      75. stop
      76. start
      77. CFML event gateway SendGatewayMessage data parameter
      78. restart
      79. fatal
      80. SMS gateway message sending commands
      1. C++ class overview
      2. Deprecated class methods
      3. CCFXException class
      4. CCFXQuery class
      5. CCFXRequest class
      6. CCFXStringSet class
      7. ColdFusion C++ CFX Reference
      1. ColdFusion Java CFX reference
      2. Class libraries overview
      3. Custom tag interface
      4. Query interface
      5. Request interface
      6. Response interface
      7. Debugging classes reference
      1. WDDX JavaScript objects
      2. JavaScript object overview
      3. WddxRecordset object
      4. WddxSerializer object
    1. ColdFusion and GCP Storage
    2. ColdFusion and GCP Firestore
    3. ColdFusion and GCP PubSub
    4. ColdFusion and Amazon S3
    5. ColdFusion and DynamoDB
    6. ColdFusion and Amazon SQS
    7. ColdFusion and Amazon SNS
    8. ColdFusion and MongoDB
    9. ColdFusion and Azure Blob
    10. ColdFusion and Azure Service Bus
    11. Multi-cloud storage services
    12. Multi-cloud RDS databases
    13. ColdFusion and Azure Cosmos DB
    1. CFML Reference User Guide
    2. ColdFusion functions
      1. ColdFusion functions by category
        1. Abs
        2. ACos
        3. AddSOAPRequestHeader
        4. AddSOAPResponseHeader
        5. AjaxLink
        6. AjaxOnLoad
        7. ApplicationStop
        8. ArrayAppend
        9. ArrayAvg
        10. ArrayClear
        11. ArrayContains
        12. ArrayContainsNoCase
        13. ArrayDelete
        14. ArrayDeleteAt
        15. ArrayDeleteNoCase
        16. ArrayEach
        17. ArrayFilter
        18. ArrayFind
        19. ArrayFindAll
        20. ArrayFindAllNoCase
        21. ArrayFindNoCase
        22. ArrayInsertAt
        23. ArrayIsDefined
        24. ArrayIsEmpty
        25. ArrayLen
        26. ArrayMap
        27. ArrayMax
        28. ArrayMin
        29. ArrayNew
        30. ArrayPrepend
        31. ArrayReduce
        32. ArrayResize
        33. ArraySet
        34. ArraySetMetadata
        35. ArraySlice
        36. ArraySort
        37. ArraySum
        38. ArraySwap
        39. ArrayToList
        40. Asc
        41. ASin
        42. Atn
        43. AuthenticatedContext
        44. AuthenticatedUser
        45. BinaryDecode
        46. BinaryEncode
        47. BitAnd
        48. BitMaskClear
        49. BitMaskRead
        50. BitMaskSet
        51. BitNot
        52. BitOr
        53. BitSHLN
        54. BitSHRN
        55. BitXor
        56. BooleanFormat
        1. CacheGet
        2. CacheGetAllIds
        3. CacheGetMetadata
        4. CacheGetProperties
        5. CacheGetSession
        6. CacheIdExists
        7. CachePut
        8. CacheRegionExists
        9. CacheRegionNew
        10. CacheRegionRemove
        11. CacheRemove
        12. CacheRemoveAll
        13. CacheSetProperties
        14. CallStackDump
        15. CallStackGet
        16. CanDeSerialize
        17. Canonicalize
        18. CanSerialize
        19. Ceiling
        20. CharsetDecode
        21. CharsetEncode
        22. Chr
        23. CJustify
        24. Compare
        25. CompareNoCase
        26. Cos
        27. CreateDate
        28. CreateDateTime
        29. CreateObject
        30. CreateObject: .NET object
        31. CreateObject: COM object
        32. CreateObject: component object
        33. CreateObject: CORBA object
        34. CreateObject: Java or EJB object
        35. CreateObject: web service object
        36. CreateODBCDate
        37. CreateODBCDateTime
        38. CreateODBCTime
        39. CreateSignedJWT
        40. CreateEncryptedJWT
        41. CreateTime
        42. CreateTimeSpan
        43. CreateUUID
        44. CSRFGenerateToken
        45. CSRFVerifyToken
        46. CSVRead
        47. CSVWrite
        48. CSVProcess
        49. DateAdd
        50. DateCompare
        51. DateConvert
        52. DateDiff
        53. DateFormat
        54. DatePart
        55. DateTimeFormat
        56. Day
        57. DayOfWeek
        58. DayOfWeekAsString
        59. DayOfYear
        60. DaysInMonth
        61. DaysInYear
        62. DE
        63. DecimalFormat
        64. DecodeForHTML
        65. DecodeFromURL
        66. DecrementValue
        67. Decrypt
        68. DecryptBinary
        69. DeleteClientVariable
        70. Deserialize
        71. DeserializeJSON
        72. DeserializeXML
        73. DirectoryCopy
        74. DirectoryCreate
        75. DirectoryDelete
        76. DirectoryExists
        77. DirectoryList
        78. DirectoryRename
        79. DollarFormat
        80. DotNetToCFType
        81. Duplicate
        1. EncodeForCSS
        2. EncodeForDN
        3. EncodeForHTML
        4. EncodeForHTMLAttribute
        5. EncodeForJavaScript
        6. EncodeForLDAP
        7. EncodeForURL
        8. EncodeForXML
        9. EncodeForXMLAttribute
        10. EncodeForXpath
        11. Encrypt
        12. EncryptBinary
        13. EntityDelete
        14. EntityLoad
        15. EntityLoadByExample
        16. EntityLoadByPK
        17. EntityMerge
        18. EntityNew
        19. EntityReload
        20. EntitySave
        21. EntityToQuery
        22. Evaluate
        23. Exp
        24. ExpandPath
        25. FileClose
        26. FileCopy
        27. FileDelete
        28. FileExists
        29. FileGetMimeType
        30. FileIsEOF
        31. FileMove
        32. FileOpen
        33. FileRead
        34. FileReadBinary
        35. FileReadLine
        36. FileSeek
        37. FileSetAccessMode
        38. FileSetAttribute
        39. FileSetLastModified
        40. FileSkipBytes
        41. FileUpload
        42. FileUploadAll
        43. FileWrite
        44. FileWriteLine
        45. Find
        46. FindNoCase
        47. FindOneOf
        48. FirstDayOfMonth
        49. Fix
        50. Floor
        51. FormatBaseN
        52. GeneratePBKDFKey
        53. GenerateSecretKey
        54. GetAuthUser
        55. GetBaseTagData
        56. GetBaseTagList
        57. GetBaseTemplatePath
        58. GetClientVariablesList
        59. GetComponentMetaData
        60. GetContextRoot
        61. GetCPUUsage
        62. GetCurrentTemplatePath
        63. GetCSPNonce
        64. GetDirectoryFromPath
        65. GetEncoding
        66. GetException
        67. GetFileFromPath
        68. GetFileInfo
        69. GetFreeSpace
        70. GetFunctionCalledName
        71. GetFunctionList
        72. GetGatewayHelper
        73. GetHttpRequestData
        74. GetHttpTimeString
        75. GetK2ServerDocCount
        76. GetK2ServerDocCountLimit
        77. GetLocale
        78. GetLocaleDisplayName
        79. GetLocalHostIP
        80. GetMetaData
        81. GetMetricData
        82. GetPageContext
        83. GetPropertyString
        84. GetPropertyFile
        85. GetPrinterInfo
        86. GetPrinterList
        87. GetProfileSections
        88. GetProfileString
        89. GetReadableImageFormats
        90. GetSafeHTML
        91. GetSAMLAuthRequest
        92. GetSAMLLogoutRequest
        93. Generate3DesKey
        94. GenerateSAMLSPMetadata
        95. GetSOAPRequest
        96. GetSOAPRequestHeader
        97. GetSOAPResponse
        98. GetSOAPResponseHeader
        99. GetSystemFreeMemory
        100. GetSystemTotalMemory
        101. GetTempDirectory
        102. GetTempFile
        103. GetTemplatePath
        104. GetTickCount
        105. GetTimeZoneInfo
        106. GetToken
        107. GetTotalSpace
        108. GetUserRoles
        109. GetVFSMetaData
        110. GetWriteableImageFormats
        1. Hash
        2. HMac
        3. Hour
        4. HQLMethods
        5. HTMLCodeFormat
        6. HTMLEditFormat
        7. IIf
        8. ImageAddBorder
        9. ImageBlur
        10. ImageClearRect
        11. ImageCopy
        12. ImageCreateCaptcha
        13. ImageCrop
        14. ImageDrawArc
        15. ImageDrawBeveledRect
        16. ImageDrawCubicCurve
        17. ImageDrawLine
        18. ImageDrawLines
        19. ImageDrawOval
        20. ImageDrawPoint
        21. ImageDrawQuadraticCurve
        22. ImageDrawRect
        23. ImageDrawRoundRect
        24. ImageDrawText
        25. ImageFlip
        26. ImageGetBlob
        27. ImageGetBufferedImage
        28. ImageGetEXIFMetadata
        29. ImageGetEXIFTag
        30. ImageGetHeight
        31. ImageGetIPTCMetadata
        32. ImageGetIPTCTag
        33. ImageGetMetadata
        34. ImageGetWidth
        35. ImageGrayscale
        36. ImageInfo
        37. ImageMakeColorTransparent
        38. ImageMakeTranslucent
        39. ImageNegative
        40. ImageNew
        41. ImageOverlay
        42. ImagePaste
        43. ImageRead
        44. ImageReadBase64
        45. ImageResize
        46. ImageRotate
        47. ImageRotateDrawingAxis
        48. ImageScaleToFit
        49. ImageSetAntialiasing
        50. ImageSetBackgroundColor
        51. ImageSetDrawingColor
        52. ImageSetDrawingStroke
        53. ImageSetDrawingTransparency
        54. ImageSharpen
        55. ImageShear
        56. ImageShearDrawingAxis
        57. ImageTranslate
        58. ImageTranslateDrawingAxis
        59. ImageWrite
        60. ImageWriteBase64
        61. ImageXORDrawingMode
        1. IncrementValue
        2. InputBaseN
        3. Insert
        4. Int
        5. InterruptThread
        6. InvalidateOauthAccesstoken
        7. Invoke
        8. InitSAMLAuthRequest
        9. InitSAMLLogoutRequest
        10. InvokeCFClientFunction
        11. IsArray
        12. IsAuthenticated
        13. IsAuthorized
        14. IsBinary
        15. IsBoolean
        16. IsClosure
        17. IsCustomFunction
        18. IsDate
        19. IsDateObject
        20. IsDDX
        21. IsDebugMode
        22. IsDefined
        23. IsImage
        24. IsImageFile
        25. IsInstanceOf
        26. IsIPv6
        27. IsJSON
        28. IsK2ServerABroker
        29. IsK2ServerDocCountExceeded
        30. IsK2ServerOnline
        31. IsLeapYear
        32. IsLocalHost
        33. IsNull
        34. IsNumeric
        35. IsNumericDate
        36. IsObject
        37. isOnline
        38. IsPDFArchive
        39. IsPDFFile
        40. IsPDFObject
        41. IsProtected
        42. IsQuery
        43. isSamlLogoutResponse
        44. isSafeHTML
        45. IsSimpleValue
        46. IsSOAPRequest
        47. IsSpreadsheetFile
        48. IsSpreadsheetObject
        49. IsStruct
        50. isThreadInterrupted
        51. IsUserInAnyRole
        52. IsUserInRole
        53. IsUserLoggedIn
        54. IsValid
        55. IsValidOauthAccesstoken
        56. IsWDDX
        57. IsXML
        58. IsXmlAttribute
        59. IsXmlDoc
        60. IsXmlElem
        61. IsXmlNode
        62. IsXmlRoot
        63. JavaCast
        64. JSStringFormat
        1. LCase
        2. Left
        3. Len
        4. ListAppend
        5. ListChangeDelims
        6. ListContains
        7. ListContainsNoCase
        8. ListDeleteAt
        9. ListEach
        10. ListFilter
        11. ListFind
        12. ListFindNoCase
        13. ListFirst
        14. ListGetAt
        15. ListGetDuplicates
        16. ListInsertAt
        17. ListLast
        18. ListLen
        19. ListMap
        20. ListPrepend
        21. ListQualify
        22. ListReduce
        23. ListRemoveDuplicates
        24. ListRest
        25. ListSetAt
        26. ListSort
        27. ListToArray
        28. ListValueCount
        29. ListValueCountNoCase
        30. LJustify
        31. Location
        32. Log
        33. Log10
        34. LSCurrencyFormat
        35. LSDateFormat
        36. LSDateTimeFormat
        37. LSEuroCurrencyFormat
        38. LSIsCurrency
        39. LSIsDate
        40. LSIsNumeric
        41. LSNumberFormat
        42. LSParseCurrency
        43. LSParseDateTime
        44. LSParseEuroCurrency
        45. LSParseNumber
        46. LSTimeFormat
        47. LTrim
        1. Max
        2. Mid
        3. Min
        4. Minute
        5. Month
        6. MonthAsString
        7. Now
        8. NumberFormat
        9. ObjectEquals
        10. ObjectLoad
        11. ObjectSave
        12. OnWSAuthenticate
        13. ORMClearSession
        14. ORMCloseAllSessions
        15. ORMCloseSession
        16. ORMEvictCollection
        17. ORMEvictEntity
        18. ORMEvictQueries
        19. ORMExecuteQuery
        20. ORMFlush
        21. ORMFlushall
        22. ORMGetSession
        23. ORMGetSessionFactory
        24. ORMIndex
        25. ORMIndexPurge
        26. ORMReload
        27. ORMSearch
        28. ORMSearchOffline
        29. ParagraphFormat
        30. ParameterExists
        31. ParseDateTime
        32. Pi
        33. PrecisionEvaluate
        34. ProcessSAMLResponse
        35. ProcessSAMLLogoutRequest
        36. Quarter
        37. PreserveSingleQuotes
        38. QueryAddColumn
        39. QueryAddRow
        40. QueryConvertForGrid
        41. QueryExecute
        42. QueryFilter
        43. QueryGetResult
        44. QueryGetRow
        45. QueryKeyExists
        46. QueryMap
        47. QueryNew
        48. QueryReduce
        49. QuerySetCell
        50. QuotedValueList
        51. QueryEach
        52. Rand
        53. Randomize
        54. RandRange
        55. ReEscape
        56. REFind
        57. REFindNoCase
        58. ReleaseComObject
        59. REMatch
        60. REMatchNoCase
        61. RemoveCachedQuery
        62. RemoveChars
        63. RepeatString
        64. Replace
        65. ReplaceList
        66. ReplaceNoCase
        67. REReplace
        68. REReplaceNoCase
        69. RestDeleteApplication
        70. RestSetResponse
        71. RestInitApplication
        72. Reverse
        73. Right
        74. RJustify
        75. Round
        76. RTrim
      9. Functions-s
        1. Second
        2. SendGatewayMessage
        3. SendSAMLLogoutResponse
        4. Serialize
        5. SerializeJSON
        6. SerializeXML
        7. SessionInvalidate
        8. SessionRotate
        9. SessionGetMetaData
        10. SessionInvalidate
        11. SessionRotate
        12. SetDay
        13. SetEncoding
        14. SetHour
        15. SetLocale
        16. SetMonth
        17. SetProfileString
        18. SetPropertyString
        19. SetVariable
        20. SetYear
        21. Sgn
        22. Sin
        23. Sleep
        24. SpanExcluding
        25. SpanIncluding
        26. SpreadsheetAddAutoFilter
        27. SpreadsheetAddColumn
        28. SpreadsheetAddFreezePane
        29. SpreadsheetAddImage
        30. SpreadsheetAddInfo
        31. SpreadsheetAddPageBreaks
        32. SpreadsheetAddRow
        33. SpreadsheetAddRows
        34. SpreadsheetAddSplitPane
        35. SpreadsheetCreateSheet
        36. SpreadsheetDeleteColumn
        37. SpreadsheetDeleteColumns
        38. SpreadsheetDeleteRow
        39. SpreadsheetDeleteRows
        40. SpreadsheetFormatCell
        41. SpreadsheetFormatColumn
        42. SpreadsheetFormatCellRange
        43. SpreadsheetFormatColumn
        44. SpreadsheetFormatColumns
        45. SpreadsheetFormatRow
        46. SpreadsheetFormatRows
        47. SpreadsheetGetCellComment
        48. SpreadsheetGetCellFormula
        49. SpreadsheetGetCellValue
        50. SpreadsheetGetColumnCount
        51. SpreadsheetInfo
        52. SpreadsheetMergeCells
        53. SpreadsheetNew
        54. SpreadsheetRead
        55. SpreadsheetReadBinary
        56. SpreadsheetRemoveSheet
        57. SpreadsheetSetActiveSheet
        58. SpreadsheetSetActiveSheetNumber
        59. SpreadsheetSetCellComment
        60. SpreadsheetSetCellFormula
        61. SpreadsheetSetCellValue
        62. SpreadsheetSetColumnWidth
        63. SpreadsheetSetFooter
        64. SpreadsheetSetHeader
        65. SpreadsheetSetRowHeight
        66. SpreadsheetShiftColumns
        67. SpreadsheetShiftRows
        68. SpreadsheetWrite
        69. StreamingSpreadsheetNew
        70. StreamingSpreadsheetCleanup
        71. StreamingSpreadsheetRead
        72. StreamingSpreadsheetProcess
        73. SpreadsheetSetFooterImage
        74. SpreadsheetSetHeaderImage
        75. SpreadsheetSetFittoPage
        76. SpreadsheetUngroupColumns
        77. SpreadsheetGroupColumns
        78. SpreadsheetUngroupRows
        79. SpreadsheetGroupRows
        80. SpreadsheetRemoveColumnBreak
        81. SpreadsheetSetColumnBreak
        82. SpreadsheetRemoveRowBreak
        83. SpreadsheetSetRowBreak
        84. SpreadsheetRemovePrintGridlines
        85. SpreadsheetAddPrintGridlines
        86. SpreadsheetGetColumnWidth
        87. SpreadsheetSetColumnHidden
        88. SpreadsheetSetRowHidden
        89. SpreadsheetisColumnHidden
        90. SpreadsheetisRowHidden
        91. SpreadsheetisStreamingXmlFormat
        92. SpreadsheetisXmlFormat
        93. SpreadsheetisBinaryFormat
        94. SpreadsheetRenameSheet
        95. SpreadsheetRemoveSheetNumber
        96. SpreadsheetGetLastRowNumber
        97. SpreadsheetGetPrintOrientation
        98. Sqr
        99. StripCR
        100. StructAppend
        101. StructClear
        102. StructCopy
        103. StructCount
        104. StructDelete
        105. StructEach
        106. StructFilter
        107. StructFind
        108. StructFindKey
        109. StructFindValue
        110. StructGet
        111. StructGetMetadata
        112. StructInsert
        113. StructIsEmpty
        114. StructKeyArray
        115. StructKeyExists
        116. StructKeyList
        117. StructMap
        118. StructNew
        119. StructReduce
        120. StructSetMetadata
        121. StructSort
        122. StructToSorted
        123. StructUpdate
        124. StructValueArray
        125. StoreSetMetadata
        126. StoreGetACL
        127. StoreGetMetadata
        128. StoreAddACL
        129. StoreSetACL
        1. Tan
        2. ThreadJoin
        3. ThreadTerminate
        4. Throw
        5. TimeFormat
        6. ToBase64
        7. ToBinary
        8. ToScript
        9. ToString
        10. Trace
        11. Transactionandconcurrency
        12. TransactionCommit
        13. TransactionRollback
        14. TransactionSetSavePoint
        15. Trim
        16. UCase
        17. URLDecode
        18. URLEncodedFormat
        19. URLSessionFormat
        20. Val
        21. ValueList
        22. VerifyClient
        23. Week
        24. Wrap
        25. WriteDump
        26. WriteLog
        27. WriteOutput
        28. WSGetAllChannels
        29. WSGetSubscribers
        30. WSPublish
        31. WSSendMessage
        32. XmlChildPos
        33. XmlElemNew
        34. XmlFormat
        35. XmlGetNodeType
        36. XmlNew
        37. XmlParse
        38. XmlSearch
        39. XmlTransform
        40. XmlValidate
        41. Year
        42. YesNoFormat
      1. ColdFusion tag summary
          1. cfapplication
          2. cfassociate
          3. cferror
          4. cfimport
          5. cfinterface
          6. cflock
          7. cfscript
          8. cfthread
          1. cfexchangecalendar
          2. cfexchangeconnection
          3. cfexchangecontact
          4. cfexchangefilter
          5. cfexchangemail
          6. cfexchangetask
          7. cfexchangefolder
          8. cfexchangeconversation
          9. cffeed
          10. cfmail
          11. cfmailparam
          12. cfmailpart
          13. cfpop
          1. cfdbinfo
          2. cfinsert
          3. cfobjectcache
          4. cfprocparam
          5. cfprocresult
          6. cfquery
          7. cfqueryparam
          8. cfstoredproc
          9. cftransaction
          10. cfupdate
          1. cfchart
          1. cfdump
          2. cftimer
          3. cftrace
          1. cfcatch
          2. cferror
          3. cffinally
          4. cfrethrow
          5. cfthrow
          6. cftry
          1. cfchart
          2. cfchartdata
          3. cfchartseries
          4. cfcollection
          5. cfcomponent
          6. cfexecute
          7. cfftp
          8. function
          9. cfindex
          10. cfinterface
          11. cfinvoke
          12. cfinvokeargument
          13. cfobject
          14. cfproperty
          15. cfreport
          16. cfreportparam
          17. cfreturn
          18. cfsearch
          19. cfsharepoint
          20. cfspreadsheet
          21. cfwddx
          22. cfxml
          1. cfdirectory
          2. cffile
          3. cffileupload
          4. cfftp
          5. cfzip
          6. cfzipparam
          1. cfabort
          2. cfbreak
          3. cfcase
          4. cfcontinue
          5. cfdefaultcase
          6. cfelse
          7. cfelseif
          8. cfexecute
          9. cfexit
          10. cfif
          11. cfinclude
          12. cflocation
          13. cfloop
          14. cfrethrow
          15. cfswitch
          16. cfthrow
          17. cftry
          1. cfapplet
          2. cfcalendar
          3. cffileupload
          4. cfform
          5. cfformgroup
          6. cfformitem
          7. cfgrid
          8. cfgridcolumn
          9. cfgridrow
          10. cfgridupdate
          11. cfinput
          12. cfpdf
          13. cfpdfform
          14. cfpdfformparam
          15. cfpdfparam
          16. cfpdfsubform
          17. cfselect
          18. cfslider
          19. cftextarea
          20. cftree
          21. cftreeitem
          1. cfajaximport
          2. cfajaxproxy
          3. cfftp
          4. cffeed
          5. cfimap
          6. cfhttp
          7. cfhttpparam
          8. cfldap
          9. cfmail
          10. cfmailparam
          11. cfmailpart
          12. cfpop
          13. cfsprydataset
          1. cfcache
          2. cfcontent
          3. cfflush
          4. cfheader
          5. cfhtmlhead
          6. cfinclude
          7. cfprocessingdirective
          8. cfsetting
          9. cfsilent
          1. cflogin
          2. cfloginuser
          3. cflogout
          4. cfNTauthenticate
          1. cfcookie
          2. cfdump
          3. cfparam
          4. cfregistry
          5. cfsavecontent
          6. cfschedule
          7. cfset
          8. cfsetting
          1. cfimage
          2. cflog
          3. cfregistry
        1. cfabort
        2. cfajaximport
        3. cfajaxproxy
        4. cfapplet
        5. cfapplication
        6. cfargument
        7. cfassociate
        8. cfauthenticate
        9. cfbreak
        1. cfcache
        2. cfcalendar
        3. cfcase
        4. cfcatch
          1. cfchart tag in ColdFusion
          2. Get started with cfchart
          3. Customize a chart using cfchart
          4. Advanced cfchart customization options
          5. Create an area chart in ColdFusion
          6. Create line charts in ColdFusion
          7. Create bar charts in ColdFusion
          8. Create floating bar charts in ColdFusion
          9. Create histograms in ColdFusion
          10. Create pie charts in ColdFusion
          11. Create funnel charts in ColdFusion
          12. Create pyramid charts in ColdFusion
          13. Create curve charts in ColdFusion
          14. Create boxplots in ColdFusion
          15. Create donut charts in ColdFusion
          16. Create bubble charts in ColdFusion
          17. Create scatterplots in ColdFusion
          18. Create radar charts in ColdFusion
          19. Other chart types in ColdFusion (Cone, Cylinder, Piano, and Bullet)
            1. Add markers to ColdFusion charts
            2. Add rules to ColdFusion charts
            3. Format numbers in ColdFusion charts
            4. Add animation to ColdFusion charts
            5. Create and apply themes to ColdFusion charts
        6. cfchartdata
        7. cfchartseries
        8. cfchartset
        9. cfclient
        10. cfclientsettings
        11. cfcol
        12. cfcollection
        13. cfcomponent
        14. cfcontent
        15. cfcontinue
        16. cfcookie
        1. cffeed
        2. cffile
        3. cffile action = "append"
        4. cffile action = "copy"
        5. cffile action = "delete"
        6. cffile action = "move"
        7. cffile action = "read"
        8. cffile action = "readBinary"
        9. cffile action = "rename"
        10. cffile action = "upload"
        11. cffile action = "uploadAll"
        12. cffile action = "write"
        13. cffileupload
        14. cffinally
        15. cfflush
        16. cfform
        17. cfformgroup
        18. cfformitem
        19. cfftp
        20. cfftp: Connection: file and directory operations
        21. cfftp: Opening and closing FTP server connections
        22. cfftp : Opening and closing secure FTP server connections
        23. cfftp action = "listDir"
        24. cffunction
        1. cfgraph
        2. cfgraphdata
        3. cfgrid
        4. cfgridcolumn
        5. cfgridrow
        6. cfgridupdate
        7. cfheader
        8. cfhtmlhead
        9. cfhtmltopdf
        10. cfhtmltopdfitem
        11. cfhttp
        12. cfhttpparam
        1. cfif
        2. cfimage
        3. cfimap
        4. cfimapfilter
        5. cfimpersonate
        6. cfimport
        7. cfinclude
        8. cfindex
        9. cfinput
        10. cfinsert
        11. cfinterface
        12. cfinvoke
        13. cfinvokeargument
        1. cfjava
        2. cflayout
        3. cflayoutarea
        4. cfldap
        5. cflocation
        6. cflock
        7. cflog
        8. cflogin
        9. cfloginuser
        10. cflogout
        11. cfloop
        12. cfloop : conditional loop
        13. cfloop : index loop
        14. cfloop : looping over a COM collection or structure
        15. cfloop : looping over a date or time range
        16. cfloop : looping over a list, a file, or an array
        17. cfloop : looping over a query
        1. cfmail
        2. cfmailparam
        3. cfmailpart
        4. cfmap
        5. cfmapitem
        6. cfmediaplayer
        7. cfmenu
        8. cfmenuitem
        9. cfmessagebox
        10. cfmodule
        11. cfNTauthenticate
        12. cfoauth
        13. cfobject
        14. cfobject: .NET object
        15. cfobject: COM object
        16. cfobject: component object
        17. cfobject: CORBA object
        18. cfobject: Java or EJB object
        19. cfobject: web service object
        20. cfobjectcache
        21. cfoutput
        1. cfparam
        2. cfpdf
        3. cfpdfform
        4. cfpdfformparam
        5. cfpdfparam
        6. cfpdfsubform
        7. cfpod
        8. cfpop
        9. cfpresentation
        10. cfpresentationslide
        11. cfpresenter
        12. cfprint
        13. cfprocessingdirective
        14. cfprocparam
        15. cfprocresult
        16. cfprogressbar
        17. cfproperty
        18. cfquery
        19. cfqueryparam
        1. cfregistry
        2. cfreport
        3. cfreportparam
        4. cfrethrow
        5. cfreturn
        6. cfsavecontent
        7. cfschedule
        8. cfscript
        9. cfsearch
        10. cfselect
        11. cfservlet
        12. cfservletparam
        13. cfset
        14. cfsetting
        15. cfsharepoint
        16. cfsilent
        17. cfslider
        18. cfspreadsheet
        19. cfsprydataset
        20. cfstoredproc
        21. cfswitch
        1. cftable
        2. cftextarea
        3. cftextinput
        4. cfthread
        5. cfthrow
        6. cftimer
        7. cftooltip
        8. cftrace
        9. cftransaction
        10. cftree
        11. cftreeitem
        12. cftry
        1. cfupdate
        2. cfwddx
        3. cfwebsocket
        4. cfwindow
        5. cfxml
        6. cfzip
        7. cfzipparam
        1. Reserved words and variables
        2. Reserved words
        3. Scope-specific built-in variables
        4. Custom tag variables
        5. ColdFusion tag-specific variables
        6. CGI environment (CGI Scope) variables
        1. Ajax JavaScript functions
        2. Function summary Ajax
        3. ColdFusion.Ajax.submitForm
        4. ColdFusion.Autosuggest.getAutosuggestObject
        5. ColdFusion.Layout.enableSourceBind
        6. ColdFusion.MessageBox.getMessageBoxObject
        7. ColdFusion.ProgressBar.getProgressBarObject
        8. ColdFusion.MessageBox.isMessageBoxDefined
        9. JavaScriptFunctionsinColdFusion9Update1
        1. ColdFusion ActionScript functions
        2. CF.http
        3. CF.query
        1. ColdFusion Mobile Functions
        2. Accelerometer Functions
        3. Camera Functions
        4. Connection Functions
        5. Contact Functions
        6. Event Functions
        7. File System Functions
        8. Geolocation Functions
        9. Media and Capture Functions
        10. Notification Functions
        11. Splash Screen Functions
        12. Storage Functions
        1. Application.CFC reference
        2. Application variables
        3. Method summary
        4. onAbort
        5. onApplicationEnd
        6. onApplicationStart
        7. onMissingTemplate
        8. onCFCRequest
        9. onError
        10. onRequestEnd
        11. onRequest
        12. onRequestStart
        13. onServerStart
        14. onSessionEnd
        15. onSessionStart
        1. Script Functions Implemented as CFCs
        2. Accessing the functions
        3. Function summary
        4. ftp
        5. http
        6. mail
        7. pdf
        8. query
        9. Script functions implemented as CFCs in ColdFusion 9 Update 1
        10. storedproc
        1. Styles valid for all controls
        2. Styles for cfform
        3. Styles for cfformgroup with horizontal or vertical type attributes
        4. Styles for box-style cfformgroup elements
        5. Styles for cfformgroup with accordion type attribute
        6. Styles for cfformgroup with tabnavigator type attribute
        7. Styles for cfformitem with hrule or vrule type attributes
        8. Styles for cfinput with radio, checkbox, button, image, or submit type attributes
        9. Styles for cftextarea tag and cfinput with text, password, or hidden type attributes
        10. Styles for cfselect with size attribute value of 1
        11. Styles for cfselect with size attribute value greater than 1
        12. Styles for cfcalendar tag and cfinput with dateField type attribute
        13. Styles for the cfgrid tag
        14. Styles for the cftree tag
        15. ColdFusion Flash Form Style Reference
        1. ColdFusion Event Gateway reference
        2. addEvent
        3. CFEvent
        4. CFEventclass
        5. Constructor
        6. Gateway development interfaces and classes
        7. getStatus
        8. setCFCPath
        9. setCFCMethod
        10. getOriginatorID
        11. getLogger
        12. getBuddyList
        13. getBuddyInfo
        14. IM gateway message sending commands
        15. IM Gateway GatewayHelper class methods
        16. onIncomingMessage
        17. onIMServerMessage
        18. onBuddyStatus
        19. onAddBuddyResponse
        20. onAddBuddyRequest
        21. IM Gateway CFC incoming message methods
        22. IM gateway methods and commands
        23. CFML CFEvent structure
        24. warn
        25. info
        26. setOriginatorID
        27. data command
        28. submit Multi command
        29. submit command
        30. setGatewayType
        31. setGatewayID
        32. setData
        33. setCFCListeners
        34. outgoingMessage
        35. getStatusTimeStamp
        36. numberOfMessagesReceived
        37. numberOfMessagesSent
        38. removeBuddy
        39. removeDeny
        40. removePermit
        41. setNickName
        42. setPermitMode
        43. setStatus
        44. SMS Gateway CFEvent structure and commands
        45. SMS Gateway incoming message CFEvent structure
        46. getStatusAsString
        47. getProtocolName
        48. getPermitMode
        49. getPermitList
        50. getNickName
        51. getName
        52. getDenyList
        53. getCustomAwayMessage
        54. getQueueSize
        55. getMaxQueueSize
        56. getHelper
        57. getGatewayType
        58. getGatewayServices
        59. getGatewayID_1
        60. getGatewayID
        61. getData
        62. getCFCTimeout
        63. setCFCTimeout
        64. getCFCPath
        65. getCFCMethod
        66. GatewayServices class
        67. Gateway interface
        68. GatewayHelper interface
        69. addPermit
        70. addDeny
        71. addBuddy
        72. error
        73. debug
        74. Logger class
        75. stop
        76. start
        77. CFML event gateway SendGatewayMessage data parameter
        78. restart
        79. fatal
        80. SMS gateway message sending commands
        1. C++ class overview
        2. Deprecated class methods
        3. CCFXException class
        4. CCFXQuery class
        5. CCFXRequest class
        6. CCFXStringSet class
        7. ColdFusion C++ CFX Reference
        1. ColdFusion Java CFX reference
        2. Class libraries overview
        3. Custom tag interface
        4. Query interface
        5. Request interface
        6. Response interface
        7. Debugging classes reference
        1. WDDX JavaScript objects
        2. JavaScript object overview
        3. WddxRecordset object
        4. WddxSerializer object
      1. ColdFusion and GCP Storage
      2. ColdFusion and GCP Firestore
      3. ColdFusion and GCP PubSub
      4. ColdFusion and Amazon S3
      5. ColdFusion and DynamoDB
      6. ColdFusion and Amazon SQS
      7. ColdFusion and Amazon SNS
      8. ColdFusion and MongoDB
      9. ColdFusion and Azure Blob
      10. ColdFusion and Azure Service Bus
      11. Multi-cloud storage services
      12. Multi-cloud RDS databases
      13. ColdFusion and Azure Cosmos DB

     

    Note:

    You can find the CFFiddle demo of this function and other spreadsheet functions as part of a project that is shared with you.

    Click the button below to launch CFFiddle.

    To copy the project in your workspace in CFFiddle, follow the steps below:

    1. Log in with your Gmail or Facebook credentials.
    2. Navigate to the project in the left pane.
    3. Once you make some changes in any cfm in the project, a pop up displays asking you to save the project.
    4. Give the project a suitable name and click Save.

    Description

    Specifies the formula for an Excel spreadsheet object cell.

    Returns

    Does not return a value.

    Category

    Microsoft Office Integration

    Function syntax

    SpreadsheetSetCellFormula(spreadsheetObj, formula, row, column)

    See also

    SpreadsheetGetCellComment, SpreadsheetFormatCell, SpreadsheetGetCellFormula, SpreadsheetGetCellValue, 

    SpreadsheetMergeCells, SpreadsheetSetCellComment, SpreadsheetSetCellValue

    History

    ColdFusion 9: Added the function.

    Parameters

    Parameter

    Description

    spreadsheetObj

    The Excel spreadsheet object to which to add the comment.

    formula

    A string containing the formula.

    row

    The row number of the cell to which to add the formula.

    column

    The column number of the cell to which to add the formula.

    Usage

    This function replaces any existing value, including specific entered values.

    Example

    The following line sets the formula for the cell at row 2 column 11 to be the sum of the cells in the column's rows 1 through 12.The following example sets a cell formula, and gets the cell formula and value.

    <cfscript>
    //Create a new Excel spreadsheet object.
    theSheet=SpreadsheetNew();
    //Set the values of column 3 rows 1-10 to the row number.
    for (i=1; i<= 10; i=i+1)
    SpreadsheetSetCellValue(theSheet,i,i,3);
    //Set the fomula for the cell in row 11 column 3 to be the sum of
    //Columns 1-10.
    SpreadsheetSetCellFormula(theSheet,"SUM(C1:C10)",11,3);
    //Get the formula from the Excel spreadsheet object.
    theValue=SpreadsheetGetCellFormula(theSheet,11,3);
    //Get the value of row 11 column 5 from the Excel spreadsheet object.
    theValue=SpreadsheetGetCellValue(theSheet,11,3);
    </cfscript>

    <cfoutput>
    Row 11, Column 3 value: #SpreadsheetGetCellValue(theSheet,11,3)#<br />
    Row 11, Column 3 formula: #SpreadsheetGetCellFormula(theSheet,11,3)#<br />
    </cfoutput>

    Get help faster and easier

    New user?

    Quick links

    View all your plans Manage your plans
    View quick links
    Hide quick links

    Legal Notices    |    Online Privacy Policy