xref: /core/sc/uiconfig/scalc/ui/optformula.ui (revision 2d2974f2)
1<?xml version="1.0" encoding="UTF-8"?>
2<!-- Generated with glade 3.38.2 -->
3<interface domain="sc">
4  <requires lib="gtk+" version="3.20"/>
5  <!-- n-columns=1 n-rows=4 -->
6  <object class="GtkGrid" id="OptFormula">
7    <property name="visible">True</property>
8    <property name="can-focus">False</property>
9    <property name="hexpand">True</property>
10    <property name="border-width">6</property>
11    <property name="row-spacing">12</property>
12    <child>
13      <object class="GtkFrame" id="frame1">
14        <property name="visible">True</property>
15        <property name="can-focus">False</property>
16        <property name="label-xalign">0</property>
17        <property name="shadow-type">none</property>
18        <child>
19          <!-- n-columns=1 n-rows=2 -->
20          <object class="GtkGrid" id="grid3">
21            <property name="visible">True</property>
22            <property name="can-focus">False</property>
23            <property name="margin-start">12</property>
24            <property name="margin-top">6</property>
25            <property name="row-spacing">6</property>
26            <child>
27              <object class="GtkCheckButton" id="englishfuncname">
28                <property name="label" translatable="yes" context="optformula|englishfuncname">Use English function names</property>
29                <property name="visible">True</property>
30                <property name="can-focus">True</property>
31                <property name="receives-default">False</property>
32                <property name="use-underline">True</property>
33                <property name="draw-indicator">True</property>
34              </object>
35              <packing>
36                <property name="left-attach">0</property>
37                <property name="top-attach">1</property>
38              </packing>
39            </child>
40            <child>
41              <!-- n-columns=2 n-rows=1 -->
42              <object class="GtkGrid" id="grid5">
43                <property name="visible">True</property>
44                <property name="can-focus">False</property>
45                <property name="hexpand">True</property>
46                <property name="column-spacing">12</property>
47                <child>
48                  <object class="GtkComboBoxText" id="formulasyntax">
49                    <property name="visible">True</property>
50                    <property name="can-focus">False</property>
51                    <property name="hexpand">True</property>
52                  </object>
53                  <packing>
54                    <property name="left-attach">1</property>
55                    <property name="top-attach">0</property>
56                  </packing>
57                </child>
58                <child>
59                  <object class="GtkLabel" id="formulasyntaxlabel">
60                    <property name="visible">True</property>
61                    <property name="can-focus">False</property>
62                    <property name="label" translatable="yes" context="optformula|formulasyntaxlabel">Formula _syntax:</property>
63                    <property name="use-underline">True</property>
64                    <property name="mnemonic-widget">formulasyntax</property>
65                  </object>
66                  <packing>
67                    <property name="left-attach">0</property>
68                    <property name="top-attach">0</property>
69                  </packing>
70                </child>
71              </object>
72              <packing>
73                <property name="left-attach">0</property>
74                <property name="top-attach">0</property>
75              </packing>
76            </child>
77          </object>
78        </child>
79        <child type="label">
80          <object class="GtkLabel" id="label1">
81            <property name="visible">True</property>
82            <property name="can-focus">False</property>
83            <property name="label" translatable="yes" context="optformula|label1">Formula Options</property>
84            <attributes>
85              <attribute name="weight" value="bold"/>
86            </attributes>
87          </object>
88        </child>
89      </object>
90      <packing>
91        <property name="left-attach">0</property>
92        <property name="top-attach">0</property>
93      </packing>
94    </child>
95    <child>
96      <object class="GtkFrame" id="frame4">
97        <property name="visible">True</property>
98        <property name="can-focus">False</property>
99        <property name="label-xalign">0</property>
100        <property name="shadow-type">none</property>
101        <child>
102          <!-- n-columns=2 n-rows=3 -->
103          <object class="GtkGrid" id="grid4">
104            <property name="visible">True</property>
105            <property name="can-focus">False</property>
106            <property name="margin-start">12</property>
107            <property name="margin-top">6</property>
108            <property name="row-spacing">6</property>
109            <property name="column-spacing">12</property>
110            <child>
111              <object class="GtkLabel" id="label9">
112                <property name="visible">True</property>
113                <property name="can-focus">False</property>
114                <property name="label" translatable="yes" context="optformula|label9">Excel 2007 and newer:</property>
115                <property name="use-underline">True</property>
116                <property name="mnemonic-widget">ooxmlrecalc</property>
117                <property name="xalign">0</property>
118              </object>
119              <packing>
120                <property name="left-attach">0</property>
121                <property name="top-attach">0</property>
122              </packing>
123            </child>
124            <child>
125              <object class="GtkLabel" id="label10">
126                <property name="visible">True</property>
127                <property name="can-focus">False</property>
128                <property name="label" translatable="yes" context="optformula|label10">ODF spreadsheet (not saved by %PRODUCTNAME):</property>
129                <property name="use-underline">True</property>
130                <property name="mnemonic-widget">odfrecalc</property>
131                <property name="xalign">0</property>
132              </object>
133              <packing>
134                <property name="left-attach">0</property>
135                <property name="top-attach">1</property>
136              </packing>
137            </child>
138            <child>
139              <object class="GtkComboBoxText" id="ooxmlrecalc">
140                <property name="visible">True</property>
141                <property name="can-focus">False</property>
142                <property name="hexpand">True</property>
143                <items>
144                  <item translatable="yes" context="optformula|ooxmlrecalc">Always recalculate</item>
145                  <item translatable="yes" context="optformula|ooxmlrecalc">Never recalculate</item>
146                  <item translatable="yes" context="optformula|ooxmlrecalc">Prompt user</item>
147                </items>
148              </object>
149              <packing>
150                <property name="left-attach">1</property>
151                <property name="top-attach">0</property>
152              </packing>
153            </child>
154            <child>
155              <object class="GtkComboBoxText" id="odfrecalc">
156                <property name="visible">True</property>
157                <property name="can-focus">False</property>
158                <property name="hexpand">True</property>
159                <items>
160                  <item translatable="yes" context="optformula|odfrecalc">Always recalculate</item>
161                  <item translatable="yes" context="optformula|odfrecalc">Never recalculate</item>
162                  <item translatable="yes" context="optformula|odfrecalc">Prompt user</item>
163                </items>
164              </object>
165              <packing>
166                <property name="left-attach">1</property>
167                <property name="top-attach">1</property>
168              </packing>
169            </child>
170            <child>
171              <object class="GtkLabel" id="label5">
172                <property name="visible">True</property>
173                <property name="can-focus">False</property>
174                <property name="label" translatable="yes" context="optformula|label10">Optimal row height:</property>
175                <property name="use-underline">True</property>
176                <property name="mnemonic-widget">odfrecalc</property>
177                <property name="xalign">0</property>
178              </object>
179              <packing>
180                <property name="left-attach">0</property>
181                <property name="top-attach">2</property>
182              </packing>
183            </child>
184            <child>
185              <object class="GtkComboBoxText" id="rowheightrecalc">
186                <property name="visible">True</property>
187                <property name="can-focus">False</property>
188                <property name="hexpand">True</property>
189                <items>
190                  <item translatable="yes" context="optformula|odfrecalc">Always recalculate</item>
191                  <item translatable="yes" context="optformula|odfrecalc">Never recalculate</item>
192                  <item translatable="yes" context="optformula|odfrecalc">Prompt user</item>
193                </items>
194                <child internal-child="accessible">
195                  <object class="AtkObject" id="rowheightrecalc-atkobject">
196                    <property name="AtkObject::accessible-description" translatable="yes" context="optformula|extended_tip|rowheightrecalc">Define either we want to calculate the optimal row heights or we do not want at load time.</property>
197                  </object>
198                </child>
199              </object>
200              <packing>
201                <property name="left-attach">1</property>
202                <property name="top-attach">2</property>
203              </packing>
204            </child>
205          </object>
206        </child>
207        <child type="label">
208          <object class="GtkLabel" id="label4">
209            <property name="visible">True</property>
210            <property name="can-focus">False</property>
211            <property name="label" translatable="yes" context="optformula|label4">Recalculation on File Load</property>
212            <attributes>
213              <attribute name="weight" value="bold"/>
214            </attributes>
215          </object>
216        </child>
217      </object>
218      <packing>
219        <property name="left-attach">0</property>
220        <property name="top-attach">3</property>
221      </packing>
222    </child>
223    <child>
224      <object class="GtkFrame" id="frame2">
225        <property name="visible">True</property>
226        <property name="can-focus">False</property>
227        <property name="hexpand">True</property>
228        <property name="label-xalign">0</property>
229        <property name="shadow-type">none</property>
230        <child>
231          <!-- n-columns=1 n-rows=2 -->
232          <object class="GtkGrid" id="grid8">
233            <property name="visible">True</property>
234            <property name="can-focus">False</property>
235            <property name="margin-start">12</property>
236            <property name="margin-top">6</property>
237            <property name="hexpand">True</property>
238            <property name="row-spacing">6</property>
239            <child>
240              <object class="GtkRadioButton" id="calcdefault">
241                <property name="label" translatable="yes" context="optformula|calcdefault">Default settings</property>
242                <property name="visible">True</property>
243                <property name="can-focus">True</property>
244                <property name="receives-default">False</property>
245                <property name="use-underline">True</property>
246                <property name="active">True</property>
247                <property name="draw-indicator">True</property>
248              </object>
249              <packing>
250                <property name="left-attach">0</property>
251                <property name="top-attach">0</property>
252              </packing>
253            </child>
254            <child>
255              <!-- n-columns=2 n-rows=1 -->
256              <object class="GtkGrid" id="grid9">
257                <property name="visible">True</property>
258                <property name="can-focus">False</property>
259                <property name="column-spacing">12</property>
260                <child>
261                  <object class="GtkRadioButton" id="calccustom">
262                    <property name="label" translatable="yes" context="optformula|calccustom">Custom (conversion of text to numbers and more):</property>
263                    <property name="visible">True</property>
264                    <property name="can-focus">True</property>
265                    <property name="receives-default">False</property>
266                    <property name="use-underline">True</property>
267                    <property name="draw-indicator">True</property>
268                    <property name="group">calcdefault</property>
269                  </object>
270                  <packing>
271                    <property name="left-attach">0</property>
272                    <property name="top-attach">0</property>
273                  </packing>
274                </child>
275                <child>
276                  <object class="GtkButton" id="details">
277                    <property name="label" translatable="yes" context="optformula|details">Details…</property>
278                    <property name="visible">True</property>
279                    <property name="can-focus">True</property>
280                    <property name="receives-default">True</property>
281                    <property name="hexpand">True</property>
282                  </object>
283                  <packing>
284                    <property name="left-attach">1</property>
285                    <property name="top-attach">0</property>
286                  </packing>
287                </child>
288              </object>
289              <packing>
290                <property name="left-attach">0</property>
291                <property name="top-attach">1</property>
292              </packing>
293            </child>
294          </object>
295        </child>
296        <child type="label">
297          <object class="GtkLabel" id="label2">
298            <property name="visible">True</property>
299            <property name="can-focus">False</property>
300            <property name="label" translatable="yes" context="optformula|label2">Detailed Calculation Settings</property>
301            <attributes>
302              <attribute name="weight" value="bold"/>
303            </attributes>
304          </object>
305        </child>
306      </object>
307      <packing>
308        <property name="left-attach">0</property>
309        <property name="top-attach">2</property>
310      </packing>
311    </child>
312    <child>
313      <object class="GtkFrame" id="frame3">
314        <property name="visible">True</property>
315        <property name="can-focus">False</property>
316        <property name="hexpand">True</property>
317        <property name="label-xalign">0</property>
318        <property name="shadow-type">none</property>
319        <child>
320          <!-- n-columns=3 n-rows=3 -->
321          <object class="GtkGrid" id="grid7">
322            <property name="visible">True</property>
323            <property name="can-focus">False</property>
324            <property name="margin-start">12</property>
325            <property name="margin-top">6</property>
326            <property name="hexpand">True</property>
327            <property name="row-spacing">6</property>
328            <property name="column-spacing">12</property>
329            <child>
330              <object class="GtkLabel" id="label6">
331                <property name="visible">True</property>
332                <property name="can-focus">False</property>
333                <property name="label" translatable="yes" context="optformula|label6">_Function:</property>
334                <property name="use-underline">True</property>
335                <property name="mnemonic-widget">function</property>
336                <property name="xalign">0</property>
337              </object>
338              <packing>
339                <property name="left-attach">0</property>
340                <property name="top-attach">0</property>
341              </packing>
342            </child>
343            <child>
344              <object class="GtkLabel" id="label7">
345                <property name="visible">True</property>
346                <property name="can-focus">False</property>
347                <property name="label" translatable="yes" context="optformula|label7">Array co_lumn:</property>
348                <property name="use-underline">True</property>
349                <property name="mnemonic-widget">arraycolumn</property>
350                <property name="xalign">0</property>
351              </object>
352              <packing>
353                <property name="left-attach">0</property>
354                <property name="top-attach">1</property>
355              </packing>
356            </child>
357            <child>
358              <object class="GtkLabel" id="label8">
359                <property name="visible">True</property>
360                <property name="can-focus">False</property>
361                <property name="label" translatable="yes" context="optformula|label8">Array _row:</property>
362                <property name="use-underline">True</property>
363                <property name="mnemonic-widget">arrayrow</property>
364                <property name="xalign">0</property>
365              </object>
366              <packing>
367                <property name="left-attach">0</property>
368                <property name="top-attach">2</property>
369              </packing>
370            </child>
371            <child>
372              <object class="GtkEntry" id="function">
373                <property name="visible">True</property>
374                <property name="can-focus">True</property>
375                <property name="max-length">1</property>
376                <property name="activates-default">True</property>
377                <property name="width-chars">5</property>
378                <property name="max-width-chars">1</property>
379                <property name="truncate-multiline">True</property>
380              </object>
381              <packing>
382                <property name="left-attach">1</property>
383                <property name="top-attach">0</property>
384              </packing>
385            </child>
386            <child>
387              <object class="GtkEntry" id="arraycolumn">
388                <property name="visible">True</property>
389                <property name="can-focus">True</property>
390                <property name="max-length">1</property>
391                <property name="activates-default">True</property>
392                <property name="width-chars">5</property>
393                <property name="max-width-chars">1</property>
394                <property name="truncate-multiline">True</property>
395              </object>
396              <packing>
397                <property name="left-attach">1</property>
398                <property name="top-attach">1</property>
399              </packing>
400            </child>
401            <child>
402              <object class="GtkEntry" id="arrayrow">
403                <property name="visible">True</property>
404                <property name="can-focus">True</property>
405                <property name="max-length">1</property>
406                <property name="activates-default">True</property>
407                <property name="width-chars">5</property>
408                <property name="max-width-chars">1</property>
409                <property name="truncate-multiline">True</property>
410              </object>
411              <packing>
412                <property name="left-attach">1</property>
413                <property name="top-attach">2</property>
414              </packing>
415            </child>
416            <child>
417              <object class="GtkButton" id="reset">
418                <property name="label" translatable="yes" context="optformula|reset">Rese_t Separators Settings</property>
419                <property name="visible">True</property>
420                <property name="can-focus">True</property>
421                <property name="receives-default">True</property>
422                <property name="halign">end</property>
423                <property name="use-underline">True</property>
424              </object>
425              <packing>
426                <property name="left-attach">2</property>
427                <property name="top-attach">2</property>
428              </packing>
429            </child>
430            <child>
431              <placeholder/>
432            </child>
433            <child>
434              <placeholder/>
435            </child>
436          </object>
437        </child>
438        <child type="label">
439          <object class="GtkLabel" id="label3">
440            <property name="visible">True</property>
441            <property name="can-focus">False</property>
442            <property name="label" translatable="yes" context="optformula|label3">Separators</property>
443            <attributes>
444              <attribute name="weight" value="bold"/>
445            </attributes>
446          </object>
447        </child>
448      </object>
449      <packing>
450        <property name="left-attach">0</property>
451        <property name="top-attach">1</property>
452      </packing>
453    </child>
454    <child internal-child="accessible">
455      <object class="AtkObject" id="OptFormula-atkobject">
456        <property name="AtkObject::accessible-description" translatable="yes" context="extended_tip|OptFormula">Defines formula syntax options and loading options for Calc.</property>
457      </object>
458    </child>
459  </object>
460  <object class="GtkSizeGroup" id="sizegroup1">
461    <widgets>
462      <widget name="grid7"/>
463      <widget name="grid8"/>
464    </widgets>
465  </object>
466  <object class="GtkAdjustment" id="adjustment1">
467    <property name="lower">1</property>
468    <property name="upper">32000</property>
469    <property name="value">1</property>
470    <property name="step-increment">1</property>
471    <property name="page-increment">10</property>
472  </object>
473</interface>
474