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(), PartGui::ArcEngine.evaluate(), App::FunctionExpression.evaluate(), Spreadsheet_legacy.Spreadsheet.evaluate(), Mod.PartDesign.WizardShaft.SegmentFunction.SegmentFunction.evaluate(), Mod.PartDesign.WizardShaft.SegmentFunction.StressFunction.evaluate(), Mod.PartDesign.WizardShaft.SegmentFunction.TranslationFunction.evaluate(), Spreadsheet_legacy.Spreadsheet.isFunction(), importXLSX.FormulaTranslator.isKey(), Spreadsheet_legacy.Spreadsheet.isKey(), Py::Object.isNumeric(), Py::seqref< T >.isNumeric(), Py::mapref< T >.isNumeric(), and Spreadsheet_legacy.Spreadsheet.isNumeric().

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

◆ execute()

def Spreadsheet_legacy.Spreadsheet.execute	(	self,
		obj
	)

Referenced by draftobjects.facebinder.Facebinder.addSubobjects(), PathScripts.PathDressupDogbone.ObjectDressup.boneStateList(), ArchSite.Compass.buildCoordinates(), PathScripts.PathDressupHoldingTags.ObjectTagDressup.generateTags(), ArchPanel.PanelCut.getWires(), ArchSchedule.CommandArchSchedule.IsActive(), Mod.PartDesign.Scripts.DistanceBolt.DistanceBolt.onChanged(), Mod.PartDesign.Scripts.Epitrochoid.Epitrochoid.onChanged(), Mod.PartDesign.Scripts.Parallelepiped.Parallelepiped.onChanged(), Mod.PartDesign.Scripts.Parallelepiped.BoxCylinder.onChanged(), Mod.PartDesign.Scripts.Spring.MySpring.onChanged(), FeaturePython.DistanceBolt.onChanged(), PathScripts.PathStock.StockFromBase.onChanged(), PathScripts.PathStock.StockCreateBox.onChanged(), PathScripts.PathStock.StockCreateCylinder.onChanged(), draftobjects.draftlink.DraftLink.onDocumentRestored(), draftobjects.patharray.PathArray.onDocumentRestored(), and draftobjects.pathtwistedarray.PathTwistedArray.onDocumentRestored().

◆ 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 ifc4.ifctable.columns, KDL::Jacobian.columns(), KDL::JntArray.columns(), KDL::JntSpaceInertiaMatrix.columns(), ifc2x3.ifctable.rows, ifc4.ifctable.rows, KDL::Jacobian.rows(), KDL::JntArray.rows(), KDL::JntSpaceInertiaMatrix.rows(), and Spreadsheet_legacy.Spreadsheet.rows.