CellInfo Constructor

CellInfo(object, StyleInfo, string, string, object, int, int, string, IFormatProvider, SheetView, int, int, ConditionalFormat[], string)

Initializes a new instance of the CellInfo class.

Declaration

public CellInfo(object rawValue, StyleInfo style, string formula, string note, object tag, int rowLink, int columnLink, string formatString, IFormatProvider formatInfo, SheetView sheet, int rowSpan, int columnSpan, ConditionalFormat[] formats, string errorText)

Public Sub New(rawValue As Object, style As StyleInfo, formula As String, note As String, tag As Object, rowLink As Integer, columnLink As Integer, formatString As String, formatInfo As IFormatProvider, sheet As SheetView, rowSpan As Integer, columnSpan As Integer, formats As ConditionalFormat(), errorText As String)

Parameters

Type	Name	Description
object	rawValue	the unformatted value.
StyleInfo	style	the style.
string	formula	The formula.
string	note	The note
object	tag	The tag.
int	rowLink	The row of the reference
int	columnLink	The column of the reference
string	formatString	the format string.
IFormatProvider	formatInfo	the format info.
SheetView	sheet	The sheetview.
int	rowSpan	The span row.
int	columnSpan	The span column.
ConditionalFormat[]	formats	The formats.
string	errorText	The error text.

CellInfo(object, StyleInfo, string, string, object, int, int, string, IFormatProvider, SheetView, int, int, ConditionalFormat[])

Initializes a new instance of the CellInfo class.

Declaration

public CellInfo(object rawValue, StyleInfo style, string formula, string note, object tag, int rowLink, int columnLink, string formatString, IFormatProvider formatInfo, SheetView sheet, int rowSpan, int columnSpan, ConditionalFormat[] formats)

Public Sub New(rawValue As Object, style As StyleInfo, formula As String, note As String, tag As Object, rowLink As Integer, columnLink As Integer, formatString As String, formatInfo As IFormatProvider, sheet As SheetView, rowSpan As Integer, columnSpan As Integer, formats As ConditionalFormat())

Parameters

Type	Name	Description
object	rawValue	the unformatted value.
StyleInfo	style	the style.
string	formula	The formula.
string	note	The note
object	tag	The tag.
int	rowLink	The row of the reference
int	columnLink	The column of the reference
string	formatString	the format string.
IFormatProvider	formatInfo	the format info.
SheetView	sheet	The sheetview.
int	rowSpan	The span row.
int	columnSpan	The span column
ConditionalFormat[]	formats	The formats

CellInfo(object, StyleInfo, string, string, object, int, int, string, IFormatProvider, SheetView, int, int, ConditionalFormat[], AggregationType, string)

Initializes a new instance of the CellInfo class.

Declaration

public CellInfo(object rawValue, StyleInfo style, string formula, string note, object tag, int rowLink, int columnLink, string formatString, IFormatProvider formatInfo, SheetView sheet, int rowSpan, int columnSpan, ConditionalFormat[] formats, AggregationType aggregationType, string aggregationFormatString)

Public Sub New(rawValue As Object, style As StyleInfo, formula As String, note As String, tag As Object, rowLink As Integer, columnLink As Integer, formatString As String, formatInfo As IFormatProvider, sheet As SheetView, rowSpan As Integer, columnSpan As Integer, formats As ConditionalFormat(), aggregationType As AggregationType, aggregationFormatString As String)

Parameters

Type	Name	Description
object	rawValue	the unformatted value.
StyleInfo	style	the style.
string	formula	The formula.
string	note	The note
object	tag	The tag.
int	rowLink	The row of the reference
int	columnLink	The column of the reference
string	formatString	the format string.
IFormatProvider	formatInfo	the format info.
SheetView	sheet	The sheetview.
int	rowSpan	The span row.
int	columnSpan	The span column
ConditionalFormat[]	formats	The formats
AggregationType	aggregationType	The type of aggregation.
string	aggregationFormatString	The format string of aggregation.

CellInfo(object, StyleInfo, string, string, object, int, int, string, IFormatProvider, SheetView, int, int, ConditionalFormat[], StickyNoteStyleInfo)

Initializes a new instance of the CellInfo class.

Declaration

public CellInfo(object rawValue, StyleInfo style, string formula, string note, object tag, int rowLink, int columnLink, string formatString, IFormatProvider formatInfo, SheetView sheet, int rowSpan, int columnSpan, ConditionalFormat[] formats, StickyNoteStyleInfo noteStyleInfo)

