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 44 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 503 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 808 of file vbaworksheet.cxx.

References getButtons().

void ScVbaWorksheet::Calculate ( )

overridevirtual

Definition at line 641 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 673 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 696 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 814 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 656 of file vbaworksheet.cxx.

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

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

overridevirtual

Definition at line 690 of file vbaworksheet.cxx.

References getSheetRange().

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

overridevirtual

Definition at line 730 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 553 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 210 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 184 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 577 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 820 of file vbaworksheet.cxx.

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

overridevirtual

Definition at line 876 of file vbaworksheet.cxx.

References Range().

sal_Bool SAL_CALL ScVbaWorksheet::getAutoFilterMode ( )

overridevirtual

Definition at line 374 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 794 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 1014 of file vbaworksheet.cxx.

References mxSheet.

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

private

Definition at line 952 of file vbaworksheet.cxx.

References getSheet(), index, and nCount.

Referenced by getValue().

sal_Bool SAL_CALL ScVbaWorksheet::getEnableCalculation ( )

overridevirtual

Definition at line 997 of file vbaworksheet.cxx.

References getModel().

sal_Int32 ScVbaWorksheet::getEnableSelection ( )

overridevirtual

Definition at line 308 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 920 of file vbaworksheet.cxx.

References getSheet().

Referenced by hasProperty().

sal_Int16 ScVbaWorksheet::getIndex ( )

overridevirtual

Definition at line 302 of file vbaworksheet.cxx.

References getSheetID().

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

overridevirtual

Definition at line 886 of file vbaworksheet.cxx.

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

inline

Definition at line 75 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 252 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 609 of file vbaworksheet.cxx.

References getSheetAtOffset().

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

overridevirtual

Definition at line 615 of file vbaworksheet.cxx.

References getSheetAtOffset().

sal_Bool ScVbaWorksheet::getProtectContents ( )

overridevirtual

Definition at line 472 of file vbaworksheet.cxx.

References getSheet().

sal_Bool ScVbaWorksheet::getProtectDrawingObjects ( )

overridevirtual

Definition at line 479 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 466 of file vbaworksheet.cxx.

sal_Bool ScVbaWorksheet::getProtectScenarios ( )

overridevirtual

Definition at line 497 of file vbaworksheet.cxx.

OUString ScVbaWorksheet::getServiceImplName ( )

overridevirtual

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

Definition at line 985 of file vbaworksheet.cxx.

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

overridevirtual

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

Definition at line 1004 of file vbaworksheet.cxx.

References aServiceNames.

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

inline

Definition at line 77 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 593 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 1021 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 664 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 1044 of file vbaworksheet.cxx.

sal_Int32 ScVbaWorksheet::getStandardHeight ( )

override

Definition at line 460 of file vbaworksheet.cxx.

References STANDARDHEIGHT.

sal_Int32 ScVbaWorksheet::getStandardWidth ( )

override

Definition at line 454 of file vbaworksheet.cxx.

References STANDARDWIDTH.

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

static

Definition at line 178 of file vbaworksheet.cxx.

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

overridevirtual

Definition at line 410 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 903 of file vbaworksheet.cxx.

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

Referenced by setValue().

sal_Int32 ScVbaWorksheet::getVisible ( )

overridevirtual

Definition at line 266 of file vbaworksheet.cxx.

References bVisible, getSheet(), and mbVeryHidden.

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

overridevirtual

Definition at line 826 of file vbaworksheet.cxx.

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

overridevirtual

Definition at line 914 of file vbaworksheet.cxx.

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

overridevirtual

Definition at line 943 of file vbaworksheet.cxx.

References getFormControls().

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

overridevirtual

Definition at line 434 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 743 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 892 of file vbaworksheet.cxx.

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

overridevirtual

Definition at line 832 of file vbaworksheet.cxx.

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

overridevirtual

Definition at line 838 of file vbaworksheet.cxx.

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

overridevirtual

Definition at line 517 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 755 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 766 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 844 of file vbaworksheet.cxx.

References getButtons().

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

overridevirtual

Definition at line 421 of file vbaworksheet.cxx.

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

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

overridevirtual

Definition at line 428 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 567 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 717 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 1028 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 621 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 648 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 684 of file vbaworksheet.cxx.

References getSheetRange().

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

overridevirtual

Definition at line 850 of file vbaworksheet.cxx.

void ScVbaWorksheet::Select ( )

overridevirtual

Definition at line 511 of file vbaworksheet.cxx.

References Activate().

void SAL_CALL ScVbaWorksheet::setAutoFilterMode ( sal_Bool  bAutoFilterMode )

overridevirtual

Definition at line 384 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 991 of file vbaworksheet.cxx.

References getModel().

void ScVbaWorksheet::setEnableSelection ( sal_Int32  nSelection )

overridevirtual

Definition at line 334 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 259 of file vbaworksheet.cxx.

References getSheet().

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

overridevirtual

Definition at line 898 of file vbaworksheet.cxx.

References getValue(), and setDefaultPropByIntrospection().

void ScVbaWorksheet::setVisible ( sal_Int32  nVisible )

overridevirtual

Definition at line 276 of file vbaworksheet.cxx.

References bVisible, getSheet(), and mbVeryHidden.

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

overridevirtual

Definition at line 780 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 862 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 856 of file vbaworksheet.cxx.

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

overridevirtual

Definition at line 632 of file vbaworksheet.cxx.

References getSheet().

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

overridevirtual

Definition at line 444 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 51 of file vbaworksheet.hxx.

Referenced by getVisible(), and setVisible().

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

private

Definition at line 50 of file vbaworksheet.hxx.

Referenced by getButtons().

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

private

Definition at line 48 of file vbaworksheet.hxx.

Referenced by ChartObjects().

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

private

Definition at line 49 of file vbaworksheet.hxx.

Referenced by Hyperlinks().

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

private

Definition at line 47 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 46 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