Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
Office client development
Microsoft Office 2003
Office 2003
Primary Interop Assembly References
Microsoft Office Excel Primary Interop Reference
Microsoft.Office.Interop.Excel
_Application Interface
_Application Properties
_Default Property
ActiveCell Property
ActiveChart Property
ActiveDialog Property
ActiveMenuBar Property
ActivePrinter Property
ActiveSheet Property
ActiveWindow Property
ActiveWorkbook Property
AddIns Property
AlertBeforeOverwriting Property
AltStartupPath Property
AnswerWizard Property
Application Property
ArbitraryXMLSupportAvailable Property
AskToUpdateLinks Property
Assistant Property
AutoCorrect Property
AutoFormatAsYouTypeReplaceHyperlinks Property
AutomationSecurity Property
AutoPercentEntry Property
AutoRecover Property
Build Property
CalculateBeforeSave Property
Calculation Property
CalculationInterruptKey Property
CalculationState Property
CalculationVersion Property
Caller Property
CanPlaySounds Property
CanRecordSounds Property
Caption Property
CellDragAndDrop Property
Cells Property
Charts Property
ClipboardFormats Property
ColorButtons Property
Columns Property
COMAddIns Property
CommandBars Property
CommandUnderlines Property
ConstrainNumeric Property
ControlCharacters Property
CopyObjectsWithCells Property
Creator Property
Cursor Property
CursorMovement Property
CustomListCount Property
CutCopyMode Property
DataEntryMode Property
DDEAppReturnCode Property
DecimalSeparator Property
DefaultFilePath Property
DefaultSaveFormat Property
DefaultSheetDirection Property
DefaultWebOptions Property
Dialogs Property
DialogSheets Property
DisplayAlerts Property
DisplayClipboardWindow Property
DisplayCommentIndicator Property
DisplayDocumentActionTaskPane Property
DisplayExcel4Menus Property
DisplayFormulaBar Property
DisplayFullScreen Property
DisplayFunctionToolTips Property
DisplayInfoWindow Property
DisplayInsertOptions Property
DisplayNoteIndicator Property
DisplayPasteOptions Property
DisplayRecentFiles Property
DisplayScrollBars Property
DisplayStatusBar Property
Dummy101 Property
EditDirectlyInCell Property
EnableAnimations Property
EnableAutoComplete Property
EnableCancelKey Property
EnableEvents Property
EnableSound Property
EnableTipWizard Property
ErrorCheckingOptions Property
Excel4IntlMacroSheets Property
Excel4MacroSheets Property
ExtendList Property
FeatureInstall Property
FileConverters Property
FileDialog Property
FileFind Property
FileSearch Property
FindFormat Property
FixedDecimal Property
FixedDecimalPlaces Property
GenerateGetPivotData Property
Height Property
Hinstance Property
Hwnd Property
IgnoreRemoteRequests Property
Interactive Property
International Property
Iteration Property
LanguageSettings Property
LargeButtons Property
Left Property
LibraryPath Property
MailSession Property
MailSystem Property
MapPaperSize Property
MathCoprocessorAvailable Property
MaxChange Property
MaxIterations Property
MemoryFree Property
MemoryTotal Property
MemoryUsed Property
MenuBars Property
Modules Property
MouseAvailable Property
MoveAfterReturn Property
MoveAfterReturnDirection Property
Name Property
Names Property
NetworkTemplatesPath Property
NewWorkbook Property
ODBCErrors Property
ODBCTimeout Property
OLEDBErrors Property
OnCalculate Property
OnData Property
OnDoubleClick Property
OnEntry Property
OnSheetActivate Property
OnSheetDeactivate Property
OnWindow Property
OperatingSystem Property
OrganizationName Property
Parent Property
Path Property
PathSeparator Property
PivotTableSelection Property
PreviousSelections Property
ProductCode Property
PromptForSummaryInfo Property
Range Property
Ready Property
RecentFiles Property
RecordRelative Property
ReferenceStyle Property
RegisteredFunctions Property
ReplaceFormat Property
RollZoom Property
Rows Property
RTD Property
ScreenUpdating Property
Selection Property
Sheets Property
SheetsInNewWorkbook Property
ShortcutMenus Property
ShowChartTipNames Property
ShowChartTipValues Property
ShowStartupDialog Property
ShowToolTips Property
ShowWindowsInTaskbar Property
SmartTagRecognizers Property
Speech Property
SpellingOptions Property
StandardFont Property
StandardFontSize Property
StartupPath Property
StatusBar Property
TemplatesPath Property
ThisCell Property
ThisWorkbook Property
ThousandsSeparator Property
Toolbars Property
Top Property
TransitionMenuKey Property
TransitionMenuKeyAction Property
TransitionNavigKeys Property
UILanguage Property
UsableHeight Property
UsableWidth Property
UsedObjects Property
UserControl Property
UserLibraryPath Property
UserName Property
UseSystemSeparators Property
Value Property
VBE Property
Version Property
Visible Property
Watches Property
Width Property
Windows Property
WindowsForPens Property
WindowState Property
Workbooks Property
WorksheetFunction Property
Worksheets Property
Expand Minimize
This topic has not yet been rated - Rate this topic

_Application.ReferenceStyle Property 

Office 2003
Returns or sets how Microsoft Excel displays cell references and row and column headings in either A1 or R1C1 reference style. Read/write XlReferenceStyle.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

VB
Copy 
'Usage
Dim _Application1 As _Application

Dim returnValue As XlReferenceStyle
returnValue = _Application1.ReferenceStyle

Dim sampleValue As XlReferenceStyle
_Application1.ReferenceStyle = sampleValue
C#
C++
VB
Copy 
XlReferenceStyle ReferenceStyle {get; set;}
J#
Copy 
public XlReferenceStyle get_ReferenceStyle();
public void set_ReferenceStyle(XlReferenceStyle);
JScript
Copy 
function get ReferenceStyle() : XlReferenceStyle;
function set ReferenceStyle(XlReferenceStyle);

XlReferenceStyle can be one of these XlReferenceStyle constants:

xlA1

xlR1C1


Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.