-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathsec-table-menu.html
178 lines (178 loc) · 13.5 KB
/
sec-table-menu.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>The Table Menu</title>
<link rel="stylesheet" type="text/css" href="scidavis.css">
<meta name="generator" content="DocBook XSL Stylesheets V1.78.1">
<meta name="keywords" content="Qt, SciDAVis, Data, Analysis, Plotting">
<link rel="home" href="index.html" title="The SciDAVis Handbook">
<link rel="up" href="reference.html" title="Chapter 5. Command Reference">
<link rel="prev" href="sec-analysis-menu.html" title="The Analysis Menu">
<link rel="next" href="sec-matrix-menu.html" title="The Matrix Menu">
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF">
<div class="navheader">
<table width="100%" summary="Navigation header">
<tr><th colspan="3" align="center">The Table Menu</th></tr>
<tr>
<td width="20%" align="left">
<a accesskey="p" href="sec-analysis-menu.html">Prev</a> </td>
<th width="60%" align="center">Chapter 5. Command Reference</th>
<td width="20%" align="right"> <a accesskey="n" href="sec-matrix-menu.html">Next</a>
</td>
</tr>
</table>
<hr>
</div>
<div class="sect1">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="sec-table-menu"></a>The Table Menu</h2></div></div></div>
<p>This menu is only active when a table is selected. For a general presentation of the tables, refer to the <a class="xref" href="general-concepts.html#sec-intro-table" title="Tables">the section called “Tables”</a>.</p>
<div class="variablelist"><dl class="variablelist">
<dt>
<a name="set-column-as-cmd"></a><span class="term"><span class="command"><strong>Set Column as</strong></span></span>
</dt>
<dd>
<p>These commands are used to define the kind of data which is stored in the different columns of a table. They can also be accessed with the right mouse button when a column is selected in a table.</p>
<div class="variablelist"><dl class="variablelist">
<dt>
<a name="set-column-as-x-cmd"></a><span class="term"><span class="command"><strong>Set Column as→X</strong></span></span>
</dt>
<dd><p>Define the selected column as abscissae for the plots. You can define more than one column as X-values in a tables, they will be referenced as X1, X2, etc.</p></dd>
<dt>
<a name="set-column-as-y-cmd"></a><span class="term"><span class="command"><strong>Set Column as→Y</strong></span></span>
</dt>
<dd><p>In the case of 2D plots, this command defines the selected column as Y-values for the plots. In the case of 3D plots, Y columns can be used as the second abscissae.</p></dd>
<dt>
<a name="set-column-as-z-cmd"></a><span class="term"><span class="command"><strong>Set Column as→Z</strong></span></span>
</dt>
<dd><p>In the case of 3D plots, Z columns will be used as plotted values.</p></dd>
<dt>
<a name="set-column-as-x-error-cmd"></a><span class="term"><span class="command"><strong>Set Column as→X Error</strong></span></span>
</dt>
<dd><p>Define the selected column for use as error bars width for abscissae. Note that the column is not related to a specific X column, you will have to specify the link to specific X values when the plot will be built.</p></dd>
<dt>
<a name="set-column-as-y-error-cmd"></a><span class="term"><span class="command"><strong>Set Column as→Y Error</strong></span></span>
</dt>
<dd><p>Define the selected column for use as error bars for Y-values. Note that the column is not related to a specific Y column, you will have to specify the link to specific Y values when the plot will be built..</p></dd>
<dt>
<a name="set-column-as-none-cmd"></a><span class="term"><span class="command"><strong>Set Column as→None</strong></span></span>
</dt>
<dd><p>The selected column can be used in different ways in several plots (as X values, Y values, etc).</p></dd>
</dl></div>
</dd>
<dt>
<a name="fill-selection-with-cmd"></a><span class="term"><span class="command"><strong>Fill Selection With</strong></span></span>
</dt>
<dd>
<p>This command is used to fill the selected column with special values. It can be applied to a limited selection of cells. These commands does not assign formulas to cells, they just fill in the cells with values.</p>
<div class="variablelist"><dl class="variablelist">
<dt>
<a name="fill-selection-with-row-number-cmd"></a><span class="term"><span class="command"><strong>Fill Selection With→Row Numbers</strong></span></span>
</dt>
<dd><p>The filling is done with the number of the corresponding rows.</p></dd>
<dt>
<a name="fill-selection-with-random-values-cmd"></a><span class="term"><span class="command"><strong>Fill Selection With→Random Values</strong></span></span>
</dt>
<dd><p>The filling is done with random values between 0 and 1.</p></dd>
</dl></div>
</dd>
<dt>
<a name="show-comments-cmd"></a><span class="term"><span class="command"><strong>Show Comments</strong></span></span>
</dt>
<dd><p>If you select this command, the <span class="emphasis"><em>Comment</em></span> field of the columns will be shown under the names of the columns. The name of the command will then change to <span class="emphasis"><em>hide comments</em></span>. This command applies only to the selected table. See the <a class="xref" href="general-concepts.html#sec-intro-table" title="Tables">the section called “Tables”</a> for more details.</p></dd>
<dt>
<a name="hide-controls-cmd"></a><span class="term"><span class="command"><strong>Hide Controls</strong></span></span>
</dt>
<dd><p>If you select this command, the <span class="emphasis"><em>Parameters</em></span> part of the table will be shown. The name of the command will then change to <span class="emphasis"><em>hide controls</em></span>. This command applies only to the selected table. See the <a class="xref" href="general-concepts.html#sec-intro-table" title="Tables">the section called “Tables”</a> for more details.</p></dd>
<dt>
<a name="formula-edit-mode-cmd"></a><span class="term"><span class="command"><strong>Formula Edit Mode</strong></span></span>
</dt>
<dd><p>If you select this command, the formula used in the different columns of the table will be shown. This command applies only to the selected table. In this mode, the formula assigned to each cell can be viewed and edited. This allows to use different formulas on each row of a column. Then, you can switch back to the normal mode and used the <a class="link" href="sec-table-menu.html#recalculate-cmd"><span class="command"><strong>Recalculate</strong></span> command</a> to view the numbers resulting from these formulas.</p></dd>
<dt>
<a name="edit-column-description-cmd"></a><span class="term"><span class="command"><strong>Edit Column Description</strong></span></span>
</dt>
<dd><p>This command is just a shortcut to the <span class="emphasis"><em>Description</em></span> tab of the table. See the <a class="xref" href="general-concepts.html#sec-intro-table" title="Tables">the section called “Tables”</a> for details.</p></dd>
<dt>
<a name="change-column-format-cmd"></a><span class="term"><span class="command"><strong>Change Type & Format</strong></span></span>
</dt>
<dd><p>This command is just a shortcut to the <span class="emphasis"><em>Type</em></span> tab of the table. See the <a class="xref" href="general-concepts.html#sec-intro-table" title="Tables">the section called “Tables”</a> for details.</p></dd>
<dt>
<a name="clear-table-cmd"></a><span class="term"><span class="command"><strong>Clear Table</strong></span></span>
</dt>
<dd><p>Removes all the values of the selected table. There is no confirmation window for this command, but you can use the <a class="link" href="sec-edit-menu.html#undo-cmd"><span class="command"><strong>Undo</strong></span> command</a> to cancel.</p></dd>
<dt>
<a name="sort-table-cmd"></a><span class="term"><span class="command"><strong>Sort Table</strong></span></span>
</dt>
<dd>
<p>This command is used to sort the table. If you choose the option separately, only the selected column is sorted. If you choose together, all the columns are sorted based on the specified leading column.</p>
<div class="informalfigure">
<a name="fig-sort-table"></a><div class="mediaobject"><img src="pics/sorting.png"></div>
</div>
</dd>
<dt>
<a name="assign-formula-cmd"></a><span class="term"><span class="command"><strong>Assign Formula</strong></span></span>
</dt>
<dd>
<a class="indexterm" name="idp1397626436"></a><p>This command is used to fill the selected column with the values resulting from a mathematical formula. This command will open the Formula tag in the properties dialog of the selected table. </p>
<p>The available mathematical functions (assuming you are using the default scripting language, muParser) are listed in the <a class="xref" href="scripting.html#sec-muParser" title="muParser">the section called “muParser”</a>. The special function <span class="emphasis"><em>col(x)</em></span> can be used to access to the values of the column x, where x can be the column's number (as in <span class="emphasis"><em>col(2)</em></span>) or its name in doublequotes (as in <span class="emphasis"><em>col("time")</em></span>).
You can also get values from other tables using the function <span class="emphasis"><em>tablecol(t,c)</em></span>, where t is the table's name in doublequotes and c is the column's number or name in doublequotes (example: <span class="emphasis"><em>tablecol("Table1","time")</em></span>).</p>
<p>The variables <code class="code">i</code> and <code class="code">j</code> can be used to access the current row and column numbers.
Similarly, <code class="code">sr</code> and <code class="code">er</code> represent the selected start and end row, respectively.
</p>
<p>Using Python as scripting language gives you even more possibilities, since you can not only use arbitrary Python code in the function body, but also access other objects within your project. For details, see <a class="xref" href="sec-python.html" title="Python">the section called “Python”</a>.</p>
<p>If you make some changes in the table, the values are not computed again. You have to explicitly tell SciDAVis to recalculate individual cells or whole columns or rows by selecting <a class="link" href="sec-table-menu.html#recalculate-cmd"><span class="command"><strong>Recalculate</strong></span> command</a> from their context menu or pressing <span class="keycode">CTRL+Return</span>.</p>
</dd>
<dt>
<a name="recalculate-cmd"></a><span class="term"><span class="command"><strong>Recalculate</strong></span></span>
</dt>
<dd><p>When you fill a column (named for example 'C1') with the results of a formula (by using the <a class="link" href="sec-table-menu.html#assign-formula-cmd"><span class="command"><strong>Assign Formula</strong></span> command</a>), the values of the column are calculated only once when you define the formula. If your formula depends on values of another column (name for example 'C2'), the values of 'C1' are not updated if you modify the values in 'C2'. This command is used to recalculate the values of the selected column.</p></dd>
<dt>
<a name="add-column-cmd"></a><span class="term"><span class="command"><strong>Add Column</strong></span></span>
</dt>
<dd><p>Adds a new column in the table. Whatever the selected column, the new one will be inserted at the right of the table after the last column. If you want to insert a column between two existing ones, select the column and use <span class="emphasis"><em>Insert Empty Columns</em></span> from the context menu. A new column will be created on the left of the selected column.</p></dd>
<dt>
<a name="table-dimensions-cmd"></a><span class="term"><span class="command"><strong>Dimensions</strong></span></span>
</dt>
<dd>
<p>Allows to define the number of columns in the table. Be carefull if you decrease the number of columns in a table, a number of columns will be removed and the data will be lost.</p>
<p>Allows to define the number of rows in the table. Be carefull if you decrease the number of rows in a table, a number of rows will be removed and the data will be lost.</p>
</dd>
<dt>
<a name="go-to-cell-cmd"></a><span class="term"><span class="command"><strong>Go To Cell</strong></span></span>
</dt>
<dd><p>Defines the active line in the selected table.</p></dd>
<dt>
<a name="table-export-ascii-cmd"></a><span class="term"><span class="command"><strong>Export Ascii</strong></span></span>
</dt>
<dd>
<p>This command can be used to export the selected table to an ascii text file. If you check the option <span class="emphasis"><em>All</em></span>, you will have to choose a directory in which one text file will be created for each table, the name of the files being the one of the tables.</p>
<div class="informalfigure">
<a name="fig-export-ascii-2"></a><div class="mediaobject"><img src="pics/export-ascii.png"></div>
</div>
</dd>
<dt>
<a name="convert-to-matrix-cmd"></a><span class="term"><span class="command"><strong>Convert to Matrix</strong></span></span>
</dt>
<dd><p>This command is used to convert a table into a matrix. It is mainly used to import data from files: the first step import data in a table, and the second one is the conversion of the table in a matrix.</p></dd>
</dl></div>
</div>
<div class="navfooter">
<hr>
<table width="100%" summary="Navigation footer">
<tr>
<td width="40%" align="left">
<a accesskey="p" href="sec-analysis-menu.html">Prev</a> </td>
<td width="20%" align="center"><a accesskey="u" href="reference.html">Up</a></td>
<td width="40%" align="right"> <a accesskey="n" href="sec-matrix-menu.html">Next</a>
</td>
</tr>
<tr>
<td width="40%" align="left" valign="top">The Analysis Menu </td>
<td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td>
<td width="40%" align="right" valign="top"> The Matrix Menu</td>
</tr>
</table>
</div>
</body>
</html>