Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server (Not)   Client   Old   Guides   Examples
New in version: 6.2   6.3   6.4   6.5   7.0   7.1   7.2   7.3   7.4   7.5    Statistic  

New in version 3.5

Name Description Mac/Win
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 only
RichText.SetAttribute Sets metadata. Mac only
RichText.SetFormattedText Sets new text for saving a document. Mac only
RichText.SetText Sets new text for saving a document. Mac only
RichText.WriteDOC Writes a Word file. Mac only
RichText.WriteRTF Writes a RTF file. Mac only
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.DeleteNameRange 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 FileMaker blog