ScVbaWorksheet Class Reference

#include <vbaworksheet.hxx>

Inheritance diagram for ScVbaWorksheet:

Collaboration diagram for ScVbaWorksheet:

Public Member Functions
	ScVbaWorksheet (const css::uno::Reference< ov::XHelperInterface > &xParent, const css::uno::Reference< css::uno::XComponentContext > &xContext, const css::uno::Reference< css::sheet::XSpreadsheet > &xSheet, const css::uno::Reference< css::frame::XModel > &xModel)
	ScVbaWorksheet (css::uno::Sequence< css::uno::Any > const &aArgs, css::uno::Reference< css::uno::XComponentContext >const &xContext)
virtual	~ScVbaWorksheet () override
const css::uno::Reference< css::frame::XModel > &	getModel () const
const css::uno::Reference< css::sheet::XSpreadsheet > &	getSheet () const
css::uno::Reference< ov::excel::XWorksheet >	createSheetCopyInNewDoc (const OUString &)
css::uno::Reference< ov::excel::XWorksheet >	createSheetCopy (css::uno::Reference< ov::excel::XWorksheet > const &xSheet, bool bAfter)
virtual OUString SAL_CALL	getName () override
virtual void SAL_CALL	setName (const OUString &rName) override
virtual sal_Int32 SAL_CALL	getVisible () override
virtual void SAL_CALL	setVisible (sal_Int32 nVisible) override
virtual ::sal_Int32 SAL_CALL	getStandardWidth () override
virtual ::sal_Int32 SAL_CALL	getStandardHeight () override
virtual sal_Bool SAL_CALL	getProtectionMode () override
virtual sal_Bool SAL_CALL	getProtectContents () override
virtual sal_Bool SAL_CALL	getProtectDrawingObjects () override
virtual sal_Bool SAL_CALL	getProtectScenarios () override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	getUsedRange () override
virtual css::uno::Any SAL_CALL	ChartObjects (const css::uno::Any &Index) override
virtual css::uno::Reference< ov::excel::XOutline > SAL_CALL	Outline () override
virtual css::uno::Reference< ov::excel::XPageSetup > SAL_CALL	PageSetup () override
virtual css::uno::Any SAL_CALL	HPageBreaks (const css::uno::Any &aIndex) override
virtual css::uno::Any SAL_CALL	VPageBreaks (const css::uno::Any &aIndex) override
virtual css::uno::Reference< ov::excel::XWorksheet > SAL_CALL	getNext () override
virtual css::uno::Reference< ov::excel::XWorksheet > SAL_CALL	getPrevious () override
virtual sal_Int16 SAL_CALL	getIndex () override
virtual sal_Int32 SAL_CALL	getEnableSelection () override
virtual void SAL_CALL	setEnableSelection (sal_Int32 nSelection) override
virtual sal_Bool SAL_CALL	getAutoFilterMode () override
virtual void SAL_CALL	setAutoFilterMode (sal_Bool bAutoFilterMode) override
virtual void SAL_CALL	Activate () override
virtual void SAL_CALL	Select () override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	Range (const css::uno::Any &Cell1, const css::uno::Any &Cell2) override
virtual void SAL_CALL	Move (const css::uno::Any &Before, const css::uno::Any &After) override
virtual void SAL_CALL	Copy (const css::uno::Any &Before, const css::uno::Any &After) override
virtual void SAL_CALL	Paste (const css::uno::Any &Destination, const css::uno::Any &Link) override
virtual void SAL_CALL	Delete () override
virtual void SAL_CALL	Protect (const css::uno::Any &Password, const css::uno::Any &DrawingObjects, const css::uno::Any &Contents, const css::uno::Any &Scenarios, const css::uno::Any &UserInterfaceOnly) override
virtual void SAL_CALL	Unprotect (const css::uno::Any &Password) override
virtual void SAL_CALL	Calculate () override
virtual void SAL_CALL	CheckSpelling (const css::uno::Any &CustomDictionary, const css::uno::Any &IgnoreUppercase, const css::uno::Any &AlwaysSuggest, const css::uno::Any &SpellingLang) override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	Cells (const css::uno::Any &nRow, const css::uno::Any &nCol) override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	Rows (const css::uno::Any &aIndex) override
virtual css::uno::Reference< ov::excel::XRange > SAL_CALL	Columns (const css::uno::Any &aIndex) override
virtual css::uno::Any SAL_CALL	Evaluate (const OUString &Name) override
virtual css::uno::Any SAL_CALL	PivotTables (const css::uno::Any &Index) override
virtual css::uno::Any SAL_CALL	Comments (const css::uno::Any &Index) override
virtual css::uno::Any SAL_CALL	Hyperlinks (const css::uno::Any &aIndex) override
virtual css::uno::Any SAL_CALL	Names (const css::uno::Any &aIndex) override
virtual css::uno::Any SAL_CALL	OLEObjects (const css::uno::Any &Index) override
virtual css::uno::Any SAL_CALL	Shapes (const css::uno::Any &aIndex) override
virtual css::uno::Any SAL_CALL	Buttons (const css::uno::Any &rIndex) override
virtual css::uno::Any SAL_CALL	CheckBoxes (const css::uno::Any &rIndex) override
virtual css::uno::Any SAL_CALL	DropDowns (const css::uno::Any &rIndex) override
virtual css::uno::Any SAL_CALL	GroupBoxes (const css::uno::Any &rIndex) override
virtual css::uno::Any SAL_CALL	Labels (const css::uno::Any &rIndex) override
virtual css::uno::Any SAL_CALL	ListBoxes (const css::uno::Any &rIndex) override
virtual css::uno::Any SAL_CALL	OptionButtons (const css::uno::Any &rIndex) override
virtual css::uno::Any SAL_CALL	ScrollBars (const css::uno::Any &rIndex) override
virtual css::uno::Any SAL_CALL	Spinners (const css::uno::Any &rIndex) override
virtual void SAL_CALL	setEnableCalculation (sal_Bool EnableCalculation) override
virtual sal_Bool SAL_CALL	getEnableCalculation () override
virtual void SAL_CALL	ShowDataForm () override
virtual css::uno::Reference< css::beans::XIntrospectionAccess > SAL_CALL	getIntrospection () override
virtual css::uno::Any SAL_CALL	invoke (const OUString &aFunctionName, const css::uno::Sequence< css::uno::Any > &aParams, css::uno::Sequence< ::sal_Int16 > &aOutParamIndex, css::uno::Sequence< css::uno::Any > &aOutParam) override
virtual void SAL_CALL	setValue (const OUString &aPropertyName, const css::uno::Any &aValue) override
virtual css::uno::Any SAL_CALL	getValue (const OUString &aPropertyName) override
virtual sal_Bool SAL_CALL	hasMethod (const OUString &aName) override
virtual sal_Bool SAL_CALL	hasProperty (const OUString &aName) override
virtual OUString SAL_CALL	getCodeName () override
sal_Int16	getSheetID () const
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, const css::uno::Any &IgnorePrintAreas) override
virtual OUString	getServiceImplName () override
virtual css::uno::Sequence< OUString >	getServiceNames () override
virtual ::sal_Int64 SAL_CALL	getSomething (const css::uno::Sequence< sal_Int8 > &rId) override
Public Member Functions inherited from InheritedHelperInterfaceWeakImpl< Ifc >
	InheritedHelperInterfaceWeakImpl (const css::uno::Reference< ov::XHelperInterface > &xParent, const css::uno::Reference< css::uno::XComponentContext > &xContext)
