1 <?xml version=
"1.0" encoding=
"UTF-8"?>
2 <!-- Generated with glade 3.16.1 -->
4 <requires lib=
"gtk+" version=
"3.0"/>
5 <!-- interface-requires LibreOffice 1.0 -->
6 <object class=
"GtkDialog" id=
"ConsolidateDialog">
7 <property name=
"can_focus">False
</property>
8 <property name=
"border_width">6</property>
9 <property name=
"title" translatable=
"yes">Consolidate
</property>
10 <property name=
"resizable">False
</property>
11 <property name=
"type_hint">dialog
</property>
12 <child internal-child=
"vbox">
13 <object class=
"GtkBox" id=
"dialog-vbox1">
14 <property name=
"can_focus">False
</property>
15 <property name=
"hexpand">True
</property>
16 <property name=
"orientation">vertical
</property>
17 <property name=
"spacing">12</property>
18 <child internal-child=
"action_area">
19 <object class=
"GtkButtonBox" id=
"dialog-action_area1">
20 <property name=
"can_focus">False
</property>
21 <property name=
"hexpand">True
</property>
22 <property name=
"layout_style">end
</property>
24 <object class=
"GtkButton" id=
"ok">
25 <property name=
"label">gtk-ok
</property>
26 <property name=
"visible">True
</property>
27 <property name=
"can_focus">True
</property>
28 <property name=
"can_default">True
</property>
29 <property name=
"has_default">True
</property>
30 <property name=
"receives_default">True
</property>
31 <property name=
"use_stock">True
</property>
34 <property name=
"expand">False
</property>
35 <property name=
"fill">True
</property>
36 <property name=
"position">0</property>
40 <object class=
"GtkButton" id=
"cancel">
41 <property name=
"label">gtk-cancel
</property>
42 <property name=
"visible">True
</property>
43 <property name=
"can_focus">True
</property>
44 <property name=
"can_default">True
</property>
45 <property name=
"receives_default">True
</property>
46 <property name=
"use_stock">True
</property>
49 <property name=
"expand">False
</property>
50 <property name=
"fill">True
</property>
51 <property name=
"position">1</property>
55 <object class=
"GtkButton" id=
"help">
56 <property name=
"label">gtk-help
</property>
57 <property name=
"visible">True
</property>
58 <property name=
"can_focus">True
</property>
59 <property name=
"can_default">True
</property>
60 <property name=
"receives_default">True
</property>
61 <property name=
"use_stock">True
</property>
64 <property name=
"expand">False
</property>
65 <property name=
"fill">True
</property>
66 <property name=
"position">2</property>
67 <property name=
"secondary">True
</property>
72 <property name=
"expand">False
</property>
73 <property name=
"fill">True
</property>
74 <property name=
"pack_type">end
</property>
75 <property name=
"position">0</property>
79 <object class=
"GtkGrid" id=
"grid1">
80 <property name=
"visible">True
</property>
81 <property name=
"can_focus">False
</property>
82 <property name=
"hexpand">True
</property>
83 <property name=
"vexpand">True
</property>
84 <property name=
"row_spacing">6</property>
86 <object class=
"GtkLabel" id=
"label1">
87 <property name=
"visible">True
</property>
88 <property name=
"can_focus">False
</property>
89 <property name=
"hexpand">True
</property>
90 <property name=
"xalign">0</property>
91 <property name=
"label" translatable=
"yes">_Function:
</property>
92 <property name=
"use_underline">True
</property>
93 <property name=
"mnemonic_widget">func
</property>
96 <property name=
"left_attach">0</property>
97 <property name=
"top_attach">0</property>
98 <property name=
"width">1</property>
99 <property name=
"height">1</property>
103 <object class=
"GtkLabel" id=
"label2">
104 <property name=
"visible">True
</property>
105 <property name=
"can_focus">False
</property>
106 <property name=
"hexpand">True
</property>
107 <property name=
"xalign">0</property>
108 <property name=
"label" translatable=
"yes">_Consolidation ranges:
</property>
109 <property name=
"use_underline">True
</property>
110 <property name=
"mnemonic_widget">consareas:border
</property>
113 <property name=
"left_attach">0</property>
114 <property name=
"top_attach">2</property>
115 <property name=
"width">1</property>
116 <property name=
"height">1</property>
120 <object class=
"GtkComboBoxText" id=
"func">
121 <property name=
"visible">True
</property>
122 <property name=
"can_focus">False
</property>
123 <property name=
"hexpand">True
</property>
125 <item translatable=
"yes">Sum
</item>
126 <item translatable=
"yes">Count
</item>
127 <item translatable=
"yes">Average
</item>
128 <item translatable=
"yes">Max
</item>
129 <item translatable=
"yes">Min
</item>
130 <item translatable=
"yes">Product
</item>
131 <item translatable=
"yes">Count (numbers only)
</item>
132 <item translatable=
"yes">StDev (sample)
</item>
133 <item translatable=
"yes">StDevP (population)
</item>
134 <item translatable=
"yes">Var (sample)
</item>
135 <item translatable=
"yes">VarP (population)
</item>
139 <property name=
"left_attach">0</property>
140 <property name=
"top_attach">1</property>
141 <property name=
"width">1</property>
142 <property name=
"height">1</property>
146 <object class=
"GtkTreeView" id=
"consareas:border">
147 <property name=
"visible">True
</property>
148 <property name=
"can_focus">True
</property>
149 <property name=
"hexpand">True
</property>
150 <property name=
"vexpand">True
</property>
151 <child internal-child=
"selection">
152 <object class=
"GtkTreeSelection" id=
"treeview-selection1">
153 <property name=
"mode">multiple
</property>
158 <property name=
"left_attach">0</property>
159 <property name=
"top_attach">3</property>
160 <property name=
"width">1</property>
161 <property name=
"height">1</property>
166 <property name=
"expand">False
</property>
167 <property name=
"fill">True
</property>
168 <property name=
"position">1</property>
172 <object class=
"GtkGrid" id=
"grid2">
173 <property name=
"visible">True
</property>
174 <property name=
"can_focus">False
</property>
175 <property name=
"row_spacing">6</property>
177 <object class=
"GtkGrid" id=
"grid3">
178 <property name=
"visible">True
</property>
179 <property name=
"can_focus">False
</property>
180 <property name=
"hexpand">True
</property>
181 <property name=
"vexpand">True
</property>
182 <property name=
"column_spacing">12</property>
184 <object class=
"GtkComboBox" id=
"lbdataarea">
185 <property name=
"visible">True
</property>
186 <property name=
"can_focus">False
</property>
187 <property name=
"hexpand">True
</property>
190 <property name=
"left_attach">0</property>
191 <property name=
"top_attach">0</property>
192 <property name=
"width">1</property>
193 <property name=
"height">1</property>
197 <object class=
"foruilo-RefEdit" id=
"eddataarea">
198 <property name=
"visible">True
</property>
199 <property name=
"can_focus">True
</property>
200 <property name=
"hexpand">True
</property>
201 <property name=
"invisible_char">●
</property>
202 <property name=
"width_chars">50</property>
205 <property name=
"left_attach">1</property>
206 <property name=
"top_attach">0</property>
207 <property name=
"width">1</property>
208 <property name=
"height">1</property>
212 <object class=
"foruilo-RefButton" id=
"rbdataarea">
213 <property name=
"visible">True
</property>
214 <property name=
"can_focus">True
</property>
215 <property name=
"receives_default">True
</property>
221 <property name=
"left_attach">2</property>
222 <property name=
"top_attach">0</property>
223 <property name=
"width">1</property>
224 <property name=
"height">1</property>
229 <property name=
"left_attach">0</property>
230 <property name=
"top_attach">1</property>
231 <property name=
"width">1</property>
232 <property name=
"height">1</property>
236 <object class=
"GtkGrid" id=
"grid4">
237 <property name=
"visible">True
</property>
238 <property name=
"can_focus">False
</property>
239 <property name=
"hexpand">True
</property>
240 <property name=
"vexpand">True
</property>
241 <property name=
"column_spacing">12</property>
243 <object class=
"GtkComboBox" id=
"lbdestarea">
244 <property name=
"visible">True
</property>
245 <property name=
"can_focus">False
</property>
246 <property name=
"hexpand">True
</property>
249 <property name=
"left_attach">0</property>
250 <property name=
"top_attach">0</property>
251 <property name=
"width">1</property>
252 <property name=
"height">1</property>
256 <object class=
"foruilo-RefEdit" id=
"eddestarea">
257 <property name=
"visible">True
</property>
258 <property name=
"can_focus">True
</property>
259 <property name=
"hexpand">True
</property>
260 <property name=
"invisible_char">●
</property>
261 <property name=
"width_chars">50</property>
264 <property name=
"left_attach">1</property>
265 <property name=
"top_attach">0</property>
266 <property name=
"width">1</property>
267 <property name=
"height">1</property>
271 <object class=
"foruilo-RefButton" id=
"rbdestarea">
272 <property name=
"visible">True
</property>
273 <property name=
"can_focus">True
</property>
274 <property name=
"receives_default">True
</property>
280 <property name=
"left_attach">2</property>
281 <property name=
"top_attach">0</property>
282 <property name=
"width">1</property>
283 <property name=
"height">1</property>
288 <property name=
"left_attach">0</property>
289 <property name=
"top_attach">3</property>
290 <property name=
"width">1</property>
291 <property name=
"height">1</property>
295 <object class=
"GtkButtonBox" id=
"buttonbox1">
296 <property name=
"visible">True
</property>
297 <property name=
"can_focus">False
</property>
298 <property name=
"hexpand">True
</property>
299 <property name=
"spacing">12</property>
300 <property name=
"layout_style">center
</property>
302 <object class=
"GtkButton" id=
"add">
303 <property name=
"label">gtk-add
</property>
304 <property name=
"visible">True
</property>
305 <property name=
"can_focus">True
</property>
306 <property name=
"can_default">True
</property>
307 <property name=
"receives_default">True
</property>
308 <property name=
"use_stock">True
</property>
311 <property name=
"expand">False
</property>
312 <property name=
"fill">True
</property>
313 <property name=
"position">0</property>
317 <object class=
"GtkButton" id=
"delete">
318 <property name=
"label">gtk-delete
</property>
319 <property name=
"visible">True
</property>
320 <property name=
"can_focus">True
</property>
321 <property name=
"can_default">True
</property>
322 <property name=
"receives_default">True
</property>
323 <property name=
"use_stock">True
</property>
326 <property name=
"expand">False
</property>
327 <property name=
"fill">True
</property>
328 <property name=
"position">1</property>
333 <property name=
"left_attach">0</property>
334 <property name=
"top_attach">4</property>
335 <property name=
"width">1</property>
336 <property name=
"height">1</property>
340 <object class=
"GtkLabel" id=
"ftdataarea">
341 <property name=
"visible">True
</property>
342 <property name=
"can_focus">False
</property>
343 <property name=
"xalign">0</property>
344 <property name=
"label" translatable=
"yes">_Source data ranges:
</property>
345 <property name=
"use_underline">True
</property>
346 <property name=
"mnemonic_widget">lbdataarea
</property>
349 <property name=
"left_attach">0</property>
350 <property name=
"top_attach">0</property>
351 <property name=
"width">1</property>
352 <property name=
"height">1</property>
356 <object class=
"GtkLabel" id=
"ftdestarea">
357 <property name=
"visible">True
</property>
358 <property name=
"can_focus">False
</property>
359 <property name=
"xalign">0</property>
360 <property name=
"label" translatable=
"yes">Copy results _to:
</property>
361 <property name=
"use_underline">True
</property>
362 <property name=
"mnemonic_widget">lbdestarea
</property>
365 <property name=
"left_attach">0</property>
366 <property name=
"top_attach">2</property>
367 <property name=
"width">1</property>
368 <property name=
"height">1</property>
373 <property name=
"expand">False
</property>
374 <property name=
"fill">True
</property>
375 <property name=
"position">2</property>
379 <object class=
"GtkExpander" id=
"more">
380 <property name=
"visible">True
</property>
381 <property name=
"can_focus">True
</property>
382 <property name=
"hexpand">True
</property>
383 <property name=
"vexpand">True
</property>
385 <object class=
"GtkBox" id=
"box2">
386 <property name=
"visible">True
</property>
387 <property name=
"can_focus">False
</property>
388 <property name=
"margin_top">6</property>
389 <property name=
"hexpand">True
</property>
390 <property name=
"vexpand">True
</property>
391 <property name=
"spacing">12</property>
393 <object class=
"GtkFrame" id=
"frame1">
394 <property name=
"visible">True
</property>
395 <property name=
"can_focus">False
</property>
396 <property name=
"hexpand">True
</property>
397 <property name=
"vexpand">True
</property>
398 <property name=
"label_xalign">0</property>
399 <property name=
"shadow_type">none
</property>
401 <object class=
"GtkAlignment" id=
"alignment1">
402 <property name=
"visible">True
</property>
403 <property name=
"can_focus">False
</property>
404 <property name=
"hexpand">True
</property>
405 <property name=
"vexpand">True
</property>
406 <property name=
"top_padding">6</property>
407 <property name=
"left_padding">12</property>
409 <object class=
"GtkGrid" id=
"grid5">
410 <property name=
"visible">True
</property>
411 <property name=
"can_focus">False
</property>
412 <property name=
"hexpand">True
</property>
413 <property name=
"vexpand">True
</property>
414 <property name=
"row_spacing">6</property>
416 <object class=
"GtkCheckButton" id=
"byrow">
417 <property name=
"label" translatable=
"yes">_Row labels
</property>
418 <property name=
"visible">True
</property>
419 <property name=
"can_focus">True
</property>
420 <property name=
"receives_default">False
</property>
421 <property name=
"hexpand">True
</property>
422 <property name=
"use_underline">True
</property>
423 <property name=
"xalign">0</property>
424 <property name=
"draw_indicator">True
</property>
427 <property name=
"left_attach">0</property>
428 <property name=
"top_attach">0</property>
429 <property name=
"width">1</property>
430 <property name=
"height">1</property>
434 <object class=
"GtkCheckButton" id=
"bycol">
435 <property name=
"label" translatable=
"yes">C_olumn labels
</property>
436 <property name=
"visible">True
</property>
437 <property name=
"can_focus">True
</property>
438 <property name=
"receives_default">False
</property>
439 <property name=
"hexpand">True
</property>
440 <property name=
"use_underline">True
</property>
441 <property name=
"xalign">0</property>
442 <property name=
"draw_indicator">True
</property>
445 <property name=
"left_attach">0</property>
446 <property name=
"top_attach">1</property>
447 <property name=
"width">1</property>
448 <property name=
"height">1</property>
456 <object class=
"GtkLabel" id=
"label3">
457 <property name=
"visible">True
</property>
458 <property name=
"can_focus">False
</property>
459 <property name=
"label" translatable=
"yes">Consolidate by
</property>
461 <attribute name=
"weight" value=
"bold"/>
467 <property name=
"expand">False
</property>
468 <property name=
"fill">True
</property>
469 <property name=
"position">0</property>
473 <object class=
"GtkFrame" id=
"frame2">
474 <property name=
"visible">True
</property>
475 <property name=
"can_focus">False
</property>
476 <property name=
"hexpand">True
</property>
477 <property name=
"vexpand">True
</property>
478 <property name=
"label_xalign">0</property>
479 <property name=
"shadow_type">none
</property>
481 <object class=
"GtkAlignment" id=
"alignment2">
482 <property name=
"visible">True
</property>
483 <property name=
"can_focus">False
</property>
484 <property name=
"valign">start
</property>
485 <property name=
"hexpand">True
</property>
486 <property name=
"vexpand">True
</property>
487 <property name=
"top_padding">6</property>
488 <property name=
"left_padding">12</property>
490 <object class=
"GtkCheckButton" id=
"refs">
491 <property name=
"label" translatable=
"yes">_Link to source data
</property>
492 <property name=
"visible">True
</property>
493 <property name=
"can_focus">True
</property>
494 <property name=
"receives_default">False
</property>
495 <property name=
"hexpand">True
</property>
496 <property name=
"use_underline">True
</property>
497 <property name=
"xalign">0</property>
498 <property name=
"draw_indicator">True
</property>
504 <object class=
"GtkLabel" id=
"label4">
505 <property name=
"visible">True
</property>
506 <property name=
"can_focus">False
</property>
507 <property name=
"label" translatable=
"yes">Options
</property>
509 <attribute name=
"weight" value=
"bold"/>
515 <property name=
"expand">False
</property>
516 <property name=
"fill">True
</property>
517 <property name=
"position">1</property>
523 <object class=
"GtkLabel" id=
"more_label">
524 <property name=
"visible">True
</property>
525 <property name=
"can_focus">False
</property>
526 <property name=
"label" translatable=
"yes">Options
</property>
531 <property name=
"expand">False
</property>
532 <property name=
"fill">True
</property>
533 <property name=
"position">3</property>
539 <action-widget response=
"0">ok
</action-widget>
540 <action-widget response=
"0">cancel
</action-widget>
541 <action-widget response=
"0">help
</action-widget>