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=
"GtkTreeStore" id=
"liststore1">
7 <!-- column-name text -->
8 <column type=
"gchararray"/>
9 <!-- column-name text2 -->
10 <column type=
"gchararray"/>
11 <!-- column-name text1 -->
12 <column type=
"gchararray"/>
13 <!-- column-name id -->
14 <column type=
"gchararray"/>
17 <object class=
"GtkDialog" id=
"ManageNamesDialog">
18 <property name=
"can_focus">False
</property>
19 <property name=
"border_width">6</property>
20 <property name=
"title" translatable=
"yes" context=
"managenamesdialog|ManageNamesDialog">Manage Names
</property>
21 <property name=
"default_width">0</property>
22 <property name=
"default_height">0</property>
23 <property name=
"type_hint">dialog
</property>
24 <child internal-child=
"vbox">
25 <object class=
"GtkBox" id=
"dialog-vbox1">
26 <property name=
"can_focus">False
</property>
27 <property name=
"orientation">vertical
</property>
28 <property name=
"spacing">12</property>
29 <child internal-child=
"action_area">
30 <object class=
"GtkButtonBox" id=
"dialog-action_area1">
31 <property name=
"can_focus">False
</property>
32 <property name=
"layout_style">end
</property>
34 <object class=
"GtkButton" id=
"ok">
35 <property name=
"label" translatable=
"yes" context=
"stock">_OK
</property>
36 <property name=
"visible">True
</property>
37 <property name=
"can_focus">True
</property>
38 <property name=
"can_default">True
</property>
39 <property name=
"has_default">True
</property>
40 <property name=
"receives_default">True
</property>
41 <property name=
"use-underline">True
</property>
42 <child internal-child=
"accessible">
43 <object class=
"AtkObject" id=
"ok-atkobject">
44 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"managenamesdialog|extended_tip|ok">Saves all changes and closes dialog.
</property>
49 <property name=
"expand">False
</property>
50 <property name=
"fill">True
</property>
51 <property name=
"position">0</property>
55 <object class=
"GtkButton" id=
"cancel">
56 <property name=
"label" translatable=
"yes" context=
"stock">_Cancel
</property>
57 <property name=
"visible">True
</property>
58 <property name=
"can_focus">True
</property>
59 <property name=
"receives_default">True
</property>
60 <property name=
"use-underline">True
</property>
61 <child internal-child=
"accessible">
62 <object class=
"AtkObject" id=
"cancel-atkobject">
63 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"managenamesdialog|extended_tip|cancel">Closes dialog and discards all changes.
</property>
68 <property name=
"expand">False
</property>
69 <property name=
"fill">True
</property>
70 <property name=
"position">1</property>
74 <object class=
"GtkButton" id=
"help">
75 <property name=
"label" translatable=
"yes" context=
"stock">_Help
</property>
76 <property name=
"visible">True
</property>
77 <property name=
"can_focus">True
</property>
78 <property name=
"receives_default">True
</property>
79 <property name=
"use-underline">True
</property>
82 <property name=
"expand">False
</property>
83 <property name=
"fill">True
</property>
84 <property name=
"position">2</property>
85 <property name=
"secondary">True
</property>
90 <property name=
"expand">False
</property>
91 <property name=
"fill">True
</property>
92 <property name=
"pack_type">end
</property>
93 <property name=
"position">0</property>
97 <object class=
"GtkBox" id=
"box1">
98 <property name=
"visible">True
</property>
99 <property name=
"can_focus">False
</property>
100 <property name=
"orientation">vertical
</property>
101 <property name=
"spacing">12</property>
103 <object class=
"GtkBox" id=
"box6">
104 <property name=
"visible">True
</property>
105 <property name=
"can_focus">False
</property>
106 <property name=
"hexpand">True
</property>
107 <property name=
"vexpand">True
</property>
108 <property name=
"orientation">vertical
</property>
110 <object class=
"GtkScrolledWindow">
111 <property name=
"visible">True
</property>
112 <property name=
"can_focus">True
</property>
113 <property name=
"hexpand">True
</property>
114 <property name=
"vexpand">True
</property>
115 <property name=
"shadow_type">in
</property>
117 <object class=
"GtkTreeView" id=
"names">
118 <property name=
"visible">True
</property>
119 <property name=
"can_focus">True
</property>
120 <property name=
"receives_default">True
</property>
121 <property name=
"hexpand">True
</property>
122 <property name=
"vexpand">True
</property>
123 <property name=
"model">liststore1
</property>
124 <property name=
"search_column">0</property>
125 <property name=
"show_expanders">False
</property>
126 <child internal-child=
"selection">
127 <object class=
"GtkTreeSelection" id=
"Macro Library List-selection1"/>
130 <object class=
"GtkTreeViewColumn" id=
"treeviewcolumn1">
131 <property name=
"resizable">True
</property>
132 <property name=
"spacing">6</property>
133 <property name=
"title" translatable=
"yes" context=
"managenamesdialog|name">Name
</property>
135 <object class=
"GtkCellRendererText" id=
"cellrenderer1"/>
137 <attribute name=
"text">0</attribute>
143 <object class=
"GtkTreeViewColumn" id=
"treeviewcolumn2">
144 <property name=
"resizable">True
</property>
145 <property name=
"spacing">6</property>
146 <property name=
"title" translatable=
"yes" context=
"managenamesdialog|expression">Range or formula expression
</property>
148 <object class=
"GtkCellRendererText" id=
"cellrenderer2"/>
150 <attribute name=
"text">1</attribute>
156 <object class=
"GtkTreeViewColumn" id=
"treeviewcolumn3">
157 <property name=
"resizable">True
</property>
158 <property name=
"spacing">6</property>
159 <property name=
"title" translatable=
"yes" context=
"managenamesdialog|scope">Scope
</property>
161 <object class=
"GtkCellRendererText" id=
"cellrenderer3"/>
163 <attribute name=
"text">2</attribute>
168 <child internal-child=
"accessible">
169 <object class=
"AtkObject" id=
"names-atkobject">
170 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"managenamesdialog|extended_tip|names">Select a named range or named formula from the list to modify its properties.
</property>
177 <property name=
"expand">True
</property>
178 <property name=
"fill">True
</property>
179 <property name=
"position">0</property>
184 <property name=
"expand">False
</property>
185 <property name=
"fill">True
</property>
186 <property name=
"position">0</property>
190 <object class=
"GtkLabel" id=
"info">
191 <property name=
"visible">True
</property>
192 <property name=
"can_focus">False
</property>
193 <property name=
"halign">start
</property>
194 <property name=
"label" translatable=
"yes" context=
"managenamesdialog|info">Select cells in the document to update the range.
</property>
197 <property name=
"expand">False
</property>
198 <property name=
"fill">True
</property>
199 <property name=
"position">1</property>
203 <!-- n-columns=1 n-rows=1 -->
204 <object class=
"GtkGrid" id=
"grid2">
205 <property name=
"visible">True
</property>
206 <property name=
"can_focus">False
</property>
207 <property name=
"hexpand">True
</property>
208 <property name=
"row_spacing">6</property>
209 <property name=
"column_spacing">6</property>
211 <object class=
"GtkLabel" id=
"label2">
212 <property name=
"visible">True
</property>
213 <property name=
"can_focus">False
</property>
214 <property name=
"halign">start
</property>
215 <property name=
"label" translatable=
"yes" context=
"managenamesdialog|label2">Name:
</property>
216 <property name=
"use_underline">True
</property>
217 <property name=
"xalign">0</property>
220 <property name=
"left_attach">0</property>
221 <property name=
"top_attach">0</property>
225 <object class=
"GtkLabel" id=
"label4">
226 <property name=
"visible">True
</property>
227 <property name=
"can_focus">False
</property>
228 <property name=
"halign">start
</property>
229 <property name=
"label" translatable=
"yes" context=
"managenamesdialog|label4">Scope:
</property>
230 <property name=
"use_underline">True
</property>
231 <property name=
"mnemonic_widget">scope
</property>
232 <property name=
"xalign">0</property>
235 <property name=
"left_attach">0</property>
236 <property name=
"top_attach">4</property>
240 <object class=
"GtkComboBoxText" id=
"scope">
241 <property name=
"visible">True
</property>
242 <property name=
"can_focus">False
</property>
243 <property name=
"hexpand">True
</property>
244 <child internal-child=
"accessible">
245 <object class=
"AtkObject" id=
"scope-atkobject">
246 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"managenamesdialog|extended_tip|scope">Select the scope of the named range or named formula. Document (Global) means the name is valid for the whole document.
</property>
251 <property name=
"left_attach">0</property>
252 <property name=
"top_attach">5</property>
256 <object class=
"GtkBox" id=
"box5">
257 <property name=
"visible">True
</property>
258 <property name=
"can_focus">False
</property>
259 <property name=
"hexpand">True
</property>
260 <property name=
"spacing">6</property>
262 <object class=
"GtkEntry" id=
"range">
263 <property name=
"visible">True
</property>
264 <property name=
"can_focus">True
</property>
265 <property name=
"hexpand">True
</property>
266 <property name=
"activates_default">True
</property>
267 <property name=
"width_chars">42</property>
268 <property name=
"truncate-multiline">True
</property>
269 <child internal-child=
"accessible">
270 <object class=
"AtkObject" id=
"range-atkobject">
271 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"managenamesdialog|extended_tip|range">The reference of the selected area name is shown here as an absolute value.
</property>
276 <property name=
"expand">False
</property>
277 <property name=
"fill">True
</property>
278 <property name=
"position">0</property>
282 <object class=
"GtkButton" id=
"assign">
283 <property name=
"visible">True
</property>
284 <property name=
"can_focus">True
</property>
285 <property name=
"receives_default">True
</property>
286 <child internal-child=
"accessible">
287 <object class=
"AtkObject" id=
"assign-atkobject">
288 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"managenamesdialog|extended_tip|assign">Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size.
</property>
293 <property name=
"expand">False
</property>
294 <property name=
"fill">True
</property>
295 <property name=
"position">1</property>
300 <property name=
"left_attach">0</property>
301 <property name=
"top_attach">3</property>
305 <object class=
"GtkLabel" id=
"label3">
306 <property name=
"visible">True
</property>
307 <property name=
"can_focus">False
</property>
308 <property name=
"halign">start
</property>
309 <property name=
"label" translatable=
"yes" context=
"managenamesdialog|label3">Range or formula expression:
</property>
310 <property name=
"use_underline">True
</property>
311 <property name=
"mnemonic_widget">range
</property>
312 <property name=
"xalign">0</property>
315 <property name=
"left_attach">0</property>
316 <property name=
"top_attach">2</property>
320 <object class=
"GtkEntry" id=
"name">
321 <property name=
"visible">True
</property>
322 <property name=
"can_focus">True
</property>
323 <property name=
"hexpand">True
</property>
324 <property name=
"activates_default">True
</property>
325 <property name=
"truncate-multiline">True
</property>
326 <child internal-child=
"accessible">
327 <object class=
"AtkObject" id=
"name-atkobject">
328 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"managenamesdialog|extended_tip|name">Enter the name of the area for which you want to define a reference or a formula expression.
</property>
333 <property name=
"left_attach">0</property>
334 <property name=
"top_attach">1</property>
339 <property name=
"expand">False
</property>
340 <property name=
"fill">True
</property>
341 <property name=
"position">2</property>
345 <object class=
"GtkExpander" id=
"more">
346 <property name=
"visible">True
</property>
347 <property name=
"can_focus">True
</property>
348 <property name=
"resize_toplevel">False
</property>
350 <!-- n-columns=1 n-rows=1 -->
351 <object class=
"GtkGrid" id=
"grid1">
352 <property name=
"visible">True
</property>
353 <property name=
"can_focus">False
</property>
354 <property name=
"row_spacing">6</property>
355 <property name=
"column_spacing">12</property>
356 <property name=
"column_homogeneous">True
</property>
357 <property name=
"margin-start">12</property>
358 <property name=
"margin-top">6</property>
360 <object class=
"GtkCheckButton" id=
"printrange">
361 <property name=
"label" translatable=
"yes" context=
"managenamesdialog|printrange">_Print range
</property>
362 <property name=
"visible">True
</property>
363 <property name=
"can_focus">True
</property>
364 <property name=
"receives_default">False
</property>
365 <property name=
"use_underline">True
</property>
366 <property name=
"draw_indicator">True
</property>
367 <child internal-child=
"accessible">
368 <object class=
"AtkObject" id=
"printrange-atkobject">
369 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"managenamesdialog|extended_tip|printrange">Defines the area as a print range.
</property>
374 <property name=
"left_attach">0</property>
375 <property name=
"top_attach">0</property>
379 <object class=
"GtkCheckButton" id=
"filter">
380 <property name=
"label" translatable=
"yes" context=
"managenamesdialog|filter">_Filter
</property>
381 <property name=
"visible">True
</property>
382 <property name=
"can_focus">True
</property>
383 <property name=
"receives_default">False
</property>
384 <property name=
"use_underline">True
</property>
385 <property name=
"draw_indicator">True
</property>
386 <child internal-child=
"accessible">
387 <object class=
"AtkObject" id=
"filter-atkobject">
388 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"managenamesdialog|extended_tip|filter">Defines the selected area to be used in an advanced filter.
</property>
393 <property name=
"left_attach">0</property>
394 <property name=
"top_attach">1</property>
398 <object class=
"GtkCheckButton" id=
"colheader">
399 <property name=
"label" translatable=
"yes" context=
"managenamesdialog|colheader">Repeat _column
</property>
400 <property name=
"visible">True
</property>
401 <property name=
"can_focus">True
</property>
402 <property name=
"receives_default">False
</property>
403 <property name=
"use_underline">True
</property>
404 <property name=
"draw_indicator">True
</property>
405 <child internal-child=
"accessible">
406 <object class=
"AtkObject" id=
"colheader-atkobject">
407 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"managenamesdialog|extended_tip|colheader">Defines the area as a repeating column.
</property>
412 <property name=
"left_attach">1</property>
413 <property name=
"top_attach">0</property>
417 <object class=
"GtkCheckButton" id=
"rowheader">
418 <property name=
"label" translatable=
"yes" context=
"managenamesdialog|rowheader">Repeat _row
</property>
419 <property name=
"visible">True
</property>
420 <property name=
"can_focus">True
</property>
421 <property name=
"receives_default">False
</property>
422 <property name=
"use_underline">True
</property>
423 <property name=
"draw_indicator">True
</property>
424 <child internal-child=
"accessible">
425 <object class=
"AtkObject" id=
"rowheader-atkobject">
426 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"managenamesdialog|extended_tip|rowheader">Defines the area as a repeating row.
</property>
431 <property name=
"left_attach">1</property>
432 <property name=
"top_attach">1</property>
438 <object class=
"GtkLabel" id=
"label1">
439 <property name=
"visible">True
</property>
440 <property name=
"can_focus">False
</property>
441 <property name=
"label" translatable=
"yes" context=
"managenamesdialog|label1">Range _Options
</property>
442 <property name=
"use_underline">True
</property>
445 <child internal-child=
"accessible">
446 <object class=
"AtkObject" id=
"more-atkobject">
447 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"managenamesdialog|extended_tip|more">Allows you to specify the Area type (optional) for the reference.
</property>
452 <property name=
"expand">False
</property>
453 <property name=
"fill">True
</property>
454 <property name=
"position">3</property>
458 <object class=
"GtkButtonBox" id=
"buttonbox1">
459 <property name=
"visible">True
</property>
460 <property name=
"can_focus">False
</property>
461 <property name=
"spacing">6</property>
462 <property name=
"layout_style">start
</property>
464 <object class=
"GtkButton" id=
"add">
465 <property name=
"label" translatable=
"yes" context=
"stock">_Add
</property>
466 <property name=
"visible">True
</property>
467 <property name=
"can_focus">True
</property>
468 <property name=
"receives_default">True
</property>
469 <property name=
"use-underline">True
</property>
470 <child internal-child=
"accessible">
471 <object class=
"AtkObject" id=
"add-atkobject">
472 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"managenamesdialog|extended_tip|add">Click the Add button to add a new defined name.
</property>
477 <property name=
"expand">False
</property>
478 <property name=
"fill">True
</property>
479 <property name=
"position">0</property>
483 <object class=
"GtkButton" id=
"delete">
484 <property name=
"label" translatable=
"yes" context=
"stock">_Delete
</property>
485 <property name=
"visible">True
</property>
486 <property name=
"can_focus">True
</property>
487 <property name=
"receives_default">True
</property>
488 <property name=
"use-underline">True
</property>
489 <child internal-child=
"accessible">
490 <object class=
"AtkObject" id=
"delete-atkobject">
491 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"managenamesdialog|extended_tip|delete">Deletes the selected element or elements without requiring confirmation.
</property>
496 <property name=
"expand">False
</property>
497 <property name=
"fill">True
</property>
498 <property name=
"position">1</property>
503 <property name=
"expand">False
</property>
504 <property name=
"fill">True
</property>
505 <property name=
"position">4</property>
510 <property name=
"expand">True
</property>
511 <property name=
"fill">True
</property>
512 <property name=
"position">1</property>
518 <action-widget response=
"-5">ok
</action-widget>
519 <action-widget response=
"-6">cancel
</action-widget>
520 <action-widget response=
"-11">help
</action-widget>
522 <child type=
"titlebar">
525 <child internal-child=
"accessible">
526 <object class=
"AtkObject" id=
"ManageNamesDialog-atkobject">
527 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"managenamesdialog|extended_tip|ManageNamesDialog">Opens a dialog where you can specify a name for a selected area or a name for a formula expression.
</property>
531 <object class=
"GtkTreeViewColumn" id=
"treeviewcolumn4">
532 <property name=
"title" translatable=
"yes" context=
"managenamesdialog|treeviewcolumn1">column
</property>