Version

GetResolvedCellFormat Method (WorksheetCell)

Gets the resolved cell formatting for this cell.
Syntax
'Declaration
 
Public Function GetResolvedCellFormat() As IWorksheetCellFormat
public IWorksheetCellFormat GetResolvedCellFormat()

Return Value

A format object describing the actual formatting that will be used when displayed this cell in Microsoft Excel.
Remarks

If any cell format properties are the default values on the cell, the values from the owning row's cell format will be used. If those are default, then the values from the owning column's cell format will be used. Otherwise, the workbook default values will be used.

Note: it is slightly faster to use the WorksheetRow.GetResolvedCellFormat method, which does not create a WorksheetCell instance internally. However, if a reference to the WorksheetCell instance already exists, using this method is equivalent to using the WorksheetRow.GetResolvedCellFormat method.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also