getReferences
Description
returns the Safety Analysis Manager spreadsheet referenced cells that the cell,
cellReferences
= getReferences(spreadsheetCell
)spreadsheetCell
, references.
Examples
Retrieve Referenced Cell
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 SpreadsheetCell
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");
Create a reference where the myCell2
cell references the
myCell1
cells by using the addReference
function.
addReference(myCell2,myCell1)
Retrieve the referenced cells.
myCellReferences = getReferences(myCell2);
Input Arguments
spreadsheetCell
— Spreadsheet cell
SpreadsheetCell
object
Spreadsheet cell to add the reference to, specified as a
SpreadsheetCell
object. The cell must be in a derived column. For
more information on derived columns, see Define Derived Values and Define the Derived Column Formula.
Output Arguments
cellReferences
— Referenced cells
cell array of CellReference
objects
Referenced cells, returned as a cell array of CellReference
objects. The cell array lists the referenced cells in the
order of their creation. To adjust the order, use the moveReference
function.
Version History
Introduced in R2024b
See Also
Objects
Functions
MATLAB Command
You clicked a link that corresponds to this MATLAB command:
Run the command by entering it in the MATLAB Command Window. Web browsers do not support MATLAB commands.
Select a Web Site
Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .
You can also select a web site from the following list:
How to Get Best Site Performance
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.
Americas
- América Latina (Español)
- Canada (English)
- United States (English)
Europe
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom (English)