SetRefStyle Method

---

See Also    DLL    Example

Applies To

fpSpread control

Description

Sets the reference style used by the control to represent formulas and custom names.

Syntax

void CSpreadSheet::SetRefStyle (long RefStyle);

fpSpread.SetRefStyle(ByVal RefStyle As Long)

Parameters

The following parameters are available:

Parameter	Description
RefStyle	Reference style Use one of the following values:
	Description	Example
	(Default) Uses letters and numbers for column and row coordinates; letters and numbers represent absolute coordinates, number sign (#) represents the current column or row	A1, B#, #2
	Constant: RefStyleDefault
	Uses letters and numbers for column and row coordinates; uses dollar sign ($) for absolute coordinates	$A$1, $B, $2, $B2, C$5, D4
	Constant: RefStyleA1
	Uses "R" and number for row, "C" and number for column coordinates; [ ] for relative coordinates, "C" or "R" without a number represents the current row or column	R1C1, RC2, R4C[3], R[2]C4, RC[-2]
	Constant: RefStyleR1C1

Remarks

The fpSpread control can use relative or absolute references for formulas. The default is absolute references that do not change when copied to another position. The default reference style lets the user indicate the current row or column using the number sign (#).

This method is applied to the entire workbook, including all sheets in the control.

RefStyleA1 provides relative references. The user can also specify absolute references using a dollar sign before the column or row coordinate. This reference style emulates Microsoft Excel.

RefStyleR1C1 uses row and column number coordinates and allows relative references, which are specified by brackets.

Your formula cannot contain both absolute and relative row or column references. For example, the following formula to add the values in the first column up to the current row is invalid.

fpSpread1.Formula = "sum(A1:A#)"

Likewise, the following formula to add the values in the first row up to the current column is invalid.

fpSpread1.Formula = "sum(A1:#1)"

Spread Designer

Choose the Calculation menu, the Reference Style menu, and then the Reference Style tab in the Calculation Settings dialog box.

Parameter	Items on Reference Style tab
RefStyle	Option buttons under Reference Style

Return Type

None

See Also

Specifying Cell References

ReCalcCell, GetRefStyle method

DLL Correspondence

SSSetRefStyle function