Inheritance diagram for scriptforge.SFDocuments.SF_Calc:

Collaboration diagram for scriptforge.SFDocuments.SF_Calc:

Public Member Functions
def	ReviewServiceArgs (cls, windowname='')

def	FirstCell (self, rangename)

def	FirstColumn (self, rangename)

def	FirstRow (self, rangename)

def	Height (self, rangename)

def	LastCell (self, rangename)

def	LastColumn (self, rangename)

def	LastRow (self, rangename)

def	Range (self, rangename)

def	Region (self, rangename)

def	Sheet (self, sheetname)

def	SheetName (self, rangename)

def	Width (self, rangename)

def	XCellRange (self, rangename)

def	XSheetCellCursor (self, rangename)

def	XSpreadsheet (self, sheetname)

def	A1Style (self, row1, column1, row2=0, column2=0, sheetname='~')

def	Activate (self, sheetname='')

def	Charts (self, sheetname, chartname='')

def	ClearAll (self, range, filterformula='', filterscope='')

def	ClearFormats (self, range, filterformula='', filterscope='')

def	ClearValues (self, range, filterformula='', filterscope='')

def	CompactLeft (self, range, wholecolumn=False, filterformula='')

def	CompactUp (self, range, wholerow=False, filterformula='')

def	CopySheet (self, sheetname, newname, beforesheet=32768)

def	CopySheetFromFile (self, filename, sheetname, newname, beforesheet=32768)

def	CopyToCell (self, sourcerange, destinationcell)

def	CopyToRange (self, sourcerange, destinationrange)

def	CreateChart (self, chartname, sheetname, range, columnheader=False, rowheader=False)

def	CreatePivotTable (self, pivottablename, sourcerange, targetcell, datafields=ScriptForge.cstSymEmpty, rowfields=ScriptForge.cstSymEmpty, columnfields=ScriptForge.cstSymEmpty, filterbutton=True, rowtotals=True, columntotals=True)

def	DAvg (self, range)

def	DCount (self, range)

def	DMax (self, range)

def	DMin (self, range)

def	DSum (self, range)

def	ExportRangeToFile (self, range, filename, imagetype='pdf', overwrite=False)

def	Forms (self, sheetname, form='')

def	GetColumnName (self, columnnumber)

def	GetFormula (self, range)

def	GetValue (self, range)

def	ImportFromCSVFile (self, filename, destinationcell, filteroptions=ScriptForge.cstSymEmpty)

def	ImportFromDatabase (self, filename='', registrationname='', destinationcell='', sqlcommand='', directsql=False)

def	InsertSheet (self, sheetname, beforesheet=32768)

def	MoveRange (self, source, destination)

def	MoveSheet (self, sheetname, beforesheet=32768)

def	Offset (self, range, rows=0, columns=0, height=ScriptForge.cstSymEmpty, width=ScriptForge.cstSymEmpty)

def	OpenRangeSelector (self, title='', selection='~', singlecell=False, closeafterselect=True)

def	Printf (self, inputstr, range, tokencharacter='%')

def	PrintOut (self, sheetname='~', pages='', copies=1)

def	RemoveDuplicates (self, range, columns=1, header=False, casesensitive=False, mode='COMPACT')

def	RemoveSheet (self, sheetname)

def	RenameSheet (self, sheetname, newname)

def	SetArray (self, targetcell, value)

def	SetCellStyle (self, targetrange, style, filterformula='', filterscope='')

def	SetFormula (self, targetrange, formula)

def	SetValue (self, targetrange, value)

def	ShiftDown (self, range, wholerow=False, rows=0)

def	ShiftLeft (self, range, wholecolumn=False, columns=0)

def	ShiftRight (self, range, wholecolumn=False, columns=0)

def	ShiftUp (self, range, wholerow=False, rows=0)

def	SortRange (self, range, sortkeys, sortorder='ASC', destinationcell=ScriptForge.cstSymEmpty, containsheader=False, casesensitive=False, sortcolumns=False)

