ScVbaRange Class Reference

#include <vbarange.hxx>

Inheritance diagram for ScVbaRange:

Collaboration diagram for ScVbaRange:

Public Member Functions
	ScVbaRange (const css::uno::Reference< ov::XHelperInterface > &xParent, const css::uno::Reference< css::uno::XComponentContext > &xContext, const css::uno::Reference< css::table::XCellRange > &xRange, bool bIsRows=false, bool bIsColumns=false)
	ScVbaRange (const css::uno::Reference< ov::XHelperInterface > &xParent, const css::uno::Reference< css::uno::XComponentContext > &xContext, const css::uno::Reference< css::sheet::XSheetCellRangeContainer > &xRanges, bool bIsRows=false, bool bIsColumns=false)
	ScVbaRange (css::uno::Sequence< css::uno::Any > const &aArgs, css::uno::Reference< css::uno::XComponentContext >const &xContext)
ScDocument &	getScDocument ()
ScDocShell *	getScDocShell ()
css::uno::Reference< css::frame::XModel >	getUnoModel ()
const ScRangeList &	getScRangeList ()
virtual	~ScVbaRange () override
virtual css::uno::Reference< ov::XHelperInterface >	thisHelperIface () override
bool	isSingleCellRange () const
virtual css::uno::Any SAL_CALL	getValue () override
virtual void SAL_CALL	setValue (const css::uno::Any &aValue) override
virtual css::uno::Any SAL_CALL	getFormula () override
virtual void SAL_CALL	setFormula (const css::uno::Any &rFormula) override
virtual css::uno::Any SAL_CALL	getFormulaArray () override
virtual void SAL_CALL	setFormulaArray (const css::uno::Any &rFormula) override
virtual css::uno::Any SAL_CALL	getFormulaR1C1 () override
virtual void SAL_CALL	setFormulaR1C1 (const css::uno::Any &rFormula) override
virtual css::uno::Any SAL_CALL	getFormulaLocal () override
virtual void SAL_CALL	setFormulaLocal (const css::uno::Any &rFormula) override
virtual css::uno::Any SAL_CALL	getFormulaR1C1Local () override
virtual void SAL_CALL	setFormulaR1C1Local (const css::uno::Any &rFormula) override
virtual ::sal_Int32 SAL_CALL	getCount () override
virtual ::sal_Int32 SAL_CALL	getRow () override
virtual ::sal_Int32 SAL_CALL	getColumn () override
virtual OUString SAL_CALL	getText () override
virtual void SAL_CALL	setNumberFormat (const css::uno::Any &rNumberFormat) override
virtual css::uno::Any SAL_CALL	getNumberFormat () override
virtual void SAL_CALL	setMergeCells (const css::uno::Any &bMerge) override
virtual css::uno::Any SAL_CALL	getMergeCells () override
virtual void SAL_CALL	setWrapText (const css::uno::Any &bIsWrapped) override
virtual css::uno::Any SAL_CALL	getWrapText () override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	getEntireRow () override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	getEntireColumn () override
virtual css::uno::Reference< ov::excel::XComment > SAL_CALL	getComment () override
virtual css::uno::Any SAL_CALL	getHidden () override
virtual void SAL_CALL	setHidden (const css::uno::Any &_hidden) override
virtual css::uno::Any SAL_CALL	getColumnWidth () override
virtual void SAL_CALL	setColumnWidth (const css::uno::Any &_columnwidth) override
virtual css::uno::Any SAL_CALL	getRowHeight () override
virtual void SAL_CALL	setRowHeight (const css::uno::Any &_rowheight) override
virtual css::uno::Any SAL_CALL	getWidth () override
virtual css::uno::Any SAL_CALL	getHeight () override
virtual css::uno::Any SAL_CALL	getTop () override
virtual css::uno::Any SAL_CALL	getLeft () override
virtual css::uno::Reference< ov::excel::XName > SAL_CALL	getName () override
virtual css::uno::Reference< ov::excel::XWorksheet > SAL_CALL	getWorksheet () override
virtual css::uno::Any SAL_CALL	getPageBreak () override
virtual void SAL_CALL	setPageBreak (const css::uno::Any &_pagebreak) override
virtual css::uno::Reference< ov::excel::XValidation > SAL_CALL	getValidation () override
virtual css::uno::Any SAL_CALL	getPrefixCharacter () override
virtual css::uno::Any SAL_CALL	getShowDetail () override
virtual void SAL_CALL	setShowDetail (const css::uno::Any &aShowDetail) override
virtual css::uno::Reference< ov::excel::XComment > SAL_CALL	AddComment (const css::uno::Any &Text) override
virtual void SAL_CALL	Clear () override
virtual void SAL_CALL	ClearComments () override
virtual void SAL_CALL	ClearContents () override
virtual void SAL_CALL	ClearFormats () override
virtual css::uno::Any SAL_CALL	HasFormula () override
virtual void SAL_CALL	FillLeft () override
virtual void SAL_CALL	FillRight () override
virtual void SAL_CALL	FillUp () override
virtual void SAL_CALL	FillDown () override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	Offset (const css::uno::Any &nRowOffset, const css::uno::Any &nColOffset) override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	CurrentRegion () override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	CurrentArray () override
virtual OUString SAL_CALL	Characters (const css::uno::Any &nIndex, const css::uno::Any &nCount) override
virtual OUString SAL_CALL	Address (const css::uno::Any &RowAbsolute, const css::uno::Any &ColumnAbsolute, const css::uno::Any &ReferenceStyle, const css::uno::Any &External, const css::uno::Any &RelativeTo) override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	Cells (const css::uno::Any &nRow, const css::uno::Any &nCol) override
virtual void SAL_CALL	Select () override
virtual void SAL_CALL	Activate () override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	Rows (const css::uno::Any &nIndex) override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	Columns (const css::uno::Any &nIndex) override
virtual void SAL_CALL	Copy (const css::uno::Any &Destination) override
virtual void SAL_CALL	Cut (const css::uno::Any &Destination) override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	Resize (const css::uno::Any &RowSize, const css::uno::Any &ColumnSize) override
virtual css::uno::Reference< ov::excel::XFont > SAL_CALL	Font () override
virtual css::uno::Reference< ov::excel::XInterior > SAL_CALL	Interior () override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	Range (const css::uno::Any &Cell1, const css::uno::Any &Cell2) override
css::uno::Reference< ov::excel::XRange >	Range (const css::uno::Any &Cell1, const css::uno::Any &Cell2, bool bForceUseInpuRangeTab)
virtual css::uno::Any SAL_CALL	getCellRange () override
virtual void SAL_CALL	PasteSpecial (const css::uno::Any &Paste, const css::uno::Any &Operation, const css::uno::Any &SkipBlanks, const css::uno::Any &Transpose) override
virtual sal_Bool SAL_CALL	Replace (const OUString &What, const OUString &Replacement, const css::uno::Any &LookAt, const css::uno::Any &SearchOrder, const css::uno::Any &MatchCase, const css::uno::Any &MatchByte, const css::uno::Any &SearchFormat, const css::uno::Any &ReplaceFormat) override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	Find (const css::uno::Any &What, const css::uno::Any &After, const css::uno::Any &LookIn, const css::uno::Any &LookAt, const css::uno::Any &SearchOrder, const css::uno::Any &SearchDirection, const css::uno::Any &MatchCase, const css::uno::Any &MatchByte, const css::uno::Any &SearchFormat) override
virtual void SAL_CALL	Sort (const css::uno::Any &Key1, const css::uno::Any &Order1, const css::uno::Any &Key2, const css::uno::Any &Type, const css::uno::Any &Order2, const css::uno::Any &Key3, const css::uno::Any &Order3, const css::uno::Any &Header, const css::uno::Any &OrderCustom, const css::uno::Any &MatchCase, const css::uno::Any &Orientation, const css::uno::Any &SortMethod, const css::uno::Any &DataOption1, const css::uno::Any &DataOption2, const css::uno::Any &DataOption3) override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	End (::sal_Int32 Direction) override
virtual css::uno::Reference< ov::excel::XCharacters > SAL_CALL	characters (const css::uno::Any &Start, const css::uno::Any &Length) override
virtual void SAL_CALL	Delete (const css::uno::Any &Shift) override
virtual css::uno::Any SAL_CALL	Areas (const css::uno::Any &) override
virtual css::uno::Any SAL_CALL	Borders (const css::uno::Any &) override
virtual css::uno::Any SAL_CALL	BorderAround (const css::uno::Any &LineStyle, const css::uno::Any &Weight, const css::uno::Any &ColorIndex, const css::uno::Any &Color) override
virtual css::uno::Any SAL_CALL	Hyperlinks (const css::uno::Any &aIndex) override
virtual void SAL_CALL	AutoFilter (const css::uno::Any &Field, const css::uno::Any &Criteria1, const css::uno::Any &Operator, const css::uno::Any &Criteria2, const css::uno::Any &VisibleDropDown) override
virtual void SAL_CALL	Insert (const css::uno::Any &Shift, const css::uno::Any &CopyOrigin) override
virtual void SAL_CALL	Autofit () override
virtual void SAL_CALL	PrintOut (const css::uno::Any &From, const css::uno::Any &To, const css::uno::Any &Copies, const css::uno::Any &Preview, const css::uno::Any &ActivePrinter, const css::uno::Any &PrintToFile, const css::uno::Any &Collate, const css::uno::Any &PrToFileName) override
virtual void SAL_CALL	AutoFill (const css::uno::Reference< ov::excel::XRange > &Destination, const css::uno::Any &Type) override
void SAL_CALL	Calculate () override
virtual void SAL_CALL	AutoOutline () override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	Item (const css::uno::Any &row, const css::uno::Any &column) override
virtual void SAL_CALL	ClearOutline () override
virtual void SAL_CALL	Ungroup () override
virtual void SAL_CALL	Group () override
virtual void SAL_CALL	Merge (const css::uno::Any &Across) override
virtual void SAL_CALL	UnMerge () override
virtual css::uno::Any SAL_CALL	getStyle () override
virtual void SAL_CALL	setStyle (const css::uno::Any &_style) override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	Next () override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	Previous () override
virtual void SAL_CALL	RemoveSubtotal () override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	MergeArea () override
virtual void SAL_CALL	Subtotal (::sal_Int32 GroupBy,::sal_Int32 Function, const css::uno::Sequence< ::sal_Int32 > &TotalList, const css::uno::Any &Replace, const css::uno::Any &PageBreaks, const css::uno::Any &SummaryBelowData) override
virtual css::uno::Reference< css::container::XEnumeration > SAL_CALL	createEnumeration () override
virtual css::uno::Type SAL_CALL	getElementType () override
virtual sal_Bool SAL_CALL	hasElements () override
OUString SAL_CALL	getDefaultMethodName () override
OUString SAL_CALL	getDefaultPropertyName () override
virtual sal_Bool SAL_CALL	GoalSeek (const css::uno::Any &Goal, const css::uno::Reference< ov::excel::XRange > &ChangingCell) override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	SpecialCells (const css::uno::Any &_oType, const css::uno::Any &_oValue) override
virtual sal_Bool SAL_CALL	hasError () override
virtual OUString	getServiceImplName () override
virtual css::uno::Sequence< OUString >	getServiceNames () override
Public Member Functions inherited from ScVbaFormat< Ifc >
	ScVbaFormat (const css::uno::Reference< ov::XHelperInterface > &xParent, const css::uno::Reference< css::uno::XComponentContext > &xContext, const css::uno::Reference< css::beans::XPropertySet > &_xPropertySet, const css::uno::Reference< css::frame::XModel > &xModel, bool bCheckAmbiguoity)
