Avoid potential negative array index access to cached text.
[LibreOffice.git] / sc / uiconfig / scalc / ui / optcalculatepage.ui
blobc26bd44341cbcf1fbb487110853ba9a2cead6ea5
1 <?xml version="1.0" encoding="UTF-8"?>
2 <!-- Generated with glade 3.36.0 -->
3 <interface domain="sc">
4 <requires lib="gtk+" version="3.20"/>
5 <object class="GtkAdjustment" id="adjustment1">
6 <property name="lower">1</property>
7 <property name="upper">32767</property>
8 <property name="value">100</property>
9 <property name="step_increment">1</property>
10 <property name="page_increment">10</property>
11 </object>
12 <object class="GtkAdjustment" id="adjustment2">
13 <property name="upper">20</property>
14 <property name="step_increment">1</property>
15 <property name="page_increment">10</property>
16 </object>
17 <!-- n-columns=1 n-rows=1 -->
18 <object class="GtkGrid" id="OptCalculatePage">
19 <property name="visible">True</property>
20 <property name="can_focus">False</property>
21 <property name="border_width">6</property>
22 <property name="row_spacing">12</property>
23 <property name="column_spacing">24</property>
24 <child>
25 <object class="GtkFrame" id="frame4">
26 <property name="visible">True</property>
27 <property name="can_focus">False</property>
28 <property name="label_xalign">0</property>
29 <property name="shadow_type">none</property>
30 <child>
31 <!-- n-columns=1 n-rows=1 -->
32 <object class="GtkGrid" id="grid4">
33 <property name="visible">True</property>
34 <property name="can_focus">False</property>
35 <property name="hexpand">True</property>
36 <property name="row_spacing">6</property>
37 <property name="column_spacing">12</property>
38 <property name="margin-start">12</property>
39 <property name="margin-top">6</property>
40 <child>
41 <object class="GtkCheckButton" id="threadingenabled">
42 <property name="label" translatable="yes" context="optcalculatepage|threadingenabled">Enable multi-threaded calculation</property>
43 <property name="visible">True</property>
44 <property name="can_focus">True</property>
45 <property name="receives_default">False</property>
46 <property name="tooltip_text" translatable="yes" context="optcalculatepage|threadingenabled|tooltip_text">Enable multi-threaded calculation of formula-groups</property>
47 <property name="use_underline">True</property>
48 <property name="draw_indicator">True</property>
49 </object>
50 <packing>
51 <property name="left_attach">0</property>
52 <property name="top_attach">0</property>
53 <property name="width">2</property>
54 </packing>
55 </child>
56 </object>
57 </child>
58 <child type="label">
59 <object class="GtkLabel" id="label4">
60 <property name="visible">True</property>
61 <property name="can_focus">False</property>
62 <property name="label" translatable="yes" context="optcalculatepage|label4">CPU Threading Settings</property>
63 <attributes>
64 <attribute name="weight" value="bold"/>
65 </attributes>
66 </object>
67 </child>
68 </object>
69 <packing>
70 <property name="left_attach">0</property>
71 <property name="top_attach">3</property>
72 <property name="width">2</property>
73 </packing>
74 </child>
75 <child>
76 <object class="GtkFrame" id="frame1">
77 <property name="visible">True</property>
78 <property name="can_focus">False</property>
79 <property name="label_xalign">0</property>
80 <property name="shadow_type">none</property>
81 <child>
82 <!-- n-columns=1 n-rows=1 -->
83 <object class="GtkGrid" id="grid3">
84 <property name="visible">True</property>
85 <property name="can_focus">False</property>
86 <property name="hexpand">True</property>
87 <property name="margin-start">12</property>
88 <property name="margin-top">6</property>
89 <child>
90 <object class="GtkCheckButton" id="case">
91 <property name="label" translatable="yes" context="optcalculatepage|case">Case se_nsitive</property>
92 <property name="visible">True</property>
93 <property name="can_focus">True</property>
94 <property name="receives_default">False</property>
95 <property name="tooltip_text" translatable="yes" context="optcalculatepage|case|tooltip_text">Disable case sensitivity for interoperability with Microsoft Excel</property>
96 <property name="use_underline">True</property>
97 <property name="draw_indicator">True</property>
98 <child internal-child="accessible">
99 <object class="AtkObject" id="case-atkobject">
100 <property name="AtkObject::accessible-description" translatable="yes" context="extended_tip|case">Specifies whether to distinguish between upper and lower case in texts when comparing cell contents.</property>
101 </object>
102 </child>
103 </object>
104 <packing>
105 <property name="left_attach">0</property>
106 <property name="top_attach">0</property>
107 </packing>
108 </child>
109 <child>
110 <object class="GtkCheckButton" id="calc">
111 <property name="label" translatable="yes" context="optcalculatepage|calc">_Precision as shown</property>
112 <property name="visible">True</property>
113 <property name="can_focus">True</property>
114 <property name="receives_default">False</property>
115 <property name="use_underline">True</property>
116 <property name="draw_indicator">True</property>
117 <child internal-child="accessible">
118 <object class="AtkObject" id="calc-atkobject">
119 <property name="AtkObject::accessible-description" translatable="yes" context="extended_tip|calc">Specifies whether to make calculations using the rounded values displayed in the sheet. Charts will be shown with the displayed values. If the Precision as shown option is not marked, the displayed numbers are rounded, but they are calculated internally using the non-rounded number.</property>
120 </object>
121 </child>
122 </object>
123 <packing>
124 <property name="left_attach">0</property>
125 <property name="top_attach">1</property>
126 </packing>
127 </child>
128 <child>
129 <object class="GtkCheckButton" id="match">
130 <property name="label" translatable="yes" context="optcalculatepage|match">Search criteria = and &lt;&gt; must apply to _whole cells</property>
131 <property name="visible">True</property>
132 <property name="can_focus">True</property>
133 <property name="receives_default">False</property>
134 <property name="tooltip_text" translatable="yes" context="optcalculatepage|match|tooltip_text">Keep this enabled for interoperability with Microsoft Excel or for better performance</property>
135 <property name="use_underline">True</property>
136 <property name="draw_indicator">True</property>
137 <child internal-child="accessible">
138 <object class="AtkObject" id="match-atkobject">
139 <property name="AtkObject::accessible-description" translatable="yes" context="extended_tip|match">Specifies that the search criteria you set for the Calc database functions must match the whole cell exactly. When both, the Search criteria = and &lt;&gt; must apply to whole cells box and the Enable wildcards in formulas box are marked, Calc behaves exactly as Microsoft Excel when searching cells in the database functions.</property>
140 </object>
141 </child>
142 </object>
143 <packing>
144 <property name="left_attach">0</property>
145 <property name="top_attach">2</property>
146 </packing>
147 </child>
148 <child>
149 <object class="GtkCheckButton" id="lookup">
150 <property name="label" translatable="yes" context="optcalculatepage|lookup">_Automatically find column and row labels</property>
151 <property name="visible">True</property>
152 <property name="can_focus">True</property>
153 <property name="receives_default">False</property>
154 <property name="use_underline">True</property>
155 <property name="draw_indicator">True</property>
156 <child internal-child="accessible">
157 <object class="AtkObject" id="lookup-atkobject">
158 <property name="AtkObject::accessible-description" translatable="yes" context="extended_tip|lookup">Specifies that you can use the text in any cell as a label for the column below the text or the row to the right of the text. The text must consist of at least one word and must not contain any operators.</property>
159 </object>
160 </child>
161 </object>
162 <packing>
163 <property name="left_attach">0</property>
164 <property name="top_attach">3</property>
165 </packing>
166 </child>
167 <child>
168 <object class="GtkCheckButton" id="generalprec">
169 <property name="label" translatable="yes" context="optcalculatepage|generalprec">_Limit decimals for general number format</property>
170 <property name="visible">True</property>
171 <property name="can_focus">True</property>
172 <property name="receives_default">False</property>
173 <property name="use_underline">True</property>
174 <property name="draw_indicator">True</property>
175 <child internal-child="accessible">
176 <object class="AtkObject" id="generalprec-atkobject">
177 <property name="AtkObject::accessible-description" translatable="yes" context="extended_tip|generalprec">You can specify the maximum number of decimal places that are shown by default for cells with General number format. If not enabled, cells with General number format show as many decimal places as the column width allows.</property>
178 </object>
179 </child>
180 </object>
181 <packing>
182 <property name="left_attach">0</property>
183 <property name="top_attach">4</property>
184 </packing>
185 </child>
186 <child>
187 <object class="GtkBox" id="box1">
188 <property name="visible">True</property>
189 <property name="can_focus">False</property>
190 <property name="spacing">6</property>
191 <property name="margin-start">18</property>
192 <child>
193 <object class="GtkLabel" id="precft">
194 <property name="visible">True</property>
195 <property name="can_focus">False</property>
196 <property name="label" translatable="yes" context="optcalculatepage|precft">_Decimal places:</property>
197 <property name="use_underline">True</property>
198 <property name="mnemonic_widget">prec</property>
199 </object>
200 <packing>
201 <property name="expand">False</property>
202 <property name="fill">True</property>
203 <property name="position">0</property>
204 </packing>
205 </child>
206 <child>
207 <object class="GtkSpinButton" id="prec">
208 <property name="visible">True</property>
209 <property name="can_focus">True</property>
210 <property name="activates_default">True</property>
211 <property name="adjustment">adjustment2</property>
212 <property name="truncate-multiline">True</property>
213 <child internal-child="accessible">
214 <object class="AtkObject" id="prec-atkobject">
215 <property name="AtkObject::accessible-description" translatable="yes" context="extended_tip|prec">Defines the number of decimals to be displayed for numbers with the General number format. The numbers are displayed as rounded numbers, but are not saved as rounded numbers.</property>
216 </object>
217 </child>
218 </object>
219 <packing>
220 <property name="expand">False</property>
221 <property name="fill">True</property>
222 <property name="position">1</property>
223 </packing>
224 </child>
225 </object>
226 <packing>
227 <property name="left_attach">0</property>
228 <property name="top_attach">5</property>
229 </packing>
230 </child>
231 </object>
232 </child>
233 <child type="label">
234 <object class="GtkLabel" id="label1">
235 <property name="visible">True</property>
236 <property name="can_focus">False</property>
237 <property name="label" translatable="yes" context="optcalculatepage|label1">General Calculations</property>
238 <attributes>
239 <attribute name="weight" value="bold"/>
240 </attributes>
241 </object>
242 </child>
243 </object>
244 <packing>
245 <property name="left_attach">0</property>
246 <property name="top_attach">1</property>
247 <property name="width">2</property>
248 </packing>
249 </child>
250 <child>
251 <object class="GtkFrame" id="frame2">
252 <property name="visible">True</property>
253 <property name="can_focus">False</property>
254 <property name="label_xalign">0</property>
255 <property name="shadow_type">none</property>
256 <child>
257 <object class="GtkBox">
258 <property name="visible">True</property>
259 <property name="can_focus">False</property>
260 <property name="orientation">vertical</property>
261 <property name="spacing">3</property>
262 <property name="margin-start">12</property>
263 <property name="margin-top">6</property>
264 <child>
265 <object class="GtkCheckButton" id="iterate">
266 <property name="label" translatable="yes" context="optcalculatepage|iterate">_Iterations</property>
267 <property name="visible">True</property>
268 <property name="can_focus">True</property>
269 <property name="receives_default">False</property>
270 <property name="use_underline">True</property>
271 <property name="draw_indicator">True</property>
272 <child internal-child="accessible">
273 <object class="AtkObject" id="iterate-atkobject">
274 <property name="AtkObject::accessible-description" translatable="yes" context="extended_tip|iterate">Specifies whether formulas with iterative references (formulas that are continuously repeated until the problem is solved) are calculated after a specific number of repetitions.</property>
275 </object>
276 </child>
277 </object>
278 <packing>
279 <property name="expand">False</property>
280 <property name="fill">True</property>
281 <property name="position">0</property>
282 </packing>
283 </child>
284 <child>
285 <!-- n-columns=1 n-rows=1 -->
286 <object class="GtkGrid" id="grid1">
287 <property name="visible">True</property>
288 <property name="can_focus">False</property>
289 <property name="row_spacing">3</property>
290 <property name="column_spacing">6</property>
291 <property name="margin-start">18</property>
292 <child>
293 <object class="GtkLabel" id="stepsft">
294 <property name="visible">True</property>
295 <property name="can_focus">False</property>
296 <property name="label" translatable="yes" context="optcalculatepage|stepsft">_Steps:</property>
297 <property name="use_underline">True</property>
298 <property name="mnemonic_widget">steps</property>
299 <property name="xalign">0</property>
300 </object>
301 <packing>
302 <property name="left_attach">0</property>
303 <property name="top_attach">0</property>
304 </packing>
305 </child>
306 <child>
307 <object class="GtkLabel" id="minchangeft">
308 <property name="visible">True</property>
309 <property name="can_focus">False</property>
310 <property name="label" translatable="yes" context="optcalculatepage|minchangeft">_Minimum change:</property>
311 <property name="use_underline">True</property>
312 <property name="mnemonic_widget">minchange</property>
313 <property name="xalign">0</property>
314 </object>
315 <packing>
316 <property name="left_attach">0</property>
317 <property name="top_attach">1</property>
318 </packing>
319 </child>
320 <child>
321 <object class="GtkSpinButton" id="steps">
322 <property name="visible">True</property>
323 <property name="can_focus">True</property>
324 <property name="activates_default">True</property>
325 <property name="adjustment">adjustment1</property>
326 <property name="truncate-multiline">True</property>
327 <child internal-child="accessible">
328 <object class="AtkObject" id="steps-atkobject">
329 <property name="AtkObject::accessible-description" translatable="yes" context="extended_tip|steps">Sets the maximum number of iteration steps.</property>
330 </object>
331 </child>
332 </object>
333 <packing>
334 <property name="left_attach">1</property>
335 <property name="top_attach">0</property>
336 </packing>
337 </child>
338 <child>
339 <object class="GtkEntry" id="minchange">
340 <property name="visible">True</property>
341 <property name="can_focus">True</property>
342 <property name="activates_default">True</property>
343 <property name="width_chars">12</property>
344 <property name="truncate-multiline">True</property>
345 <child internal-child="accessible">
346 <object class="AtkObject" id="minchange-atkobject">
347 <property name="AtkObject::accessible-description" translatable="yes" context="extended_tip|minchange">Specifies the difference between two consecutive iteration step results. If the result of the iteration is lower than the minimum change value, then the iteration will stop.</property>
348 </object>
349 </child>
350 </object>
351 <packing>
352 <property name="left_attach">1</property>
353 <property name="top_attach">1</property>
354 </packing>
355 </child>
356 </object>
357 <packing>
358 <property name="expand">False</property>
359 <property name="fill">True</property>
360 <property name="position">1</property>
361 </packing>
362 </child>
363 </object>
364 </child>
365 <child type="label">
366 <object class="GtkLabel" id="label2">
367 <property name="visible">True</property>
368 <property name="can_focus">False</property>
369 <property name="label" translatable="yes" context="optcalculatepage|label2">Iterative References</property>
370 <attributes>
371 <attribute name="weight" value="bold"/>
372 </attributes>
373 </object>
374 </child>
375 </object>
376 <packing>
377 <property name="left_attach">0</property>
378 <property name="top_attach">2</property>
379 <property name="width">2</property>
380 </packing>
381 </child>
382 <child>
383 <object class="GtkFrame" id="frame3">
384 <property name="visible">True</property>
385 <property name="can_focus">False</property>
386 <property name="label_xalign">0</property>
387 <property name="shadow_type">none</property>
388 <child>
389 <!-- n-columns=1 n-rows=1 -->
390 <object class="GtkGrid" id="grid2">
391 <property name="visible">True</property>
392 <property name="can_focus">False</property>
393 <property name="margin-start">12</property>
394 <property name="margin-top">6</property>
395 <child>
396 <object class="GtkRadioButton" id="datestd">
397 <property name="label" translatable="yes" context="optcalculatepage|datestd">12/30/1899 (defa_ult)</property>
398 <property name="visible">True</property>
399 <property name="can_focus">True</property>
400 <property name="receives_default">False</property>
401 <property name="tooltip_text" translatable="yes" context="optcalculatepage|datestd|tooltip_text">Value 0 corresponds to 12/30/1899</property>
402 <property name="use_underline">True</property>
403 <property name="active">True</property>
404 <property name="draw_indicator">True</property>
405 <child internal-child="accessible">
406 <object class="AtkObject" id="datestd-atkobject">
407 <property name="AtkObject::accessible-description" translatable="yes" context="extended_tip|datestd">Sets 12/30/1899 as day zero.</property>
408 </object>
409 </child>
410 </object>
411 <packing>
412 <property name="left_attach">0</property>
413 <property name="top_attach">0</property>
414 </packing>
415 </child>
416 <child>
417 <object class="GtkRadioButton" id="datesc10">
418 <property name="label" translatable="yes" context="optcalculatepage|datesc10">01/01/1900 (Star_Calc 1.0)</property>
419 <property name="visible">True</property>
420 <property name="can_focus">True</property>
421 <property name="receives_default">False</property>
422 <property name="tooltip_text" translatable="yes" context="optcalculatepage|datesc10|tooltip_text">Value 0 corresponds to 01/01/1900</property>
423 <property name="use_underline">True</property>
424 <property name="draw_indicator">True</property>
425 <property name="group">datestd</property>
426 <child internal-child="accessible">
427 <object class="AtkObject" id="datesc10-atkobject">
428 <property name="AtkObject::accessible-description" translatable="yes" context="extended_tip|datesc10">Sets 1/1/1900 as day zero. Use this setting for StarCalc 1.0 spreadsheets containing date entries.</property>
429 </object>
430 </child>
431 </object>
432 <packing>
433 <property name="left_attach">0</property>
434 <property name="top_attach">1</property>
435 </packing>
436 </child>
437 <child>
438 <object class="GtkRadioButton" id="date1904">
439 <property name="label" translatable="yes" context="optcalculatepage|date1904">_01/01/1904</property>
440 <property name="visible">True</property>
441 <property name="can_focus">True</property>
442 <property name="receives_default">False</property>
443 <property name="tooltip_text" translatable="yes" context="optcalculatepage|date1904|tooltip_text">0 corresponds to 01/01/1904</property>
444 <property name="use_underline">True</property>
445 <property name="draw_indicator">True</property>
446 <property name="group">datestd</property>
447 <child internal-child="accessible">
448 <object class="AtkObject" id="date1904-atkobject">
449 <property name="AtkObject::accessible-description" translatable="yes" context="extended_tip|date1904">Sets 1/1/1904 as day zero. Use this setting for spreadsheets that are imported in a foreign format.</property>
450 </object>
451 </child>
452 </object>
453 <packing>
454 <property name="left_attach">0</property>
455 <property name="top_attach">2</property>
456 </packing>
457 </child>
458 </object>
459 </child>
460 <child type="label">
461 <object class="GtkLabel" id="label3">
462 <property name="visible">True</property>
463 <property name="can_focus">False</property>
464 <property name="label" translatable="yes" context="optcalculatepage|label3">Date</property>
465 <attributes>
466 <attribute name="weight" value="bold"/>
467 </attributes>
468 </object>
469 </child>
470 </object>
471 <packing>
472 <property name="left_attach">1</property>
473 <property name="top_attach">0</property>
474 </packing>
475 </child>
476 <child>
477 <object class="GtkFrame" id="frame5">
478 <property name="visible">True</property>
479 <property name="can_focus">False</property>
480 <property name="label_xalign">0</property>
481 <property name="shadow_type">none</property>
482 <child>
483 <!-- n-columns=1 n-rows=1 -->
484 <object class="GtkGrid" id="grid5">
485 <property name="visible">True</property>
486 <property name="can_focus">False</property>
487 <property name="margin-start">12</property>
488 <property name="margin-top">6</property>
489 <child>
490 <object class="GtkRadioButton" id="formulawildcards">
491 <property name="label" translatable="yes" context="optcalculatepage|formulawildcards">Enable w_ildcards in formulas</property>
492 <property name="visible">True</property>
493 <property name="can_focus">True</property>
494 <property name="receives_default">False</property>
495 <property name="tooltip_text" translatable="yes" context="optcalculatepage|formulawildcards|tooltip_text">Enable wildcards for interoperability with Microsoft Excel</property>
496 <property name="use_underline">True</property>
497 <property name="active">True</property>
498 <property name="draw_indicator">True</property>
499 <child internal-child="accessible">
500 <object class="AtkObject" id="formulawildcards-atkobject">
501 <property name="AtkObject::accessible-description" translatable="yes" context="extended_tip|formulawildcards">Specifies that wildcards are enabled when searching and also for character string comparisons.</property>
502 </object>
503 </child>
504 </object>
505 <packing>
506 <property name="left_attach">0</property>
507 <property name="top_attach">0</property>
508 </packing>
509 </child>
510 <child>
511 <object class="GtkRadioButton" id="formularegex">
512 <property name="label" translatable="yes" context="optcalculatepage|formularegex">Enable r_egular expressions in formulas</property>
513 <property name="visible">True</property>
514 <property name="can_focus">True</property>
515 <property name="receives_default">False</property>
516 <property name="use_underline">True</property>
517 <property name="draw_indicator">True</property>
518 <property name="group">formulawildcards</property>
519 <child internal-child="accessible">
520 <object class="AtkObject" id="formularegex-atkobject">
521 <property name="AtkObject::accessible-description" translatable="yes" context="extended_tip|formularegex">Specifies that regular expressions instead of simple wildcards are enabled when searching and also for character string comparisons.</property>
522 </object>
523 </child>
524 </object>
525 <packing>
526 <property name="left_attach">0</property>
527 <property name="top_attach">1</property>
528 </packing>
529 </child>
530 <child>
531 <object class="GtkRadioButton" id="formulaliteral">
532 <property name="label" translatable="yes" context="optcalculatepage|formulaliteral">No wildcards or regular expressions in formulas</property>
533 <property name="visible">True</property>
534 <property name="can_focus">True</property>
535 <property name="receives_default">False</property>
536 <property name="use_underline">True</property>
537 <property name="draw_indicator">True</property>
538 <property name="group">formulawildcards</property>
539 <child internal-child="accessible">
540 <object class="AtkObject" id="formulaliteral-atkobject">
541 <property name="AtkObject::accessible-description" translatable="yes" context="extended_tip|formulaliteral">Specifies that only literal strings are used when searching and also for character string comparisons.</property>
542 </object>
543 </child>
544 </object>
545 <packing>
546 <property name="left_attach">0</property>
547 <property name="top_attach">2</property>
548 </packing>
549 </child>
550 </object>
551 </child>
552 <child type="label">
553 <object class="GtkLabel" id="label5">
554 <property name="visible">True</property>
555 <property name="can_focus">False</property>
556 <property name="label" translatable="yes" context="optcalculatepage|label5">Formulas Wildcards</property>
557 <attributes>
558 <attribute name="weight" value="bold"/>
559 </attributes>
560 </object>
561 </child>
562 </object>
563 <packing>
564 <property name="left_attach">0</property>
565 <property name="top_attach">0</property>
566 </packing>
567 </child>
568 </object>
569 </interface>