Public Member Functions inherited from scriptforge.SFDocuments.SF_Document
def	ReviewServiceArgs (cls, windowname='')

def	Activate (self)

def	CloseDocument (self, saveask=True)

def	CreateMenu (self, menuheader, before='', submenuchar='>')

def	Echo (self, echoon=True, hourglass=False)

def	ExportAsPDF (self, filename, overwrite=False, pages='', password='', watermark='')

def	PrintOut (self, pages='', copies=1)

def	RemoveMenu (self, menuheader)

def	RunCommand (self, command, args, *kwargs)

def	Save (self)

def	SaveAs (self, filename, overwrite=False, password='', filtername='', filteroptions='')

def	SaveCopyAs (self, filename, overwrite=False, password='', filtername='', filteroptions='')

def	SetPrinter (self, printer='', orientation='', paperformat='')

def	Toolbars (self, toolbarname='')

Public Member Functions inherited from scriptforge.SFServices
def	__init__ (self, reference=-1, objtype=None, classmodule=0, name='')

def	__getattr__ (self, name)

def	__setattr__ (self, name, value)

def	__repr__ (self)

def	Dispose (self)

def	ExecMethod (self, flags=0, methodname='', *args)

def	GetProperty (self, propertyname, arg=None)

def	Properties (self)

def	basicmethods (self)

def	basicproperties (self)

def	SetProperty (self, propertyname, value)

Static Public Attributes
string	serviceimplementation = 'basic'

string	servicename = 'SFDocuments.Calc'

tuple	servicesynonyms = ('calc', 'sfdocuments.calc')

	serviceproperties

bool	forceGetProperty = True

Static Public Attributes inherited from scriptforge.SFDocuments.SF_Document
string	serviceimplementation = 'basic'

string	servicename = 'SFDocuments.Document'

tuple	servicesynonyms = ('document', 'sfdocuments.document')

	serviceproperties

bool	forceGetProperty = True

Static Public Attributes inherited from scriptforge.SFServices
	vbGet

	vbLet

	vbMethod

	vbSet

int	flgPost = 32

int	flgDateArg = 64

int	flgDateRet = 128

int	flgArrayArg = 512

int	flgArrayRet = 1024

int	flgUno = 256

int	flgObject = 2048

int	flgHardCode = 4096

	moduleClass

	moduleStandard

bool	forceGetProperty = False

dictionary	propertysynonyms = {}

tuple	internal_attributes

	SIMPLEEXEC = ScriptForge.InvokeSimpleScript

	EXEC = ScriptForge.InvokeBasicService

Additional Inherited Members
Public Attributes inherited from scriptforge.SFServices
	objectreference

	objecttype

	classmodule

	name

	internal

	localProperties

	serviceimplementation

Detailed Description

    The SF_Calc module is focused on :
        - management (copy, insert, move, ...) of sheets within a Calc document
        - exchange of data between Basic data structures and Calc ranges of values

Definition at line 2235 of file scriptforge.py.

Member Function Documentation

◆ A1Style()

def scriptforge.SFDocuments.SF_Calc.A1Style	(	self,
		row1,
		column1,
		row2 = `0`,
		column2 = `0`,
		sheetname = `'~'`
	)

Definition at line 2307 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ Activate()

def scriptforge.SFDocuments.SF_Calc.Activate	(	self,
		sheetname = `''`
	)

Reimplemented from scriptforge.SFDocuments.SF_Document.

Definition at line 2310 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ Charts()

def scriptforge.SFDocuments.SF_Calc.Charts	(	self,
		sheetname,
		chartname = `''`
	)

Definition at line 2313 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), scriptforge.SFServices.flgArrayRet, and scriptforge.SFServices.vbMethod.

◆ ClearAll()

def scriptforge.SFDocuments.SF_Calc.ClearAll	(	self,
		range,
		filterformula = `''`,
		filterscope = `''`
	)

Definition at line 2316 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ ClearFormats()