Public Member Functions inherited from InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >
	InheritedHelperInterfaceImpl (const css::uno::Reference< ov::XHelperInterface > &xParent, const css::uno::Reference< css::uno::XComponentContext > &xContext)
virtual ::sal_Int32 SAL_CALL	getCreator () override
virtual css::uno::Reference< ov::XHelperInterface > SAL_CALL	getParent () override
virtual css::uno::Any SAL_CALL	Application () override
virtual OUString SAL_CALL	getImplementationName () override
virtual sal_Bool SAL_CALL	supportsService (const OUString &ServiceName) override
virtual css::uno::Sequence< OUString > SAL_CALL	getSupportedServiceNames () override

Static Public Member Functions
static const css::uno::Sequence< sal_Int8 > &	getUnoTunnelId ()

Private Member Functions
css::uno::Reference< ov::excel::XWorksheet >	getSheetAtOffset (SCTAB offset)
css::uno::Reference< ov::excel::XRange >	getSheetRange ()
css::uno::Reference< css::container::XNameAccess >	getFormControls () const
css::uno::Any	getControlShape (std::u16string_view sName)
css::uno::Any	getButtons (const css::uno::Any &rIndex, bool bOptionButtons)

Private Attributes
css::uno::Reference< css::sheet::XSpreadsheet >	mxSheet
css::uno::Reference< css::frame::XModel >	mxModel
css::uno::Reference< ov::excel::XChartObjects >	mxCharts
css::uno::Reference< ov::excel::XHyperlinks >	mxHlinks
::rtl::Reference< ScVbaSheetObjectsBase >	mxButtons [2]
bool	mbVeryHidden

