Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

New in version 14.2

Item Details Server
CURL.AvailableSSLBackends
Queries the list of available SSL backends.
All
  ✅ Server
CURL.SetSSLBackend
Sets which backend to use for SSL connections.
All
  ✅ Server
Container.RemovePreview
Removes the preview from a container value.
All
  ✅ Server
Dictionary.HasKeys
Checks if the given keys exist in dictionary.
All
  ✅ Server
Files.IsSystemImmutable
Queries the system immutable flag.
Mac/iOS
  ✅ Server
Files.IsUserImmutable
Queries the user immutable flag.
Mac/iOS
  ✅ Server
Files.SetSystemImmutable
Sets the system immutable flag.
Mac/iOS
  ✅ Server
Files.SetUserImmutable
Sets the user immutable flag.
Mac/iOS
  ✅ Server
GMImage.Flatten
Flatten the alpha channel.
All
  ✅ Server
JSON.CurrentMatch
Queries JSON for current match in JSON.ReplaceEvaluate function.
All
  ✅ Server
JSON.CurrentMatchPath
Queries JSON for current match path in JSON.ReplaceEvaluate function.
All
  ✅ Server
JSON.Import.SetBaseFields
Sets the names of the base fields per record.
All
  ✅ Server
JSON.Import.SetExtraField
Sets the extra field to add to all tables.
All
  ✅ Server
JSON.Merge
Merges multiple JSON objects or arrays.
All
  ✅ Server
JSON.ReplaceEvaluate
Searches for all values that match the JSONPath expression and replaces them with the result of the evaluation.
All
  ✅ Server
ListDialog.GetShowCloseBox
Queries whether the close box is enabled.
Mac/Win
  ❌ Server
ListDialog.SetShowCloseBox
Sets whether the close box widget is enabled.
Mac/Win
  ❌ Server
Math.MovingAverage
Calculates moving average.
All
  ✅ Server
MongoDB.ClientCommand
Execute a command on the server, interpreting options according to the MongoDB server version.
All
  ✅ Server
MongoDB.ClientCommandQuery
Creates a query cursor.
All
  ✅ Server
MongoDB.ClientCommandWithServerId
This function executes a command on a specific server, using the database and command specification provided.
All
  ✅ Server
MongoDB.GetAppName
Queries the client application name.
All
  ✅ Server
MongoDB.GetCredentials
Queries credentials as JSON.
All
  ✅ Server
MongoDB.SetAppName
Sets the client application name.
All
  ✅ Server
PDFKit.SelectPrinter
Shows the printer picker.
iOS
  ❌ Server
QuickList.HasValues
Checks whether a list contains the given values.
All
  ✅ Server
Text.LeftTrim
Trims whitespace on the left side.
All
  ✅ Server
Text.RightTrim
Trims whitespace on the right side.
All
  ✅ Server
XL.Book.AddConditionalFormat
Adds a new conditional format to the workbook for using with conditional formatting rules.
All
  ✅ Server
XL.ConditionalFormat.Font
Returns the font for this format.
All
  ✅ Server
XL.ConditionalFormat.GetBorderBottom
Returns the bottom border style.
All
  ✅ Server
XL.ConditionalFormat.GetBorderBottomColor
Returns the color of the bottom border.
All
  ✅ Server
XL.ConditionalFormat.GetBorderLeft
Returns the left border style.
All
  ✅ Server
XL.ConditionalFormat.GetBorderLeftColor
Returns the color of the left border.
All
  ✅ Server
XL.ConditionalFormat.GetBorderRight
Returns the right border style.
All
  ✅ Server
XL.ConditionalFormat.GetBorderRightColor
Returns the color of the right border.
All
  ✅ Server
XL.ConditionalFormat.GetBorderTop
Returns the top border style.
All
  ✅ Server
XL.ConditionalFormat.GetBorderTopColor
Returns the color of the top border.
All
  ✅ Server
XL.ConditionalFormat.GetCustomNumFormat
Queries custom format string.
All
  ✅ Server
XL.ConditionalFormat.GetFillPattern
Returns the fill pattern.
All
  ✅ Server
XL.ConditionalFormat.GetNumFormat
Returns the number format identifier.
All
  ✅ Server
XL.ConditionalFormat.GetPatternBackgroundColor
Returns the background color of the fill pattern.
All
  ✅ Server
XL.ConditionalFormat.GetPatternForegroundColor
Returns the foreground color of the fill pattern.
All
  ✅ Server
