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 css::uno::Any SAL_CALL	getValue2 () override
virtual void SAL_CALL	setValue (const css::uno::Any &aValue) override
virtual void SAL_CALL	setValue2 (const css::uno::Any &aValue2) 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 void SAL_CALL	ExportAsFixedFormat (const css::uno::Any &Type, const css::uno::Any &FileName, const css::uno::Any &Quality, const css::uno::Any &IncludeDocProperties, const css::uno::Any &IgnorePrintAreas, const css::uno::Any &From, const css::uno::Any &To, const css::uno::Any &OpenAfterPublish, const css::uno::Any &FixedFormatExtClassPtr) 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
virtual void SAL_CALL	setNumberFormat (const css::uno::Any &NumberFormat)
Public Member Functions inherited from ScVbaFormat< Ifc >
	ScVbaFormat (const css::uno::Reference< ov::XHelperInterface > &xParent, const css::uno::Reference< css::uno::XComponentContext > &xContext, css::uno::Reference< css::beans::XPropertySet > _xPropertySet, css::uno::Reference< css::frame::XModel > xModel, bool bCheckAmbiguoity)
virtual css::uno::Reference< ov::XHelperInterface >	thisHelperIface ()=0
void SAL_CALL	setAddIndent (const css::uno::Any &BAddIndent)
css::uno::Any SAL_CALL	getAddIndent ()
virtual css::uno::Any SAL_CALL	Borders (const css::uno::Any &Index)
virtual css::uno::Reference< ::ooo::vba::excel::XFont > SAL_CALL	Font ()
virtual css::uno::Reference< ::ooo::vba::excel::XInterior > SAL_CALL	Interior ()
virtual void SAL_CALL	setNumberFormat (const css::uno::Any &NumberFormat)
virtual css::uno::Any SAL_CALL	getNumberFormat ()
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	setWrapText (const css::uno::Any &WrapText)
virtual css::uno::Any SAL_CALL	getWrapText ()
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	setMergeCells (const css::uno::Any &MergeCells)=0
virtual css::uno::Any SAL_CALL	getMergeCells ()=0
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, css::uno::Reference< css::uno::XComponentContext > xContext)
virtual OUString	getServiceImplName ()=0
virtual css::uno::Sequence< OUString >	getServiceNames ()=0
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 ()
virtual ScCellRangesBase *	getCellRangesBase ()

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)
css::uno::Any	DoGetValue (RangeValueType eValueType)
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...
ScRange	obtainRangeEvenIfRangeListIsEmpty (const ScRangeList &rCellRanges) const

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 74 of file vbarange.hxx.

Constructor & Destructor Documentation

ScVbaRange() [1/3]

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() [2/3]

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() [3/3]

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::~ScVbaRange ( )

overridevirtual

Definition at line 1475 of file vbarange.cxx.

Member Function Documentation

Activate()

void ScVbaRange::Activate ( )

overridevirtual

Definition at line 2348 of file vbarange.cxx.

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

AddComment()

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

overridevirtual

Definition at line 2993 of file vbarange.cxx.

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

Address()

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 2102 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.

ApplicationRange()

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 4266 of file vbarange.cxx.

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

Referenced by ScVbaApplication::Range().

Areas()

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

overridevirtual

Definition at line 3934 of file vbarange.cxx.

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

AutoFill()

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

overridevirtual

Definition at line 5094 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(), MAXDOUBLE, mxRange, nCount, ScAddress::Row(), ScAddress::SetCol(), and ScAddress::SetRow().

AutoFilter()

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 4476 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, Operator, STR_ERRORMESSAGE_APPLIESTOSINGLERANGEONLY(), and xConverter.

Autofit()

void SAL_CALL ScVbaRange::Autofit ( )

overridevirtual

Definition at line 4805 of file vbarange.cxx.

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

AutoOutline()

void ScVbaRange::AutoOutline ( )

overridevirtual

Definition at line 5260 of file vbarange.cxx.

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

BorderAround()

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 3959 of file vbarange.cxx.

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