void SAL_CALL	setAddIndent (const css::uno::Any &BAddIndent)
css::uno::Any SAL_CALL	getAddIndent ()
virtual void SAL_CALL	setNumberFormatLocal (const css::uno::Any &NumberFormatLocal)
virtual css::uno::Any SAL_CALL	getNumberFormatLocal ()
virtual void SAL_CALL	setIndentLevel (const css::uno::Any &IndentLevel)
virtual css::uno::Any SAL_CALL	getIndentLevel ()
virtual void SAL_CALL	setHorizontalAlignment (const css::uno::Any &HorizontalAlignment)
virtual css::uno::Any SAL_CALL	getHorizontalAlignment ()
virtual void SAL_CALL	setVerticalAlignment (const css::uno::Any &VerticalAlignment)
virtual css::uno::Any SAL_CALL	getVerticalAlignment ()
virtual void SAL_CALL	setOrientation (const css::uno::Any &Orientation)
virtual css::uno::Any SAL_CALL	getOrientation ()
virtual void SAL_CALL	setShrinkToFit (const css::uno::Any &ShrinkToFit)
virtual css::uno::Any SAL_CALL	getShrinkToFit ()
virtual void SAL_CALL	setLocked (const css::uno::Any &Locked)
virtual css::uno::Any SAL_CALL	getLocked ()
virtual void SAL_CALL	setFormulaHidden (const css::uno::Any &FormulaHidden)
virtual css::uno::Any SAL_CALL	getFormulaHidden ()
virtual void SAL_CALL	setReadingOrder (const css::uno::Any &ReadingOrder)
virtual css::uno::Any SAL_CALL	getReadingOrder ()
Public Member Functions inherited from InheritedHelperInterfaceWeakImpl< Ifc... >
	InheritedHelperInterfaceWeakImpl (const css::uno::Reference< ov::XHelperInterface > &xParent, const css::uno::Reference< css::uno::XComponentContext > &xContext)
Public Member Functions inherited from InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >
	InheritedHelperInterfaceImpl (const css::uno::Reference< ov::XHelperInterface > &xParent, const css::uno::Reference< css::uno::XComponentContext > &xContext)
virtual ::sal_Int32 SAL_CALL	getCreator () override
virtual css::uno::Reference< ov::XHelperInterface > SAL_CALL	getParent () override
virtual css::uno::Any SAL_CALL	Application () override
virtual OUString SAL_CALL	getImplementationName () override
virtual sal_Bool SAL_CALL	supportsService (const OUString &ServiceName) override
virtual css::uno::Sequence< OUString > SAL_CALL	getSupportedServiceNames () override

Static Public Member Functions
static ScVbaRange *	getImplementation (const css::uno::Reference< ov::excel::XRange > &rxRange)
	Returns the ScVbaRange implementation object for the passed VBA Range object. More...
static css::uno::Reference< css::frame::XModel >	getUnoModel (const css::uno::Reference< ov::excel::XRange > &rxRange)
static const ScRangeList &	getScRangeList (const css::uno::Reference< ov::excel::XRange > &rxRange)
static css::uno::Reference< ov::excel::XRange >	getRangeObjectForName (const css::uno::Reference< css::uno::XComponentContext > &xContext, const OUString &sRangeName, ScDocShell *pDocSh, formula::FormulaGrammar::AddressConvention eConv)
static css::uno::Reference< ov::excel::XRange >	CellsHelper (const ScDocument &rDoc, const css::uno::Reference< ov::XHelperInterface > &xParent, const css::uno::Reference< css::uno::XComponentContext > &xContext, const css::uno::Reference< css::table::XCellRange > &xRange, const css::uno::Any &nRowIndex, const css::uno::Any &nColumnIndex)
static css::uno::Any	getCellRange (const css::uno::Reference< ov::excel::XRange > &rxRange)
static css::uno::Reference< ov::excel::XRange >	ApplicationRange (const css::uno::Reference< css::uno::XComponentContext > &xContext, const css::uno::Any &Cell1, const css::uno::Any &Cell2)
static bool	getCellRangesForAddress (ScRefFlags &rResFlags, const OUString &sAddress, ScDocShell *pDocSh, ScRangeList &rCellRanges, formula::FormulaGrammar::AddressConvention eConv, char cDelimiter)

Protected Member Functions
virtual ScCellRangesBase *	getCellRangesBase () override
SfxItemSet *	getCurrentDataSet ()
Protected Member Functions inherited from ScVbaFormat< Ifc >
bool	isAmbiguous (const OUString &_sPropertyName)
css::uno::Reference< css::beans::XPropertyState > const &	getXPropertyState ()
void	initializeNumberFormats ()
SfxItemSet *	getCurrentDataSet ()

Private Member Functions
double	getCalcColWidth (const css::table::CellRangeAddress &)
double	getCalcRowHeight (const css::table::CellRangeAddress &)
void	visitArray (ArrayVisitor &visitor)
css::uno::Reference< ov::excel::XRange >	getEntireColumnOrRow (bool bColumn)
void	fillSeries (css::sheet::FillDirection nFillDirection, css::sheet::FillMode nFillMode, css::sheet::FillDateMode nFillDateMode, double fStep, double fEndValue)
void	ClearContents (sal_Int32 nFlags, bool bFireEvent)
css::uno::Any	getValue (ValueGetter &rValueGetter)
void	setValue (const css::uno::Any &aValue, ValueSetter &setter)
css::uno::Any	getFormulaValue (formula::FormulaGrammar::Grammar)
void	setFormulaValue (const css::uno::Any &aValue, formula::FormulaGrammar::Grammar)
css::uno::Reference< ov::excel::XRange >	getArea (sal_Int32 nIndex)
ScCellRangeObj *	getCellRangeObj ()
css::uno::Reference< ov::XCollection > &	getBorders ()
void	groupUnGroup (bool bUnGroup)
css::uno::Reference< ov::excel::XRange >	PreviousNext (bool bIsPrevious)
css::uno::Reference< ov::excel::XRange >	SpecialCellsImpl (sal_Int32 nType, const css::uno::Any &_oValue)
css::awt::Point	getPosition () const
void	fireChangeEvent ()
	Fires a Worksheet_Change event for this range or range list. More...

Private Attributes
css::uno::Reference< ov::XCollection >	m_Areas
css::uno::Reference< ov::XCollection >	m_Borders
css::uno::Reference< css::table::XCellRange >	mxRange
css::uno::Reference< css::sheet::XSheetCellRangeContainer >	mxRanges
bool	mbIsRows
bool	mbIsColumns
css::uno::Reference< ov::excel::XValidation >	m_xValidation