def scriptforge.SFDocuments.SF_Calc.ClearFormats	(	self,
		range,
		filterformula = `''`,
		filterscope = `''`
	)

Definition at line 2319 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ ClearValues()

def scriptforge.SFDocuments.SF_Calc.ClearValues	(	self,
		range,
		filterformula = `''`,
		filterscope = `''`
	)

Definition at line 2322 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ CompactLeft()

def scriptforge.SFDocuments.SF_Calc.CompactLeft	(	self,
		range,
		wholecolumn = `False`,
		filterformula = `''`
	)

Definition at line 2325 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ CompactUp()

def scriptforge.SFDocuments.SF_Calc.CompactUp	(	self,
		range,
		wholerow = `False`,
		filterformula = `''`
	)

Definition at line 2328 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ CopySheet()

def scriptforge.SFDocuments.SF_Calc.CopySheet	(	self,
		sheetname,
		newname,
		beforesheet = `32768`
	)

Definition at line 2331 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), scriptforge.SFServices.flgObject, and scriptforge.SFServices.vbMethod.

◆ CopySheetFromFile()

def scriptforge.SFDocuments.SF_Calc.CopySheetFromFile	(	self,
		filename,
		sheetname,
		newname,
		beforesheet = `32768`
	)

Definition at line 2335 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), scriptforge.SFServices.flgObject, and scriptforge.SFServices.vbMethod.

◆ CopyToCell()

def scriptforge.SFDocuments.SF_Calc.CopyToCell	(	self,
		sourcerange,
		destinationcell
	)

Definition at line 2340 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), scriptforge.SFServices.flgObject, and scriptforge.SFServices.vbMethod.

◆ CopyToRange()

def scriptforge.SFDocuments.SF_Calc.CopyToRange	(	self,
		sourcerange,
		destinationrange
	)

Definition at line 2345 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), scriptforge.SFServices.flgObject, and scriptforge.SFServices.vbMethod.

◆ CreateChart()

def scriptforge.SFDocuments.SF_Calc.CreateChart	(	self,
		chartname,
		sheetname,
		range,
		columnheader = `False`,
		rowheader = `False`
	)

Definition at line 2350 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ CreatePivotTable()

def scriptforge.SFDocuments.SF_Calc.CreatePivotTable	(	self,
		pivottablename,
		sourcerange,
		targetcell,
		datafields = `ScriptForge.cstSymEmpty`,
		rowfields = `ScriptForge.cstSymEmpty`,
		columnfields = `ScriptForge.cstSymEmpty`,
		filterbutton = `True`,
		rowtotals = `True`,
		columntotals = `True`
	)

Definition at line 2353 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ DAvg()

def scriptforge.SFDocuments.SF_Calc.DAvg	(	self,
		range
	)

Definition at line 2359 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ DCount()

def scriptforge.SFDocuments.SF_Calc.DCount	(	self,
		range
	)

Definition at line 2362 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ DMax()

def scriptforge.SFDocuments.SF_Calc.DMax	(	self,
		range
	)

Definition at line 2365 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ DMin()

def scriptforge.SFDocuments.SF_Calc.DMin	(	self,
		range
	)

Definition at line 2368 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ DSum()

def scriptforge.SFDocuments.SF_Calc.DSum	(	self,
		range
	)

Definition at line 2371 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ ExportRangeToFile()

def scriptforge.SFDocuments.SF_Calc.ExportRangeToFile	(	self,
		range,
		filename,
		imagetype = `'pdf'`,
		overwrite = `False`
	)

Definition at line 2374 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ FirstCell()

def scriptforge.SFDocuments.SF_Calc.FirstCell	(	self,
		rangename
	)

Definition at line 2261 of file scriptforge.py.