Public Sub New(rawValue As Object, style As StyleInfo, formula As String, note As String, tag As Object, rowLink As Integer, columnLink As Integer, formatString As String, formatInfo As IFormatProvider, sheet As SheetView, rowSpan As Integer, columnSpan As Integer, formats As ConditionalFormat(), noteStyleInfo As StickyNoteStyleInfo)

Parameters

Type	Name	Description
object	rawValue	the unformatted value.
StyleInfo	style	the style.
string	formula	The formula.
string	note	The note
object	tag	The tag.
int	rowLink	The row of the reference
int	columnLink	The column of the reference
string	formatString	the format string.
IFormatProvider	formatInfo	the format info.
SheetView	sheet	The sheetview.
int	rowSpan	The span row.
int	columnSpan	The span column
ConditionalFormat[]	formats	The formats
StickyNoteStyleInfo	noteStyleInfo	The style of note.

CellInfo(object, StyleInfo, string, string, object, int, int, string, IFormatProvider, SheetView, int, int, ConditionalFormat[], StickyNoteStyleInfo, SparklineInfo)

Initializes a new instance of the CellInfo class.

Declaration

public CellInfo(object rawValue, StyleInfo style, string formula, string note, object tag, int rowLink, int columnLink, string formatString, IFormatProvider formatInfo, SheetView sheet, int rowSpan, int columnSpan, ConditionalFormat[] formats, StickyNoteStyleInfo noteStyleInfo, SparklineInfo sparklineInfo)

Public Sub New(rawValue As Object, style As StyleInfo, formula As String, note As String, tag As Object, rowLink As Integer, columnLink As Integer, formatString As String, formatInfo As IFormatProvider, sheet As SheetView, rowSpan As Integer, columnSpan As Integer, formats As ConditionalFormat(), noteStyleInfo As StickyNoteStyleInfo, sparklineInfo As SparklineInfo)

Parameters

Type	Name	Description
object	rawValue	the unformatted value.
StyleInfo	style	the style.
string	formula	The formula.
string	note	The note
object	tag	The tag.
int	rowLink	The row of the reference
int	columnLink	The column of the reference
string	formatString	the format string.
IFormatProvider	formatInfo	the format info.
SheetView	sheet	The sheetview.
int	rowSpan	The span row.
int	columnSpan	The span column
ConditionalFormat[]	formats	The formats
StickyNoteStyleInfo	noteStyleInfo	The style of note.
SparklineInfo	sparklineInfo	The sparkline info.

CellInfo(object, StyleInfo, string, string, object, int, int, string, IFormatProvider, SheetView, int, int, ConditionalFormat[], StickyNoteStyleInfo, SparklineInfo, string)

Initializes a new instance of the CellInfo class.

Declaration

public CellInfo(object rawValue, StyleInfo style, string formula, string note, object tag, int rowLink, int columnLink, string formatString, IFormatProvider formatInfo, SheetView sheet, int rowSpan, int columnSpan, ConditionalFormat[] formats, StickyNoteStyleInfo noteStyleInfo, SparklineInfo sparklineInfo, string errorText)

Public Sub New(rawValue As Object, style As StyleInfo, formula As String, note As String, tag As Object, rowLink As Integer, columnLink As Integer, formatString As String, formatInfo As IFormatProvider, sheet As SheetView, rowSpan As Integer, columnSpan As Integer, formats As ConditionalFormat(), noteStyleInfo As StickyNoteStyleInfo, sparklineInfo As SparklineInfo, errorText As String)

Parameters

Type	Name	Description
object	rawValue	the unformatted value.
StyleInfo	style	the style.
string	formula	The formula.
string	note	The note
object	tag	The tag.
int	rowLink	The row of the reference
int	columnLink	The column of the reference
string	formatString	the format string.
IFormatProvider	formatInfo	the format info.
SheetView	sheet	The sheetview.
int	rowSpan	The span row.
int	columnSpan	The span column
ConditionalFormat[]	formats	The formats
StickyNoteStyleInfo	noteStyleInfo	The style of note.
SparklineInfo	sparklineInfo	The sparkline info.
string	errorText	The error text.

CellInfo(object, StyleInfo, string, string, object, int, int, string, IFormatProvider, SheetView, int, int)

