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, std::u16string_view 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 1464 of file vbarange.cxx.

Member Function Documentation

void ScVbaRange::Activate ( )

overridevirtual

Definition at line 2317 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 2954 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 2071 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 4212 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 3880 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 5040 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 4422 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 4751 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 5207 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 3905 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 3897 of file vbarange.cxx.

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

void ScVbaRange::Calculate ( )

override

Definition at line 5184 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 2168 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 2187 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 2045 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 3659 of file vbarange.cxx.

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

void SAL_CALL ScVbaRange::Clear ( )

overridevirtual

Definition at line 1591 of file vbarange.cxx.

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

void SAL_CALL ScVbaRange::ClearComments ( )

overridevirtual

Definition at line 1627 of file vbarange.cxx.

References ClearContents().

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

private

Exceptions

css::uno::RuntimeException

Definition at line 1600 of file vbarange.cxx.

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

void SAL_CALL ScVbaRange::ClearContents ( )

overridevirtual

Definition at line 1633 of file vbarange.cxx.

References DATETIME, STRING, and VALUE.

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

void SAL_CALL ScVbaRange::ClearFormats ( )

overridevirtual

Definition at line 1641 of file vbarange.cxx.

References ClearContents(), EDITATTR, and HARDATTR.

void SAL_CALL ScVbaRange::ClearOutline ( )

overridevirtual

Definition at line 5231 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 2419 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 2522 of file vbarange.cxx.

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

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

overridevirtual

Definition at line 3732 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 1951 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 1930 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 2552 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 3671 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 3568 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 1871 of file vbarange.cxx.

References fillSeries().

void ScVbaRange::FillLeft ( )

overridevirtual

Definition at line 1850 of file vbarange.cxx.

References fillSeries().

void ScVbaRange::FillRight ( )

overridevirtual

Definition at line 1857 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 1828 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 1864 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 3158 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 249 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 2146 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 3888 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 1468 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 3757 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 3767 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 2809 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 236 of file vbarange.cxx.

References getCellRangesBase().

Referenced by Font().

ScCellRangesBase * ScVbaRange::getCellRangesBase ( )

overrideprotectedvirtual

Exceptions

css::uno::RuntimeException

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 227 of file vbarange.cxx.

References mxRange, and mxRanges.

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

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

static

Definition at line 1149 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 1770 of file vbarange.cxx.

References getArea(), m_Areas, and mxRange.

Referenced by Insert().

uno::Any SAL_CALL ScVbaRange::getColumnWidth ( )

overridevirtual

Definition at line 3790 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 2978 of file vbarange.cxx.

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

Referenced by AddComment().

sal_Int32 ScVbaRange::getCount ( )

override

Definition at line 1730 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 241 of file vbarange.cxx.

References getCellRangesBase().

Referenced by getWrapText().

OUString SAL_CALL ScVbaRange::getDefaultMethodName ( )

override

Definition at line 3750 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 2948 of file vbarange.cxx.

References getEntireColumnOrRow().

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

private

Exceptions

css::uno::RuntimeException

Definition at line 2910 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 2942 of file vbarange.cxx.

References getEntireColumnOrRow().

uno::Any ScVbaRange::getFormula ( )

overridevirtual

Definition at line 1682 of file vbarange.cxx.

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

uno::Any ScVbaRange::getFormulaArray ( )

overridevirtual

Definition at line 1971 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 1706 of file vbarange.cxx.

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

uno::Any ScVbaRange::getFormulaR1C1 ( )

overridevirtual

Definition at line 1694 of file vbarange.cxx.

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

uno::Any ScVbaRange::getFormulaR1C1Local ( )

overridevirtual

Definition at line 1718 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 1665 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 4084 of file vbarange.cxx.

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

uno::Any SAL_CALL ScVbaRange::getHidden ( )

overridevirtual

Definition at line 3003 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 439 of file vbarange.cxx.

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

uno::Any SAL_CALL ScVbaRange::getLeft ( )

overridevirtual

