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

Member Function Documentation

Activate()

void ScVbaRange::Activate ( )

overridevirtual

Definition at line 2345 of file vbarange.cxx.

References cellInRange(), SfxObjectShell::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 2990 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 2099 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 4263 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 3931 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 5091 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 4473 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 4802 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 5258 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 3956 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 3948 of file vbarange.cxx.

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

Calculate()

void ScVbaRange::Calculate ( )

override

Definition at line 5235 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 2196 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 2215 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 2073 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 3710 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 1618 of file vbarange.cxx.

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

ClearComments()

void SAL_CALL ScVbaRange::ClearComments ( )

overridevirtual

Definition at line 1654 of file vbarange.cxx.

References ClearContents().

ClearContents() [1/2]

void SAL_CALL ScVbaRange::ClearContents ( )

overridevirtual

Definition at line 1660 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 1627 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 1668 of file vbarange.cxx.

References ClearContents(), EDITATTR, and HARDATTR.

ClearOutline()

void SAL_CALL ScVbaRange::ClearOutline ( )

overridevirtual

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

References ScRange::aEnd, aIndex, ScRange::aStart, ScAddress::Col(), formula::FormulaGrammar::CONV_XL_A1, getCellRangesBase(), ScCellRangesBase::GetDocShell(), ScCellRangesBase::GetRangeList(), 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 2560 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 3783 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 1979 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 1958 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 2590 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 3722 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 1529 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 3619 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.

FillDown()

void ScVbaRange::FillDown ( )

overridevirtual

Definition at line 1898 of file vbarange.cxx.

References fillSeries().

FillLeft()

void ScVbaRange::FillLeft ( )

overridevirtual

Definition at line 1877 of file vbarange.cxx.

References fillSeries().

FillRight()

void ScVbaRange::FillRight ( )

overridevirtual

Definition at line 1884 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 1855 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 1891 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 3194 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 251 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 2174 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 3939 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 1477 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 3808 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 3818 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 2844 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 238 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 229 of file vbarange.cxx.

References mxRange, and mxRanges.

Referenced by Columns(), 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 1155 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 1797 of file vbarange.cxx.

References getArea(), m_Areas, and mxRange.

Referenced by Insert().

getColumnWidth()

uno::Any SAL_CALL ScVbaRange::getColumnWidth ( )

overridevirtual

Definition at line 3841 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 3014 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 1757 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 243 of file vbarange.cxx.

References getCellRangesBase().

Referenced by getWrapText().

getDefaultMethodName()

OUString SAL_CALL ScVbaRange::getDefaultMethodName ( )

override

Definition at line 3801 of file vbarange.cxx.

getDefaultPropertyName()

OUString SAL_CALL ScVbaRange::getDefaultPropertyName ( )

inlineoverride

Definition at line 306 of file vbarange.hxx.

getElementType()

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

inlineoverridevirtual

Definition at line 297 of file vbarange.hxx.

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

getEntireColumn()

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

overridevirtual

Definition at line 2984 of file vbarange.cxx.

References getEntireColumnOrRow().

getEntireColumnOrRow()

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

private

Exceptions

css::uno::RuntimeException

Definition at line 2945 of file vbarange.cxx.

References ScRange::aEnd, ScRange::aStart, getCellRangesBase(), ScCellRangesBase::GetDocShell(), ScCellRangesBase::GetRangeList(), 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 2978 of file vbarange.cxx.

References getEntireColumnOrRow().

getFormula()

uno::Any ScVbaRange::getFormula ( )

overridevirtual

Definition at line 1709 of file vbarange.cxx.

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

getFormulaArray()

uno::Any ScVbaRange::getFormulaArray ( )

overridevirtual

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

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

getFormulaR1C1()

uno::Any ScVbaRange::getFormulaR1C1 ( )

overridevirtual

Definition at line 1721 of file vbarange.cxx.

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

getFormulaR1C1Local()

uno::Any ScVbaRange::getFormulaR1C1Local ( )

overridevirtual

Definition at line 1745 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 1692 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 4135 of file vbarange.cxx.

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

getHidden()

uno::Any SAL_CALL ScVbaRange::getHidden ( )

overridevirtual

Definition at line 3039 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 441 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 4168 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 2531 of file vbarange.cxx.

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

getName()

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

overridevirtual

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

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

getPageBreak()

uno::Any SAL_CALL ScVbaRange::getPageBreak ( )

overridevirtual

Definition at line 4068 of file vbarange.cxx.

References getDocShellFromRange(), getDocumentFromRange(), SfxObjectShell::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 4156 of file vbarange.cxx.

