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, css::uno::Reference< css::sheet::XSpreadsheet > xSheet, 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 void SAL_CALL	ExportAsFixedFormat (const css::uno::Any &Type, const css::uno::Any &FileName, const css::uno::Any &Quality, const css::uno::Any &IncludeDocProperties, const css::uno::Any &IgnorePrintAreas, const css::uno::Any &From, const css::uno::Any &To, const css::uno::Any &OpenAfterPublish, const css::uno::Any &FixedFormatExtClassPtr) 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< typename... 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 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() [1/2]

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

Exceptions

css::uno::RuntimeException

Referenced by getSheetAtOffset().

ScVbaWorksheet() [2/2]

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::~ScVbaWorksheet ( )

overridevirtual

Definition at line 170 of file vbaworksheet.cxx.

Member Function Documentation

Activate()

void ScVbaWorksheet::Activate ( )

overridevirtual

Definition at line 508 of file vbaworksheet.cxx.

References getModel(), and getSheet().

Referenced by Select().

Buttons()

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

overridevirtual

Definition at line 814 of file vbaworksheet.cxx.

References getButtons().

Calculate()

void ScVbaWorksheet::Calculate ( )

overridevirtual

Definition at line 646 of file vbaworksheet.cxx.

References getModel().

Cells()

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

overridevirtual

Definition at line 678 of file vbaworksheet.cxx.

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

ChartObjects()

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

overridevirtual

Definition at line 702 of file vbaworksheet.cxx.

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

CheckBoxes()

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

overridevirtual

Definition at line 820 of file vbaworksheet.cxx.

CheckSpelling()

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 661 of file vbaworksheet.cxx.

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

Columns()

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

overridevirtual

Definition at line 696 of file vbaworksheet.cxx.

References aIndex, and getSheetRange().

Comments()

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

overridevirtual

Definition at line 736 of file vbaworksheet.cxx.

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

Copy()

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

overridevirtual

Definition at line 558 of file vbaworksheet.cxx.

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

createSheetCopy()

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

Definition at line 208 of file vbaworksheet.cxx.

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

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

createSheetCopyInNewDoc()

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

(

const OUString &

aCurrSheetName

)

Definition at line 181 of file vbaworksheet.cxx.

References ScDocument::GetCodeName(), ooo::vba::excel::getDocShell(), ScDocShell::GetDocument(), 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 Copy(), and ScVbaWorksheets::Copy().

Delete()

void ScVbaWorksheet::Delete ( )

overridevirtual

Definition at line 582 of file vbaworksheet.cxx.

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

Referenced by Move().

DropDowns()

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

overridevirtual

Definition at line 826 of file vbaworksheet.cxx.

Evaluate()

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

overridevirtual

Definition at line 882 of file vbaworksheet.cxx.

References Name, and Range().

ExportAsFixedFormat()

void SAL_CALL ScVbaWorksheet::ExportAsFixedFormat ( const css::uno::Any &  Type, const css::uno::Any &  FileName, const css::uno::Any &  Quality, const css::uno::Any &  IncludeDocProperties, const css::uno::Any &  IgnorePrintAreas, const css::uno::Any &  From, const css::uno::Any &  To, const css::uno::Any &  OpenAfterPublish, const css::uno::Any &  FixedFormatExtClassPtr  )

overridevirtual

Definition at line 1050 of file vbaworksheet.cxx.

References InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::Application(), ooo::vba::excel::ExportAsFixedFormatHelper(), getModel(), To, and xModel.

getAutoFilterMode()

sal_Bool SAL_CALL ScVbaWorksheet::getAutoFilterMode ( )

overridevirtual

Definition at line 374 of file vbaworksheet.cxx.

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

getButtons()

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

private

Definition at line 800 of file vbaworksheet.cxx.

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

Referenced by Buttons(), and OptionButtons().

getCodeName()

OUString SAL_CALL ScVbaWorksheet::getCodeName ( )

overridevirtual

Definition at line 1020 of file vbaworksheet.cxx.

References mxSheet.

getControlShape()

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

private

Definition at line 958 of file vbaworksheet.cxx.

References getSheet(), index, nCount, and sName.

Referenced by getValue().

getEnableCalculation()

sal_Bool SAL_CALL ScVbaWorksheet::getEnableCalculation ( )

overridevirtual

Definition at line 1003 of file vbaworksheet.cxx.

References getModel().

getEnableSelection()

