LibreOffice Module sc (master) 1
Public Member Functions | Static Public Member Functions | Protected Member Functions | Private Member Functions | Private Attributes | List of all members
ScVbaRange Class Reference

#include <vbarange.hxx>

Inheritance diagram for ScVbaRange:
[legend]
Collaboration diagram for ScVbaRange:
[legend]

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)
 
ScDocumentgetScDocument ()
 
ScDocShellgetScDocShell ()
 
css::uno::Reference< css::frame::XModel > getUnoModel ()
 
const ScRangeListgetScRangeList ()
 
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 ScVbaRangegetImplementation (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 ScRangeListgetScRangeList (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 ScCellRangesBasegetCellRangesBase () override
 
SfxItemSetgetCurrentDataSet ()
 
- Protected Member Functions inherited from ScVbaFormat< Ifc >
bool isAmbiguous (const OUString &_sPropertyName)
 
css::uno::Reference< css::beans::XPropertyState > const & getXPropertyState ()
 
void initializeNumberFormats ()
 
SfxItemSetgetCurrentDataSet ()
 
virtual ScCellRangesBasegetCellRangesBase ()
 

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)
 
ScCellRangeObjgetCellRangeObj ()
 
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::XPropertySetmxPropertySet
 
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 
)

◆ 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

◆ AddComment()

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

◆ 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

◆ 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

◆ 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

◆ Autofit()

void SAL_CALL ScVbaRange::Autofit ( )
overridevirtual

◆ AutoOutline()

void ScVbaRange::AutoOutline ( )
overridevirtual

◆ 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

◆ 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

◆ 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

◆ 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

◆ Copy()

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

◆ createEnumeration()

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

◆ CurrentArray()

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

◆ CurrentRegion()

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

◆ Cut()

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

◆ Delete()

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

◆ 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

◆ 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

◆ 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

◆ 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

◆ 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

◆ getComment()

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

◆ 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

◆ 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

◆ getFormulaArray()

uno::Any ScVbaRange::getFormulaArray ( )
overridevirtual

◆ 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

◆ getFormulaR1C1Local()

uno::Any ScVbaRange::getFormulaR1C1Local ( )
overridevirtual

◆ 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

◆ 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

◆ 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

◆ 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

◆ getScDocShell()

ScDocShell * ScVbaRange::getScDocShell ( )

◆ getScDocument()

ScDocument & ScVbaRange::getScDocument ( )

◆ 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

◆ getServiceNames()

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

◆ getShowDetail()

uno::Any ScVbaRange::getShowDetail ( )
overridevirtual

◆ getStyle()

uno::Any SAL_CALL ScVbaRange::getStyle ( )
overridevirtual

◆ 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

◆ 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

◆ 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

◆ HasFormula()

uno::Any ScVbaRange::HasFormula ( )
overridevirtual

◆ Hyperlinks()

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

◆ Insert()

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

◆ 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

◆ 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

◆ 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

◆ 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

◆ 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

◆ 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

◆ 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

◆ Resize()

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

◆ Rows()

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

◆ Select()

void ScVbaRange::Select ( )
overridevirtual

◆ setColumnWidth()

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

◆ setFormula()

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

◆ setFormulaArray()

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

◆ 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

◆ setFormulaR1C1Local()

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

◆ 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

◆ 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

◆ setRowHeight()

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

◆ 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

◆ SpecialCells()

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

◆ SpecialCellsImpl()

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

◆ 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

◆ 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

◆ mxRange

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

◆ mxRanges

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

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