Additional Inherited Members
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 43 of file vbaworksheet.hxx.

Constructor & Destructor Documentation

ScVbaWorksheet::ScVbaWorksheet	(	const css::uno::Reference< ov::XHelperInterface > &	xParent,
		const css::uno::Reference< css::uno::XComponentContext > &	xContext,
		const css::uno::Reference< css::sheet::XSpreadsheet > &	xSheet,
		const css::uno::Reference< css::frame::XModel > &	xModel
	)

Exceptions

css::uno::RuntimeException

Referenced by getSheetAtOffset().

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

Exceptions

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

ScVbaWorksheet::~ScVbaWorksheet ( )

overridevirtual

Definition at line 169 of file vbaworksheet.cxx.

Member Function Documentation

void ScVbaWorksheet::Activate ( )

overridevirtual

Definition at line 499 of file vbaworksheet.cxx.

References getModel(), and getSheet().

Referenced by Select().

uno::Any SAL_CALL ScVbaWorksheet::Buttons ( const css::uno::Any &  rIndex )

overridevirtual

Definition at line 804 of file vbaworksheet.cxx.

References getButtons().

void ScVbaWorksheet::Calculate ( )

overridevirtual

Definition at line 637 of file vbaworksheet.cxx.

References getModel().

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

overridevirtual

Definition at line 669 of file vbaworksheet.cxx.

