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 (const OUString &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 165 of file vbaworksheet.cxx.

Member Function Documentation

void ScVbaWorksheet::Activate ( )

overridevirtual

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

References getButtons().

void ScVbaWorksheet::Calculate ( )

overridevirtual

Definition at line 635 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 667 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 690 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 808 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 650 of file vbaworksheet.cxx.

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

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

overridevirtual

Definition at line 684 of file vbaworksheet.cxx.

References getSheetRange().

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

overridevirtual

Definition at line 724 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 547 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 571 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 814 of file vbaworksheet.cxx.

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

overridevirtual

Definition at line 870 of file vbaworksheet.cxx.

References Range().

sal_Bool SAL_CALL ScVbaWorksheet::getAutoFilterMode ( )

overridevirtual

Definition at line 368 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 788 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 1008 of file vbaworksheet.cxx.

References mxSheet.

uno::Any ScVbaWorksheet::getControlShape ( const OUString &  sName )

private

Definition at line 946 of file vbaworksheet.cxx.

References getSheet(), index, and nCount.

Referenced by getValue().

sal_Bool SAL_CALL ScVbaWorksheet::getEnableCalculation ( )

overridevirtual

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

References getSheetAtOffset().

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

overridevirtual

Definition at line 609 of file vbaworksheet.cxx.

References getSheetAtOffset().

sal_Bool ScVbaWorksheet::getProtectContents ( )

overridevirtual

Definition at line 466 of file vbaworksheet.cxx.

References getSheet().

sal_Bool ScVbaWorksheet::getProtectDrawingObjects ( )

overridevirtual

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

sal_Bool ScVbaWorksheet::getProtectScenarios ( )

overridevirtual

Definition at line 491 of file vbaworksheet.cxx.

OUString ScVbaWorksheet::getServiceImplName ( )

overridevirtual

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

Definition at line 979 of file vbaworksheet.cxx.

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

overridevirtual

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

Definition at line 998 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 587 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 1015 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 658 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 1038 of file vbaworksheet.cxx.

sal_Int32 ScVbaWorksheet::getStandardHeight ( )

override

Definition at line 454 of file vbaworksheet.cxx.

References STANDARDHEIGHT.

sal_Int32 ScVbaWorksheet::getStandardWidth ( )

override

Definition at line 448 of file vbaworksheet.cxx.

References STANDARDWIDTH.

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

static

Definition at line 174 of file vbaworksheet.cxx.

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

overridevirtual

Definition at line 404 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 897 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 820 of file vbaworksheet.cxx.

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

overridevirtual

Definition at line 908 of file vbaworksheet.cxx.

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

overridevirtual

Definition at line 937 of file vbaworksheet.cxx.

References getFormControls().

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

overridevirtual

Definition at line 428 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 737 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 886 of file vbaworksheet.cxx.

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

overridevirtual

Definition at line 826 of file vbaworksheet.cxx.

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

overridevirtual

Definition at line 832 of file vbaworksheet.cxx.

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

overridevirtual

Definition at line 511 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 749 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 760 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 838 of file vbaworksheet.cxx.

References getButtons().

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

overridevirtual

Definition at line 415 of file vbaworksheet.cxx.

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

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

overridevirtual

Definition at line 422 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 561 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 711 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 1022 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 615 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 642 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 678 of file vbaworksheet.cxx.

References getSheetRange().

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

overridevirtual

Definition at line 844 of file vbaworksheet.cxx.

void ScVbaWorksheet::Select ( )

overridevirtual

Definition at line 505 of file vbaworksheet.cxx.

References Activate().

void SAL_CALL ScVbaWorksheet::setAutoFilterMode ( sal_Bool  bAutoFilterMode )

overridevirtual

Definition at line 378 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 985 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(), 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 892 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 774 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 856 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 850 of file vbaworksheet.cxx.

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

overridevirtual

Definition at line 626 of file vbaworksheet.cxx.

References getSheet().

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

overridevirtual

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