Additional Inherited Members
Protected Attributes inherited from ScVbaFormat< Ifc >
css::uno::Reference< css::beans::XPropertySet >	mxPropertySet
css::uno::Reference< css::util::XNumberFormatsSupplier >	mxNumberFormatsSupplier
css::uno::Reference< css::util::XNumberFormats >	xNumberFormats
css::uno::Reference< css::util::XNumberFormatTypes >	xNumberFormatTypes
css::uno::Reference< css::frame::XModel >	mxModel
css::uno::Reference< css::beans::XPropertyState >	xPropertyState
bool	mbCheckAmbiguoity
bool	mbAddIndent
Protected Attributes inherited from InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >
css::uno::WeakReference< ov::XHelperInterface >	mxParent
css::uno::Reference< css::uno::XComponentContext >	mxContext

Detailed Description

Definition at line 72 of file vbarange.hxx.

Constructor & Destructor Documentation

ScVbaRange::ScVbaRange	(	const css::uno::Reference< ov::XHelperInterface > &	xParent,
		const css::uno::Reference< css::uno::XComponentContext > &	xContext,
		const css::uno::Reference< css::table::XCellRange > &	xRange,
		bool	bIsRows = false,
		bool	bIsColumns = false
	)

Exceptions

css::lang::IllegalArgumentException

Referenced by ApplicationRange(), CellsHelper(), Columns(), Find(), getEntireColumnOrRow(), Insert(), MergeArea(), Offset(), PreviousNext(), Replace(), Resize(), Rows(), and SpecialCells().

ScVbaRange::ScVbaRange	(	const css::uno::Reference< ov::XHelperInterface > &	xParent,
		const css::uno::Reference< css::uno::XComponentContext > &	xContext,
		const css::uno::Reference< css::sheet::XSheetCellRangeContainer > &	xRanges,
		bool	bIsRows = false,
		bool	bIsColumns = false
	)

Exceptions

css::lang::IllegalArgumentException
css::uno::RuntimeException

ScVbaRange::ScVbaRange	(	css::uno::Sequence< css::uno::Any > const &	aArgs,
		css::uno::Reference< css::uno::XComponentContext >const &	xContext
	)

Exceptions

css::lang::IllegalArgumentException
css::uno::RuntimeException

ScVbaRange::~ScVbaRange ( )

overridevirtual

Definition at line 1462 of file vbarange.cxx.

Member Function Documentation

void ScVbaRange::Activate ( )

overridevirtual

Definition at line 2308 of file vbarange.cxx.

References cellInRange(), SfxObjectShell::GetModel(), getScDocShell(), isSingleCellRange(), mxRange, mxRanges, Select(), setCursor(), and xModel.

uno::Reference< excel::XComment > SAL_CALL ScVbaRange::AddComment ( const css::uno::Any &  Text )

overridevirtual

Definition at line 2943 of file vbarange.cxx.