Borders()

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

overridevirtual

Exceptions

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

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 3951 of file vbarange.cxx.

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

Calculate()

void ScVbaRange::Calculate ( )

override

Definition at line 5237 of file vbarange.cxx.

References getWorksheet().

Cells()

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

overridevirtual

Definition at line 2199 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().

CellsHelper()

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 2218 of file vbarange.cxx.

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

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

Characters()

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

overridevirtual

Definition at line 2076 of file vbarange.cxx.

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

characters()

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

overridevirtual

Definition at line 3713 of file vbarange.cxx.

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

Clear()

void SAL_CALL ScVbaRange::Clear ( )

overridevirtual

Definition at line 1620 of file vbarange.cxx.

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

ClearComments()

void SAL_CALL ScVbaRange::ClearComments ( )

overridevirtual

Definition at line 1656 of file vbarange.cxx.

References ClearContents().

ClearContents() [1/2]

void SAL_CALL ScVbaRange::ClearContents ( )

overridevirtual

Definition at line 1662 of file vbarange.cxx.

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

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

ClearContents() [2/2]

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

private

Exceptions

css::uno::RuntimeException

Definition at line 1629 of file vbarange.cxx.

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

Referenced by ClearContents().

ClearFormats()

void SAL_CALL ScVbaRange::ClearFormats ( )

overridevirtual

Definition at line 1670 of file vbarange.cxx.

References ClearContents(), EDITATTR, and HARDATTR.

ClearOutline()

void SAL_CALL ScVbaRange::ClearOutline ( )

overridevirtual

Definition at line 5284 of file vbarange.cxx.

References index, m_Areas, and mxRange.

Columns()

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

overridevirtual

Definition at line 2461 of file vbarange.cxx.