Definition at line 4117 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 2493 of file vbarange.cxx.

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

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

overridevirtual

Definition at line 4160 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 2597 of file vbarange.cxx.

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

uno::Any SAL_CALL ScVbaRange::getPageBreak ( )

overridevirtual

Definition at line 4017 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 4105 of file vbarange.cxx.

References mxRange, and mxRanges.

Referenced by getLeft(), and getTop().

uno::Any SAL_CALL ScVbaRange::getPrefixCharacter ( )

overridevirtual

Definition at line 4885 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 1365 of file vbarange.cxx.

References getRangeForName().

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

sal_Int32 ScVbaRange::getRow ( )

override

Definition at line 1754 of file vbarange.cxx.

References getArea(), m_Areas, and mxRange.

Referenced by Insert().

uno::Any SAL_CALL ScVbaRange::getRowHeight ( )

overridevirtual

Definition at line 3952 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 428 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 416 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 459 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 5651 of file vbarange.cxx.

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

overridevirtual

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

Definition at line 5657 of file vbarange.cxx.

uno::Any ScVbaRange::getShowDetail ( )

overridevirtual

Definition at line 4910 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 5327 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 1878 of file vbarange.cxx.

References getArea(), m_Areas, and mxRange.

uno::Any SAL_CALL ScVbaRange::getTop ( )

overridevirtual

Definition at line 4127 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 445 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 4809 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 1503 of file vbarange.cxx.

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

uno::Any SAL_CALL ScVbaRange::getValue ( )

overridevirtual

Definition at line 1521 of file vbarange.cxx.

References getArea(), and m_Areas.

Referenced by getFormulaValue().

uno::Any SAL_CALL ScVbaRange::getWidth ( )

overridevirtual

Definition at line 3859 of file vbarange.cxx.

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

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

overridevirtual

Definition at line 4187 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 2669 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 5154 of file vbarange.cxx.

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

void SAL_CALL ScVbaRange::Group ( )

overridevirtual

Definition at line 5266 of file vbarange.cxx.

References groupUnGroup().

void ScVbaRange::groupUnGroup ( bool  bUnGroup )

private

Exceptions

css::uno::RuntimeException

Definition at line 5249 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 3720 of file vbarange.cxx.

References mxRange.

sal_Bool SAL_CALL ScVbaRange::hasError ( )

overridevirtual

Definition at line 5663 of file vbarange.cxx.

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

uno::Any ScVbaRange::HasFormula ( )

overridevirtual

Definition at line 1786 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 4788 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 4699 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 2697 of file vbarange.cxx.

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

bool ScVbaRange::isSingleCellRange

(

)

const

Definition at line 3647 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 5190 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 5283 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 4982 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 5388 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 1894 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 2875 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 5399 of file vbarange.cxx.

References m_Areas, and PreviousNext().

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

private

Definition at line 5359 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 5008 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 5572 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 3057 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 2626 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 2377 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 2269 of file vbarange.cxx.

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

Referenced by Activate(), Copy(), and Cut().

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

overridevirtual

Definition at line 3827 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 1688 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 2009 of file vbarange.cxx.

References ScTokenConversion::ConvertToTokenArray(), 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 1712 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 1700 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 1724 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 1650 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 3029 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 2458 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 2578 of file vbarange.cxx.

References index, m_Areas, and mxRange.

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

overridevirtual

Definition at line 4053 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 3991 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 4947 of file vbarange.cxx.

References extractBoolFromAny(), m_Areas, and mxRange.

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

overridevirtual

Definition at line 5343 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 2650 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 3392 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 5410 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 5517 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 5579 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 5271 of file vbarange.cxx.

References groupUnGroup().

void SAL_CALL ScVbaRange::UnMerge ( )

overridevirtual

Definition at line 5311 of file vbarange.cxx.

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

void ScVbaRange::visitArray ( ArrayVisitor &  visitor )

private

Definition at line 1479 of file vbarange.cxx.

References i, ScDocShell::LockPaint(), mxRange, ScDocShell::UnlockPaint(), 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