xlLinkedDataTypeState

Specifies the state of cells that may contain Linked data types such as Stocks or Geography.

xlLinkedDataTypeStateBrokenLinkedDataThere is a valid Linked data type in the cell, but entity no longer exists on the service (3)
xlLinkedDataTypeStateDisambiguationNeededThe cell needs to be disambiguated by the user before a Linked data type can be inserted
For example, if the user types "New York" into a cell and attempts to convert it to a "Geography" data type, they may need to select whether they meant New York State or New York City
Until they do so, the cell will be in this state (2)
xlLinkedDataTypeStateFetchingDataThe Linked data type in the cell is in the middle of refreshing new data from the service (4)
xlLinkedDataTypeStateNoneThe cell does not contain any Linked data types (0)
xlLinkedDataTypeStateValidLinkedDataThe cell contains a Linked data type (1)

xlLinkedDataTypeStateBrokenLinkedData
There is a valid Linked data type in the cell, but entity no longer exists on the service (3)
xlLinkedDataTypeStateDisambiguationNeeded
The cell needs to be disambiguated by the user before a Linked data type can be inserted
For example, if the user types "New York" into a cell and attempts to convert it to a "Geography" data type, they may need to select whether they meant New York State or New York City
Until they do so, the cell will be in this state (2)
xlLinkedDataTypeStateFetchingData
The Linked data type in the cell is in the middle of refreshing new data from the service (4)
xlLinkedDataTypeStateNone
The cell does not contain any Linked data types (0)
xlLinkedDataTypeStateValidLinkedData
The cell contains a Linked data type (1)

REMARKS
* Added in 2019.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top