References OpenStormBento::CBenValue.GetProperty(), sdext::presenter::PresenterConfigurationAccess.GetProperty(), oox::drawingml::DrawingML.GetProperty(), chart::DataInterpreter.GetProperty(), SbModule.GetProperty(), SfxOleSection.GetProperty(), BaseFrameProperties_Impl.GetProperty(), Section.GetProperty(), LwpPara.GetProperty(), scriptforge.SFServices.GetProperty(), SvtLinguConfig.GetProperty(), SvtLinguConfigItem.GetProperty(), ScfPropertySet.GetProperty(), and access2base._BasicObject.GetProperty.

◆ FirstColumn()

def scriptforge.SFDocuments.SF_Calc.FirstColumn	(	self,
		rangename
	)

Definition at line 2264 of file scriptforge.py.

References OpenStormBento::CBenValue.GetProperty(), sdext::presenter::PresenterConfigurationAccess.GetProperty(), oox::drawingml::DrawingML.GetProperty(), chart::DataInterpreter.GetProperty(), SbModule.GetProperty(), SfxOleSection.GetProperty(), BaseFrameProperties_Impl.GetProperty(), Section.GetProperty(), LwpPara.GetProperty(), scriptforge.SFServices.GetProperty(), SvtLinguConfig.GetProperty(), SvtLinguConfigItem.GetProperty(), ScfPropertySet.GetProperty(), and access2base._BasicObject.GetProperty.

◆ FirstRow()

def scriptforge.SFDocuments.SF_Calc.FirstRow	(	self,
		rangename
	)

Definition at line 2267 of file scriptforge.py.

References OpenStormBento::CBenValue.GetProperty(), sdext::presenter::PresenterConfigurationAccess.GetProperty(), oox::drawingml::DrawingML.GetProperty(), chart::DataInterpreter.GetProperty(), SbModule.GetProperty(), SfxOleSection.GetProperty(), BaseFrameProperties_Impl.GetProperty(), Section.GetProperty(), LwpPara.GetProperty(), scriptforge.SFServices.GetProperty(), SvtLinguConfig.GetProperty(), SvtLinguConfigItem.GetProperty(), ScfPropertySet.GetProperty(), and access2base._BasicObject.GetProperty.

◆ Forms()

def scriptforge.SFDocuments.SF_Calc.Forms	(	self,
		sheetname,
		form = `''`
	)

Definition at line 2377 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), scriptforge.SFServices.flgArrayRet, and scriptforge.SFServices.vbMethod.

◆ GetColumnName()

def scriptforge.SFDocuments.SF_Calc.GetColumnName	(	self,
		columnnumber
	)

Definition at line 2380 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ GetFormula()

def scriptforge.SFDocuments.SF_Calc.GetFormula	(	self,
		range
	)

Definition at line 2383 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), scriptforge.SFServices.flgArrayRet, and scriptforge.SFServices.vbMethod.

◆ GetValue()

def scriptforge.SFDocuments.SF_Calc.GetValue	(	self,
		range
	)

Definition at line 2386 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), scriptforge.SFServices.flgArrayRet, and scriptforge.SFServices.vbMethod.

◆ Height()

def scriptforge.SFDocuments.SF_Calc.Height	(	self,
		rangename
	)

Definition at line 2270 of file scriptforge.py.

References OpenStormBento::CBenValue.GetProperty(), sdext::presenter::PresenterConfigurationAccess.GetProperty(), oox::drawingml::DrawingML.GetProperty(), chart::DataInterpreter.GetProperty(), SbModule.GetProperty(), SfxOleSection.GetProperty(), BaseFrameProperties_Impl.GetProperty(), Section.GetProperty(), LwpPara.GetProperty(), scriptforge.SFServices.GetProperty(), SvtLinguConfig.GetProperty(), SvtLinguConfigItem.GetProperty(), ScfPropertySet.GetProperty(), and access2base._BasicObject.GetProperty.

◆ ImportFromCSVFile()

def scriptforge.SFDocuments.SF_Calc.ImportFromCSVFile	(	self,
		filename,
		destinationcell,
		filteroptions = `ScriptForge.cstSymEmpty`
	)

Definition at line 2389 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ ImportFromDatabase()

