Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.1   7.2   7.3   7.4   7.5   8.0   8.1   8.2   8.3   8.4    Statistic  

New in version 3.5

Item Details
Addressbook.LocalizedPropertyOrLabel
Queries a localized name for a label or property.
Mac only
Addressbook.Notification.Clear
Clears the registered notification script.
Mac only
Addressbook.Notification.GetChangedExternally
Queries if the last notification script call was caused by a changed in another app.
Mac only
Addressbook.Notification.GetDeletedRecords
Queries list of deleted records.
Mac only
Addressbook.Notification.GetInsertedRecords
Queries list of inserted records.
Mac only
Addressbook.Notification.GetProcessID
Queries the process ID.
Mac only
Addressbook.Notification.GetProcessName
Queries the process name.
Mac only
Addressbook.Notification.GetUpdatedRecords
Queries list of updated records.
Mac only
Addressbook.Notification.GetUserUID
Queries the user ID.
Mac only
Addressbook.Notification.Set
Installs a notification script.
Mac only
Addressbook.personFromVCardTextRepresentation
Creates an Person instance initialized with the given text.
Mac/iOS
Addressbook.searchPeopleWithCreationDate
Searches for people in addressbook with creation date between both dates.
Mac only
Addressbook.searchPeopleWithModificationDate
Searches for people in addressbook with creation date between both dates.
Mac only
App.GetProcessPath
Queries the path of the application.
All
Barcode.Detect
Detects a barcode.
All
Barcode.DrawBarcode
Draws a barcode into a PDF page.
All
Barcode.Generate
Generates a barcode.
All
Barcode.UPCChecksum
Calculates checksum for UPC barcodes.
All
CURL.SetOptionTLSAuthPassword
Sets the TSL authentication password.
All
CURL.SetOptionTLSAuthType
Sets the TLS authentication type.
All
CURL.SetOptionTLSAuthUsername
Sets the TSL authentication user name.
All
Calendar.Alarm.Duplicate
Creates a copy of an alarm.
Mac only
Calendar.Alarm.GetAbsoluteTrigger
Queries the absolute trigger timestamp.
Mac only
Calendar.Alarm.GetAcknowledged
Queries acknowledged flag.
Mac only
Calendar.Alarm.GetAction
Queries the action for this alarm.
Mac only
Calendar.Alarm.GetEmailAddress
Queries the email address for an alarm.
Mac only
Calendar.Alarm.GetRelatedTo
Queries the related to setting.
Mac only
Calendar.Alarm.GetRelativeTrigger
Queries the relative trigger value.
Mac only
Calendar.Alarm.GetSound
Queries the sounds for this alarm.
Mac only
Calendar.Alarm.GetURL
Queries the URL of the alarm.
Mac only
Calendar.Alarm.SetAbsoluteTrigger
Sets the absolute trigger timestamp.
Mac only
Calendar.Alarm.SetAcknowledged
Sets acknowledged flag.
Mac only
Calendar.Alarm.SetAction
Sets an action for this alarm.
Mac only
Calendar.Alarm.SetEmailAddress
Sets the email address for this alarm.
Mac only
Calendar.Alarm.SetRelatedTo
Sets the related to setting.
Mac only
Calendar.Alarm.SetRelativeTrigger
Sets the relative trigger value.
Mac only
Calendar.Alarm.SetSound
Sets the sounds for this alarm.
Mac only
Calendar.Alarm.SetURL
Sets the URL of the alarm.
Mac only
Calendar.Alarm.TriggerDateRelativeTo
Queries the relative trigger date for this alarm.
Mac only
Calendar.Attendee.GetAddress
Returns URL address of attendee entry.
Mac only
Calendar.Attendee.GetCommonName
Returns the user-entered name of the attendee.
Mac only
Calendar.Attendee.GetStatus
Returns status of attendee.
Mac only
Calendar.Item.AddAlarm
Adds an alarm to a calendar item.
Mac only
Calendar.Item.GetAlarms
Queries the list of alarms for this item.
Mac only
Calendar.Item.GetAttendees
Queries the list of attendees for this event.
Mac only
Calendar.Item.RemoveAlarm
Removes an alarm from an item.
Mac only
Calendar.NewAlarm
Creates a new alarm.
Mac only
Calendar.Notification.Clear
Clears the registered notification script.
Mac only
Calendar.Notification.GetChangedExternally
Queries if the last notification script call was caused by a changed in another app.
Mac only
Calendar.Notification.GetDeletedRecords
Queries list of deleted records.
Mac only
Calendar.Notification.GetInsertedRecords
Queries list of inserted records.
Mac only
Calendar.Notification.GetProcessID
Queries the process ID.
Mac only
Calendar.Notification.GetProcessName
Queries the process name.
Mac only
Calendar.Notification.GetUpdatedRecords
Queries list of updated records.
Mac only
Calendar.Notification.GetUserUID
Queries the user ID.
Mac only
Calendar.Notification.GetWhat
Queries what changed in the database.
Mac only
Calendar.Notification.Set
Installs a notification script.
Mac only
DynaPDF.GetImportOrientation
Queries orientation for input page.
All
DynaPDF.GetOrientation
Queries orientation of current page.
All
DynaPDF.HighlightPattern
Searches a text and adds highlights for it.
All
DynaPDF.New
Creates a new DynaPDF instance.
All
DynaPDF.Release
Releases a PDF reference.
All
DynaPDF.SetOrientation
Changes the orientation of the page.
All
DynaPDF.SetOrientationEx
Changes the orientation of the page.
All
DynaPDF.Table.AddColumn
Adds a column on the left or right side of the table.
All
DynaPDF.Table.AddRow
Adds a new row to the table.
All
DynaPDF.Table.AddRows
Adds new rows to the table.
All
DynaPDF.Table.ClearColumn
Deletes the content in the specified column in all rows.
All
DynaPDF.Table.ClearContent
Deletes the specified object types from the table.
All
DynaPDF.Table.ClearRow
The function deletes the content in the specified row.
All
DynaPDF.Table.Create
Creates a new table object.
All
DynaPDF.Table.DeleteCol
Deletes a column from the table.
All
DynaPDF.Table.DeleteRow
Deletes a row from the table.
All
DynaPDF.Table.DeleteRows
Deletes all rows from the table.
All
DynaPDF.Table.Draw
Draws the table on the specified position.
All
DynaPDF.Table.GetFirstRow
Queres first row drawn.
All
DynaPDF.Table.GetNextHeight
Calculates the height of the table.
All
DynaPDF.Table.GetNextHeightRow
Calculates the height of the table.
All
DynaPDF.Table.GetNextRow
Queres next row to be drawn.
All
DynaPDF.Table.GetNumCols
Queries number of columns in table.
All
DynaPDF.Table.GetNumRows
Queries number of rows in table.
All
DynaPDF.Table.GetPDF
Returns the reference to the PDF.
All
DynaPDF.Table.GetTableHeight
Returns the full height of the table.
All
DynaPDF.Table.GetTableWidth
Returns the width of the table.
All
DynaPDF.Table.HaveMore
Checks whether all rows where drawn.
All
DynaPDF.Table.Release
Releases the PDF table.
All
DynaPDF.Table.SetBorderWidth
Sets or changes the border width.
All
DynaPDF.Table.SetBoxProperty
Sets or changes the border width, cell spacing, or cell padding.
All
DynaPDF.Table.SetCellImage
Inserts an image horizontally and vertically aligned as specified.
All
DynaPDF.Table.SetCellImageEx
Inserts an image from container.
All
DynaPDF.Table.SetCellOrientation
Sets the cell orientation.
All
DynaPDF.Table.SetCellPadding
Sets or changes the cell padding.
All
DynaPDF.Table.SetCellSpacing
Sets or changes the cell spacing.
All
DynaPDF.Table.SetCellTable
The function inserts a sub table into the specfied cell. A sub table is always a foreground object that has a strong width and height. That means, if the cell is not large enough then it will be expanded.
All
DynaPDF.Table.SetCellTemplate
Inserts a template into the specified cell.
All
DynaPDF.Table.SetCellText
Inserts the specified text into the cell.
All
DynaPDF.Table.SetColWidth
The function changes the width of a column.
All
DynaPDF.Table.SetColor
Sets or changes the specified color as well as the corresponding device color space.
All
DynaPDF.Table.SetColorFloat
Sets or changes the specified color and color space.
All
DynaPDF.Table.SetFlags
The function sets various flags.
All
DynaPDF.Table.SetFont
Sets the font that is used to output text.
All
DynaPDF.Table.SetFontSelMode
The function sets or changes the font selection mode.
All
DynaPDF.Table.SetFontSize
Sets or changes the font size.
All
DynaPDF.Table.SetGridWidth
Sets the grid width.
All
DynaPDF.Table.SetPDF
Changes the PDF instance that is associated with the table.
All
DynaPDF.Table.SetRGBColor
Sets RGB color.
All
DynaPDF.Table.SetRowHeight
Changes the row height.
All
DynaPDF.Table.SetTableWidth
Changes the width of the table.
All
FM.ExecuteFileSQL
Execute the SQL Statement against a FileMaker database.
All
Files.GetTagNames
Queries names of the tags assigned to the file/folder.
Mac only
Files.ReadFile
Reads a file with the given path.
All
Files.SetTagNames
Sets the tags for a file/folder.
Mac only
Files.WriteFile
Writes a file with the given data.
All
GMImage.Strip
Remove all profiles and text attributes from the image.
All
IKPictureTaker.ClearNotification
Clears the script to be called.
Mac only
IKPictureTaker.GetAllowsEditing
Queries whether image editing is allowed.
Mac only
IKPictureTaker.GetAllowsFileChoosing
Queries whether image files can be chosen.
Mac only
IKPictureTaker.GetAllowsVideoCapture
Queries whether video capture is allowed.
Mac only
IKPictureTaker.GetInformationalText
Queries informational text.
Mac only
IKPictureTaker.GetInputImage
Return the original PictureTaker's input-image.
Mac only
IKPictureTaker.GetMirroring
Queries video mirroring status.
Mac only
IKPictureTaker.GetOutputImage
Return the edited image.
Mac only
IKPictureTaker.GetOutputImageMaxHeight
Queries the maximum allowed image height.
Mac only
IKPictureTaker.GetOutputImageMaxWidth
Queries the maximum allowed image width.
Mac only
IKPictureTaker.GetRemainOpenAfterValidate
Queries whether the picture taker should remain open after the user selects done.
Mac only
IKPictureTaker.GetShowAddressBookPicture
Queries whether addressbook pictures are shown.
Mac only
IKPictureTaker.GetShowEffects
Queries wether to show effects.
Mac only
IKPictureTaker.GetShowEmptyPicture
Queries the image to be shown for empty picture.
Mac only
IKPictureTaker.GetShowRecentPicture
Queries whether to show recent pictures.
Mac only
IKPictureTaker.GetUpdateRecentPicture
Queries whether to allow a recent picture to be updated.
Mac only
IKPictureTaker.Run
Launch the PictureTaker.
Mac only
IKPictureTaker.SetAllowsEditing
Sets whether image editing is allowed.
Mac only
IKPictureTaker.SetAllowsFileChoosing
Sets whether image files can be chosen.
Mac only
IKPictureTaker.SetAllowsVideoCapture
Sets whether video capture is allowed.
Mac only
IKPictureTaker.SetInformationalText
Sets informational text.
Mac only
IKPictureTaker.SetInputImage
Set the image input for the PictureTaker.
Mac only
IKPictureTaker.SetMirroring
Controls whether the receiver enable/disable video mirroring durring snapshots (default is on).
Mac only
IKPictureTaker.SetNotification
Installs a notification script.
Mac only
IKPictureTaker.SetOutputImageMaxSize
Sets maximum size of the output image.
Mac only
IKPictureTaker.SetRemainOpenAfterValidate
Sets whether the picture taker should remain open after the user selects done.
Mac only
IKPictureTaker.SetShowAddressBookPicture
Sets whether address book pictures are shown.
Mac only
IKPictureTaker.SetShowEffects
Sets wether to show effects.
Mac only
IKPictureTaker.SetShowEmptyPicture
Sets the image to be shown for empty picture.
Mac only
IKPictureTaker.SetShowRecentPicture
Sets whether to show recent pictures.
Mac only
IKPictureTaker.SetUpdateRecentPicture
Sets whether to allow a recent picture to be updated.
Mac only
MediaLibraryBrowser.getMediaLibraries
Queries which media libraries are currently showing.
Mac only
MediaLibraryBrowser.getVisible
Queries visible state of the browser panel.
Mac only
MediaLibraryBrowser.setFrame
Sets the panel rectangle.
Mac only
MediaLibraryBrowser.setMediaLibraries
Sets which media type is shown in browser.
Mac only
MediaLibraryBrowser.setVisible
Sets visible state of the panel.
Mac only
MediaLibraryBrowser.togglePanel
Toggles the panel.
Mac only
PrintDialog.Disable
Disables the print dialog extension.
Mac only
PrintDialog.Enable
Enables the print dialog extension.
Mac only
PrintDialog.GetDestinationPath
Queries the destination path.
Mac only
PrintDialog.GetNoDialog
Queries whether dialog shows.
Mac only
PrintDialog.GetPrintToPDF
Queries whether printing is going to PDF file.
Mac only
PrintDialog.GetPrinterName
Queries printer name.
Mac only
PrintDialog.Install
Installs the extension for the printer dialog.
Mac only
PrintDialog.SetDestinationPath
Sets the destination path for PDF.
Mac only
PrintDialog.SetNoDialog
Sets whether dialog should show.
Mac only
PrintDialog.SetPrintToPDF
Sets whether plugin will redirect print to PDF.
Mac only
PrintDialog.SetPrinterName
Sets printer name.
Mac only
RichText.Clear
Clears current document.
Mac/iOS
RichText.SetAttribute
Sets metadata.
Mac/iOS
RichText.SetFormattedText
Sets new text for saving a document.
Mac/iOS
RichText.SetText
Sets new text for saving a document.
Mac/iOS
RichText.WriteDOC
Writes a Word file.
Mac only
RichText.WriteRTF
Writes a RTF file.
Mac/iOS
Socket.SSL.Accept
Wait for a TLS/SSL client to initiate a TLS/SSL handshake.
All
Socket.SSL.Connect
Initiate the TLS/SSL handshake with an TLS/SSL server.
All
Socket.SSL.GetMethod
Queries the SSL method.
All
Socket.SSL.Initialize
Initializes a SSL connection.
All
Socket.SSL.Prepare
First step in SSL initialization.
All
Socket.SSL.SetMethod
Sets the SSL method for this socket.
All
Socket.SSL.UseCertificateFile
Defines to use a certificate key file for this SSL socket.
All
Socket.SSL.UsePrivateKeyFile
Defines to use a private key file for this SSL socket.
All
SyntaxColoring.CheckVariableDeclaration.Disable
Disables checking variable declarations in FileMaker Scripts.
Mac only
SyntaxColoring.CheckVariableDeclaration.Enable
Enables checking variable declarations in FileMaker Scripts.
Mac only
SyntaxColoring.CheckVariableDeclaration.Enabled
Queries if checking variable declarations are enabled or not.
Mac only
SyntaxColoring.LineNumbers.Disable
Disables line numbers in FileMaker Scripts.
Mac only
SyntaxColoring.LineNumbers.Enable
Enables line numbers in FileMaker Scripts.
Mac only
SyntaxColoring.LineNumbers.Enabled
Queries if line numbers are enabled or not.
Mac only
SyntaxColoring.LineNumbers.GetColor
Queries the current color for line numbers.
Mac only
SyntaxColoring.LineNumbers.SetColor
Sets the new color to use for line numbers.
Mac only
SystemInfo.isMavericks
Whether the operation system is Mac OS X 10.9 Lion or newer.
All
Text.SoundExGerman
Returns soundex string for the given text.
All
Trace.ErrorsOnly
Limits logging to errors only.
All
Twain.GetAutomaticBrightness
Queries the Source's Auto-brightness function (if any).
Mac/Win
Twain.GetBrightness
Queries the brightness setting to use.
Mac/Win
Twain.GetContrast
Queries which contrast value to use.
Mac/Win
Twain.GetGamma
Queries the gamma correction value for the image data.
Mac/Win
Twain.GetHighlight
Queries which value to use for highlight.
Mac/Win
Twain.GetShadow
Queries which value in an image should be interpreted as the darkest shadow.
Mac/Win
Twain.SetAutomaticBrightness
Enables or disables the Source's Auto-brightness function (if any).
Mac/Win
Twain.SetBrightness
Sets the brightness setting to use.
Mac/Win
Twain.SetContrast
Sets which contrast value to use.
Mac/Win
Twain.SetGamma
Sets the gamma correction value for the image data.
Mac/Win
Twain.SetHighlight
Specifies which value in an image should be interpreted as the lightest highlight.
Mac/Win
Twain.SetShadow
Specifies which value in an image should be interpreted as the darkest shadow.
Mac/Win
UserNotification.ContentImage
Queries image shown in the content of the notification.
Mac only
UserNotification.GetIdentifier
Queries the identifier used to uniquely identify a notification.
Mac only
UserNotification.GetResponse
Queries the response text.
Mac only
UserNotification.GetResponsePlaceholder
Queries the optional placeholder for inline reply field.
Mac only
UserNotification.HasReplyButton
Queries whether the notification has a reply button.
Mac only
UserNotification.SetContentImage
Sets image shown in the content of the notification.
Mac only
UserNotification.SetHasReplyButton
Sets whether the notification has a reply button.
Mac only
UserNotification.SetIdentifier
Sets the identifier used to uniquely identify a notification.
Mac only
UserNotification.SetResponsePlaceholder
Sets the optional placeholder for inline reply field.
Mac only
XL.Book.AddCustomNumFormat
Adds a new custom number format to the workbook.
All
XL.Book.AddFont
Adds a new font to the workbook, initial parameters can be copied from other font.
All
XL.Book.AddFormat
Adds a new format to the workbook, initial parameters can be copied from other format.
All
XL.Book.AddPictureContainer
Adds a picture to the workbook from container.
All
XL.Book.AddPictureFile
Adds a picture to the workbook.
All
XL.Book.AddSheet
Adds a new sheet to this book, returns the sheet index.
All
XL.Book.BiffVersion
Returns BIFF version of binary file.
All
XL.Book.CustomNumFormat
Returns a custom format string for specified custom format identifier fmt.
All
XL.Book.DeleteSheet
Deletes a sheet with specified index.
All
XL.Book.FontCount
Returns a number of fonts in this book.
All
XL.Book.FormatCount
Returns a number of formats in this book.
All
XL.Book.GetActiveSheet
Returns an active sheet index in this workbook.
All
XL.Book.GetDefaultFontName
Returns a default font name for this workbook.
All
XL.Book.GetDefaultFontSize
Returns a default font size for this workbook.
All
XL.Book.GetPicture
Returns a picture at position index.
All
XL.Book.GetPictureType
Returns a picture type at position index.
All
XL.Book.GetRGBMode
Returns whether the RGB mode is active.
All
XL.Book.GetRefR1C1
Returns whether the R1C1 reference mode is active.
All
XL.Book.GetText
Queries the text of a workbook.
All
XL.Book.InsertSheet
Inserts a new sheet to this book at position index, returns the new sheet index.
All
XL.Book.PictureCount
Returns a number of pictures in this workbook.
All
XL.Book.Release
Frees a workbook from memory.
All
XL.Book.Save
Writes excel file to container for storing in database.
All
XL.Book.SaveToFile
Saves current workbook into xls-file.
All
XL.Book.SetActiveSheet
Sets an active sheet index in this workbook.
All
XL.Book.SetDefaultFont
Sets a default font name and size for this workbook.
All
XL.Book.SetRGBMode
Sets a RGB mode.
All
XL.Book.SetRefR1C1
Sets the R1C1 reference mode.
All
XL.Book.SheetCount
Queries how many sheets are part of the workbook.
All
XL.Color.Pack
Packs red, green and blue components in color type.
All
XL.Color.UnPack
Unpacks color type to red, green and blue components.
All
XL.Date.Pack
Packs date and time information into double type.
All
XL.Date.UnPack
Unpacks date and time information from double type.
All
XL.Font.GetBold
Returns whether the font is bold.
All
XL.Font.GetColor
Returns the color of the font.
All
XL.Font.GetItalic
Returns whether the font is italic.
All
XL.Font.GetName
Returns the name of the font.
All
XL.Font.GetScript
Returns the script style of the font.
All
XL.Font.GetSize
Returns the size of the font in points.
All
XL.Font.GetStrikeOut
Returns whether the font is strikeout.
All
XL.Font.GetUnderline
Returns the underline style of the font.
All
XL.Font.SetBold
Turns on/off the bold font.
All
XL.Font.SetColor
Sets the color of the font.
All
XL.Font.SetItalic
Turns on/off the italic font.
All
XL.Font.SetName
Sets the name of the font.
All
XL.Font.SetScript
Sets the script style of the font.
All
XL.Font.SetSize
Sets the size of the font in points.
All
XL.Font.SetStrikeOut
Turns on/off the strikeout font.
All
XL.Font.SetUnderline
Sets the underline style of the font.
All
XL.Format.GetAlignH
Returns the horizontal alignment.
All
XL.Format.GetAlignV
Returns the vertical alignment.
All
XL.Format.GetBorderBottom
Returns the bottom border style.
All
XL.Format.GetBorderBottomColor
Returns the color of the bottom border.
All
XL.Format.GetBorderDiagonal
Returns the diagonal border.
All
XL.Format.GetBorderDiagonalColor
Returns the color of the diagonal border.
All
XL.Format.GetBorderDiagonalStyle
Gets the style for diagonal border.
All
XL.Format.GetBorderLeft
Returns the left border style.
All
XL.Format.GetBorderLeftColor
Returns the color of the left border.
All
XL.Format.GetBorderRight
Returns the right border style.
All
XL.Format.GetBorderRightColor
Returns the color of the right border.
All
XL.Format.GetBorderTop
Returns the top border style.
All
XL.Format.GetBorderTopColor
Returns the color of the top border.
All
XL.Format.GetFillPattern
Returns the fill pattern.
All
XL.Format.GetFont
Returns the font for this format.
All
XL.Format.GetHidden
Returns whether the hidden property is set to true.
All
XL.Format.GetIndent
Returns the text indentation level.
All
XL.Format.GetLocked
Returns whether the locked property is set to true.
All
XL.Format.GetNumFormat
Returns the number format identifier.
All
XL.Format.GetPatternBackgroundColor
Returns the background color of the fill pattern.
All
XL.Format.GetPatternForegroundColor
Returns the foreground color of the fill pattern.
All
XL.Format.GetRotation
Returns the text rotation.
All
XL.Format.GetShrinkToFit
Returns whether the cell is shrink-to-fit.
All
XL.Format.GetWrap
Returns whether the cell text is wrapped.
All
XL.Format.SetAlignH
Sets the horizontal alignment.
All
XL.Format.SetAlignV
Sets the vertical alignment.
All
XL.Format.SetBorder
Sets the border style.
All
XL.Format.SetBorderBottom
Sets the bottom border style.
All
XL.Format.SetBorderBottomColor
Sets the color of the bottom border.
All
XL.Format.SetBorderColor
Sets the border color.
All
XL.Format.SetBorderDiagonal
Sets the diagonal border.
All
XL.Format.SetBorderDiagonalColor
Sets the color of the diagonal border.
All
XL.Format.SetBorderDiagonalStyle
Sets the style for diagonal border.
All
XL.Format.SetBorderLeft
Sets the left border style.
All
XL.Format.SetBorderLeftColor
Sets the color of the left border.
All
XL.Format.SetBorderRight
Sets the right border style.
All
XL.Format.SetBorderRightColor
Sets the color of the right border.
All
XL.Format.SetBorderTop
Sets the top border style.
All
XL.Format.SetBorderTopColor
Sets the color of the top border.
All
XL.Format.SetFillPattern
Sets the fill pattern.
All
XL.Format.SetFont
Sets the font for the format.
All
XL.Format.SetHidden
Sets the hidden property.
All
XL.Format.SetIndent
Sets the text indentation level.
All
XL.Format.SetLocked
Sets the locked property.
All
XL.Format.SetNumFormat
Sets the number format identifier.
All
XL.Format.SetPatternBackgroundColor
Sets the background color of the fill pattern.
All
XL.Format.SetPatternForegroundColor
Sets the foreground color of the fill pattern.
All
XL.Format.SetRotation
Sets the text rotation.
All
XL.Format.SetShrinkToFit
Sets the flag whether the cell is shrink-to-fit.
All
XL.Format.SetWrap
Sets the flag whether the cell text is wrapped.
All
XL.Sheet.AddrToRowCol
Converts a cell reference to row and column.
All
XL.Sheet.CellIsDate
Checks that cell contains a date or time value.
All
XL.Sheet.CellIsFormula
Checks that cell contains a formula.
All
XL.Sheet.CellReadBlank
Checks if cell is blank.
All
XL.Sheet.CellReadBoolean
Reads a boolean value from a cell.
All
XL.Sheet.CellReadComment
Reads a comment value from a cell.
All
XL.Sheet.CellReadFormula
Reads the formula value from a cell.
All
XL.Sheet.CellReadNumber
Reads a number value from a cell.
All
XL.Sheet.CellReadText
Reads a text value from a cell.
All
XL.Sheet.CellType
Queries type of cell.
All
XL.Sheet.CellWriteBlank
Writes a blank cell.
All
XL.Sheet.CellWriteBoolean
Writes a boolean value into cell.
All
XL.Sheet.CellWriteComment
Writes a comment to a cell.
All
XL.Sheet.CellWriteFormula
Writes a formula into cell.
All
XL.Sheet.CellWriteNumber
Writes a number into cell.
All
XL.Sheet.CellWriteText
Writes a string into cell.
All
XL.Sheet.Clear
Clears cells in specified area.
All
XL.Sheet.ClearPrintArea
Clears the print area.
All
XL.Sheet.ClearPrintRepeats
Clears repeated rows and columns on each page.
All
XL.Sheet.CopyCell
Copies cell with format from (rowSrc, colSrc) to (rowDst, colDst).
All
XL.Sheet.DeleteMerge
Removes merged cells.
All
XL.Sheet.DeleteNamedRange
Deletes the named range by name.
All
XL.Sheet.GetCellError
Reads error from cell.
All
XL.Sheet.GetCellFormat
Returns cell's format.
All
XL.Sheet.GetColHidden
Returns whether column is hidden.
All
XL.Sheet.GetColWidth
Returns column width.
All
XL.Sheet.GetDisplayGridlines
Returns whether the gridlines are displayed.
All
XL.Sheet.GetFirstCol
Returns the first column in the sheet that contains a used cell.
All
XL.Sheet.GetFirstRow
Returns the first row in the sheet that contains a used cell.
All
XL.Sheet.GetFooter
Returns the footer text of the sheet when printed.
All
XL.Sheet.GetFooterMargin
Returns the footer margin in inches.
All
XL.Sheet.GetGroupSummaryBelow
Returns whether grouping rows summary is below.
All
XL.Sheet.GetGroupSummaryRight
Returns whether grouping columns summary is right.
All
XL.Sheet.GetHCenter
Returns whether the sheet is centered horizontally when printed.
All
XL.Sheet.GetHeader
Returns the header text of the sheet when printed.
All
XL.Sheet.GetHeaderMargin
Returns the header margin in inches.
All
XL.Sheet.GetHidden
Returns whether sheet is hidden.
All
XL.Sheet.GetHorPageBreak
Returns row with horizontal page break at position index.
All
XL.Sheet.GetHorPageBreakCount
Returns a number of horizontal page breaks in the sheet.
All
XL.Sheet.GetLandscape
Returns a page orientation mode.
All
XL.Sheet.GetLastCol
Returns the zero-based index of the column after the last column in the sheet that contains a used cell.
All
XL.Sheet.GetLastRow
Returns the zero-based index of the row after the last row in the sheet that contains a used cell.
All
XL.Sheet.GetMarginBottom
Returns the bottom margin of the sheet in inches.
All
XL.Sheet.GetMarginLeft
Returns the left margin of the sheet in inches.
All
XL.Sheet.GetMarginRight
Returns the right margin of the sheet in inches.
All
XL.Sheet.GetMarginTop
Returns the top margin of the sheet in inches.
All
XL.Sheet.GetMerge
Gets merged cells for cell at row, col.
All
XL.Sheet.GetName
Returns the name of the sheet.
All
XL.Sheet.GetNamedRange
Gets the named range coordianates by name.
All
XL.Sheet.GetPaper
Returns the paper size.
All
XL.Sheet.GetPicture
Returns a workbook picture index at position index in worksheet.
All
XL.Sheet.GetPrintFit
Returns whether fit to page option is enabled.
All
XL.Sheet.GetPrintGridlines
Returns whether the gridlines are printed.
All
XL.Sheet.GetPrintRow
Returns whether the row and column headers are printed.
All
XL.Sheet.GetPrintZoom
Returns the scaling factor for printing as a percentage.
All
XL.Sheet.GetProtect
Returns whether sheet is protected.
All
XL.Sheet.GetRowHeight
Returns row height.
All
XL.Sheet.GetRowHidden
Returns whether row is hidden.
All
XL.Sheet.GetText
Queries the text of a sheet in a workbook.
All
XL.Sheet.GetTopLeftView
Extracts the first visible row and the leftmost visible column of the sheet.
All
XL.Sheet.GetVCenter
Returns whether the sheet is centered vertically when printed.
All
XL.Sheet.GetVerPageBreak
Returns column with vertical page break at position index.
All
XL.Sheet.GetVerPageBreakCount
Returns a number of vertical page breaks in the sheet.
All
XL.Sheet.GetZoom
Returns the zoom level of the current view as a percentage.
All
XL.Sheet.GroupCols
Groups columns from colFirst to colLast.
All
XL.Sheet.GroupRows
Groups rows from rowFirst to rowLast.
All
XL.Sheet.InsertCol
Inserts columns from colFirst to colLast.
All
XL.Sheet.InsertRow
Inserts rows from rowFirst to rowLast.
All
XL.Sheet.NamedRange
Gets the named range coordinates by index.
All
XL.Sheet.NamedRangeCount
Returns the number of named ranges in the sheet.
All
XL.Sheet.PictureCount
Returns a number of pictures in this worksheet.
All
XL.Sheet.RemoveCol
Removes columns from colFirst to colLast.
All
XL.Sheet.RemoveRow
Removes rows from rowFirst to rowLast.
All
XL.Sheet.RowColToAddr
Converts row and column to a cell reference.
All
XL.Sheet.SetCellFormat
Sets cell's format.
All
XL.Sheet.SetCol
Sets column width and format for all columns from colFirst to colLast.
All
XL.Sheet.SetColHidden
Hides or shows a column.
All
XL.Sheet.SetColumn
Sets column width and format for all columns from colFirst to colLast.
All
XL.Sheet.SetDisplayGridlines
Sets gridlines for displaying.
All
XL.Sheet.SetFooter
Sets the footer text for the sheet when printed.
All
XL.Sheet.SetGroupSummaryBelow
Sets a flag of grouping rows summary.
All
XL.Sheet.SetGroupSummaryRight
Sets a flag of grouping rows summary.
All
XL.Sheet.SetHCenter
Sets a flag that the sheet is centered horizontally when printed.
All
XL.Sheet.SetHeader
Sets the header text of the sheet when printed.
All
XL.Sheet.SetHorPageBreak
Sets/removes a horizontal page break.
All
XL.Sheet.SetLandscape
Sets landscape or portrait mode for printing.
All
XL.Sheet.SetMarginBottom
Sets the bottom margin of the sheet in inches.
All
XL.Sheet.SetMarginLeft
Sets the left margin of the sheet in inches.
All
XL.Sheet.SetMarginRight
Sets the right margin of the sheet in inches.
All
XL.Sheet.SetMarginTop
Sets the top margin of the sheet in inches.
All
XL.Sheet.SetMerge
Sets merged cells for range: rowFirst - rowLast, colFirst - colLast.
All
XL.Sheet.SetName
Sets the name of the sheet.
All
XL.Sheet.SetNamedRange
Sets the named range.
All
XL.Sheet.SetPaper
Sets the paper size.
All
XL.Sheet.SetPictureWithScale
Sets a picture with pictureId identifier at position row and col with scale factor and offsets in pixels.
All
XL.Sheet.SetPictureWithSize
Sets a picture with pictureId identifier at position row and col with custom size and offsets in pixels.
All
XL.Sheet.SetPrintArea
Sets the print area.
All
XL.Sheet.SetPrintFit
Fits sheet width and sheet height to wPages and hPages respectively.
All
XL.Sheet.SetPrintGridliens
Sets gridlines for printing.
All
XL.Sheet.SetPrintRepeatCols
Sets repeated columns on each page from colFirst to colLast.
All
XL.Sheet.SetPrintRepeatRows
Sets repeated rows on each page from rowFirst to rowLast.
All
XL.Sheet.SetPrintRow
Sets a flag that the row and column headers are printed.
All
XL.Sheet.SetPrintZoom
Sets the scaling factor for printing as a percentage.
All
XL.Sheet.SetProtect
Protects/unprotects the sheet.
All
XL.Sheet.SetRow
Sets row height and format.
All
XL.Sheet.SetRowHidden
Hides or shows a row.
All
XL.Sheet.SetTopLeftView
Sets the first visible row and the leftmost visible column of the sheet.
All
XL.Sheet.SetVCenter
ets a flag that the sheet is centered vertically when printed.
All
XL.Sheet.SetVerPageBreak
Sets/removes a vertical page break.
All
XL.Sheet.SetZoom
Sets the zoom level of the current view.
All
XL.Sheet.Split
Splits a sheet at position (row, col).
All

418 functions.

Older Version 3.4   Newer Version 4.0

Feedback: Report problem or ask question.




Links
MBS Xojo PDF Plugins