SpreadsheetRow

Spreadsheet row in Safety Analysis Manager

Since R2024b

Description

SpreadsheetRow objects represent spreadsheet rows in the Safety Analysis Manager. Use SpreadsheetRow objects to configure spreadsheet rows you use for safety analyses.

Creation

To create a SpreadsheetRow object,

• use the getRow function on a Spreadsheet or SpreadsheetCell object.

• Select a row in a Safety Analysis Manager spreadsheet and use the safetyAnalysisMgr.getCurrentSelection function.

Properties

Index — Row index

positive integer

This property is read-only.

Row index in the spreadsheet, returned as a positive integer. The first row has the index 1.

Data Types: uint64

Cells — Number of cells in row

positive integer

This property is read-only.

Number of cells in the row, returned as a positive integer. To add cells to the row, add columns by using the addColumn function on the Spreadsheet object. To remove cells from the row, delete columns by using the deleteColumn function on the Spreadsheet object.

Data Types: uint64

Description — Spreadsheet row description

'' (default) | string scalar | character vector

Spreadsheet row description, specified as a string scalar or character vector.

Data Types: char | string

Object Functions

acceptAllChanges	Accept detected changes to linked artifacts in Safety Analysis Manager
addFlag	Add flag to Safety Analysis Manager spreadsheet cell or row
clearFlags	Clear flags in Safety Analysis Manager spreadsheet
getChanges	Get changed artifacts linked to artifacts in Safety Analysis Manager
getCell	Retrieve spreadsheet cells
getFlags	Retrieve flags from Safety Analysis Manager spreadsheets
getLinks	Get links associated with spreadsheet cell or row in Safety Analysis Manager
getSpreadsheet	Retrieve spreadsheet containing specified cell

Examples

Add Check Flag to Spreadsheet Row

Suppose that only one spreadsheet is loaded in the Safety Analysis Manager. Retrieve the Spreadsheet object of the spreadsheet.

mySpreadsheet = safetyAnalysisMgr.getOpenDocuments;

Retrieve the second row as a SpreadsheetRow object.

myRow = getRow(mySpreadsheet,2);

Add a check flag to the row.

addFlag(myRow,"check");

Limitations

• The SpreadsheetRow objects that you use in derived column formulas are read-only.

Version History

Introduced in R2024b