def scriptforge.SFDocuments.SF_Calc.ImportFromDatabase	(	self,
		filename = `''`,
		registrationname = `''`,
		destinationcell = `''`,
		sqlcommand = `''`,
		directsql = `False`
	)

Definition at line 2392 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ InsertSheet()

def scriptforge.SFDocuments.SF_Calc.InsertSheet	(	self,
		sheetname,
		beforesheet = `32768`
	)

Definition at line 2397 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ LastCell()

def scriptforge.SFDocuments.SF_Calc.LastCell	(	self,
		rangename
	)

Definition at line 2273 of file scriptforge.py.

References OpenStormBento::CBenValue.GetProperty(), sdext::presenter::PresenterConfigurationAccess.GetProperty(), oox::drawingml::DrawingML.GetProperty(), chart::DataInterpreter.GetProperty(), SbModule.GetProperty(), SfxOleSection.GetProperty(), BaseFrameProperties_Impl.GetProperty(), Section.GetProperty(), LwpPara.GetProperty(), scriptforge.SFServices.GetProperty(), SvtLinguConfig.GetProperty(), SvtLinguConfigItem.GetProperty(), ScfPropertySet.GetProperty(), and access2base._BasicObject.GetProperty.

◆ LastColumn()

def scriptforge.SFDocuments.SF_Calc.LastColumn	(	self,
		rangename
	)

Definition at line 2276 of file scriptforge.py.

References OpenStormBento::CBenValue.GetProperty(), sdext::presenter::PresenterConfigurationAccess.GetProperty(), oox::drawingml::DrawingML.GetProperty(), chart::DataInterpreter.GetProperty(), SbModule.GetProperty(), SfxOleSection.GetProperty(), BaseFrameProperties_Impl.GetProperty(), Section.GetProperty(), LwpPara.GetProperty(), scriptforge.SFServices.GetProperty(), SvtLinguConfig.GetProperty(), SvtLinguConfigItem.GetProperty(), ScfPropertySet.GetProperty(), and access2base._BasicObject.GetProperty.

◆ LastRow()

def scriptforge.SFDocuments.SF_Calc.LastRow	(	self,
		rangename
	)

Definition at line 2279 of file scriptforge.py.

References OpenStormBento::CBenValue.GetProperty(), sdext::presenter::PresenterConfigurationAccess.GetProperty(), oox::drawingml::DrawingML.GetProperty(), chart::DataInterpreter.GetProperty(), SbModule.GetProperty(), SfxOleSection.GetProperty(), BaseFrameProperties_Impl.GetProperty(), Section.GetProperty(), LwpPara.GetProperty(), scriptforge.SFServices.GetProperty(), SvtLinguConfig.GetProperty(), SvtLinguConfigItem.GetProperty(), ScfPropertySet.GetProperty(), and access2base._BasicObject.GetProperty.

◆ MoveRange()

def scriptforge.SFDocuments.SF_Calc.MoveRange	(	self,
		source,
		destination
	)

Definition at line 2400 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ MoveSheet()

def scriptforge.SFDocuments.SF_Calc.MoveSheet	(	self,
		sheetname,
		beforesheet = `32768`
	)

Definition at line 2403 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ Offset()

def scriptforge.SFDocuments.SF_Calc.Offset	(	self,
		range,
		rows = `0`,
		columns = `0`,
		height = `ScriptForge.cstSymEmpty`,
		width = `ScriptForge.cstSymEmpty`
	)

Definition at line 2406 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ OpenRangeSelector()

def scriptforge.SFDocuments.SF_Calc.OpenRangeSelector	(	self,
		title = `''`,
		selection = `'~'`,
		singlecell = `False`,
		closeafterselect = `True`
	)

Definition at line 2410 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ Printf()

def scriptforge.SFDocuments.SF_Calc.Printf	(	self,
		inputstr,
		range,
		tokencharacter = `'%'`
	)

Definition at line 2413 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ PrintOut()

