getCallback

Retrieve spreadsheet callback code in Safety Analysis Manager

Since R2024a

Syntax

code = getCallback(spreadsheet,callbackType)

Description

code = getCallback(spreadsheet,callbackType) returns the callback code for the callback, callbackType, in the Safety Analysis Manager spreadsheet, spreadsheet.

Examples

Create and Retrieve 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 by using the setCallback function.

setCallback(mySpreadsheet,"AnalyzeFcn",callBackString)

Retrieve the callback that you assigned.

getCallback(mySpreadsheet,"AnalyzeFcn")

ans =

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

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 retrieve

"PreloadFcn" | "PostloadFcn" | "AnalyzeFcn" | "PresaveFcn" | ...

Callback type to retrieve the code from, 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 get 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.

Output Arguments

code — Callback code

character vector

Callback code, returned as a character vector.

Version History

Introduced in R2024a