References getComment(), getUnoModel(), uno::Any::hasValue(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, and mxRange.

OUString ScVbaRange::Address ( const css::uno::Any &  RowAbsolute, const css::uno::Any &  ColumnAbsolute, const css::uno::Any &  ReferenceStyle, const css::uno::Any &  External, const css::uno::Any &  RelativeTo  )

overridevirtual

Definition at line 2062 of file vbarange.cxx.

References COL2_ABS, COL_ABS, formula::FormulaGrammar::CONV_XL_A1, formula::FormulaGrammar::CONV_XL_R1C1, FORCE_DOC, ScRange::Format(), getCellRangeAddressForVBARange(), ScDocShell::GetDocument(), getScDocShell(), uno::Any::hasValue(), index, m_Areas, mxRange, RANGE_ABS, ROW2_ABS, ROW_ABS, and TAB_3D.

uno::Reference< excel::XRange > ScVbaRange::ApplicationRange ( const css::uno::Reference< css::uno::XComponentContext > &  xContext, const css::uno::Any &  Cell1, const css::uno::Any &  Cell2  )

static

Exceptions

css::uno::RuntimeException

Definition at line 4200 of file vbarange.cxx.

References getCurrentExcelDoc(), ooo::vba::excel::getUnoSheetModuleObj(), and ScVbaRange().

Referenced by ScVbaApplication::Range().

uno::Any SAL_CALL ScVbaRange::Areas ( const css::uno::Any &  )

overridevirtual

Definition at line 3868 of file vbarange.cxx.

References uno::Any::hasValue(), and m_Areas.

void SAL_CALL ScVbaRange::AutoFill ( const css::uno::Reference< ov::excel::XRange > &  Destination, const css::uno::Any &  Type  )

overridevirtual

Definition at line 5022 of file vbarange.cxx.

References ScRange::aEnd, ScRange::aStart, ScAddress::Col(), FILL_AUTO, FILL_DATE, FILL_DAY, FILL_GROWTH, FILL_LINEAR, FILL_MONTH, FILL_SIMPLE, FILL_TO_BOTTOM, FILL_TO_LEFT, FILL_TO_RIGHT, FILL_TO_TOP, FILL_WEEKDAY, FILL_YEAR, ScDocFunc::FillAuto(), ScUnoConversion::FillScRange(), ScDocShell::GetDocFunc(), getDocShellFromRange(), getImplementation(), uno::Any::hasValue(), MAXDOUBLE, mxRange, ScAddress::Row(), ScAddress::SetCol(), and ScAddress::SetRow().

void SAL_CALL ScVbaRange::AutoFilter ( const css::uno::Any &  Field, const css::uno::Any &  Criteria1, const css::uno::Any &  Operator, const css::uno::Any &  Criteria2, const css::uno::Any &  VisibleDropDown  )

overridevirtual

Definition at line 4410 of file vbarange.cxx.

References ScQueryEntry::bDoQuery, CurrentRegion(), Field, ooo::vba::excel::GetAutoFiltRange(), ScDocument::GetDataArea(), ScDocShell::GetDocument(), ScQueryParamBase::GetEntry(), ScQueryParamBase::GetEntryCount(), getImplementation(), getScDocShell(), getTypeConverter(), ooo::vba::excel::GetUnnamedDataBaseRanges(), uno::Any::hasValue(), i, isSingleCellRange(), lcl_GetQueryParam(), lcl_SetAllQueryForField(), lcl_setTableFieldsFromCriteria(), m_Areas, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, mxRange, ScQueryEntry::nField, nLength, and STR_ERRORMESSAGE_APPLIESTOSINGLERANGEONLY().

void SAL_CALL ScVbaRange::Autofit ( )

overridevirtual

Definition at line 4734 of file vbarange.cxx.

References ERRCODE_BASIC_METHOD_FAILED, getDocShellFromRange(), index, m_Areas, mbIsColumns, mbIsRows, mxRange, and SC_SIZE_OPTIMAL.

void ScVbaRange::AutoOutline ( )

overridevirtual

Definition at line 5189 of file vbarange.cxx.

References ERRCODE_BASIC_METHOD_FAILED, isSingleCellRange(), m_Areas, mbIsRows, mxRange, and STR_ERRORMESSAGE_APPLIESTOSINGLERANGEONLY().

uno::Any SAL_CALL ScVbaRange::BorderAround ( const css::uno::Any &  LineStyle, const css::uno::Any &  Weight, const css::uno::Any &  ColorIndex, const css::uno::Any &  Color  )

overridevirtual

Definition at line 3893 of file vbarange.cxx.

References getBorders(), i, m_Borders, and supportedIndexTable.

uno::Any ScVbaRange::Borders ( const css::uno::Any &  Index )

overridevirtual

Exceptions

css::script::BasicErrorException
css::uno::RuntimeException

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 3885 of file vbarange.cxx.

References getBorders(), and uno::Any::hasValue().

void ScVbaRange::Calculate ( )

override

Definition at line 5166 of file vbarange.cxx.

References getWorksheet().

uno::Reference< excel::XRange > ScVbaRange::Cells ( const css::uno::Any &  nRow, const css::uno::Any &  nCol  )

overridevirtual

Definition at line 2159 of file vbarange.cxx.

References CellsHelper(), getArea(), getScDocument(), m_Areas, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxParent, and mxRange.

Referenced by End(), Find(), Item(), and SpecialCellsImpl().

uno::Reference< excel::XRange > ScVbaRange::CellsHelper ( const ScDocument &  rDoc, const css::uno::Reference< ov::XHelperInterface > &  xParent, const css::uno::Reference< css::uno::XComponentContext > &  xContext, const css::uno::Reference< css::table::XCellRange > &  xRange, const css::uno::Any &  nRowIndex, const css::uno::Any &  nColumnIndex  )

static

Exceptions

css::uno::RuntimeException

Definition at line 2178 of file vbarange.cxx.

References ScRange::aStart, ScAddress::Col(), COL_VALID, formula::FormulaGrammar::CONV_XL_A1, getTypeConverter(), uno::Any::hasValue(), nIndex, ScRange::ParseCols(), ScVbaRange(), and ZERO.

Referenced by ScVbaWorksheet::Cells(), and Cells().

OUString ScVbaRange::Characters ( const css::uno::Any &  nIndex, const css::uno::Any &  nCount  )

overridevirtual

Definition at line 2036 of file vbarange.cxx.

References getArea(), m_Areas, mxRange, and nIndex.

uno::Reference< excel::XCharacters > SAL_CALL ScVbaRange::characters ( const css::uno::Any &  Start, const css::uno::Any &  Length  )

overridevirtual

Definition at line 3647 of file vbarange.cxx.

References getDocumentFromRange(), isSingleCellRange(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, and mxRange.

void SAL_CALL ScVbaRange::Clear ( )

overridevirtual

Definition at line 1582 of file vbarange.cxx.

References ClearContents(), DATETIME, EDITATTR, HARDATTR, STRING, and VALUE.

void SAL_CALL ScVbaRange::ClearComments ( )

overridevirtual

Definition at line 1618 of file vbarange.cxx.

References ClearContents().

void ScVbaRange::ClearContents ( sal_Int32  nFlags, bool  bFireEvent  )

private

Exceptions

css::uno::RuntimeException

Definition at line 1591 of file vbarange.cxx.

References fireChangeEvent(), getImplementation(), index, m_Areas, and mxRange.

void SAL_CALL ScVbaRange::ClearContents ( )

overridevirtual

Definition at line 1624 of file vbarange.cxx.

References DATETIME, STRING, and VALUE.

Referenced by Clear(), ClearComments(), and ClearFormats().

void SAL_CALL ScVbaRange::ClearFormats ( )

overridevirtual

Definition at line 1632 of file vbarange.cxx.

References ClearContents(), EDITATTR, and HARDATTR.

void SAL_CALL ScVbaRange::ClearOutline ( )

overridevirtual

Definition at line 5213 of file vbarange.cxx.

References index, m_Areas, and mxRange.

uno::Reference< excel::XRange > ScVbaRange::Columns ( const css::uno::Any &  nIndex )

overridevirtual

Definition at line 2410 of file vbarange.cxx.

References ScRange::aEnd, ScRange::aStart, ScAddress::Col(), formula::FormulaGrammar::CONV_XL_A1, ScRangeList::front(), getCellRangesBase(), ScCellRangesBase::GetDocShell(), ScCellRangesBase::GetRangeList(), getScDocument(), uno::Any::hasValue(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxParent, nValue, ScRange::ParseCols(), ScVbaRange(), and ScAddress::SetCol().

Referenced by Item().

void ScVbaRange::Copy ( const css::uno::Any &  Destination )

overridevirtual

Definition at line 2513 of file vbarange.cxx.

References getImplementation(), getUnoModel(), ooo::vba::excel::implnCopy(), m_Areas, and mxRange.

uno::Reference< container::XEnumeration > SAL_CALL ScVbaRange::createEnumeration ( )

overridevirtual

Definition at line 3720 of file vbarange.cxx.

References m_Areas, mbIsColumns, mbIsRows, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxParent, and mxRange.

uno::Reference< excel::XRange > ScVbaRange::CurrentArray ( )

overridevirtual

Definition at line 1942 of file vbarange.cxx.

References getArea(), m_Areas, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxParent, and mxRange.

uno::Reference< excel::XRange > ScVbaRange::CurrentRegion ( )

overridevirtual

Definition at line 1921 of file vbarange.cxx.

References getArea(), m_Areas, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxParent, and mxRange.

Referenced by AutoFilter().

void ScVbaRange::Cut ( const css::uno::Any &  Destination )

overridevirtual

Definition at line 2542 of file vbarange.cxx.

References getModelFromRange(), ooo::vba::excel::implnCut(), m_Areas, mxRange, Select(), and xModel.

void SAL_CALL ScVbaRange::Delete ( const css::uno::Any &  Shift )

overridevirtual

Definition at line 3659 of file vbarange.cxx.

References getScDocument(), uno::Any::hasValue(), index, m_Areas, ScDocument::MaxCol(), mbIsRows, mode, and mxRange.

uno::Reference< excel::XRange > SAL_CALL ScVbaRange::End ( ::sal_Int32  Direction )

overridevirtual

Definition at line 3556 of file vbarange.cxx.

References InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::Application(), Cells(), SfxDispatcher::Execute(), getArea(), SfxViewFrame::GetDispatcher(), getModelFromRange(), ooo::vba::excel::getViewFrame(), m_Areas, mxRange, SfxItemSet::Put(), SfxGetpApp(), SfxPoolItem::Which(), and xModel.

void ScVbaRange::FillDown ( )

overridevirtual

Definition at line 1862 of file vbarange.cxx.

References fillSeries().

void ScVbaRange::FillLeft ( )

overridevirtual

Definition at line 1841 of file vbarange.cxx.

References fillSeries().

void ScVbaRange::FillRight ( )

overridevirtual

Definition at line 1848 of file vbarange.cxx.

References fillSeries().

void ScVbaRange::fillSeries ( css::sheet::FillDirection  nFillDirection, css::sheet::FillMode  nFillMode, css::sheet::FillDateMode  nFillDateMode, double  fStep, double  fEndValue  )

private

Exceptions

css::uno::RuntimeException

Definition at line 1819 of file vbarange.cxx.

References fireChangeEvent(), getImplementation(), index, m_Areas, and mxRange.

Referenced by FillDown(), FillLeft(), FillRight(), and FillUp().

void ScVbaRange::FillUp ( )

overridevirtual

Definition at line 1855 of file vbarange.cxx.

References fillSeries().

uno::Reference< excel::XRange > SAL_CALL ScVbaRange::Find ( const css::uno::Any &  What, const css::uno::Any &  After, const css::uno::Any &  LookIn, const css::uno::Any &  LookAt, const css::uno::Any &  SearchOrder, const css::uno::Any &  SearchDirection, const css::uno::Any &  MatchCase, const css::uno::Any &  MatchByte, const css::uno::Any &  SearchFormat  )

overridevirtual

Definition at line 3147 of file vbarange.cxx.

References Cells(), ScGlobal::GetSearchItem(), uno::Any::hasValue(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxParent, mxRange, SC_UNO_SRCHBYROW, SC_UNO_SRCHCASE, SC_UNO_SRCHREGEXP, SC_UNO_SRCHWORDS, ScVbaRange(), SvxSearchItem::SetBackward(), SvxSearchItem::SetCellType(), SvxSearchItem::SetRowDirection(), ScGlobal::SetSearchItem(), SvxSearchItem::SetWordOnly(), and VBAToRegexp().

void ScVbaRange::fireChangeEvent ( )

private

Fires a Worksheet_Change event for this range or range list.

Definition at line 247 of file vbarange.cxx.

References ScVbaApplication::getDocumentEventsEnabled(), getScDocument(), and ScDocument::GetVbaEventProcessor().

Referenced by ClearContents(), fillSeries(), and Replace().

uno::Reference< excel::XFont > ScVbaRange::Font ( )

overridevirtual

Exceptions

css::script::BasicErrorException
css::uno::RuntimeException

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 2137 of file vbarange.cxx.

References getCellRangeObj(), ScDocument::GetDocumentShell(), getScDocument(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, mxRange, and mxRanges.

uno::Reference< excel::XRange > ScVbaRange::getArea ( sal_Int32  nIndex )

private

Exceptions

css::uno::RuntimeException

Definition at line 3876 of file vbarange.cxx.

References m_Areas.

Referenced by Cells(), Characters(), CurrentArray(), CurrentRegion(), End(), getColumn(), getFormulaArray(), getFormulaValue(), getLeft(), getRow(), getText(), getTop(), getValue(), and setFormulaArray().

uno::Reference< XCollection > & ScVbaRange::getBorders ( )

private

Definition at line 1466 of file vbarange.cxx.

References lcl_setupBorders(), m_Areas, m_Borders, and InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext.

Referenced by BorderAround(), and Borders().

double ScVbaRange::getCalcColWidth ( const css::table::CellRangeAddress &  )

private

Exceptions

css::uno::RuntimeException

Definition at line 3745 of file vbarange.cxx.

References ScDocument::GetOriginalWidth(), getScDocument(), lcl_Round2DecPlaces(), and lcl_TwipsToPoints().

Referenced by getWidth().

double ScVbaRange::getCalcRowHeight ( const css::table::CellRangeAddress &  )

private

Exceptions

css::uno::RuntimeException

Definition at line 3755 of file vbarange.cxx.

References getDocumentFromRange(), ScDocument::GetOriginalHeight(), lcl_Round2DecPlaces(), lcl_TwipsToPoints(), and mxRange.

Referenced by getHeight().

uno::Any SAL_CALL ScVbaRange::getCellRange ( )

overridevirtual

Definition at line 2799 of file vbarange.cxx.

References mxRange, and mxRanges.

Referenced by getName().

static css::uno::Any ScVbaRange::getCellRange ( const css::uno::Reference< ov::excel::XRange > &  rxRange )

static

Exceptions

css::uno::RuntimeException

ScCellRangeObj * ScVbaRange::getCellRangeObj ( )

private

Exceptions

css::uno::RuntimeException

Definition at line 234 of file vbarange.cxx.

References getCellRangesBase().

Referenced by Font().

ScCellRangesBase * ScVbaRange::getCellRangesBase ( )

overrideprotectedvirtual

Exceptions

css::uno::RuntimeException

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 225 of file vbarange.cxx.

References mxRange, and mxRanges.

Referenced by Columns(), getCellRangeObj(), getCurrentDataSet(), getEntireColumnOrRow(), getScRangeList(), Offset(), Rows(), and Select().

bool ScVbaRange::getCellRangesForAddress ( ScRefFlags &  rResFlags, const OUString &  sAddress, ScDocShell *  pDocSh, ScRangeList &  rCellRanges, formula::FormulaGrammar::AddressConvention  eConv, char  cDelimiter  )

static

Definition at line 1147 of file vbarange.cxx.

References ScDocShell::GetDocument(), ScRangeList::Parse(), and VALID.

Referenced by ScVbaNames::Add(), ScVbaValidation::getFormula1(), and getScRangeListForAddress().

sal_Int32 ScVbaRange::getColumn ( )

override

Definition at line 1761 of file vbarange.cxx.

References getArea(), m_Areas, and mxRange.

Referenced by Insert().

uno::Any SAL_CALL ScVbaRange::getColumnWidth ( )

overridevirtual

Definition at line 3778 of file vbarange.cxx.

References aNULL(), fExtraWidth, getDefaultCharWidth(), ScDocShell::GetDocument(), ScDocument::GetOriginalWidth(), getScDocShell(), lcl_Round2DecPlaces(), lcl_TwipsToPoints(), m_Areas, and mxRange.

uno::Reference< excel::XComment > SAL_CALL ScVbaRange::getComment ( )

overridevirtual

Definition at line 2967 of file vbarange.cxx.

References getUnoModel(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, and mxRange.

Referenced by AddComment().

sal_Int32 ScVbaRange::getCount ( )

override

Definition at line 1721 of file vbarange.cxx.

References m_Areas, mbIsColumns, mbIsRows, and mxRange.

Referenced by SpecialCellsImpl().

SfxItemSet * ScVbaRange::getCurrentDataSet ( )

protected

Exceptions

css::uno::RuntimeException

Definition at line 239 of file vbarange.cxx.

References getCellRangesBase().

Referenced by getWrapText().

OUString SAL_CALL ScVbaRange::getDefaultMethodName ( )

override

Definition at line 3738 of file vbarange.cxx.

OUString SAL_CALL ScVbaRange::getDefaultPropertyName ( )

inlineoverride

Definition at line 298 of file vbarange.hxx.

virtual css::uno::Type SAL_CALL ScVbaRange::getElementType ( )

inlineoverridevirtual

Definition at line 289 of file vbarange.hxx.

References cppu::UnoType< class >::get().

uno::Reference< excel::XRange > SAL_CALL ScVbaRange::getEntireColumn ( )

overridevirtual

Definition at line 2937 of file vbarange.cxx.

References getEntireColumnOrRow().

uno::Reference< excel::XRange > ScVbaRange::getEntireColumnOrRow ( bool  bColumn )

private

Exceptions

css::uno::RuntimeException

Definition at line 2899 of file vbarange.cxx.

References ScRange::aEnd, ScRange::aStart, ScRangeList::front(), getCellRangesBase(), ScCellRangesBase::GetDocShell(), ScCellRangesBase::GetRangeList(), getScDocument(), i, ScDocument::MaxCol(), ScDocument::MaxRow(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxParent, ScVbaRange(), ScAddress::SetCol(), ScAddress::SetRow(), and ScRangeList::size().

Referenced by getEntireColumn(), and getEntireRow().

uno::Reference< excel::XRange > SAL_CALL ScVbaRange::getEntireRow ( )

overridevirtual

Definition at line 2931 of file vbarange.cxx.

References getEntireColumnOrRow().

uno::Any ScVbaRange::getFormula ( )

overridevirtual

Definition at line 1673 of file vbarange.cxx.

References getFormulaValue(), and formula::FormulaGrammar::GRAM_ENGLISH_XL_A1.

uno::Any ScVbaRange::getFormulaArray ( )

overridevirtual

Definition at line 1962 of file vbarange.cxx.

References getArea(), getLength(), getTypeConverter(), m_Areas, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, and mxRange.

uno::Any ScVbaRange::getFormulaLocal ( )

overridevirtual

Definition at line 1697 of file vbarange.cxx.

References getFormulaValue(), and formula::FormulaGrammar::GRAM_NATIVE_XL_A1.

uno::Any ScVbaRange::getFormulaR1C1 ( )

overridevirtual

Definition at line 1685 of file vbarange.cxx.

References getFormulaValue(), and formula::FormulaGrammar::GRAM_ENGLISH_XL_R1C1.

uno::Any ScVbaRange::getFormulaR1C1Local ( )

overridevirtual

Definition at line 1709 of file vbarange.cxx.

References getFormulaValue(), and formula::FormulaGrammar::GRAM_NATIVE_XL_R1C1.

uno::Any ScVbaRange::getFormulaValue ( formula::FormulaGrammar::Grammar  eGram )

private

Exceptions

css::uno::RuntimeException

Definition at line 1656 of file vbarange.cxx.

References getArea(), getScDocument(), getValue(), and m_Areas.

Referenced by getFormula(), getFormulaLocal(), getFormulaR1C1(), and getFormulaR1C1Local().

uno::Any SAL_CALL ScVbaRange::getHeight ( )

overridevirtual

Definition at line 4072 of file vbarange.cxx.

References getCalcRowHeight(), index, m_Areas, and mxRange.

uno::Any SAL_CALL ScVbaRange::getHidden ( )

overridevirtual

Definition at line 2992 of file vbarange.cxx.

References cppu::getCaughtException(), getRowOrColumnProps(), m_Areas, mbIsRows, and mxRange.

ScVbaRange * ScVbaRange::getImplementation ( const css::uno::Reference< ov::excel::XRange > &  rxRange )

static

Returns the ScVbaRange implementation object for the passed VBA Range object.

Definition at line 438 of file vbarange.cxx.

Referenced by AutoFill(), AutoFilter(), ClearContents(), Copy(), fillSeries(), PrintOut(), and SpecialCells().

uno::Any SAL_CALL ScVbaRange::getLeft ( )

overridevirtual

Definition at line 4105 of file vbarange.cxx.

References getArea(), getPosition(), m_Areas, o3tl::mm100, and o3tl::pt.

uno::Any ScVbaRange::getMergeCells ( )

overridevirtual

Exceptions

css::script::BasicErrorException
css::uno::RuntimeException

Implements ScVbaFormat< Ifc >.

Definition at line 2484 of file vbarange.cxx.

References aNULL(), mxRange, mxRanges, and nIndex.

uno::Reference< excel::XName > ScVbaRange::getName ( )

overridevirtual

Definition at line 4148 of file vbarange.cxx.

References getCellRange(), getNamedRange(), getUnoModel(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, and InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxParent.

uno::Any ScVbaRange::getNumberFormat ( )

overridevirtual

Exceptions

css::script::BasicErrorException
css::uno::RuntimeException

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 2587 of file vbarange.cxx.

References aNULL(), index, m_Areas, and mxRange.

uno::Any SAL_CALL ScVbaRange::getPageBreak ( )

overridevirtual

Definition at line 4005 of file vbarange.cxx.

References getDocShellFromRange(), getDocumentFromRange(), SfxObjectShell::GetModel(), ScDocument::HasColBreak(), ScDocument::HasRowBreak(), Manual, mxRange, NONE, Page, and xModel.

awt::Point ScVbaRange::getPosition ( ) const

private

Exceptions

css::uno::RuntimeException

Definition at line 4093 of file vbarange.cxx.

References mxRange, and mxRanges.

Referenced by getLeft(), and getTop().

uno::Any SAL_CALL ScVbaRange::getPrefixCharacter ( )

overridevirtual

Definition at line 4868 of file vbarange.cxx.

References mxRange, and mxRanges.

css::uno::Reference< excel::XRange > ScVbaRange::getRangeObjectForName ( const css::uno::Reference< css::uno::XComponentContext > &  xContext, const OUString &  sRangeName, ScDocShell *  pDocSh, formula::FormulaGrammar::AddressConvention  eConv  )

static

Exceptions

css::uno::RuntimeException

Definition at line 1363 of file vbarange.cxx.

References getRangeForName().

Referenced by ScVbaName::getRefersToRange(), and ScVbaApplication::GoTo().

sal_Int32 ScVbaRange::getRow ( )

override

Definition at line 1745 of file vbarange.cxx.

References getArea(), m_Areas, and mxRange.

Referenced by Insert().

uno::Any SAL_CALL ScVbaRange::getRowHeight ( )

overridevirtual

Definition at line 3940 of file vbarange.cxx.

References aNULL(), ScDocShell::GetDocument(), ScDocument::GetOriginalHeight(), getScDocShell(), lcl_Round2DecPlaces(), lcl_TwipsToPoints(), m_Areas, and mxRange.

ScDocShell * ScVbaRange::getScDocShell

(

)

Exceptions

css::uno::RuntimeException

Definition at line 427 of file vbarange.cxx.

References getDocShellFromRange(), mxRange, and mxRanges.

Referenced by Activate(), Address(), AutoFilter(), getColumnWidth(), getRowHeight(), getStyle(), getUnoModel(), GoalSeek(), MergeArea(), PasteSpecial(), PreviousNext(), setColumnWidth(), setFormulaArray(), Sort(), SpecialCells(), and SpecialCellsImpl().

ScDocument & ScVbaRange::getScDocument

(

)

Exceptions

css::uno::RuntimeException

Definition at line 415 of file vbarange.cxx.

References getDocumentFromRange(), mxRange, and mxRanges.

Referenced by Cells(), Columns(), Delete(), fireChangeEvent(), Font(), getCalcColWidth(), getEntireColumnOrRow(), getFormulaValue(), Interior(), PreviousNext(), Rows(), setFormulaArray(), setFormulaValue(), ScVbaChart::setSourceData(), and Sort().

const ScRangeList & ScVbaRange::getScRangeList

(

)

Exceptions

css::uno::RuntimeException

Definition at line 458 of file vbarange.cxx.

References getCellRangesBase().

Referenced by Hyperlinks(), and setFormulaArray().

static const ScRangeList& ScVbaRange::getScRangeList ( const css::uno::Reference< ov::excel::XRange > &  rxRange )

static

Exceptions

css::uno::RuntimeException

OUString ScVbaRange::getServiceImplName ( )

overridevirtual

Implements InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >.

Definition at line 5632 of file vbarange.cxx.

uno::Sequence< OUString > ScVbaRange::getServiceNames ( )

overridevirtual

Implements InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >.

Definition at line 5638 of file vbarange.cxx.

uno::Any ScVbaRange::getShowDetail ( )

overridevirtual

Definition at line 4893 of file vbarange.cxx.

References aNULL(), ScOutlineTable::GetColArray(), getDocumentFromRange(), ScOutlineArray::GetEntryByPos(), ScDocument::GetOutlineTable(), ScOutlineTable::GetRowArray(), ScOutlineEntry::IsHidden(), m_Areas, mxRange, and nPos.

uno::Any SAL_CALL ScVbaRange::getStyle ( )

overridevirtual

Definition at line 5309 of file vbarange.cxx.

References SfxObjectShell::GetModel(), getScDocShell(), m_Areas, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, mxRange, and xModel.

OUString ScVbaRange::getText ( )

overridevirtual

Definition at line 1869 of file vbarange.cxx.

References getArea(), m_Areas, and mxRange.

uno::Any SAL_CALL ScVbaRange::getTop ( )

overridevirtual

Definition at line 4115 of file vbarange.cxx.

References getArea(), getPosition(), m_Areas, o3tl::mm100, and o3tl::pt.

uno::Reference< frame::XModel > ScVbaRange::getUnoModel

(

)

Exceptions

css::uno::RuntimeException

Definition at line 444 of file vbarange.cxx.

References getScDocShell().

Referenced by AddComment(), Copy(), getComment(), getName(), and setFormulaArray().

static css::uno::Reference< css::frame::XModel > ScVbaRange::getUnoModel ( const css::uno::Reference< ov::excel::XRange > &  rxRange )

static

Exceptions

css::uno::RuntimeException

css::uno::Reference< excel::XValidation > SAL_CALL ScVbaRange::getValidation ( )

overridevirtual

Definition at line 4792 of file vbarange.cxx.

References m_xValidation, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, and mxRange.

uno::Any ScVbaRange::getValue ( ValueGetter &  rValueGetter )

private

Exceptions

css::uno::RuntimeException

Definition at line 1494 of file vbarange.cxx.

References ValueGetter::getValue(), isSingleCellRange(), mxRange, and visitArray().

uno::Any SAL_CALL ScVbaRange::getValue ( )

overridevirtual

Definition at line 1512 of file vbarange.cxx.

References getArea(), and m_Areas.

Referenced by getFormulaValue().

uno::Any SAL_CALL ScVbaRange::getWidth ( )

overridevirtual

Definition at line 3847 of file vbarange.cxx.

References getCalcColWidth(), index, m_Areas, and mxRange.

uno::Reference< excel::XWorksheet > ScVbaRange::getWorksheet ( )

overridevirtual

Definition at line 4175 of file vbarange.cxx.

References getDocShellFromRange(), SfxObjectShell::GetModel(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::getParent(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, mxRange, and mxRanges.

Referenced by Calculate(), and SpecialCells().

uno::Any ScVbaRange::getWrapText ( )

overridevirtual

Exceptions

css::script::BasicErrorException
css::uno::RuntimeException

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 2659 of file vbarange.cxx.

References aNULL(), ATTR_LINEBREAK(), getCurrentDataSet(), SfxItemSet::GetItemState(), index, m_Areas, and mxRange.

sal_Bool SAL_CALL ScVbaRange::GoalSeek ( const css::uno::Any &  Goal, const css::uno::Reference< ov::excel::XRange > &  ChangingCell  )

overridevirtual

Definition at line 5136 of file vbarange.cxx.

References getAnyAsString(), SfxObjectShell::GetModel(), getScDocShell(), and mxRange.

void SAL_CALL ScVbaRange::Group ( )

overridevirtual

Definition at line 5248 of file vbarange.cxx.

References groupUnGroup().

void ScVbaRange::groupUnGroup ( bool  bUnGroup )

private

Exceptions

css::uno::RuntimeException

Definition at line 5231 of file vbarange.cxx.

References ERRCODE_BASIC_METHOD_FAILED, m_Areas, mbIsColumns, mxRange, and STR_ERRORMESSAGE_APPLIESTOSINGLERANGEONLY().

Referenced by Group(), and Ungroup().

sal_Bool SAL_CALL ScVbaRange::hasElements ( )

overridevirtual

Definition at line 3708 of file vbarange.cxx.

References mxRange.

sal_Bool SAL_CALL ScVbaRange::hasError ( )

overridevirtual

Definition at line 5644 of file vbarange.cxx.

References InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::Application().

uno::Any ScVbaRange::HasFormula ( )

overridevirtual

Definition at line 1777 of file vbarange.cxx.

References ScRange::aEnd, aNULL(), ScRange::aStart, ScRangeList::front(), ScCellRangesBase::GetRangeList(), index, m_Areas, mxRange, and ScCellRangesBase::queryFormulaCells().

uno::Any SAL_CALL ScVbaRange::Hyperlinks ( const css::uno::Any &  aIndex )

overridevirtual

Definition at line 4771 of file vbarange.cxx.

References InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::getParent(), getScRangeList(), uno::Any::hasValue(), and InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext.

void SAL_CALL ScVbaRange::Insert ( const css::uno::Any &  Shift, const css::uno::Any &  CopyOrigin  )

overridevirtual

Definition at line 4682 of file vbarange.cxx.

References ScDocShell::GetClipData(), getColumn(), getDocShellFromRange(), ScTransferObj::GetOwnClipboard(), getRow(), ScTransferObj::GetUseInApi(), uno::Any::hasValue(), mbIsColumns, mbIsRows, mode, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxParent, mxRange, and ScVbaRange().

uno::Reference< excel::XInterior > ScVbaRange::Interior ( )

overridevirtual

Exceptions

css::script::BasicErrorException
css::uno::RuntimeException

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 2687 of file vbarange.cxx.

References getScDocument(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, and mxRange.

bool ScVbaRange::isSingleCellRange

(

)

const

Definition at line 3635 of file vbarange.cxx.

References mxRange.

Referenced by Activate(), AutoFilter(), AutoOutline(), characters(), getValue(), and SpecialCells().

uno::Reference< excel::XRange > SAL_CALL ScVbaRange::Item ( const css::uno::Any &  row, const css::uno::Any &  column  )

overridevirtual

Definition at line 5172 of file vbarange.cxx.

References Cells(), Columns(), ERRCODE_BASIC_BAD_PARAMETER, uno::Any::hasValue(), mbIsColumns, mbIsRows, and Rows().

void SAL_CALL ScVbaRange::Merge ( const css::uno::Any &  Across )

overridevirtual

Definition at line 5265 of file vbarange.cxx.

References i, index, lcl_mergeCellsOfRange(), m_Areas, mxRange, and Rows().

uno::Reference< excel::XRange > SAL_CALL ScVbaRange::MergeArea ( )

overridevirtual

Definition at line 4965 of file vbarange.cxx.

References getScDocShell(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxParent, mxRange, and ScVbaRange().

uno::Reference< excel::XRange > SAL_CALL ScVbaRange::Next ( void  )

overridevirtual

Definition at line 5370 of file vbarange.cxx.

References m_Areas, and PreviousNext().

uno::Reference< excel::XRange > ScVbaRange::Offset ( const css::uno::Any &  nRowOffset, const css::uno::Any &  nColOffset  )

overridevirtual

Definition at line 1885 of file vbarange.cxx.

References ScRange::aEnd, ScRange::aStart, ScAddress::Col(), ScRangeList::front(), getCellRangesBase(), ScCellRangesBase::GetDocShell(), ScCellRangesBase::GetRangeList(), i, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxParent, ScAddress::Row(), ScVbaRange(), ScAddress::SetCol(), ScAddress::SetRow(), and ScRangeList::size().

void SAL_CALL ScVbaRange::PasteSpecial ( const css::uno::Any &  Paste, const css::uno::Any &  Operation, const css::uno::Any &  SkipBlanks, const css::uno::Any &  Transpose  )

overridevirtual

Definition at line 2865 of file vbarange.cxx.

References SfxObjectShell::GetModel(), getPasteFlags(), getPasteFormulaBits(), getScDocShell(), uno::Any::hasValue(), ooo::vba::excel::implnPasteSpecial(), m_Areas, mxRange, and xModel.

uno::Reference< excel::XRange > SAL_CALL ScVbaRange::Previous ( )

overridevirtual

Definition at line 5381 of file vbarange.cxx.

References m_Areas, and PreviousNext().

uno::Reference< excel::XRange > ScVbaRange::PreviousNext ( bool  bIsPrevious )

private

Definition at line 5341 of file vbarange.cxx.

References ScRange::aEnd, ScRange::aStart, ScAddress::Col(), ScUnoConversion::FillScRange(), ScDocument::GetNextPos(), getScDocShell(), getScDocument(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxParent, mxRange, ScAddress::Row(), ScVbaRange(), ScAddress::SetCol(), ScAddress::SetRow(), ScAddress::SetTab(), and ScAddress::Tab().

Referenced by Next(), and Previous().

void SAL_CALL ScVbaRange::PrintOut ( const css::uno::Any &  From, const css::uno::Any &  To, const css::uno::Any &  Copies, const css::uno::Any &  Preview, const css::uno::Any &  ActivePrinter, const css::uno::Any &  PrintToFile, const css::uno::Any &  Collate, const css::uno::Any &  PrToFileName  )

overridevirtual

Definition at line 4991 of file vbarange.cxx.

References ooo::vba::excel::getBestViewShell(), getDocShellFromRange(), getImplementation(), SfxObjectShell::GetModel(), index, m_Areas, mxRange, PrintOutHelper(), and xModel.

virtual css::uno::Reference< ov::excel::XRange > SAL_CALL ScVbaRange::Range ( const css::uno::Any &  Cell1, const css::uno::Any &  Cell2  )

overridevirtual

css::uno::Reference< ov::excel::XRange > ScVbaRange::Range	(	const css::uno::Any &	Cell1,
		const css::uno::Any &	Cell2,
		bool	bForceUseInpuRangeTab
	)

Exceptions

css::uno::RuntimeException

void SAL_CALL ScVbaRange::RemoveSubtotal ( )

overridevirtual

Definition at line 5554 of file vbarange.cxx.

References mxRange.

sal_Bool SAL_CALL ScVbaRange::Replace ( const OUString &  What, const OUString &  Replacement, const css::uno::Any &  LookAt, const css::uno::Any &  SearchOrder, const css::uno::Any &  MatchCase, const css::uno::Any &  MatchByte, const css::uno::Any &  SearchFormat, const css::uno::Any &  ReplaceFormat  )

overridevirtual

Definition at line 3046 of file vbarange.cxx.

References fireChangeEvent(), ScGlobal::GetSearchItem(), uno::Any::hasValue(), i, index, m_Areas, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxParent, mxRange, SC_UNO_SRCHBYROW, SC_UNO_SRCHCASE, SC_UNO_SRCHREGEXP, SC_UNO_SRCHWORDS, ScVbaRange(), SvxSearchItem::SetRowDirection(), ScGlobal::SetSearchItem(), SvxSearchItem::SetWordOnly(), and VBAToRegexp().

uno::Reference< excel::XRange > ScVbaRange::Resize ( const css::uno::Any &  RowSize, const css::uno::Any &  ColumnSize  )

overridevirtual

Definition at line 2616 of file vbarange.cxx.

References InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxParent, mxRange, and ScVbaRange().

uno::Reference< excel::XRange > ScVbaRange::Rows ( const css::uno::Any &  nIndex )

overridevirtual

Definition at line 2368 of file vbarange.cxx.

References ScRange::aEnd, ScRange::aStart, formula::FormulaGrammar::CONV_XL_A1, ScRangeList::front(), getCellRangesBase(), ScCellRangesBase::GetDocShell(), ScCellRangesBase::GetRangeList(), getScDocument(), uno::Any::hasValue(), m_Areas, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxParent, mxRange, mxRanges, nValue, ScRange::ParseRows(), ScAddress::Row(), ScVbaRange(), and ScAddress::SetRow().

Referenced by Item(), and Merge().

void ScVbaRange::Select ( )

overridevirtual

Definition at line 2260 of file vbarange.cxx.

References getCellRangesBase(), ScCellRangesBase::GetDocShell(), SfxObjectShell::GetModel(), mxRange, mxRanges, xController, xFrame, and xModel.

Referenced by Activate(), and Cut().

void SAL_CALL ScVbaRange::setColumnWidth ( const css::uno::Any &  _columnwidth )

overridevirtual

Definition at line 3815 of file vbarange.cxx.

References fExtraWidth, getDefaultCharWidth(), ScDocShell::GetDocFunc(), getScDocShell(), index, lcl_pointsToTwips(), lcl_Round2DecPlaces(), m_Areas, mxRange, SC_SIZE_DIRECT, and ScDocFunc::SetWidthOrHeight().

void ScVbaRange::setFormula ( const css::uno::Any &  rFormula )

overridevirtual

Definition at line 1679 of file vbarange.cxx.

References formula::FormulaGrammar::GRAM_ENGLISH_XL_A1, and setFormulaValue().

void ScVbaRange::setFormulaArray ( const css::uno::Any &  rFormula )

overridevirtual

Definition at line 2000 of file vbarange.cxx.

References ScTokenConversion::ConvertToTokenArray(), EMPTY_OUSTRING, ScDocFunc::EnterMatrix(), getArea(), ScDocShell::GetDocFunc(), getScDocShell(), getScDocument(), getScRangeList(), getUnoModel(), formula::FormulaGrammar::GRAM_API, m_Areas, mxRange, and void().

void ScVbaRange::setFormulaLocal ( const css::uno::Any &  rFormula )

overridevirtual

Definition at line 1703 of file vbarange.cxx.

References formula::FormulaGrammar::GRAM_NATIVE_XL_A1, and setFormulaValue().

void ScVbaRange::setFormulaR1C1 ( const css::uno::Any &  rFormula )

overridevirtual

Definition at line 1691 of file vbarange.cxx.

References formula::FormulaGrammar::GRAM_ENGLISH_XL_R1C1, and setFormulaValue().

void ScVbaRange::setFormulaR1C1Local ( const css::uno::Any &  rFormula )

overridevirtual

Definition at line 1715 of file vbarange.cxx.

References formula::FormulaGrammar::GRAM_NATIVE_XL_R1C1, and setFormulaValue().

void ScVbaRange::setFormulaValue ( const css::uno::Any &  aValue, formula::FormulaGrammar::Grammar    )

private

Exceptions

css::uno::RuntimeException

Definition at line 1641 of file vbarange.cxx.

References getScDocument(), m_Areas, and setValue().

Referenced by setFormula(), setFormulaLocal(), setFormulaR1C1(), and setFormulaR1C1Local().

void SAL_CALL ScVbaRange::setHidden ( const css::uno::Any &  _hidden )

overridevirtual

Definition at line 3018 of file vbarange.cxx.

References extractBoolFromAny(), cppu::getCaughtException(), getRowOrColumnProps(), index, m_Areas, mbIsRows, and mxRange.

void ScVbaRange::setMergeCells ( const css::uno::Any &  MergeCells )

overridevirtual

Exceptions

css::script::BasicErrorException
css::uno::RuntimeException

Implements ScVbaFormat< Ifc >.

Definition at line 2449 of file vbarange.cxx.

References extractBoolFromAny(), ScUnoConversion::Intersects(), mxRange, mxRanges, and nIndex.

void ScVbaRange::setNumberFormat ( const css::uno::Any &  NumberFormat )

overridevirtual

Exceptions

css::script::BasicErrorException
css::uno::RuntimeException

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 2568 of file vbarange.cxx.

References index, m_Areas, and mxRange.

void SAL_CALL ScVbaRange::setPageBreak ( const css::uno::Any &  _pagebreak )

overridevirtual

Definition at line 4041 of file vbarange.cxx.

References ScViewFunc::DeletePageBreak(), ooo::vba::excel::getBestViewShell(), getDocShellFromRange(), SfxObjectShell::GetModel(), ScViewFunc::InsertPageBreak(), mxRange, and xModel.

void SAL_CALL ScVbaRange::setRowHeight ( const css::uno::Any &  _rowheight )

overridevirtual

Definition at line 3979 of file vbarange.cxx.

References ScDocShell::GetDocFunc(), getDocShellFromRange(), index, lcl_pointsToTwips(), lcl_Round2DecPlaces(), m_Areas, mxRange, SC_SIZE_ORIGINAL, and ScDocFunc::SetWidthOrHeight().

void ScVbaRange::setShowDetail ( const css::uno::Any &  aShowDetail )

overridevirtual

Definition at line 4930 of file vbarange.cxx.

References extractBoolFromAny(), m_Areas, and mxRange.

void SAL_CALL ScVbaRange::setStyle ( const css::uno::Any &  _style )

overridevirtual

Definition at line 5325 of file vbarange.cxx.

References m_Areas, and mxRange.

void ScVbaRange::setValue ( const css::uno::Any &  aValue, ValueSetter &  setter  )

private

Exceptions

css::uno::RuntimeException

Referenced by setFormulaValue().

virtual void SAL_CALL ScVbaRange::setValue ( const css::uno::Any &  aValue )

overridevirtual

void ScVbaRange::setWrapText ( const css::uno::Any &  WrapText )

overridevirtual

Exceptions

css::script::BasicErrorException
css::uno::RuntimeException

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 2640 of file vbarange.cxx.

References extractBoolFromAny(), index, m_Areas, and mxRange.

void SAL_CALL ScVbaRange::Sort ( const css::uno::Any &  Key1, const css::uno::Any &  Order1, const css::uno::Any &  Key2, const css::uno::Any &  Type, const css::uno::Any &  Order2, const css::uno::Any &  Key3, const css::uno::Any &  Order3, const css::uno::Any &  Header, const css::uno::Any &  OrderCustom, const css::uno::Any &  MatchCase, const css::uno::Any &  Orientation, const css::uno::Any &  SortMethod, const css::uno::Any &  DataOption1, const css::uno::Any &  DataOption2, const css::uno::Any &  DataOption3  )

overridevirtual

Definition at line 3381 of file vbarange.cxx.

References ScSortParam::bByRow, ScSortParam::bCaseSens, findSortPropertyIndex(), getScDocShell(), getScDocument(), ScDocument::GetSortParam(), ScDocument::HasColHeader(), ScDocument::HasRowHeader(), uno::Any::hasValue(), m_Areas, ScSortParam::maKeyState, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, mxRange, ScSortParam::nCompatHeader, nIndex, ScSortParam::nUserIndex, processKey(), ScDocument::SetSortParam(), updateTableSortField(), and void().

uno::Reference< excel::XRange > SAL_CALL ScVbaRange::SpecialCells ( const css::uno::Any &  _oType, const css::uno::Any &  _oValue  )

overridevirtual

Definition at line 5392 of file vbarange.cxx.

References ERRCODE_BASIC_BAD_PARAMETER, ERRCODE_BASIC_METHOD_FAILED, ERRCODE_BASIC_NOT_IMPLEMENTED, ScUnoConversion::FillScRange(), ScRangeList::front(), getImplementation(), getScDocShell(), getWorksheet(), index, isSingleCellRange(), m_Areas, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxParent, ScRangeList::push_back(), ScVbaRange(), ScRangeList::size(), and SpecialCellsImpl().

uno::Reference< excel::XRange > ScVbaRange::SpecialCellsImpl ( sal_Int32  nType, const css::uno::Any &  _oValue  )

private

Exceptions

css::script::BasicErrorException

Definition at line 5499 of file vbarange.cxx.

References Cells(), ERRCODE_BASIC_BAD_PARAMETER, ERRCODE_BASIC_METHOD_FAILED, ERRCODE_BASIC_NOT_IMPLEMENTED, getCount(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::getParent(), getScDocShell(), lcl_getFormulaResultFlags(), lcl_makeXRangeFromSheetCellRanges(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc...... > >::mxContext, mxRange, and u.

Referenced by SpecialCells().

void SAL_CALL ScVbaRange::Subtotal ( ::sal_Int32  GroupBy, ::sal_Int32  Function, const css::uno::Sequence< ::sal_Int32 > &  TotalList, const css::uno::Any &  Replace, const css::uno::Any &  PageBreaks, const css::uno::Any &  SummaryBelowData  )

overridevirtual

Definition at line 5561 of file vbarange.cxx.

References ERRCODE_BASIC_BAD_PARAMETER, ERRCODE_BASIC_METHOD_FAILED, i, and mxRange.

virtual css::uno::Reference< ov::XHelperInterface > ScVbaRange::thisHelperIface ( )

inlineoverridevirtual

Implements ScVbaFormat< Ifc >.

Definition at line 155 of file vbarange.hxx.

void SAL_CALL ScVbaRange::Ungroup ( )

overridevirtual

Definition at line 5253 of file vbarange.cxx.

References groupUnGroup().

void SAL_CALL ScVbaRange::UnMerge ( )

overridevirtual

Definition at line 5293 of file vbarange.cxx.

References index, lcl_mergeCellsOfRange(), m_Areas, and mxRange.

void ScVbaRange::visitArray ( ArrayVisitor &  visitor )

private

Definition at line 1477 of file vbarange.cxx.

References i, mxRange, and ArrayVisitor::visitNode().

Referenced by getValue().

Member Data Documentation

css::uno::Reference< ov::XCollection > ScVbaRange::m_Areas

private

Definition at line 74 of file vbarange.hxx.

Referenced by Address(), Areas(), AutoFilter(), Autofit(), AutoOutline(), Cells(), Characters(), ClearContents(), ClearOutline(), Copy(), createEnumeration(), CurrentArray(), CurrentRegion(), Cut(), Delete(), End(), fillSeries(), getArea(), getBorders(), getColumn(), getColumnWidth(), getCount(), getFormulaArray(), getFormulaValue(), getHeight(), getHidden(), getLeft(), getNumberFormat(), getRow(), getRowHeight(), getShowDetail(), getStyle(), getText(), getTop(), getValue(), getWidth(), getWrapText(), groupUnGroup(), HasFormula(), Merge(), Next(), PasteSpecial(), Previous(), PrintOut(), Replace(), Rows(), setColumnWidth(), setFormulaArray(), setFormulaValue(), setHidden(), setNumberFormat(), setRowHeight(), setShowDetail(), setStyle(), setWrapText(), Sort(), SpecialCells(), and UnMerge().

css::uno::Reference< ov::XCollection > ScVbaRange::m_Borders

private

Definition at line 75 of file vbarange.hxx.

Referenced by BorderAround(), and getBorders().

css::uno::Reference< ov::excel::XValidation > ScVbaRange::m_xValidation

private

Definition at line 80 of file vbarange.hxx.

Referenced by getValidation().

bool ScVbaRange::mbIsColumns

private

Definition at line 79 of file vbarange.hxx.

Referenced by Autofit(), createEnumeration(), getCount(), groupUnGroup(), Insert(), and Item().

bool ScVbaRange::mbIsRows

private

Definition at line 78 of file vbarange.hxx.

Referenced by Autofit(), AutoOutline(), createEnumeration(), Delete(), getCount(), getHidden(), Insert(), Item(), and setHidden().

css::uno::Reference< css::table::XCellRange > ScVbaRange::mxRange

private

Definition at line 76 of file vbarange.hxx.

Referenced by Activate(), AddComment(), Address(), AutoFill(), AutoFilter(), Autofit(), AutoOutline(), Cells(), Characters(), characters(), ClearContents(), ClearOutline(), Copy(), createEnumeration(), CurrentArray(), CurrentRegion(), Cut(), Delete(), End(), fillSeries(), Find(), Font(), getCalcRowHeight(), getCellRange(), getCellRangesBase(), getColumn(), getColumnWidth(), getComment(), getCount(), getFormulaArray(), getHeight(), getHidden(), getMergeCells(), getNumberFormat(), getPageBreak(), getPosition(), getPrefixCharacter(), getRow(), getRowHeight(), getScDocShell(), getScDocument(), getShowDetail(), getStyle(), getText(), getValidation(), getValue(), getWidth(), getWorksheet(), getWrapText(), GoalSeek(), groupUnGroup(), hasElements(), HasFormula(), Insert(), Interior(), isSingleCellRange(), Merge(), MergeArea(), PasteSpecial(), PreviousNext(), PrintOut(), RemoveSubtotal(), Replace(), Resize(), Rows(), Select(), setColumnWidth(), setFormulaArray(), setHidden(), setMergeCells(), setNumberFormat(), setPageBreak(), setRowHeight(), setShowDetail(), setStyle(), setWrapText(), Sort(), SpecialCellsImpl(), Subtotal(), UnMerge(), and visitArray().

css::uno::Reference< css::sheet::XSheetCellRangeContainer > ScVbaRange::mxRanges

private

Definition at line 77 of file vbarange.hxx.

Referenced by Activate(), Font(), getCellRange(), getCellRangesBase(), getMergeCells(), getPosition(), getPrefixCharacter(), getScDocShell(), getScDocument(), getWorksheet(), Rows(), Select(), and setMergeCells().

---

The documentation for this class was generated from the following files:

• vbarange.hxx
• vbarange.cxx