def scriptforge.SFDocuments.SF_Calc.PrintOut	(	self,
		sheetname = `'~'`,
		pages = `''`,
		copies = `1`
	)

Reimplemented from scriptforge.SFDocuments.SF_Document.

Definition at line 2416 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ Range()

def scriptforge.SFDocuments.SF_Calc.Range	(	self,
		rangename
	)

Definition at line 2282 of file scriptforge.py.

References OpenStormBento::CBenValue.GetProperty(), sdext::presenter::PresenterConfigurationAccess.GetProperty(), oox::drawingml::DrawingML.GetProperty(), chart::DataInterpreter.GetProperty(), SbModule.GetProperty(), SfxOleSection.GetProperty(), BaseFrameProperties_Impl.GetProperty(), Section.GetProperty(), LwpPara.GetProperty(), scriptforge.SFServices.GetProperty(), SvtLinguConfig.GetProperty(), SvtLinguConfigItem.GetProperty(), ScfPropertySet.GetProperty(), and access2base._BasicObject.GetProperty.

◆ Region()

def scriptforge.SFDocuments.SF_Calc.Region	(	self,
		rangename
	)

Definition at line 2285 of file scriptforge.py.

References OpenStormBento::CBenValue.GetProperty(), sdext::presenter::PresenterConfigurationAccess.GetProperty(), oox::drawingml::DrawingML.GetProperty(), chart::DataInterpreter.GetProperty(), SbModule.GetProperty(), SfxOleSection.GetProperty(), BaseFrameProperties_Impl.GetProperty(), Section.GetProperty(), LwpPara.GetProperty(), scriptforge.SFServices.GetProperty(), SvtLinguConfig.GetProperty(), SvtLinguConfigItem.GetProperty(), ScfPropertySet.GetProperty(), and access2base._BasicObject.GetProperty.

◆ RemoveDuplicates()

def scriptforge.SFDocuments.SF_Calc.RemoveDuplicates	(	self,
		range,
		columns = `1`,
		header = `False`,
		casesensitive = `False`,
		mode = `'COMPACT'`
	)

Definition at line 2419 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ RemoveSheet()

def scriptforge.SFDocuments.SF_Calc.RemoveSheet	(	self,
		sheetname
	)

Definition at line 2422 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ RenameSheet()

def scriptforge.SFDocuments.SF_Calc.RenameSheet	(	self,
		sheetname,
		newname
	)

Definition at line 2425 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ ReviewServiceArgs()

def scriptforge.SFDocuments.SF_Calc.ReviewServiceArgs	(	cls,
		windowname = `''`
	)

    Transform positional and keyword arguments into positional only

Reimplemented from scriptforge.SFDocuments.SF_Document.

Definition at line 2254 of file scriptforge.py.

◆ SetArray()

def scriptforge.SFDocuments.SF_Calc.SetArray	(	self,
		targetcell,
		value
	)

Definition at line 2428 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), scriptforge.SFServices.flgArrayArg, and scriptforge.SFServices.vbMethod.

◆ SetCellStyle()

def scriptforge.SFDocuments.SF_Calc.SetCellStyle	(	self,
		targetrange,
		style,
		filterformula = `''`,
		filterscope = `''`
	)

Definition at line 2431 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ SetFormula()

def scriptforge.SFDocuments.SF_Calc.SetFormula	(	self,
		targetrange,
		formula
	)

Definition at line 2434 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), scriptforge.SFServices.flgArrayArg, and scriptforge.SFServices.vbMethod.

◆ SetValue()

def scriptforge.SFDocuments.SF_Calc.SetValue	(	self,
		targetrange,
		value
	)

Definition at line 2437 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), scriptforge.SFServices.flgArrayArg, and scriptforge.SFServices.vbMethod.

◆ Sheet()

def scriptforge.SFDocuments.SF_Calc.Sheet	(	self,
		sheetname
	)

Definition at line 2288 of file scriptforge.py.

