Spreadsheet PropertyController/en

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  button
 * 3) Adjust the needed properties

Properties

 * : The type of item to control: a property of the target object, or a datum-based constraint if the target object is a sketch
 * : The object to be controlled
 * : The name of the property to control, or the number of the datum-based constraint
 * : 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:

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.