86 lines
5.8 KiB
HTML
86 lines
5.8 KiB
HTML
<html><head><title>Spreadsheet PropertyController</title><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><link type='text/css' href='wiki.css' rel='stylesheet'></head><body><h1>Spreadsheet PropertyController</h1></div>
|
|
|
|
<div id="mw-content-text" lang="en" dir="ltr" class="mw-content-ltr"><div class="mw-parser-output"><div id="itsfree" style="text-align:center;color:black;background:#FDE0A8;margin:1em 7em;padding:0.5em 2em;border:2px solid #FF5706;">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.</div>
|
|
<p><br />
|
|
</p>
|
|
<table class="fcinfobox wikitable ct" >
|
|
<tr>
|
|
<td class="ctTitle">
|
|
<h3><span class="mw-headline" id="Spreadsheet_PropertyController"><a href="https://www.freecadweb.org/wiki/index.php?title=File:Spreadsheet_PropertyController.png" class="image"><img alt="Spreadsheet PropertyController.png" src="32px-Spreadsheet_PropertyController.png" width="32" height="32" srcset="/wiki/images/thumb/d/df/Spreadsheet_PropertyController.png/48px-Spreadsheet_PropertyController.png 1.5x, /wiki/images/d/df/Spreadsheet_PropertyController.png 2x" /></a> Spreadsheet PropertyController</span></h3>
|
|
</td></tr>
|
|
<tr>
|
|
<th class="ctOdd">Menu location
|
|
</th></tr>
|
|
<tr>
|
|
<td class="ctEven">Spreadsheet → Property Controller
|
|
</td></tr>
|
|
<tr>
|
|
<th class="ctOdd">Workbenches
|
|
</th></tr>
|
|
<tr>
|
|
<td class="ctEven"><a href="Spreadsheet_Module.html" class="mw-redirect" title="Spreadsheet Module">Spreadsheet</a>
|
|
</td></tr>
|
|
<tr>
|
|
<th class="ctOdd">Default shortcut
|
|
</th></tr>
|
|
<tr>
|
|
<td class="ctEven">None
|
|
</td></tr>
|
|
<tr>
|
|
<th class="ctOdd">See also
|
|
</th></tr>
|
|
<tr>
|
|
<td class="ctEven"><a href="Spreadsheet_Controller.html" title="Spreadsheet Controller">Spreadsheet Controller</a>
|
|
</td></tr>
|
|
<tr>
|
|
<td class="ctToc"><br /><div id="toc" class="toc"><div class="toctitle"><h2>Contents</h2></div>
|
|
<ul>
|
|
<li class="toclevel-1"><a href="#Spreadsheet_PropertyController"><span class="tocnumber">1</span> <span class="toctext">Spreadsheet PropertyController</span></a></li>
|
|
<li class="toclevel-1 tocsection-1"><a href="#Description"><span class="tocnumber">2</span> <span class="toctext">Description</span></a></li>
|
|
<li class="toclevel-1 tocsection-2"><a href="#How_to_use"><span class="tocnumber">3</span> <span class="toctext">How to use</span></a></li>
|
|
<li class="toclevel-1 tocsection-3"><a href="#Properties"><span class="tocnumber">4</span> <span class="toctext">Properties</span></a></li>
|
|
<li class="toclevel-1 tocsection-4"><a href="#Scripting"><span class="tocnumber">5</span> <span class="toctext">Scripting</span></a></li>
|
|
<li class="toclevel-1 tocsection-5"><a href="#Limitations"><span class="tocnumber">6</span> <span class="toctext">Limitations</span></a></li>
|
|
</ul>
|
|
</div>
|
|
|
|
</td></tr></table>
|
|
<p><br />
|
|
</p>
|
|
<h2><span class="mw-headline" id="Description">Description</span></h2>
|
|
<p>This tool adds a new property controller object to a selected <a href="Spreadsheet_Create.html" title="Spreadsheet Create">spreadsheet</a> 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.
|
|
</p>
|
|
<h2><span class="mw-headline" id="How_to_use">How to use</span></h2>
|
|
<ol><li> Select an existing <a href="Spreadsheet_Create.html" title="Spreadsheet Create">spreadsheet</a> object</li>
|
|
<li> Press the <span style="background: #DDDDDD; border: 1px solid #888888; padding: 0px 5px 1px 5px;"><a href="https://www.freecadweb.org/wiki/index.php?title=File:Spreadsheet_PropertyController.png" class="image"><img alt="Spreadsheet PropertyController.png" src="16px-Spreadsheet_PropertyController.png" width="16" height="16" srcset="/wiki/images/thumb/d/df/Spreadsheet_PropertyController.png/24px-Spreadsheet_PropertyController.png 1.5x, 32px-Spreadsheet_PropertyController.png 2x" /></a> <a class="mw-selflink selflink">Property Controller</a></span> button</li>
|
|
<li> Adjust the needed properties</li></ol>
|
|
<h2><span class="mw-headline" id="Properties">Properties</span></h2>
|
|
<ul><li> <span style="font-size: 0.6em;padding-right:10px;">DATA</span><b>Target Type</b>: The type of item to control: a property of the target object, or a datum-based constraint if the target object is a sketch</li>
|
|
<li> <span style="font-size: 0.6em;padding-right:10px;">DATA</span><b>Target Object</b>: The object to be controlled</li>
|
|
<li> <span style="font-size: 0.6em;padding-right:10px;">DATA</span><b>Target Property</b>: The name of the property to control, or the number of the datum-based constraint</li>
|
|
<li> <span style="font-size: 0.6em;padding-right:10px;">DATA</span><b>Cell</b>: The cell from the host spreadsheet to take the value from</li></ul>
|
|
<h2><span class="mw-headline" id="Scripting">Scripting</span></h2>
|
|
<p>Spreadsheets can be created from python scripts and <a href="Macros.html" title="Macros">macros</a> using the makeSpreadsheetPropertyController() function:
|
|
</p>
|
|
<div class="mw-highlight mw-content-ltr" dir="ltr"><pre> import Spreadsheet
|
|
mySpreadsheet = Spreadsheet.makeSpreadsheet()
|
|
controller = Spreadsheet.makeSpreadsheetPropertyController(mySpreadsheet)</pre></div>
|
|
<h2><span class="mw-headline" id="Limitations">Limitations</span></h2>
|
|
<ul><li> This tool is not available below FreeCAD version 0.14</li>
|
|
<li> Currently it is not possible to undo the changes that a controller does to its controlled object.</li></ul>
|
|
<div style="clear:both"></div>
|
|
</div>
|
|
|
|
|
|
|
|
</div>
|
|
|
|
</div><div class="printfooter">
|
|
Online version: "<a dir="ltr" href="https://www.freecadweb.org/wiki/index.php?title=Spreadsheet_PropertyController&oldid=282401">http://www.freecadweb.org/wiki/index.php?title=Spreadsheet_PropertyController&oldid=282401</a>"</div>
|
|
<div id="catlinks" class="catlinks" data-mw="interface"></div><div class="visualClear"></div>
|
|
</div>
|
|
</div>
|
|
<div id="mw-navigation">
|
|
<h2>Navigation menu</h2>
|
|
|
|
</body></html> |