References OpenStormBento::CBenValue.GetProperty(), sdext::presenter::PresenterConfigurationAccess.GetProperty(), oox::drawingml::DrawingML.GetProperty(), chart::DataInterpreter.GetProperty(), SbModule.GetProperty(), SfxOleSection.GetProperty(), BaseFrameProperties_Impl.GetProperty(), Section.GetProperty(), LwpPara.GetProperty(), scriptforge.SFServices.GetProperty(), SvtLinguConfig.GetProperty(), SvtLinguConfigItem.GetProperty(), ScfPropertySet.GetProperty(), and access2base._BasicObject.GetProperty.

◆ SheetName()

def scriptforge.SFDocuments.SF_Calc.SheetName	(	self,
		rangename
	)

Definition at line 2291 of file scriptforge.py.

References OpenStormBento::CBenValue.GetProperty(), sdext::presenter::PresenterConfigurationAccess.GetProperty(), oox::drawingml::DrawingML.GetProperty(), chart::DataInterpreter.GetProperty(), SbModule.GetProperty(), SfxOleSection.GetProperty(), BaseFrameProperties_Impl.GetProperty(), Section.GetProperty(), LwpPara.GetProperty(), scriptforge.SFServices.GetProperty(), SvtLinguConfig.GetProperty(), SvtLinguConfigItem.GetProperty(), ScfPropertySet.GetProperty(), and access2base._BasicObject.GetProperty.

◆ ShiftDown()

def scriptforge.SFDocuments.SF_Calc.ShiftDown	(	self,
		range,
		wholerow = `False`,
		rows = `0`
	)

Definition at line 2440 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ ShiftLeft()

def scriptforge.SFDocuments.SF_Calc.ShiftLeft	(	self,
		range,
		wholecolumn = `False`,
		columns = `0`
	)

Definition at line 2443 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ ShiftRight()

def scriptforge.SFDocuments.SF_Calc.ShiftRight	(	self,
		range,
		wholecolumn = `False`,
		columns = `0`
	)

Definition at line 2446 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ ShiftUp()

def scriptforge.SFDocuments.SF_Calc.ShiftUp	(	self,
		range,
		wholerow = `False`,
		rows = `0`
	)

Definition at line 2449 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ SortRange()

def scriptforge.SFDocuments.SF_Calc.SortRange	(	self,
		range,
		sortkeys,
		sortorder = `'ASC'`,
		destinationcell = `ScriptForge.cstSymEmpty`,
		containsheader = `False`,
		casesensitive = `False`,
		sortcolumns = `False`
	)

Definition at line 2452 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), and scriptforge.SFServices.vbMethod.

◆ Width()

def scriptforge.SFDocuments.SF_Calc.Width	(	self,
		rangename
	)

Definition at line 2294 of file scriptforge.py.

References OpenStormBento::CBenValue.GetProperty(), sdext::presenter::PresenterConfigurationAccess.GetProperty(), oox::drawingml::DrawingML.GetProperty(), chart::DataInterpreter.GetProperty(), SbModule.GetProperty(), SfxOleSection.GetProperty(), BaseFrameProperties_Impl.GetProperty(), Section.GetProperty(), LwpPara.GetProperty(), scriptforge.SFServices.GetProperty(), SvtLinguConfig.GetProperty(), SvtLinguConfigItem.GetProperty(), ScfPropertySet.GetProperty(), and access2base._BasicObject.GetProperty.

◆ XCellRange()

def scriptforge.SFDocuments.SF_Calc.XCellRange	(	self,
		rangename
	)

Definition at line 2297 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), scriptforge.SFServices.flgUno, and scriptforge.SFServices.vbGet.

◆ XSheetCellCursor()

def scriptforge.SFDocuments.SF_Calc.XSheetCellCursor	(	self,
		rangename
	)

Definition at line 2300 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), scriptforge.SFServices.flgUno, and scriptforge.SFServices.vbGet.

◆ XSpreadsheet()

def scriptforge.SFDocuments.SF_Calc.XSpreadsheet	(	self,
		sheetname
	)