References ScRange::aEnd, aIndex, ScRange::aStart, ScAddress::Col(), formula::FormulaGrammar::CONV_XL_A1, getCellRangesBase(), getScDocument(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::mxContext, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::mxParent, nValue, obtainRangeEvenIfRangeListIsEmpty(), ScRange::ParseCols(), ScVbaRange(), and ScAddress::SetCol().

Referenced by Item().

Copy()

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

overridevirtual

Definition at line 2563 of file vbarange.cxx.

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

createEnumeration()

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

overridevirtual

Definition at line 3786 of file vbarange.cxx.

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

CurrentArray()

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

overridevirtual

Definition at line 1982 of file vbarange.cxx.

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

CurrentRegion()

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

overridevirtual

Definition at line 1961 of file vbarange.cxx.

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

Referenced by AutoFilter(), and Sort().

Cut()

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

overridevirtual

Definition at line 2593 of file vbarange.cxx.

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

Delete()

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

overridevirtual

Definition at line 3725 of file vbarange.cxx.

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

DoGetValue()

css::uno::Any ScVbaRange::DoGetValue ( RangeValueType  eValueType )

private

Definition at line 1531 of file vbarange.cxx.

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

Referenced by getValue(), and getValue2().

End()

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

overridevirtual

Definition at line 3622 of file vbarange.cxx.

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

ExportAsFixedFormat()

void SAL_CALL ScVbaRange::ExportAsFixedFormat ( const css::uno::Any &  Type, const css::uno::Any &  FileName, const css::uno::Any &  Quality, const css::uno::Any &  IncludeDocProperties, const css::uno::Any &  IgnorePrintAreas, const css::uno::Any &  From, const css::uno::Any &  To, const css::uno::Any &  OpenAfterPublish, const css::uno::Any &  FixedFormatExtClassPtr  )

overridevirtual

Definition at line 5725 of file vbarange.cxx.

References InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::Application(), ooo::vba::excel::ExportAsFixedFormatHelper(), getCellRangesBase(), ScDocShell::GetModel(), To, and xModel.

FillDown()

void ScVbaRange::FillDown ( )

overridevirtual

Definition at line 1901 of file vbarange.cxx.

References fillSeries().

FillLeft()

void ScVbaRange::FillLeft ( )

overridevirtual

Definition at line 1880 of file vbarange.cxx.

References fillSeries().

FillRight()

void ScVbaRange::FillRight ( )

overridevirtual

Definition at line 1887 of file vbarange.cxx.

References fillSeries().

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 1858 of file vbarange.cxx.

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

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

FillUp()

void ScVbaRange::FillUp ( )

overridevirtual

Definition at line 1894 of file vbarange.cxx.

References fillSeries().

Find()

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 3197 of file vbarange.cxx.

References Cells(), ScGlobal::GetSearchItem(), uno::Any::hasValue(), MatchCase, 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().

fireChangeEvent()

void ScVbaRange::fireChangeEvent ( )

private

Fires a Worksheet_Change event for this range or range list.

Definition at line 252 of file vbarange.cxx.

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

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

Font()

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

overridevirtual

Exceptions

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

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 2177 of file vbarange.cxx.

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

getArea()

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

private

Exceptions

css::uno::RuntimeException

Definition at line 3942 of file vbarange.cxx.

References m_Areas, and nIndex.

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

getBorders()

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

private

Definition at line 1479 of file vbarange.cxx.

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

Referenced by BorderAround(), and Borders().

getCalcColWidth()

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

private

Exceptions

css::uno::RuntimeException

Definition at line 3811 of file vbarange.cxx.

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

Referenced by getWidth().

getCalcRowHeight()

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

private

Exceptions

css::uno::RuntimeException

Definition at line 3821 of file vbarange.cxx.

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

Referenced by getHeight().

getCellRange() [1/2]

uno::Any SAL_CALL ScVbaRange::getCellRange ( )

overridevirtual

Definition at line 2847 of file vbarange.cxx.

References mxRange, and mxRanges.

Referenced by getName().

getCellRange() [2/2]

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

static

Exceptions

css::uno::RuntimeException

getCellRangeObj()

ScCellRangeObj * ScVbaRange::getCellRangeObj ( )

private

Exceptions

css::uno::RuntimeException

Definition at line 239 of file vbarange.cxx.

References getCellRangesBase().

Referenced by Font().

getCellRangesBase()

ScCellRangesBase * ScVbaRange::getCellRangesBase ( )

overrideprotectedvirtual

Exceptions

css::uno::RuntimeException

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 230 of file vbarange.cxx.

References mxRange, and mxRanges.

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

getCellRangesForAddress()

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

static

Definition at line 1158 of file vbarange.cxx.

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

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

getColumn()

sal_Int32 ScVbaRange::getColumn ( )

override

Definition at line 1799 of file vbarange.cxx.

References getArea(), m_Areas, and mxRange.

Referenced by Insert().

getColumnWidth()

uno::Any SAL_CALL ScVbaRange::getColumnWidth ( )

overridevirtual

Definition at line 3844 of file vbarange.cxx.

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

getComment()

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

overridevirtual

Definition at line 3017 of file vbarange.cxx.

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

Referenced by AddComment().

getCount()

sal_Int32 ScVbaRange::getCount ( )

override

Definition at line 1759 of file vbarange.cxx.

References m_Areas, mbIsColumns, mbIsRows, and mxRange.

Referenced by SpecialCellsImpl().

getCurrentDataSet()

SfxItemSet * ScVbaRange::getCurrentDataSet ( )

protected

Exceptions

css::uno::RuntimeException

Definition at line 244 of file vbarange.cxx.

References getCellRangesBase().

Referenced by getWrapText().

getDefaultMethodName()

OUString SAL_CALL ScVbaRange::getDefaultMethodName ( )

override

Definition at line 3804 of file vbarange.cxx.

getDefaultPropertyName()

OUString SAL_CALL ScVbaRange::getDefaultPropertyName ( )

inlineoverride

Definition at line 309 of file vbarange.hxx.

getElementType()

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

inlineoverridevirtual

Definition at line 300 of file vbarange.hxx.

References cppu::UnoType< typename T >::get().

getEntireColumn()

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

overridevirtual

Definition at line 2987 of file vbarange.cxx.

References getEntireColumnOrRow().

getEntireColumnOrRow()

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

private

Exceptions

css::uno::RuntimeException

Definition at line 2948 of file vbarange.cxx.

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

Referenced by getEntireColumn(), and getEntireRow().

getEntireRow()

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

overridevirtual

Definition at line 2981 of file vbarange.cxx.

References getEntireColumnOrRow().

getFormula()

uno::Any ScVbaRange::getFormula ( )

overridevirtual

Definition at line 1711 of file vbarange.cxx.

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

getFormulaArray()

uno::Any ScVbaRange::getFormulaArray ( )

overridevirtual

Definition at line 2002 of file vbarange.cxx.

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

getFormulaLocal()

uno::Any ScVbaRange::getFormulaLocal ( )

overridevirtual

Definition at line 1735 of file vbarange.cxx.

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

getFormulaR1C1()

uno::Any ScVbaRange::getFormulaR1C1 ( )

overridevirtual

Definition at line 1723 of file vbarange.cxx.

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

getFormulaR1C1Local()

uno::Any ScVbaRange::getFormulaR1C1Local ( )

overridevirtual

Definition at line 1747 of file vbarange.cxx.

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

getFormulaValue()

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

private

Exceptions

css::uno::RuntimeException

Definition at line 1694 of file vbarange.cxx.

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

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

getHeight()

uno::Any SAL_CALL ScVbaRange::getHeight ( )

overridevirtual

Definition at line 4138 of file vbarange.cxx.

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

getHidden()

uno::Any SAL_CALL ScVbaRange::getHidden ( )

overridevirtual

Definition at line 3042 of file vbarange.cxx.

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

getImplementation()

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 442 of file vbarange.cxx.

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

getLeft()

uno::Any SAL_CALL ScVbaRange::getLeft ( )

overridevirtual

Definition at line 4171 of file vbarange.cxx.

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

getMergeCells()

uno::Any ScVbaRange::getMergeCells ( )

overridevirtual

Exceptions

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

Implements ScVbaFormat< Ifc >.

Definition at line 2534 of file vbarange.cxx.

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

getName()

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

overridevirtual

Definition at line 4214 of file vbarange.cxx.

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

getNumberFormat()

uno::Any ScVbaRange::getNumberFormat ( )

overridevirtual

Exceptions

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

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 2638 of file vbarange.cxx.

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

getPageBreak()

uno::Any SAL_CALL ScVbaRange::getPageBreak ( )

overridevirtual

Definition at line 4071 of file vbarange.cxx.

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

getPosition()

awt::Point ScVbaRange::getPosition ( ) const

private

Exceptions

css::uno::RuntimeException

Definition at line 4159 of file vbarange.cxx.

References mxRange, and mxRanges.

Referenced by getLeft(), and getTop().

getPrefixCharacter()

uno::Any SAL_CALL ScVbaRange::getPrefixCharacter ( )

overridevirtual

Definition at line 4939 of file vbarange.cxx.

References mxRange, and mxRanges.

getRangeObjectForName()

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 1376 of file vbarange.cxx.

References getRangeForName().

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

getRow()

sal_Int32 ScVbaRange::getRow ( )

override

Definition at line 1783 of file vbarange.cxx.

References getArea(), m_Areas, and mxRange.

Referenced by Insert().

getRowHeight()

uno::Any SAL_CALL ScVbaRange::getRowHeight ( )

overridevirtual

Definition at line 4006 of file vbarange.cxx.

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

getScDocShell()

ScDocShell * ScVbaRange::getScDocShell

(

)

Exceptions

css::uno::RuntimeException

Definition at line 431 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().

getScDocument()

ScDocument & ScVbaRange::getScDocument

(

)

Exceptions

css::uno::RuntimeException

Definition at line 419 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().

getScRangeList() [1/2]

const ScRangeList & ScVbaRange::getScRangeList

(

)

Exceptions

css::uno::RuntimeException

Definition at line 462 of file vbarange.cxx.

References getCellRangesBase().

Referenced by Hyperlinks(), and setFormulaArray().

getScRangeList() [2/2]

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

static

Exceptions

css::uno::RuntimeException

getServiceImplName()

OUString ScVbaRange::getServiceImplName ( )

overridevirtual

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

Definition at line 5744 of file vbarange.cxx.

getServiceNames()

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

overridevirtual

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

Definition at line 5750 of file vbarange.cxx.

getShowDetail()

uno::Any ScVbaRange::getShowDetail ( )

overridevirtual

Definition at line 4964 of file vbarange.cxx.

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

getStyle()

uno::Any SAL_CALL ScVbaRange::getStyle ( )

overridevirtual

Definition at line 5380 of file vbarange.cxx.

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

getText()

OUString ScVbaRange::getText ( )

overridevirtual

Definition at line 1908 of file vbarange.cxx.

References getArea(), m_Areas, and mxRange.

getTop()

uno::Any SAL_CALL ScVbaRange::getTop ( )

overridevirtual

Definition at line 4181 of file vbarange.cxx.

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

getUnoModel() [1/2]

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

(

)

Exceptions

css::uno::RuntimeException

Definition at line 448 of file vbarange.cxx.

References getScDocShell().

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

getUnoModel() [2/2]

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

static

Exceptions

css::uno::RuntimeException

getValidation()

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

overridevirtual

Definition at line 4863 of file vbarange.cxx.

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

getValue() [1/2]

uno::Any SAL_CALL ScVbaRange::getValue ( )

overridevirtual

Definition at line 1548 of file vbarange.cxx.

References DoGetValue(), and value.

Referenced by DoGetValue(), and getFormulaValue().

getValue() [2/2]

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

private

Exceptions

css::uno::RuntimeException

Definition at line 1514 of file vbarange.cxx.

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

getValue2()

uno::Any SAL_CALL ScVbaRange::getValue2 ( )

overridevirtual

Definition at line 1554 of file vbarange.cxx.

References DoGetValue(), and value2.

getWidth()

uno::Any SAL_CALL ScVbaRange::getWidth ( )

overridevirtual

Definition at line 3913 of file vbarange.cxx.

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

getWorksheet()

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

overridevirtual

Definition at line 4241 of file vbarange.cxx.

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

Referenced by Calculate(), and SpecialCells().

getWrapText()

uno::Any ScVbaRange::getWrapText ( )

overridevirtual

Exceptions

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

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 2707 of file vbarange.cxx.

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

GoalSeek()

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

overridevirtual

Definition at line 5208 of file vbarange.cxx.

References getAnyAsString(), ScDocShell::GetModel(), getScDocShell(), mxRange, and ScModelObj::seekGoal().

Group()

void SAL_CALL ScVbaRange::Group ( )

overridevirtual

Definition at line 5319 of file vbarange.cxx.

References groupUnGroup().

groupUnGroup()

void ScVbaRange::groupUnGroup ( bool  bUnGroup )

private

Exceptions

css::uno::RuntimeException

Definition at line 5302 of file vbarange.cxx.

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

Referenced by Group(), and Ungroup().

hasElements()

sal_Bool SAL_CALL ScVbaRange::hasElements ( )

overridevirtual

Definition at line 3774 of file vbarange.cxx.

References mxRange.

hasError()

sal_Bool SAL_CALL ScVbaRange::hasError ( )

overridevirtual

Definition at line 5756 of file vbarange.cxx.

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

HasFormula()

uno::Any ScVbaRange::HasFormula ( )

overridevirtual

Definition at line 1815 of file vbarange.cxx.

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

Hyperlinks()

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

overridevirtual

Definition at line 4842 of file vbarange.cxx.

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

Insert()

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

overridevirtual

Definition at line 4753 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().

Interior()

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

overridevirtual

Exceptions

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

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 2735 of file vbarange.cxx.

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

isSingleCellRange()

bool ScVbaRange::isSingleCellRange

(

)

const

Definition at line 3701 of file vbarange.cxx.

References mxRange.

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

Item()

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

overridevirtual

Definition at line 5243 of file vbarange.cxx.

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

Merge()

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

overridevirtual

Definition at line 5336 of file vbarange.cxx.

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

MergeArea()

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

overridevirtual

Definition at line 5036 of file vbarange.cxx.

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

Next()

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

overridevirtual

Definition at line 5441 of file vbarange.cxx.

References m_Areas, and PreviousNext().

obtainRangeEvenIfRangeListIsEmpty()

ScRange ScVbaRange::obtainRangeEvenIfRangeListIsEmpty ( const ScRangeList &  rCellRanges ) const

private

Exceptions

css::uno::RuntimeException

Definition at line 2407 of file vbarange.cxx.

References ScRangeList::empty(), ScRangeList::front(), and mxRange.

Referenced by Columns(), getEntireColumnOrRow(), Offset(), and Rows().

Offset()

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

overridevirtual

Definition at line 1924 of file vbarange.cxx.

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

PasteSpecial()

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 2913 of file vbarange.cxx.

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

Previous()

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

overridevirtual

Definition at line 5452 of file vbarange.cxx.

References m_Areas, and PreviousNext().

PreviousNext()

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

private

Definition at line 5412 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().

PrintOut()

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 5062 of file vbarange.cxx.

References Copies, ooo::vba::excel::getBestViewShell(), getDocShellFromRange(), getImplementation(), ScDocShell::GetModel(), index, m_Areas, mxRange, Preview, PrintOutHelper(), To, and xModel.

Range() [1/2]

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

overridevirtual

Range() [2/2]

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

Exceptions

css::uno::RuntimeException

RemoveSubtotal()

void SAL_CALL ScVbaRange::RemoveSubtotal ( )

overridevirtual

Definition at line 5646 of file vbarange.cxx.

References mxRange.

Replace()

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 3096 of file vbarange.cxx.

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

Resize()

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

overridevirtual

Definition at line 2667 of file vbarange.cxx.

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

Rows()

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

overridevirtual

Definition at line 2420 of file vbarange.cxx.

References ScRange::aEnd, aIndex, ScRange::aStart, formula::FormulaGrammar::CONV_XL_A1, getCellRangesBase(), getScDocument(), m_Areas, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::mxContext, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::mxParent, mxRange, mxRanges, nValue, obtainRangeEvenIfRangeListIsEmpty(), ScRange::ParseRows(), ScAddress::Row(), ScVbaRange(), and ScAddress::SetRow().

Referenced by Item(), and Merge().

Select()

void ScVbaRange::Select ( )

overridevirtual

Definition at line 2300 of file vbarange.cxx.

References getCellRangesBase(), ScDocShell::GetModel(), mxRange, mxRanges, xController, xFrame, and xModel.

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

setColumnWidth()

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

overridevirtual

Definition at line 3881 of file vbarange.cxx.

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

setFormula()

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

overridevirtual

Definition at line 1717 of file vbarange.cxx.

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

setFormulaArray()

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

overridevirtual

Definition at line 2040 of file vbarange.cxx.

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

setFormulaLocal()

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

overridevirtual

Definition at line 1741 of file vbarange.cxx.

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

setFormulaR1C1()

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

overridevirtual

Definition at line 1729 of file vbarange.cxx.

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

setFormulaR1C1Local()

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

overridevirtual

Definition at line 1753 of file vbarange.cxx.

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

setFormulaValue()

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

private

Exceptions

css::uno::RuntimeException

Definition at line 1679 of file vbarange.cxx.

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

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

setHidden()

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

overridevirtual

Definition at line 3068 of file vbarange.cxx.

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

setMergeCells()

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

overridevirtual

Exceptions

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

Implements ScVbaFormat< Ifc >.

Definition at line 2499 of file vbarange.cxx.

References extractBoolFromAny(), mxRange, mxRanges, nCount, and nIndex.

setNumberFormat() [1/2]

void SAL_CALL ScVbaFormat< Ifc >::setNumberFormat ( const css::uno::Any &  NumberFormat )

virtual

Exceptions

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

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 82 of file vbaformat.cxx.

setNumberFormat() [2/2]

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

overridevirtual

Exceptions

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

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 2619 of file vbarange.cxx.

References index, m_Areas, and mxRange.

setPageBreak()

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

overridevirtual

Definition at line 4107 of file vbarange.cxx.

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

setRowHeight()

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

overridevirtual

Definition at line 4045 of file vbarange.cxx.

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

setShowDetail()

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

overridevirtual

Definition at line 5001 of file vbarange.cxx.

References extractBoolFromAny(), m_Areas, and mxRange.

setStyle()

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

overridevirtual

Definition at line 5396 of file vbarange.cxx.

References CELLSTYLE, m_Areas, and mxRange.

setValue() [1/2]

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

overridevirtual

setValue() [2/2]

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

private

Exceptions

css::uno::RuntimeException

Referenced by setFormulaValue(), and setValue2().

setValue2()

void SAL_CALL ScVbaRange::setValue2 ( const css::uno::Any &  aValue2 )

overridevirtual

Definition at line 1613 of file vbarange.cxx.

References setValue().

setWrapText()

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

overridevirtual

Exceptions

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

Reimplemented from ScVbaFormat< Ifc >.

Definition at line 2688 of file vbarange.cxx.

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

Sort()

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 3431 of file vbarange.cxx.

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

SpecialCells()

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

overridevirtual

Definition at line 5463 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, nType, ScRangeList::push_back(), ScVbaRange(), ScRangeList::size(), and SpecialCellsImpl().

SpecialCellsImpl()

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

private

Exceptions

css::script::BasicErrorException

Definition at line 5591 of file vbarange.cxx.

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

Referenced by SpecialCells().

Subtotal()

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 5653 of file vbarange.cxx.

References ERRCODE_BASIC_BAD_PARAMETER, ERRCODE_BASIC_METHOD_FAILED, i, and mxRange.

thisHelperIface()

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

inlineoverridevirtual

Implements ScVbaFormat< Ifc >.

Definition at line 161 of file vbarange.hxx.

Ungroup()

void SAL_CALL ScVbaRange::Ungroup ( )

overridevirtual

Definition at line 5324 of file vbarange.cxx.

References groupUnGroup().

UnMerge()

void SAL_CALL ScVbaRange::UnMerge ( )

overridevirtual

Definition at line 5364 of file vbarange.cxx.

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

visitArray()

void ScVbaRange::visitArray ( ArrayVisitor &  visitor )

private

Definition at line 1490 of file vbarange.cxx.

References i, ScDocShell::LockPaint(), mxRange, ScDocShell::UnlockPaint(), and ArrayVisitor::visitNode().

Referenced by getValue().

Member Data Documentation

m_Areas

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

private

Definition at line 76 of file vbarange.hxx.

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

m_Borders

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

private

Definition at line 77 of file vbarange.hxx.

Referenced by BorderAround(), and getBorders().

m_xValidation

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

private

Definition at line 82 of file vbarange.hxx.

Referenced by getValidation().

mbIsColumns

bool ScVbaRange::mbIsColumns

private

Definition at line 81 of file vbarange.hxx.

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

mbIsRows

bool ScVbaRange::mbIsRows

private

Definition at line 80 of file vbarange.hxx.

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

mxRange

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

private

Definition at line 78 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(), obtainRangeEvenIfRangeListIsEmpty(), PasteSpecial(), PreviousNext(), PrintOut(), RemoveSubtotal(), Replace(), Resize(), Rows(), Select(), setColumnWidth(), setFormulaArray(), setHidden(), setMergeCells(), setNumberFormat(), setPageBreak(), setRowHeight(), setShowDetail(), setStyle(), setWrapText(), Sort(), SpecialCellsImpl(), Subtotal(), UnMerge(), and visitArray().

mxRanges

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

private

Definition at line 79 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