References mxRange, and mxRanges.

Referenced by getLeft(), and getTop().

getPrefixCharacter()

uno::Any SAL_CALL ScVbaRange::getPrefixCharacter ( )

overridevirtual

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

References getRangeForName().

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

getRow()

sal_Int32 ScVbaRange::getRow ( )

override

Definition at line 1781 of file vbarange.cxx.

References getArea(), m_Areas, and mxRange.

Referenced by Insert().

getRowHeight()

uno::Any SAL_CALL ScVbaRange::getRowHeight ( )

overridevirtual

Definition at line 4003 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 430 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 418 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 461 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 5723 of file vbarange.cxx.

getServiceNames()

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

overridevirtual

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

Definition at line 5729 of file vbarange.cxx.

getShowDetail()

uno::Any ScVbaRange::getShowDetail ( )

overridevirtual

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

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

getText()

OUString ScVbaRange::getText ( )

overridevirtual

Definition at line 1905 of file vbarange.cxx.

References getArea(), m_Areas, and mxRange.

getTop()

uno::Any SAL_CALL ScVbaRange::getTop ( )

overridevirtual

Definition at line 4178 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 447 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 4860 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 1546 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 1512 of file vbarange.cxx.

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

getValue2()

uno::Any SAL_CALL ScVbaRange::getValue2 ( )

overridevirtual

Definition at line 1552 of file vbarange.cxx.

References DoGetValue(), and value2.

getWidth()

uno::Any SAL_CALL ScVbaRange::getWidth ( )

overridevirtual

Definition at line 3910 of file vbarange.cxx.

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

getWorksheet()

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

overridevirtual

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

getWrapText()

uno::Any ScVbaRange::getWrapText ( )

overridevirtual

Exceptions

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

Reimplemented from ScVbaFormat< Ifc >.

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

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

Group()

void SAL_CALL ScVbaRange::Group ( )

overridevirtual

Definition at line 5317 of file vbarange.cxx.

References groupUnGroup().

groupUnGroup()

void ScVbaRange::groupUnGroup ( bool  bUnGroup )

private

Exceptions

css::uno::RuntimeException

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

References mxRange.

hasError()

sal_Bool SAL_CALL ScVbaRange::hasError ( )

overridevirtual

Definition at line 5735 of file vbarange.cxx.

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

HasFormula()

uno::Any ScVbaRange::HasFormula ( )

overridevirtual

Definition at line 1813 of file vbarange.cxx.

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

Hyperlinks()

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

overridevirtual

Definition at line 4839 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 4750 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 2732 of file vbarange.cxx.

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

isSingleCellRange()

bool ScVbaRange::isSingleCellRange

(

)

const

Definition at line 3698 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 5241 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 5334 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 5033 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 5439 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 2404 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 1921 of file vbarange.cxx.

References ScRange::aEnd, ScRange::aStart, ScAddress::Col(), getCellRangesBase(), ScCellRangesBase::GetDocShell(), ScCellRangesBase::GetRangeList(), 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 2910 of file vbarange.cxx.

References SfxObjectShell::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 5450 of file vbarange.cxx.

References m_Areas, and PreviousNext().

PreviousNext()

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

private

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

References Copies, ooo::vba::excel::getBestViewShell(), getDocShellFromRange(), getImplementation(), SfxObjectShell::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 5644 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 3093 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 2664 of file vbarange.cxx.

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

Rows()

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

overridevirtual

Definition at line 2417 of file vbarange.cxx.

References ScRange::aEnd, aIndex, ScRange::aStart, formula::FormulaGrammar::CONV_XL_A1, getCellRangesBase(), ScCellRangesBase::GetDocShell(), ScCellRangesBase::GetRangeList(), 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 2297 of file vbarange.cxx.

References getCellRangesBase(), ScCellRangesBase::GetDocShell(), SfxObjectShell::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 3878 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 1715 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 2037 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 1739 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 1727 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 1751 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 1677 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 3065 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 2496 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 2616 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 4104 of file vbarange.cxx.

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

setRowHeight()

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

overridevirtual

Definition at line 4042 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 4998 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 5394 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 1611 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 2685 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 3428 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 5461 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 5589 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 5651 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 5322 of file vbarange.cxx.

References groupUnGroup().

UnMerge()

void SAL_CALL ScVbaRange::UnMerge ( )

overridevirtual

Definition at line 5362 of file vbarange.cxx.

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

visitArray()

void ScVbaRange::visitArray ( ArrayVisitor &  visitor )

private

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