sal_Int32 ScVbaWorksheet::getEnableSelection ( )

overridevirtual

Definition at line 306 of file vbaworksheet.cxx.

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

getFormControls()

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

private

Definition at line 926 of file vbaworksheet.cxx.

References getSheet().

Referenced by hasProperty().

getIndex()

sal_Int16 ScVbaWorksheet::getIndex ( )

overridevirtual

Definition at line 300 of file vbaworksheet.cxx.

References getSheetID().

getIntrospection()

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

overridevirtual

Definition at line 892 of file vbaworksheet.cxx.

getModel()

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(), ExportAsFixedFormat(), getAutoFilterMode(), getEnableCalculation(), getEnableSelection(), getProtectDrawingObjects(), getSheetAtOffset(), getValue(), Move(), PageSetup(), PrintOut(), setAutoFilterMode(), setEnableCalculation(), setEnableSelection(), Shapes(), and ShowDataForm().

getName()

OUString ScVbaWorksheet::getName ( )

overridevirtual

Definition at line 250 of file vbaworksheet.cxx.

References getSheet().

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

getNext()

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

overridevirtual

Definition at line 614 of file vbaworksheet.cxx.

References getSheetAtOffset().

getPrevious()

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

overridevirtual

Definition at line 620 of file vbaworksheet.cxx.

References getSheetAtOffset().

getProtectContents()

sal_Bool ScVbaWorksheet::getProtectContents ( )

overridevirtual

Definition at line 475 of file vbaworksheet.cxx.

References getSheet().

getProtectDrawingObjects()

sal_Bool ScVbaWorksheet::getProtectDrawingObjects ( )

overridevirtual

Definition at line 482 of file vbaworksheet.cxx.

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

getProtectionMode()

sal_Bool ScVbaWorksheet::getProtectionMode ( )

overridevirtual

Definition at line 469 of file vbaworksheet.cxx.

getProtectScenarios()

sal_Bool ScVbaWorksheet::getProtectScenarios ( )

overridevirtual

Definition at line 502 of file vbaworksheet.cxx.

getServiceImplName()

OUString ScVbaWorksheet::getServiceImplName ( )

overridevirtual

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

Definition at line 991 of file vbaworksheet.cxx.

getServiceNames()

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

overridevirtual

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

Definition at line 1010 of file vbaworksheet.cxx.

References aServiceNames.

getSheet()

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().

getSheetAtOffset()

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

private

Exceptions

css::uno::RuntimeException

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

getSheetID()

sal_Int16 ScVbaWorksheet::getSheetID

(

)

const

Exceptions

css::uno::RuntimeException

Definition at line 1027 of file vbaworksheet.cxx.

References mxSheet.

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

getSheetRange()

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

private

Exceptions

css::uno::RuntimeException

Definition at line 669 of file vbaworksheet.cxx.

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

Referenced by Columns(), and Rows().

getSomething()

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

override

Definition at line 1062 of file vbaworksheet.cxx.

References comphelper::getSomethingImpl().

getStandardHeight()

sal_Int32 ScVbaWorksheet::getStandardHeight ( )

override

Definition at line 463 of file vbaworksheet.cxx.

References STANDARDHEIGHT.

getStandardWidth()

sal_Int32 ScVbaWorksheet::getStandardWidth ( )

override

Definition at line 457 of file vbaworksheet.cxx.

References STANDARDWIDTH.

getUnoTunnelId()

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

static

Definition at line 174 of file vbaworksheet.cxx.

References comphelper::UnoIdInit::getSeq().

getUsedRange()

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

overridevirtual

Definition at line 413 of file vbaworksheet.cxx.

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

getValue()

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

overridevirtual

Definition at line 909 of file vbaworksheet.cxx.

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

Referenced by setValue().

getVisible()

sal_Int32 ScVbaWorksheet::getVisible ( )

overridevirtual

Definition at line 264 of file vbaworksheet.cxx.

References bVisible, getSheet(), and mbVeryHidden.

GroupBoxes()

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

overridevirtual

Definition at line 832 of file vbaworksheet.cxx.

hasMethod()

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

overridevirtual

Definition at line 920 of file vbaworksheet.cxx.

hasProperty()

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

overridevirtual

Definition at line 949 of file vbaworksheet.cxx.

References aName, and getFormControls().

HPageBreaks()

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

overridevirtual

Definition at line 437 of file vbaworksheet.cxx.

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

