| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
13.4 13.5 14.0 14.1 14.2 14.3 14.4 14.5 15.0 15.1 15.2 15.3
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 |
| Overlay.AddWebViewer Adds a web viewer to an overlay. | Mac only |
✅ 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 |
71 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%).
Blog Entries
