Spreadsheet PropertyController

From FreeCAD Documentation
Jump to: navigation, search
Other languages:
English • ‎français • ‎italiano • ‎română • ‎русский
This tool has been deprecated in version 0.15 because of the switch to the new C++-based spreadsheet workbench. This functionality will be reintroduced at a later time.


Spreadsheet PropertyController.png Spreadsheet PropertyController

Menu location
Spreadsheet → Property Controller
Workbenches
Spreadsheet
Default shortcut
None
Introduced in version
-
See also
Spreadsheet Controller


Description

This tool adds a new property controller object to a selected spreadsheet object. The controller can then manage a certain property of a certain object, and update it with the value of a cell from the spreadsheet, whenever that cell changes.

How to use

  1. Select an existing spreadsheet object
  2. Press the Spreadsheet PropertyController.png Property Controller button
  3. Adjust the needed properties

Properties

  • DATATarget Type: The type of item to control: a property of the target object, or a datum-based constraint if the target object is a sketch
  • DATATarget Object: The object to be controlled
  • DATATarget Property: The name of the property to control, or the number of the datum-based constraint
  • DATACell: The cell from the host spreadsheet to take the value from

Scripting

Spreadsheets can be created from python scripts and macros using the makeSpreadsheetPropertyController() function:

 import Spreadsheet
 mySpreadsheet = Spreadsheet.makeSpreadsheet()
 controller = Spreadsheet.makeSpreadsheetPropertyController(mySpreadsheet)

Limitations

  • This tool is not available below FreeCAD version 0.14
  • Currently it is not possible to undo the changes that a controller does to its controlled object.