Initializes a new instance of the CellInfo class.

Declaration

public CellInfo(object rawValue, StyleInfo style, string formula, string note, object tag, int rowLink, int columnLink, string formatString, IFormatProvider formatInfo, SheetView sheet, int rowSpan, int columnSpan)

Public Sub New(rawValue As Object, style As StyleInfo, formula As String, note As String, tag As Object, rowLink As Integer, columnLink As Integer, formatString As String, formatInfo As IFormatProvider, sheet As SheetView, rowSpan As Integer, columnSpan As Integer)

Parameters

Type	Name	Description
object	rawValue	the unformatted value.
StyleInfo	style	the style.
string	formula	The formula.
string	note	The note
object	tag	The tag.
int	rowLink	The row of the reference
int	columnLink	The column of the reference
string	formatString	the format string.
IFormatProvider	formatInfo	the format info.
SheetView	sheet	The sheetview.
int	rowSpan	The span row.
int	columnSpan	The span column

CellInfo(object, StyleInfo, string, string, object, int, int, string, IFormatProvider, SheetView)

Initializes a new instance of the CellInfo class.

Declaration

public CellInfo(object rawValue, StyleInfo style, string formula, string note, object tag, int rowLink, int columnLink, string formatString, IFormatProvider formatInfo, SheetView sheet)

Public Sub New(rawValue As Object, style As StyleInfo, formula As String, note As String, tag As Object, rowLink As Integer, columnLink As Integer, formatString As String, formatInfo As IFormatProvider, sheet As SheetView)

Parameters

Type	Name	Description
object	rawValue	the unformatted value.
StyleInfo	style	the style.
string	formula	The formula.
string	note	The note
object	tag	The tag.
int	rowLink	The row of the reference
int	columnLink	The column of the reference
string	formatString	the format string.
IFormatProvider	formatInfo	the format info.
SheetView	sheet	The sheetview.

CellInfo(object)

Creates a new a set of cell information (CellInfo object) with a value.

Declaration

public CellInfo(object rawValue)

Public Sub New(rawValue As Object)

Parameters

Type	Name	Description
object	rawValue	The unformatted value

CellInfo(object, StyleInfo)

Initializes a new instance of the CellInfo class.

Declaration

public CellInfo(object rawValue, StyleInfo style)

Public Sub New(rawValue As Object, style As StyleInfo)

Parameters

Type	Name	Description
object	rawValue	the unformatted value.
StyleInfo	style	the style.

CellInfo(object, StyleInfo, string)

Initializes a new instance of the CellInfo class.

Declaration

public CellInfo(object rawValue, StyleInfo style, string formula)

Public Sub New(rawValue As Object, style As StyleInfo, formula As String)

Parameters

Type	Name	Description
object	rawValue	the unformatted value.
StyleInfo	style	the style.
string	formula	The formula.

CellInfo(object, StyleInfo, string, string)

Initializes a new instance of the CellInfo class.

Declaration

public CellInfo(object rawValue, StyleInfo style, string formula, string note)

Public Sub New(rawValue As Object, style As StyleInfo, formula As String, note As String)

Parameters

Type	Name	Description
object	rawValue	the unformatted value.
StyleInfo	style	the style.
string	formula	The formula.
string	note	The note

CellInfo(object, StyleInfo, string, string, object)

Initializes a new instance of the CellInfo class.

Declaration

public CellInfo(object rawValue, StyleInfo style, string formula, string note, object tag)

Public Sub New(rawValue As Object, style As StyleInfo, formula As String, note As String, tag As Object)

Parameters

Type	Name	Description
object	rawValue	the unformatted value.
StyleInfo	style	the style.
string	formula	The formula.
string	note	The note
object	tag	The tag.

CellInfo(object, StyleInfo, string, string, object, int, int)

Initializes a new instance of the CellInfo class.

Declaration

public CellInfo(object rawValue, StyleInfo style, string formula, string note, object tag, int rowLink, int columnLink)

Public Sub New(rawValue As Object, style As StyleInfo, formula As String, note As String, tag As Object, rowLink As Integer, columnLink As Integer)

Parameters

Type	Name	Description
object	rawValue	the unformatted value.
StyleInfo	style	the style.
string	formula	The formula.
string	note	The note
object	tag	The tag.
int	rowLink	The row of the reference
int	columnLink	The column of the reference