Spreadsheet_legacy.Spreadsheet Class Reference

Public Member Functions
def	evaluate (self, key)
def	execute (self, obj)
def	getCells (self, index)
def	getControlledCells (self, obj)
def	getControllingCells (self, obj)
def	getFunction (self, key)
def	getSize (self)
def	isFunction (self, key)
def	isKey (self, value)
def	isNumeric (self, key)
def	recompute (self, obj)
def	splitKey (self, key)

Public Attributes
	cols
	Object
	rows
	Type

Detailed Description

An object representing a spreadsheet. Can be used as a
FreeCAD object or as a standalone python object.
Cells of the spreadsheet can be got/set as arguments, as:

    myspreadsheet = Spreadsheet()
    myspreadsheet.a1 = 54
    print(myspreadsheet.a1)
    myspreadsheet.a2 = "My text"
    myspreadsheet.b1 = "=a1*3"
    print(myspreadsheet.b1)

The cell names are case-insensitive (a1 = A1)

Member Function Documentation

evaluate()

def Spreadsheet_legacy.Spreadsheet.evaluate	(		self,
			key
	)

References Spreadsheet_legacy.Spreadsheet._cells, MeshGui::SoFCMaterialEngine.evaluate(), Mod.PartDesign.WizardShaft.SegmentFunction.SegmentFunction.evaluate(), PartGui::ArcEngine.evaluate(), Mod.PartDesign.WizardShaft.SegmentFunction.StressFunction.evaluate(), App::FunctionExpression.evaluate(), Mod.PartDesign.WizardShaft.SegmentFunction.TranslationFunction.evaluate(), Spreadsheet_legacy.Spreadsheet.evaluate(), Spreadsheet_legacy.Spreadsheet.isFunction(), Spreadsheet_legacy.Spreadsheet.isKey(), Py::Object.isNumeric(), Spreadsheet_legacy.Spreadsheet.isNumeric(), Py::seqref< T >.isNumeric(), and Py::mapref< T >.isNumeric().

Referenced by Spreadsheet_legacy.Spreadsheet.evaluate(), and Spreadsheet_legacy.Spreadsheet.isNumeric().

execute()

def Spreadsheet_legacy.Spreadsheet.execute	(		self,
			obj
	)

Referenced by ArchSite.Compass.buildCoordinates(), ArchSchedule.CommandArchSchedule.IsActive(), and FeaturePython.DistanceBolt.onChanged().

getCells()

def Spreadsheet_legacy.Spreadsheet.getCells	(		self,
			index
	)

References Spreadsheet_legacy.Spreadsheet._cells, and Spreadsheet_legacy.Spreadsheet.splitKey().

getControlledCells()

def Spreadsheet_legacy.Spreadsheet.getControlledCells	(		self,
			obj
	)

getControllingCells()

def Spreadsheet_legacy.Spreadsheet.getControllingCells	(		self,
			obj
	)

getFunction()

def Spreadsheet_legacy.Spreadsheet.getFunction	(		self,
			key
	)

References Spreadsheet_legacy.Spreadsheet._cells.

getSize()

def Spreadsheet_legacy.Spreadsheet.getSize

(

self

)

References KDL::Jacobian.columns(), KDL::JntSpaceInertiaMatrix.columns(), KDL::JntArray.columns(), ifc4.ifctable.columns, Spreadsheet_legacy.Spreadsheet.rows, ifc2x3.ifctable.rows, and ifc4.ifctable.rows.

isFunction()

def Spreadsheet_legacy.Spreadsheet.isFunction	(		self,
			key
	)

Referenced by Spreadsheet_legacy.Spreadsheet.evaluate(), and Spreadsheet_legacy.Spreadsheet.isNumeric().

isKey()

def Spreadsheet_legacy.Spreadsheet.isKey	(		self,
			value
	)

Referenced by Spreadsheet_legacy.Spreadsheet.evaluate(), and importXLSX.FormulaTranslator.getNextToken().

isNumeric()

def Spreadsheet_legacy.Spreadsheet.isNumeric	(		self,
			key
	)

References Spreadsheet_legacy.Spreadsheet._cells, MeshGui::SoFCMaterialEngine.evaluate(), Mod.PartDesign.WizardShaft.SegmentFunction.SegmentFunction.evaluate(), PartGui::ArcEngine.evaluate(), Mod.PartDesign.WizardShaft.SegmentFunction.StressFunction.evaluate(), App::FunctionExpression.evaluate(), Mod.PartDesign.WizardShaft.SegmentFunction.TranslationFunction.evaluate(), Spreadsheet_legacy.Spreadsheet.evaluate(), and Spreadsheet_legacy.Spreadsheet.isFunction().

Referenced by Spreadsheet_legacy.Spreadsheet.evaluate().

recompute()

def Spreadsheet_legacy.Spreadsheet.recompute	(		self,
			obj
	)

splitKey()

def Spreadsheet_legacy.Spreadsheet.splitKey	(		self,
			key
	)

Referenced by Spreadsheet_legacy.Spreadsheet.getCells().

Member Data Documentation

cols

Spreadsheet_legacy.Spreadsheet.cols

Object

Spreadsheet_legacy.Spreadsheet.Object

Referenced by ArchPanel.CommandPanelSheet.Activated(), ArchSite.Compass.buildCoordinates(), Spreadsheet_legacy.ViewProviderSpreadsheet.claimChildren(), and ArchSchedule.CommandArchSchedule.IsActive().

rows

Spreadsheet_legacy.Spreadsheet.rows

Referenced by Spreadsheet_legacy.Spreadsheet.getSize().

Type

Spreadsheet_legacy.Spreadsheet.Type

Referenced by ArchPanel.CommandPanelSheet.Activated(), ArchStructure.StructSelectionObserver.addSelection(), ArchSite.Compass.buildCoordinates(), ArchSchedule.CommandArchSchedule.IsActive(), and ArchAxis.CommandArchGrid.IsActive().

---

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

• src/Mod/Spreadsheet/App/Spreadsheet_legacy.py