setCallback

Assign code to Safety Analysis Manager spreadsheet callback

Since R2024a

Syntax

setCallback(spreadsheet,callbackType,code)

Description

setCallback(spreadsheet,callbackType,code) assigns the code, code, to the callback, callbackType, in the Safety Analysis Manager spreadsheet, spreadsheet.

Examples

Assign Callback

Suppose you have one Safety Analysis Manager spreadsheet open, mySpreadsheet.mldatx, and it has two columns. The first is a check box column and the second is a text column. You want to write a callback script where, if the check box for a cell is not selected, you mark the adjacent cell in the text column with a warning flag.

Retrieve the Spreadsheet object of the spreadsheet.

mySpreadsheet = safetyAnalysisMgr.getOpenDocuments;

Create the callback code as a string.

callBackString = "for n = 1:sfa_spreadsheet.Rows" + newline + ...
"  textCell = getCell(sfa_spreadsheet,n,2);" + newline + ...
"  checkCell = getCell(sfa_spreadsheet,n,1);" + newline + ...
"  if checkCell.Value == 0" + newline + ...
"      addFlag(textCell,""warning"")" + newline + ...
"  end" + newline + ...
"end";

The code uses the sfa_spreadsheet keyword to retrieve the Spreadsheet object of the spreadsheet that contains this script.

Assign the code to the default AnalyzeFcn callback.

setCallback(mySpreadsheet,"AnalyzeFcn",callBackString)

Input Arguments

spreadsheet — Spreadsheet in Safety Analysis Manager

Spreadsheet object

Spreadsheet in the Safety Analysis Manager, specified as a Spreadsheet object.

callbackType — Callback type to assign

"PreLoadFcn" | "PostLoadFcn" | "AnalyzeFcn" | "PreSaveFcn" | ...

Callback type to assign the code to, specified as one of these values:

Callback Type	When Callback Executes
"PreLoadFcn"	Before the spreadsheet loads
"PostLoadFcn"	After the spreadsheet loads
"AnalyzeFcn"	When you use the runAnalysis function or press F5. This corresponds to the default AnalyzeFcn callback. To set callback code for a custom callback, set callbackType to the custom callback name.
"PreSaveFcn"	Before the spreadsheet is saved
"PostSaveFcn"	After the spreadsheet is saved
"CloseFcn"	Before the spreadsheet is closed
Custom callback name	If the custom callback is enabled, it executes when you use the runAnalysis function or press F5. Create the custom callback by using the addCallback function.

code — Callback code

character vector | string scalar

Callback code, specified as a character vector or a string scalar.

Data Types: char | string

Version History

Introduced in R2024a