Hyperlinks()

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

overridevirtual

Definition at line 749 of file vbaworksheet.cxx.

References aIndex, InheritedHelperInterfaceImpl< ::cppu::WeakImplHelper< Ifc... > >::mxContext, and mxHlinks.

invoke()

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 898 of file vbaworksheet.cxx.

Labels()

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

overridevirtual

Definition at line 838 of file vbaworksheet.cxx.

ListBoxes()

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

overridevirtual

Definition at line 844 of file vbaworksheet.cxx.

Move()

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

overridevirtual

Definition at line 522 of file vbaworksheet.cxx.

References Before, 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.

Names()

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

overridevirtual

Definition at line 761 of file vbaworksheet.cxx.

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

OLEObjects()

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

overridevirtual

Definition at line 772 of file vbaworksheet.cxx.

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

OptionButtons()

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

overridevirtual

Definition at line 850 of file vbaworksheet.cxx.

References getButtons().

Outline()

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

overridevirtual

Definition at line 424 of file vbaworksheet.cxx.

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

PageSetup()

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

overridevirtual

Definition at line 431 of file vbaworksheet.cxx.

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

Paste()

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

overridevirtual

Definition at line 572 of file vbaworksheet.cxx.

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

PivotTables()

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

overridevirtual

Definition at line 723 of file vbaworksheet.cxx.

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

PrintOut()

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 1034 of file vbaworksheet.cxx.

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

Protect()

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 626 of file vbaworksheet.cxx.

References getSheet(), and Password.

Range()

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

overridevirtual

Definition at line 653 of file vbaworksheet.cxx.

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

Referenced by Evaluate().

Rows()

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

overridevirtual

Definition at line 690 of file vbaworksheet.cxx.

References aIndex, and getSheetRange().

ScrollBars()

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

overridevirtual

Definition at line 856 of file vbaworksheet.cxx.

Select()

void ScVbaWorksheet::Select ( )

overridevirtual

Definition at line 516 of file vbaworksheet.cxx.

References Activate().

setAutoFilterMode()

void SAL_CALL ScVbaWorksheet::setAutoFilterMode ( sal_Bool  bAutoFilterMode )

overridevirtual

Definition at line 386 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(), and ScAddress::Tab().

setEnableCalculation()

void SAL_CALL ScVbaWorksheet::setEnableCalculation ( sal_Bool  EnableCalculation )

overridevirtual

Definition at line 997 of file vbaworksheet.cxx.

References getModel().

setEnableSelection()

void ScVbaWorksheet::setEnableSelection ( sal_Int32  nSelection )

overridevirtual

Definition at line 334 of file vbaworksheet.cxx.

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

setName()

void ScVbaWorksheet::setName ( const OUString &  rName )

overridevirtual

Definition at line 257 of file vbaworksheet.cxx.

References getSheet().

setValue()

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

overridevirtual

Definition at line 904 of file vbaworksheet.cxx.

References getValue(), and setDefaultPropByIntrospection().

setVisible()

void ScVbaWorksheet::setVisible ( sal_Int32  nVisible )

overridevirtual

Definition at line 274 of file vbaworksheet.cxx.

References bVisible, getSheet(), and mbVeryHidden.

Shapes()

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

overridevirtual

Definition at line 786 of file vbaworksheet.cxx.

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

ShowDataForm()

void SAL_CALL ScVbaWorksheet::ShowDataForm ( )

overridevirtual

Definition at line 868 of file vbaworksheet.cxx.

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

Spinners()

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

overridevirtual

Definition at line 862 of file vbaworksheet.cxx.

Unprotect()

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

overridevirtual

Definition at line 637 of file vbaworksheet.cxx.

References getSheet(), and Password.

VPageBreaks()

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

overridevirtual

Definition at line 447 of file vbaworksheet.cxx.

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

Member Data Documentation

mbVeryHidden

bool ScVbaWorksheet::mbVeryHidden

private

Definition at line 50 of file vbaworksheet.hxx.

Referenced by getVisible(), and setVisible().

mxButtons

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

private

Definition at line 49 of file vbaworksheet.hxx.

Referenced by getButtons().

mxCharts

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

private

Definition at line 47 of file vbaworksheet.hxx.

Referenced by ChartObjects().

mxHlinks

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

private

Definition at line 48 of file vbaworksheet.hxx.

Referenced by Hyperlinks().

mxModel

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().

mxSheet

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