TypeScript
JavaScript
References ▼
Retrieves the text representation of a cell's value as it is displayed in sheet processing applications. Useful for obtaining the formatted output of a cell, regardless of the cell's actual data type or value.
Cell.prototype.getDisplayStringValue = function()
A string representing the value of the cell as displayed in sheet processing applications. This includes any formatting applied to the cell.
The GetDisplayStringValue method returns the text representation of a cell's value, including any formatting that has been applied to the cell. For instance, if a cell contains a date value with a specific date format, this method returns the date as a string formatted according to the set date format.
The method abstracts the complexity of cell formatting, providing a simple way to access the cell's content as it appears to the user in Sheet processing applications. It can handle different data types, like dates, numbers, formulas, and others.