Click or drag to resize

CellLink Class

Represents a link to a cell in a different sheet.
Remarks
If status is not “OK” (i.e., there is a problem with the link), any or all of the following attributes may be null: sheetId, rowId, columnId

You can create and modify cell links by using any API operation that creates or updates cell data. Creating or updating cell links via the cell.linkInFromCell attribute is a special operation. A given row or cell update operation may contain only link updates, or no link updates. Attempting to mix row/cell updates with cell link updates will result in error code 1115.

When creating a cell link, cell.value must be null (the data will be pulled from the linked cell).

A cell may not contain both a hyperlink and a cell link, so hyperlink and linkInFromCell may never both be non-null at the same time.

A cell link can only be added to an existing cell, so the cell.linkInFromCell attribute is not allowed when POSTing a new row to a sheet.

Inheritance Hierarchy
SystemObject
  Smartsheet.Api.ModelsCellLink

Namespace:  Smartsheet.Api.Models
Assemblies:   smartsheet-csharp-sdk (in smartsheet-csharp-sdk.dll) Version: 2.126.0
  smartsheet-csharp-sdk (in smartsheet-csharp-sdk.dll) Version: 2.126.0
Syntax
Copy
public class CellLink

The CellLink type exposes the following members.

Constructors
  NameDescription
Public methodCellLink
Top
Properties
  NameDescription
Public propertyColumnId
Column Id of the linked cell
Public propertyIsNull
Public propertyRowId
Row Id of the linked cell
Public propertySheetId
Sheet Id of the sheet that the linked cell belongs to
Public propertySheetName
Sheet name of the linked cell
Public propertyStatus
One of the following values:
  • OK: - the link is in a good state
  • BROKEN: - the row or sheet linked to was deleted
  • INACCESSIBLE: - the sheet linked to cannot be viewed by this user
  • Several other values indicating unusual error conditions: BLOCKED, CIRCULAR, DISABLED, INVALID, and NOT_SHARED.
Top
See Also