getReferencedValues

Create two Safety Analysis Manager spreadsheets, and store each Spreadsheet object in a variable.

mySpreadsheet1 = safetyAnalysisMgr.newSpreadsheet;
mySpreadsheet2 = safetyAnalysisMgr.newSpreadsheet;

Add three rows to each spreadsheet by using the addRow function.

addRow(mySpreadsheet1,Count=3)
addRow(mySpreadsheet2,Count=3)

Add a text column and derived column that have custom labels to the mySpreadsheet2 spreadsheet by using the addColumn function.

addColumn(mySpreadsheet2,Count=2,Type=["text","derived"]...
  ,Label=["Check Box Column","Derived Column"])

Add a check box column that has a custom label to the mySpreadsheet1 spreadsheet by using the addColumn function.

addColumn(mySpreadsheet1,Type="checkbox",Label="Check Box Column")

Save the spreadsheets.

save(mySpreadsheet1,"spreadsheet1.mldatx")
save(mySpreadsheet2,"spreadsheet2.mldatx")

Retrieve the SperadsheetCell objects for the first cells in the first and second column in the mySpreadsheet1 spreadsheet and the first cell in the derived column in the mySpreadsheet2 spreadsheet.

myCell1(1) = getCell(mySpreadsheet1,1,1);
myCell1(2) = getCell(mySpreadsheet1,1,2);
myCell2 = getCell(mySpreadsheet2,1,"Derived Column");

Assign values to the cells in the mySpreadsheet1 spreadsheet.

myCell1(1).Value = "value 1";
myCell1(2).Value = true;

Create a reference where the myCell2 cell references the myCell1 cells by using the addReference function.

addReference(myCell2,myCell1)

Retrieve the referenced cell values.

myCellReferenceValues = getReferencedValues(myCell2)

myCellReferenceValues =

  1×2 cell array

    {'value 1'}    {[1]}