LibreOffice Module wizards (master) 1
scriptforge.SFDocuments.SF_Calc Member List

This is the complete list of members for scriptforge.SFDocuments.SF_Calc, including all inherited members.

A1Style(self, row1, column1, row2=0, column2=0, sheetname='~')scriptforge.SFDocuments.SF_Calc
Activate(self, sheetname='')scriptforge.SFDocuments.SF_Calc
Charts(self, sheetname, chartname='')scriptforge.SFDocuments.SF_Calc
ClearAll(self, range, filterformula='', filterscope='')scriptforge.SFDocuments.SF_Calc
ClearFormats(self, range, filterformula='', filterscope='')scriptforge.SFDocuments.SF_Calc
ClearValues(self, range, filterformula='', filterscope='')scriptforge.SFDocuments.SF_Calc
CompactLeft(self, range, wholecolumn=False, filterformula='')scriptforge.SFDocuments.SF_Calc
CompactUp(self, range, wholerow=False, filterformula='')scriptforge.SFDocuments.SF_Calc
CopySheet(self, sheetname, newname, beforesheet=32768)scriptforge.SFDocuments.SF_Calc
CopySheetFromFile(self, filename, sheetname, newname, beforesheet=32768)scriptforge.SFDocuments.SF_Calc
CopyToCell(self, sourcerange, destinationcell)scriptforge.SFDocuments.SF_Calc
CopyToRange(self, sourcerange, destinationrange)scriptforge.SFDocuments.SF_Calc
CreateChart(self, chartname, sheetname, range, columnheader=False, rowheader=False)scriptforge.SFDocuments.SF_Calc
CreatePivotTable(self, pivottablename, sourcerange, targetcell, datafields=ScriptForge.cstSymEmpty, rowfields=ScriptForge.cstSymEmpty, columnfields=ScriptForge.cstSymEmpty, filterbutton=True, rowtotals=True, columntotals=True)scriptforge.SFDocuments.SF_Calc
DAvg(self, range)scriptforge.SFDocuments.SF_Calc
DCount(self, range)scriptforge.SFDocuments.SF_Calc
DMax(self, range)scriptforge.SFDocuments.SF_Calc
DMin(self, range)scriptforge.SFDocuments.SF_Calc
DSum(self, range)scriptforge.SFDocuments.SF_Calc
ExportRangeToFile(self, range, filename, imagetype='pdf', overwrite=False)scriptforge.SFDocuments.SF_Calc
FirstCell(self, rangename)scriptforge.SFDocuments.SF_Calc
FirstColumn(self, rangename)scriptforge.SFDocuments.SF_Calc
FirstRow(self, rangename)scriptforge.SFDocuments.SF_Calc
forceGetPropertyscriptforge.SFDocuments.SF_Calcstatic
Forms(self, sheetname, form='')scriptforge.SFDocuments.SF_Calc
GetColumnName(self, columnnumber)scriptforge.SFDocuments.SF_Calc
GetFormula(self, range)scriptforge.SFDocuments.SF_Calc
GetValue(self, range)scriptforge.SFDocuments.SF_Calc
Height(self, rangename)scriptforge.SFDocuments.SF_Calc
ImportFromCSVFile(self, filename, destinationcell, filteroptions=ScriptForge.cstSymEmpty)scriptforge.SFDocuments.SF_Calc
ImportFromDatabase(self, filename='', registrationname='', destinationcell='', sqlcommand='', directsql=False)scriptforge.SFDocuments.SF_Calc
InsertSheet(self, sheetname, beforesheet=32768)scriptforge.SFDocuments.SF_Calc
LastCell(self, rangename)scriptforge.SFDocuments.SF_Calc
LastColumn(self, rangename)scriptforge.SFDocuments.SF_Calc
LastRow(self, rangename)scriptforge.SFDocuments.SF_Calc
MoveRange(self, source, destination)scriptforge.SFDocuments.SF_Calc
MoveSheet(self, sheetname, beforesheet=32768)scriptforge.SFDocuments.SF_Calc
Offset(self, range, rows=0, columns=0, height=ScriptForge.cstSymEmpty, width=ScriptForge.cstSymEmpty)scriptforge.SFDocuments.SF_Calc
OpenRangeSelector(self, title='', selection='~', singlecell=False, closeafterselect=True)scriptforge.SFDocuments.SF_Calc
Printf(self, inputstr, range, tokencharacter='%')scriptforge.SFDocuments.SF_Calc
PrintOut(self, sheetname='~', pages='', copies=1)scriptforge.SFDocuments.SF_Calc
Range(self, rangename)scriptforge.SFDocuments.SF_Calc
Region(self, rangename)scriptforge.SFDocuments.SF_Calc
RemoveDuplicates(self, range, columns=1, header=False, casesensitive=False, mode='COMPACT')scriptforge.SFDocuments.SF_Calc
RemoveSheet(self, sheetname)scriptforge.SFDocuments.SF_Calc
RenameSheet(self, sheetname, newname)scriptforge.SFDocuments.SF_Calc
ReviewServiceArgs(cls, windowname='')scriptforge.SFDocuments.SF_Calc
serviceimplementationscriptforge.SFDocuments.SF_Calcstatic
servicenamescriptforge.SFDocuments.SF_Calcstatic
servicepropertiesscriptforge.SFDocuments.SF_Calcstatic
servicesynonymsscriptforge.SFDocuments.SF_Calcstatic
SetArray(self, targetcell, value)scriptforge.SFDocuments.SF_Calc
SetCellStyle(self, targetrange, style, filterformula='', filterscope='')scriptforge.SFDocuments.SF_Calc
SetFormula(self, targetrange, formula)scriptforge.SFDocuments.SF_Calc
SetValue(self, targetrange, value)scriptforge.SFDocuments.SF_Calc
Sheet(self, sheetname)scriptforge.SFDocuments.SF_Calc
SheetName(self, rangename)scriptforge.SFDocuments.SF_Calc
ShiftDown(self, range, wholerow=False, rows=0)scriptforge.SFDocuments.SF_Calc
ShiftLeft(self, range, wholecolumn=False, columns=0)scriptforge.SFDocuments.SF_Calc
ShiftRight(self, range, wholecolumn=False, columns=0)scriptforge.SFDocuments.SF_Calc
ShiftUp(self, range, wholerow=False, rows=0)scriptforge.SFDocuments.SF_Calc
SortRange(self, range, sortkeys, sortorder='ASC', destinationcell=ScriptForge.cstSymEmpty, containsheader=False, casesensitive=False, sortcolumns=False)scriptforge.SFDocuments.SF_Calc
Width(self, rangename)scriptforge.SFDocuments.SF_Calc
XCellRange(self, rangename)scriptforge.SFDocuments.SF_Calc
XSheetCellCursor(self, rangename)scriptforge.SFDocuments.SF_Calc
XSpreadsheet(self, sheetname)scriptforge.SFDocuments.SF_Calc