XL.ConditionalFormat.SetBorder
Sets the border style.
All
  ✅ Server
XL.ConditionalFormat.SetBorderBottom
Sets the bottom border style.
All
  ✅ Server
XL.ConditionalFormat.SetBorderBottomColor
Sets the color of the bottom border.
All
  ✅ Server
XL.ConditionalFormat.SetBorderColor
Sets the border color.
All
  ✅ Server
XL.ConditionalFormat.SetBorderLeft
Sets the left border style.
All
  ✅ Server
XL.ConditionalFormat.SetBorderLeftColor
Sets the color of the left border.
All
  ✅ Server
XL.ConditionalFormat.SetBorderRight
Sets the right border style.
All
  ✅ Server
XL.ConditionalFormat.SetBorderRightColor
Sets the color of the right border.
All
  ✅ Server
XL.ConditionalFormat.SetBorderTop
Sets the top border style.
All
  ✅ Server
XL.ConditionalFormat.SetBorderTopColor
Sets the color of the top border.
All
  ✅ Server
XL.ConditionalFormat.SetCustomNumFormat
Sets a custom number format.
All
  ✅ Server
XL.ConditionalFormat.SetFillPattern
Sets the fill pattern.
All
  ✅ Server
XL.ConditionalFormat.SetNumFormat
Sets the number format identifier.
All
  ✅ Server
XL.ConditionalFormat.SetPatternBackgroundColor
Sets the background color of the fill pattern.
All
  ✅ Server
XL.ConditionalFormat.SetPatternForegroundColor
Sets the foreground color of the fill pattern.
All
  ✅ Server
XL.ConditionalFormating.Add2ColorScaleFormulaRule
Adds a conditional formatting rule that creates a gradated 2-color scale on the cells.
All
  ✅ Server
XL.ConditionalFormating.Add2ColorScaleRule
Adds a conditional formatting rule that creates a gradated 2-color scale on the cells.
All
  ✅ Server
XL.ConditionalFormating.Add3ColorScaleFormulaRule
Adds a conditional formatting rule that creates a gradated 3-color scale on the cells.
All
  ✅ Server
XL.ConditionalFormating.Add3ColorScaleRule
Adds a conditional formatting rule that creates a gradated 3-color scale on the cells.
All
  ✅ Server
XL.ConditionalFormating.AddAboveAverageRule
Adds a conditional formatting rule that highlights cells that are above or below the average for all values in the range.
All
  ✅ Server
XL.ConditionalFormating.AddOpNumRule
Adds a conditional formatting rule that highlights cells whose values are compared with a calculated result, using an operator.
All
  ✅ Server
XL.ConditionalFormating.AddOpStrRule
Adds a conditional formatting rule that highlights cells whose values are compared with a calculated result, using an operator.
All
  ✅ Server
XL.ConditionalFormating.AddRange
Adds a range to these conditional formatting rules.
All
  ✅ Server
XL.ConditionalFormating.AddRule
Adds a conditional formatting rule that highlights cells whose values correspond to the specified criteria.
All
  ✅ Server
XL.ConditionalFormating.AddTimePeriodRule
Adds a conditional formatting rule that highlights cells containing dates in the specified time period.
All
  ✅ Server
XL.ConditionalFormating.AddTopRule
Adds a conditional formatting rule that highlights cells whose values fall in the [top N] or [bottom N] bracket.
All
  ✅ Server
XL.Sheet.AddConditionalFormatting
Adds a conditional formatting rules to the sheet.
All
  ✅ Server

70 functions shown.

New parameters added

Item Details Server
DynaPDF.SaveAndSignFileWinCryptDialog: CertificateName
Saves and signs the current PDF.
Win only
  ❌ Server
FM.SQL.JSONRecords: firstRow, lastRow
Returns rows as JSON array.
All
  ✅ Server
FM.SQL.XMLRecords: firstRow, lastRow
Returns rows as XML.
All
  ✅ Server
Hash.DigestFile: UpdateProgressbar
Calculates a hash of a file.
All
  ✅ Server
Matrix.JSONRecords: firstRow, lastRow
Returns rows as JSON array.
All
  ✅ Server
Overlay.Move: AnimationTime
Moves the window the given position.
Mac/Win
  ❌ Server
XL.LoadBookPartially: keepAllSheets
Loads a Excel file partially.
All
  ✅ Server

7 functions shown.

These functions require a license (86%).

Older Version 14.1