References ScVbaRange::CellsHelper(), ooo::vba::excel::getDocShell(), ScDocShell::GetDocument(), getModel(), getSheet(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::mxContext, and xModel.

uno::Any SAL_CALL ScVbaWorksheet::ChartObjects ( const css::uno::Any &  Index )

overridevirtual

Definition at line 692 of file vbaworksheet.cxx.

References getSheet(), uno::Any::hasValue(), mxCharts, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::mxContext, and mxSheet.

uno::Any SAL_CALL ScVbaWorksheet::CheckBoxes ( const css::uno::Any &  rIndex )

overridevirtual

Definition at line 810 of file vbaworksheet.cxx.

void ScVbaWorksheet::CheckSpelling ( const css::uno::Any &  CustomDictionary, const css::uno::Any &  IgnoreUppercase, const css::uno::Any &  AlwaysSuggest, const css::uno::Any &  SpellingLang  )

overridevirtual

Definition at line 652 of file vbaworksheet.cxx.

References dispatchRequests(), getModel(), and xModel.

uno::Reference< excel::XRange > ScVbaWorksheet::Columns ( const css::uno::Any &  aIndex )

overridevirtual

Definition at line 686 of file vbaworksheet.cxx.

References getSheetRange().

uno::Any SAL_CALL ScVbaWorksheet::Comments ( const css::uno::Any &  Index )

overridevirtual

Definition at line 726 of file vbaworksheet.cxx.

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

void ScVbaWorksheet::Copy ( const css::uno::Any &  Before, const css::uno::Any &  After  )

overridevirtual

Definition at line 549 of file vbaworksheet.cxx.

References createSheetCopy(), createSheetCopyInNewDoc(), getName(), and uno::Any::hasValue().

css::uno::Reference< ov::excel::XWorksheet > ScVbaWorksheet::createSheetCopy	(	css::uno::Reference< ov::excel::XWorksheet > const &	xSheet,
		bool	bAfter
	)

Definition at line 206 of file vbaworksheet.cxx.

References InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::Application(), ooo::vba::excel::getDocShell(), getModel(), getName(), getNewSpreadsheetName(), ScVbaWorksheets::nameExists(), and ScDocShell::TransferTab().

Referenced by ScVbaWorksheets::Copy(), and Copy().

uno::Reference< ov::excel::XWorksheet > ScVbaWorksheet::createSheetCopyInNewDoc

(

const OUString &

aCurrSheetName

)

Definition at line 180 of file vbaworksheet.cxx.

References ooo::vba::excel::getDocShell(), getSheet(), getUnoDocModule(), ooo::vba::excel::implnCopy(), ooo::vba::excel::implnPaste(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::mxContext, mxModel, openNewDoc(), ooo::vba::excel::setUpDocumentModules(), and xModel.

Referenced by ScVbaWorksheets::Copy(), and Copy().

void ScVbaWorksheet::Delete ( )

overridevirtual

Definition at line 573 of file vbaworksheet.cxx.

References getModel(), getName(), mxSheet, and ScVbaWorksheets::nameExists().

Referenced by Move().

uno::Any SAL_CALL ScVbaWorksheet::DropDowns ( const css::uno::Any &  rIndex )

overridevirtual

Definition at line 816 of file vbaworksheet.cxx.

uno::Any SAL_CALL ScVbaWorksheet::Evaluate ( const OUString &  Name )

overridevirtual

Definition at line 872 of file vbaworksheet.cxx.

References Range().

sal_Bool SAL_CALL ScVbaWorksheet::getAutoFilterMode ( )

overridevirtual

Definition at line 370 of file vbaworksheet.cxx.

References ScDocument::GetAnonymousDBData(), ooo::vba::excel::getDocShell(), ScDocShell::GetDocument(), getModel(), getSheetID(), ScDBData::HasAutoFilter(), and xModel.

uno::Any ScVbaWorksheet::getButtons ( const css::uno::Any &  rIndex, bool  bOptionButtons  )

private

Definition at line 790 of file vbaworksheet.cxx.

References uno::Any::hasValue(), mxButtons, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::mxContext, mxModel, and mxSheet.

Referenced by Buttons(), and OptionButtons().

OUString SAL_CALL ScVbaWorksheet::getCodeName ( )

overridevirtual

Definition at line 1010 of file vbaworksheet.cxx.

References mxSheet.

uno::Any ScVbaWorksheet::getControlShape ( std::u16string_view  sName )

private

Definition at line 948 of file vbaworksheet.cxx.

References getSheet(), index, and nCount.

Referenced by getValue().

sal_Bool SAL_CALL ScVbaWorksheet::getEnableCalculation ( )

overridevirtual

Definition at line 993 of file vbaworksheet.cxx.

References getModel().

sal_Int32 ScVbaWorksheet::getEnableSelection ( )

overridevirtual

Definition at line 304 of file vbaworksheet.cxx.

References ooo::vba::excel::getDocShell(), ScDocShell::GetDocument(), getModel(), getName(), ScDocument::GetTabProtection(), ScTableProtection::isOptionEnabled(), ScVbaWorksheets::nameExists(), ScTableProtection::SELECT_LOCKED_CELLS, ScTableProtection::SELECT_UNLOCKED_CELLS, and xModel.

uno::Reference< container::XNameAccess > ScVbaWorksheet::getFormControls ( ) const

private

Definition at line 916 of file vbaworksheet.cxx.

References getSheet().

Referenced by hasProperty().

sal_Int16 ScVbaWorksheet::getIndex ( )

overridevirtual

Definition at line 298 of file vbaworksheet.cxx.

References getSheetID().

uno::Reference< beans::XIntrospectionAccess > SAL_CALL ScVbaWorksheet::getIntrospection ( )

overridevirtual

Definition at line 882 of file vbaworksheet.cxx.

const css::uno::Reference< css::frame::XModel >& ScVbaWorksheet::getModel ( ) const

inline

Definition at line 74 of file vbaworksheet.hxx.

References mxModel.

Referenced by Activate(), Calculate(), Cells(), CheckSpelling(), createSheetCopy(), Delete(), getAutoFilterMode(), getEnableCalculation(), getEnableSelection(), getProtectDrawingObjects(), getSheetAtOffset(), getValue(), Move(), PageSetup(), PrintOut(), setAutoFilterMode(), setEnableCalculation(), setEnableSelection(), Shapes(), and ShowDataForm().

OUString ScVbaWorksheet::getName ( )

overridevirtual

Definition at line 248 of file vbaworksheet.cxx.

References getSheet().

Referenced by Copy(), createSheetCopy(), Delete(), getEnableSelection(), getProtectDrawingObjects(), getSheetAtOffset(), Move(), and setEnableSelection().

uno::Reference< excel::XWorksheet > ScVbaWorksheet::getNext ( )

overridevirtual

Definition at line 605 of file vbaworksheet.cxx.

References getSheetAtOffset().

uno::Reference< excel::XWorksheet > ScVbaWorksheet::getPrevious ( )

overridevirtual

Definition at line 611 of file vbaworksheet.cxx.

References getSheetAtOffset().

sal_Bool ScVbaWorksheet::getProtectContents ( )

overridevirtual

Definition at line 468 of file vbaworksheet.cxx.

References getSheet().

sal_Bool ScVbaWorksheet::getProtectDrawingObjects ( )

overridevirtual

Definition at line 475 of file vbaworksheet.cxx.

References ooo::vba::excel::getDocShell(), ScDocShell::GetDocument(), getModel(), getName(), ScDocument::GetTabProtection(), ScTableProtection::isOptionEnabled(), ScVbaWorksheets::nameExists(), ScTableProtection::OBJECTS, and xModel.

sal_Bool ScVbaWorksheet::getProtectionMode ( )

overridevirtual

Definition at line 462 of file vbaworksheet.cxx.

sal_Bool ScVbaWorksheet::getProtectScenarios ( )

overridevirtual

Definition at line 493 of file vbaworksheet.cxx.

OUString ScVbaWorksheet::getServiceImplName ( )

overridevirtual

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

Definition at line 981 of file vbaworksheet.cxx.

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

overridevirtual

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

Definition at line 1000 of file vbaworksheet.cxx.

References aServiceNames.

const css::uno::Reference< css::sheet::XSpreadsheet >& ScVbaWorksheet::getSheet ( ) const

inline

Definition at line 76 of file vbaworksheet.hxx.

References mxSheet.

Referenced by Activate(), Cells(), ChartObjects(), Comments(), createSheetCopyInNewDoc(), getControlShape(), getFormControls(), getName(), getProtectContents(), getSheetRange(), getUsedRange(), getVisible(), HPageBreaks(), ScVbaWorksheets::Item(), Move(), Names(), OLEObjects(), Outline(), PageSetup(), PivotTables(), Protect(), Range(), setName(), setVisible(), Shapes(), Unprotect(), and VPageBreaks().

uno::Reference< excel::XWorksheet > ScVbaWorksheet::getSheetAtOffset ( SCTAB  offset )

private

Exceptions

css::uno::RuntimeException

Definition at line 589 of file vbaworksheet.cxx.

References getModel(), getName(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::getParent(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::mxContext, ScVbaWorksheets::nameExists(), and ScVbaWorksheet().

Referenced by getNext(), and getPrevious().

sal_Int16 ScVbaWorksheet::getSheetID

(

)

const

Exceptions

css::uno::RuntimeException

Definition at line 1017 of file vbaworksheet.cxx.

References mxSheet.

Referenced by getAutoFilterMode(), getIndex(), ScVbaWorksheets::PrintPreview(), ScVbaWorksheets::Select(), and setAutoFilterMode().

uno::Reference< excel::XRange > ScVbaWorksheet::getSheetRange ( )

private

Exceptions

css::uno::RuntimeException

Definition at line 660 of file vbaworksheet.cxx.

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

Referenced by Columns(), and Rows().

sal_Int64 SAL_CALL ScVbaWorksheet::getSomething ( const css::uno::Sequence< sal_Int8 > &  rId )

override

Definition at line 1040 of file vbaworksheet.cxx.

sal_Int32 ScVbaWorksheet::getStandardHeight ( )

override

Definition at line 456 of file vbaworksheet.cxx.

References STANDARDHEIGHT.

sal_Int32 ScVbaWorksheet::getStandardWidth ( )

override

Definition at line 450 of file vbaworksheet.cxx.

References STANDARDWIDTH.

const uno::Sequence< sal_Int8 > & ScVbaWorksheet::getUnoTunnelId ( )

static

Definition at line 173 of file vbaworksheet.cxx.

References UnoTunnelIdInit::getSeq().

uno::Reference< excel::XRange > ScVbaWorksheet::getUsedRange ( )

overridevirtual

Definition at line 406 of file vbaworksheet.cxx.

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

uno::Any SAL_CALL ScVbaWorksheet::getValue ( const OUString &  aPropertyName )

overridevirtual

Definition at line 899 of file vbaworksheet.cxx.

References getControlShape(), getModel(), and InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::mxContext.

Referenced by setValue().

sal_Int32 ScVbaWorksheet::getVisible ( )

overridevirtual

Definition at line 262 of file vbaworksheet.cxx.

References bVisible, getSheet(), and mbVeryHidden.

uno::Any SAL_CALL ScVbaWorksheet::GroupBoxes ( const css::uno::Any &  rIndex )

overridevirtual

Definition at line 822 of file vbaworksheet.cxx.

sal_Bool SAL_CALL ScVbaWorksheet::hasMethod ( const OUString &  aName )

overridevirtual

Definition at line 910 of file vbaworksheet.cxx.

sal_Bool SAL_CALL ScVbaWorksheet::hasProperty ( const OUString &  aName )

overridevirtual

Definition at line 939 of file vbaworksheet.cxx.

References getFormControls().

uno::Any ScVbaWorksheet::HPageBreaks ( const css::uno::Any &  aIndex )

overridevirtual

Definition at line 430 of file vbaworksheet.cxx.

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

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

overridevirtual

Definition at line 739 of file vbaworksheet.cxx.

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

uno::Any SAL_CALL ScVbaWorksheet::invoke ( const OUString &  aFunctionName, const css::uno::Sequence< css::uno::Any > &  aParams, css::uno::Sequence< ::sal_Int16 > &  aOutParamIndex, css::uno::Sequence< css::uno::Any > &  aOutParam  )

overridevirtual

Definition at line 888 of file vbaworksheet.cxx.

uno::Any SAL_CALL ScVbaWorksheet::Labels ( const css::uno::Any &  rIndex )

overridevirtual

Definition at line 828 of file vbaworksheet.cxx.

uno::Any SAL_CALL ScVbaWorksheet::ListBoxes ( const css::uno::Any &  rIndex )

overridevirtual

Definition at line 834 of file vbaworksheet.cxx.

void ScVbaWorksheet::Move ( const css::uno::Any &  Before, const css::uno::Any &  After  )

overridevirtual

Definition at line 513 of file vbaworksheet.cxx.

References Delete(), getModel(), getName(), getSheet(), uno::Any::hasValue(), ooo::vba::excel::implnCopy(), ooo::vba::excel::implnPaste(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::mxContext, mxModel, ScVbaWorksheets::nameExists(), openNewDoc(), and xModel.

uno::Any SAL_CALL ScVbaWorksheet::Names ( const css::uno::Any &  aIndex )

overridevirtual

Definition at line 751 of file vbaworksheet.cxx.

References getSheet(), InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::mxContext, and mxModel.

uno::Any SAL_CALL ScVbaWorksheet::OLEObjects ( const css::uno::Any &  Index )

overridevirtual

Definition at line 762 of file vbaworksheet.cxx.

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

uno::Any SAL_CALL ScVbaWorksheet::OptionButtons ( const css::uno::Any &  rIndex )

overridevirtual

Definition at line 840 of file vbaworksheet.cxx.

References getButtons().

uno::Reference< excel::XOutline > ScVbaWorksheet::Outline ( )

overridevirtual

Definition at line 417 of file vbaworksheet.cxx.

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

uno::Reference< excel::XPageSetup > ScVbaWorksheet::PageSetup ( )

overridevirtual

Definition at line 424 of file vbaworksheet.cxx.

References getModel(), getSheet(), and InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::mxContext.

void ScVbaWorksheet::Paste ( const css::uno::Any &  Destination, const css::uno::Any &  Link  )

overridevirtual

Definition at line 563 of file vbaworksheet.cxx.

References ooo::vba::excel::implnPaste(), and mxModel.

uno::Any SAL_CALL ScVbaWorksheet::PivotTables ( const css::uno::Any &  Index )

overridevirtual

Definition at line 713 of file vbaworksheet.cxx.

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

void SAL_CALL ScVbaWorksheet::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, const css::uno::Any &  IgnorePrintAreas  )

overridevirtual

Definition at line 1024 of file vbaworksheet.cxx.

References ooo::vba::excel::getBestViewShell(), getModel(), PrintOutHelper(), and xModel.

void ScVbaWorksheet::Protect ( const css::uno::Any &  Password, const css::uno::Any &  DrawingObjects, const css::uno::Any &  Contents, const css::uno::Any &  Scenarios, const css::uno::Any &  UserInterfaceOnly  )

overridevirtual

Definition at line 617 of file vbaworksheet.cxx.

References getSheet().

uno::Reference< excel::XRange > ScVbaWorksheet::Range ( const css::uno::Any &  Cell1, const css::uno::Any &  Cell2  )

overridevirtual

Definition at line 644 of file vbaworksheet.cxx.

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

Referenced by Evaluate().

uno::Reference< excel::XRange > ScVbaWorksheet::Rows ( const css::uno::Any &  aIndex )

overridevirtual

Definition at line 680 of file vbaworksheet.cxx.

References getSheetRange().

uno::Any SAL_CALL ScVbaWorksheet::ScrollBars ( const css::uno::Any &  rIndex )

overridevirtual

Definition at line 846 of file vbaworksheet.cxx.

void ScVbaWorksheet::Select ( )

overridevirtual

Definition at line 507 of file vbaworksheet.cxx.

References Activate().

void SAL_CALL ScVbaWorksheet::setAutoFilterMode ( sal_Bool  bAutoFilterMode )

overridevirtual

Definition at line 380 of file vbaworksheet.cxx.

References ScRange::aEnd, ScDocument::ApplyFlagsTab(), ScRange::aStart, Auto, ScAddress::Col(), ScDocument::GetAnonymousDBData(), ScDBData::GetArea(), ooo::vba::excel::getDocShell(), ScDocShell::GetDocument(), getModel(), getSheetID(), Grid, ScDocShell::PostPaint(), ScDocument::RemoveFlagsTab(), ScAddress::Row(), ScDBData::SetAutoFilter(), ScAddress::SetRow(), ScAddress::Tab(), and xModel.

void SAL_CALL ScVbaWorksheet::setEnableCalculation ( sal_Bool  EnableCalculation )

overridevirtual

Definition at line 987 of file vbaworksheet.cxx.

References getModel().

void ScVbaWorksheet::setEnableSelection ( sal_Int32  nSelection )

overridevirtual

Definition at line 330 of file vbaworksheet.cxx.

References ERRCODE_BASIC_BAD_PARAMETER, ooo::vba::excel::getDocShell(), ScDocShell::GetDocument(), getModel(), getName(), ScDocument::GetTabProtection(), ScVbaWorksheets::nameExists(), ScTableProtection::SELECT_LOCKED_CELLS, ScTableProtection::SELECT_UNLOCKED_CELLS, ScTableProtection::setOption(), ScDocument::SetTabProtection(), and xModel.

void ScVbaWorksheet::setName ( const OUString &  rName )

overridevirtual

Definition at line 255 of file vbaworksheet.cxx.

References getSheet().

void SAL_CALL ScVbaWorksheet::setValue ( const OUString &  aPropertyName, const css::uno::Any &  aValue  )

overridevirtual

Definition at line 894 of file vbaworksheet.cxx.

References getValue(), and setDefaultPropByIntrospection().

void ScVbaWorksheet::setVisible ( sal_Int32  nVisible )

overridevirtual

Definition at line 272 of file vbaworksheet.cxx.

References bVisible, getSheet(), and mbVeryHidden.

uno::Any SAL_CALL ScVbaWorksheet::Shapes ( const css::uno::Any &  aIndex )

overridevirtual

Definition at line 776 of file vbaworksheet.cxx.

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

void SAL_CALL ScVbaWorksheet::ShowDataForm ( )

overridevirtual

Definition at line 858 of file vbaworksheet.cxx.

References ScAbstractDialogFactory::Create(), ScAbstractDialogFactory::CreateScDataFormDlg(), VclAbstractDialog::Execute(), ooo::vba::excel::getBestViewShell(), SfxViewShell::GetFrameWeld(), getModel(), and xModel.

uno::Any SAL_CALL ScVbaWorksheet::Spinners ( const css::uno::Any &  rIndex )

overridevirtual

Definition at line 852 of file vbaworksheet.cxx.

void ScVbaWorksheet::Unprotect ( const css::uno::Any &  Password )

overridevirtual

Definition at line 628 of file vbaworksheet.cxx.

References getSheet().

uno::Any ScVbaWorksheet::VPageBreaks ( const css::uno::Any &  aIndex )

overridevirtual

Definition at line 440 of file vbaworksheet.cxx.

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

Member Data Documentation

bool ScVbaWorksheet::mbVeryHidden

private

Definition at line 50 of file vbaworksheet.hxx.

Referenced by getVisible(), and setVisible().

::rtl::Reference< ScVbaSheetObjectsBase > ScVbaWorksheet::mxButtons[2]

private

Definition at line 49 of file vbaworksheet.hxx.

Referenced by getButtons().

css::uno::Reference< ov::excel::XChartObjects > ScVbaWorksheet::mxCharts

private

Definition at line 47 of file vbaworksheet.hxx.

Referenced by ChartObjects().

css::uno::Reference< ov::excel::XHyperlinks > ScVbaWorksheet::mxHlinks

private

Definition at line 48 of file vbaworksheet.hxx.

Referenced by Hyperlinks().

css::uno::Reference< css::frame::XModel > ScVbaWorksheet::mxModel

private

Definition at line 46 of file vbaworksheet.hxx.

Referenced by Comments(), createSheetCopyInNewDoc(), getButtons(), getModel(), Move(), Names(), and Paste().

css::uno::Reference< css::sheet::XSpreadsheet > ScVbaWorksheet::mxSheet

private

Definition at line 45 of file vbaworksheet.hxx.

Referenced by ChartObjects(), Delete(), getButtons(), getCodeName(), getSheet(), and getSheetID().

---

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

• vbaworksheet.hxx
• vbaworksheet.cxx