Spreadsheet Controller/fr

Description
Cet outil ajoute un nouveau contrôleur de cellule objet à un tableur objet sélectionné. Le contrôleur peut alors extraire certaines valeurs de certains objets dans le document actif, et remplir une plage de cellules de la feuille de calcul hôte avec ces valeurs.

Utilisation

 * 1) Sélectionnez un  Tableur objet existant
 * 2) Appuyez sur le bouton
 * 3) Ajuster les propriétés nécessaires

Options

 * As soon as the needed properties are set, and objects corresponding to the filter properties are found, the values of the host spreadsheet are filled. There is no way to undo this operation at the moment.
 * The best way to set the properties of a cell controller object is to start from the bottom, setting the filter options first, and finishing with the starting cell. This way, you won't write to the spreadsheet before all the needed settings are set.

Properties

 * : The cell address to start automatic filling (ex: A5)
 * : Specifies if the values will fill cells horizontally or vertically from the starting cell
 * : If "Data Type" is set to "Get Property", you can indicate here a property of the filtered objects to be retrieved. You can specify nested properties by using a dot (ex: Shape.Volume)
 * : Specifies if you want to retrieve a property of the filtered objects, or to count them
 * : A pattern to look for in the label or type of the objects in the document. For example, setting this value to "Struct" will get all objects containing Struct in their name, such as Structure001
 * : Specifies if the filter must be applied to the object label or type.

Scripting
Spreadsheets can be created from python scripts and macros using the makeSpreadsheetController 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 host spreadsheet.