Definition at line 2303 of file scriptforge.py.

References scriptforge.SFServices.ExecMethod(), sfx2::SfxNotebookBar.ExecMethod(), scriptforge.SFServices.flgUno, and scriptforge.SFServices.vbGet.

Member Data Documentation

◆ forceGetProperty

bool scriptforge.SFDocuments.SF_Calc.forceGetProperty = True

static

Definition at line 2251 of file scriptforge.py.

◆ serviceimplementation

string scriptforge.SFDocuments.SF_Calc.serviceimplementation = 'basic'

static

Definition at line 2242 of file scriptforge.py.

Referenced by scriptforge.SFServices.__repr__(), scriptforge.SFServices.__setattr__(), scriptforge.SFServices.basicmethods(), scriptforge.SFServices.basicproperties(), scriptforge.SFServices.Dispose(), scriptforge.SFServices.GetProperty(), and scriptforge.SFServices.SetProperty().

◆ servicename

string scriptforge.SFDocuments.SF_Calc.servicename = 'SFDocuments.Calc'

static

Definition at line 2243 of file scriptforge.py.

Referenced by scriptforge.ScriptForge.__init__(), and scriptforge.SFServices.__repr__().

◆ serviceproperties

scriptforge.SFDocuments.SF_Calc.serviceproperties

static

Initial value:

=  dict(CurrentSelection = True, Sheets = False,
                                 Description = True, DocumentType = False, ExportFilters = False, FileSystem = False,
                                 ImportFilters = False, IsBase = False, IsCalc = False, IsDraw = False,
                                 IsFormDocument = False, IsImpress = False, IsMath = False, IsWriter = False,
                                 Keywords = True, Readonly = False, Subject = True, Title = True, XComponent = False)

Definition at line 2245 of file scriptforge.py.

Referenced by scriptforge.SFServices.__setattr__(), and scriptforge.SFServices.Properties().

◆ servicesynonyms

tuple scriptforge.SFDocuments.SF_Calc.servicesynonyms = ('calc', 'sfdocuments.calc')

static

Definition at line 2244 of file scriptforge.py.

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

scriptforge.py

Public Member Functions

Static Public Attributes

Additional Inherited Members

Detailed Description

Member Function Documentation

◆ A1Style()

◆ Activate()

◆ Charts()

◆ ClearAll()

◆ ClearFormats()

◆ ClearValues()

◆ CompactLeft()

◆ CompactUp()

◆ CopySheet()

◆ CopySheetFromFile()

◆ CopyToCell()

◆ CopyToRange()

◆ CreateChart()

◆ CreatePivotTable()

◆ DAvg()

◆ DCount()

◆ DMax()

◆ DMin()

◆ DSum()

◆ ExportRangeToFile()

◆ FirstCell()

◆ FirstColumn()

◆ FirstRow()

◆ Forms()

◆ GetColumnName()

◆ GetFormula()

◆ GetValue()

◆ Height()

◆ ImportFromCSVFile()

◆ ImportFromDatabase()

◆ InsertSheet()

◆ LastCell()

◆ LastColumn()

◆ LastRow()

◆ MoveRange()

◆ MoveSheet()

◆ Offset()

◆ OpenRangeSelector()

◆ Printf()

◆ PrintOut()

◆ Range()

◆ Region()

◆ RemoveDuplicates()

◆ RemoveSheet()

◆ RenameSheet()

◆ ReviewServiceArgs()

◆ SetArray()

◆ SetCellStyle()

◆ SetFormula()

◆ SetValue()

◆ Sheet()

◆ SheetName()

◆ ShiftDown()

◆ ShiftLeft()

◆ ShiftRight()

◆ ShiftUp()

◆ SortRange()

◆ Width()

◆ XCellRange()

◆ XSheetCellCursor()

◆ XSpreadsheet()

Member Data Documentation

◆ forceGetProperty

◆ serviceimplementation

◆ servicename

◆ serviceproperties

◆ servicesynonyms