1 <?xml version=
"1.0" encoding=
"UTF-8"?>
2 <!-- Generated with glade 3.18.3 -->
4 <requires lib=
"gtk+" version=
"3.0"/>
5 <requires lib=
"LibreOffice" version=
"1.0"/>
6 <object class=
"GtkDialog" id=
"PivotTableLayout">
7 <property name=
"can_focus">False
</property>
8 <property name=
"border_width">6</property>
9 <property name=
"title" translatable=
"yes">Pivot Table Layout
</property>
10 <property name=
"type_hint">dialog
</property>
11 <child internal-child=
"vbox">
12 <object class=
"GtkBox" id=
"dialog-vbox1">
13 <property name=
"can_focus">False
</property>
14 <property name=
"orientation">vertical
</property>
15 <property name=
"spacing">12</property>
16 <child internal-child=
"action_area">
17 <object class=
"GtkButtonBox" id=
"dialog-action_area1">
18 <property name=
"can_focus">False
</property>
19 <property name=
"layout_style">end
</property>
21 <object class=
"GtkButton" id=
"ok">
22 <property name=
"label">gtk-ok
</property>
23 <property name=
"visible">True
</property>
24 <property name=
"can_focus">True
</property>
25 <property name=
"has_default">True
</property>
26 <property name=
"receives_default">True
</property>
27 <property name=
"use_stock">True
</property>
30 <property name=
"expand">True
</property>
31 <property name=
"fill">True
</property>
32 <property name=
"position">0</property>
36 <object class=
"GtkButton" id=
"cancel">
37 <property name=
"label">gtk-cancel
</property>
38 <property name=
"visible">True
</property>
39 <property name=
"can_focus">True
</property>
40 <property name=
"receives_default">True
</property>
41 <property name=
"use_stock">True
</property>
44 <property name=
"expand">True
</property>
45 <property name=
"fill">True
</property>
46 <property name=
"position">1</property>
50 <object class=
"GtkButton" id=
"help">
51 <property name=
"label">gtk-help
</property>
52 <property name=
"visible">True
</property>
53 <property name=
"can_focus">True
</property>
54 <property name=
"receives_default">True
</property>
55 <property name=
"use_stock">True
</property>
58 <property name=
"expand">False
</property>
59 <property name=
"fill">True
</property>
60 <property name=
"position">2</property>
61 <property name=
"secondary">True
</property>
66 <property name=
"expand">False
</property>
67 <property name=
"fill">True
</property>
68 <property name=
"pack_type">end
</property>
69 <property name=
"position">0</property>
73 <object class=
"GtkBox" id=
"box1">
74 <property name=
"visible">True
</property>
75 <property name=
"can_focus">False
</property>
76 <property name=
"hexpand">True
</property>
77 <property name=
"vexpand">True
</property>
78 <property name=
"orientation">vertical
</property>
79 <property name=
"spacing">6</property>
81 <object class=
"GtkBox" id=
"box2">
82 <property name=
"visible">True
</property>
83 <property name=
"can_focus">False
</property>
84 <property name=
"vexpand">True
</property>
85 <property name=
"border_width">6</property>
86 <property name=
"spacing">6</property>
88 <object class=
"GtkGrid" id=
"grid7">
89 <property name=
"visible">True
</property>
90 <property name=
"can_focus">False
</property>
91 <property name=
"hexpand">True
</property>
92 <property name=
"vexpand">True
</property>
93 <property name=
"row_spacing">6</property>
94 <property name=
"column_spacing">6</property>
96 <object class=
"GtkBox" id=
"box4">
97 <property name=
"visible">True
</property>
98 <property name=
"can_focus">False
</property>
99 <property name=
"hexpand">True
</property>
100 <property name=
"vexpand">True
</property>
101 <property name=
"orientation">vertical
</property>
102 <property name=
"spacing">6</property>
104 <object class=
"GtkLabel" id=
"label3">
105 <property name=
"visible">True
</property>
106 <property name=
"can_focus">False
</property>
107 <property name=
"xalign">0</property>
108 <property name=
"yalign">0</property>
109 <property name=
"xpad">4</property>
110 <property name=
"label" translatable=
"yes">Column Fields:
</property>
111 <property name=
"use_underline">True
</property>
112 <property name=
"mnemonic_widget">listbox-column
</property>
114 <attribute name=
"weight" value=
"bold"/>
118 <property name=
"expand">False
</property>
119 <property name=
"fill">True
</property>
120 <property name=
"position">0</property>
124 <object class=
"sclo-ScPivotLayoutTreeList" id=
"listbox-column">
125 <property name=
"width_request">200</property>
126 <property name=
"height_request">100</property>
127 <property name=
"visible">True
</property>
128 <property name=
"can_focus">True
</property>
129 <property name=
"hexpand">True
</property>
130 <property name=
"vexpand">True
</property>
131 <child internal-child=
"selection">
132 <object class=
"GtkTreeSelection" id=
"Pivot Table List-selection"/>
136 <property name=
"expand">False
</property>
137 <property name=
"fill">True
</property>
138 <property name=
"position">1</property>
143 <property name=
"left_attach">1</property>
144 <property name=
"top_attach">1</property>
148 <object class=
"GtkBox" id=
"box5">
149 <property name=
"visible">True
</property>
150 <property name=
"can_focus">False
</property>
151 <property name=
"hexpand">True
</property>
152 <property name=
"vexpand">True
</property>
153 <property name=
"orientation">vertical
</property>
154 <property name=
"spacing">6</property>
156 <object class=
"GtkLabel" id=
"label5">
157 <property name=
"visible">True
</property>
158 <property name=
"can_focus">False
</property>
159 <property name=
"xalign">0</property>
160 <property name=
"yalign">0</property>
161 <property name=
"xpad">4</property>
162 <property name=
"label" translatable=
"yes">Data Fields:
</property>
163 <property name=
"use_underline">True
</property>
164 <property name=
"mnemonic_widget">listbox-data
</property>
166 <attribute name=
"weight" value=
"bold"/>
170 <property name=
"expand">False
</property>
171 <property name=
"fill">True
</property>
172 <property name=
"position">0</property>
176 <object class=
"sclo-ScPivotLayoutTreeListData" id=
"listbox-data">
177 <property name=
"width_request">240</property>
178 <property name=
"height_request">120</property>
179 <property name=
"visible">True
</property>
180 <property name=
"can_focus">True
</property>
181 <property name=
"hexpand">True
</property>
182 <property name=
"vexpand">True
</property>
183 <child internal-child=
"selection">
184 <object class=
"GtkTreeSelection" id=
"Pivot Table Data List-selection"/>
188 <property name=
"expand">False
</property>
189 <property name=
"fill">True
</property>
190 <property name=
"position">1</property>
195 <property name=
"left_attach">1</property>
196 <property name=
"top_attach">2</property>
200 <object class=
"GtkBox" id=
"box6">
201 <property name=
"visible">True
</property>
202 <property name=
"can_focus">False
</property>
203 <property name=
"hexpand">True
</property>
204 <property name=
"vexpand">True
</property>
205 <property name=
"orientation">vertical
</property>
206 <property name=
"spacing">6</property>
208 <object class=
"GtkLabel" id=
"label4">
209 <property name=
"visible">True
</property>
210 <property name=
"can_focus">False
</property>
211 <property name=
"xalign">0</property>
212 <property name=
"yalign">0</property>
213 <property name=
"xpad">4</property>
214 <property name=
"label" translatable=
"yes">Row Fields:
</property>
215 <property name=
"use_underline">True
</property>
216 <property name=
"mnemonic_widget">listbox-row
</property>
218 <attribute name=
"weight" value=
"bold"/>
222 <property name=
"expand">False
</property>
223 <property name=
"fill">True
</property>
224 <property name=
"position">0</property>
228 <object class=
"sclo-ScPivotLayoutTreeList" id=
"listbox-row">
229 <property name=
"width_request">180</property>
230 <property name=
"height_request">100</property>
231 <property name=
"visible">True
</property>
232 <property name=
"can_focus">True
</property>
233 <property name=
"vexpand">True
</property>
234 <child internal-child=
"selection">
235 <object class=
"GtkTreeSelection" id=
"Pivot Table List-selection4"/>
239 <property name=
"expand">False
</property>
240 <property name=
"fill">True
</property>
241 <property name=
"position">1</property>
246 <property name=
"left_attach">0</property>
247 <property name=
"top_attach">2</property>
251 <object class=
"GtkBox" id=
"box7">
252 <property name=
"visible">True
</property>
253 <property name=
"can_focus">False
</property>
254 <property name=
"hexpand">True
</property>
255 <property name=
"vexpand">True
</property>
256 <property name=
"orientation">vertical
</property>
257 <property name=
"spacing">6</property>
259 <object class=
"GtkLabel" id=
"label2">
260 <property name=
"visible">True
</property>
261 <property name=
"can_focus">False
</property>
262 <property name=
"xalign">0</property>
263 <property name=
"yalign">0</property>
264 <property name=
"xpad">4</property>
265 <property name=
"label" translatable=
"yes">Page Fields:
</property>
266 <property name=
"use_underline">True
</property>
267 <property name=
"mnemonic_widget">listbox-page
</property>
269 <attribute name=
"weight" value=
"bold"/>
273 <property name=
"expand">False
</property>
274 <property name=
"fill">True
</property>
275 <property name=
"position">0</property>
279 <object class=
"sclo-ScPivotLayoutTreeList" id=
"listbox-page">
280 <property name=
"width_request">200</property>
281 <property name=
"height_request">100</property>
282 <property name=
"visible">True
</property>
283 <property name=
"can_focus">True
</property>
284 <property name=
"hexpand">True
</property>
285 <property name=
"vexpand">True
</property>
286 <child internal-child=
"selection">
287 <object class=
"GtkTreeSelection" id=
"Pivot Table List-selection5"/>
291 <property name=
"expand">False
</property>
292 <property name=
"fill">True
</property>
293 <property name=
"position">1</property>
298 <property name=
"left_attach">0</property>
299 <property name=
"top_attach">0</property>
300 <property name=
"width">2</property>
308 <property name=
"expand">False
</property>
309 <property name=
"fill">True
</property>
310 <property name=
"position">0</property>
314 <object class=
"GtkBox" id=
"box3">
315 <property name=
"visible">True
</property>
316 <property name=
"can_focus">False
</property>
317 <property name=
"vexpand">True
</property>
318 <property name=
"orientation">vertical
</property>
319 <property name=
"spacing">6</property>
321 <object class=
"GtkLabel" id=
"label1">
322 <property name=
"visible">True
</property>
323 <property name=
"can_focus">False
</property>
324 <property name=
"xalign">0</property>
325 <property name=
"xpad">4</property>
326 <property name=
"label" translatable=
"yes">Available Fields:
</property>
327 <property name=
"use_underline">True
</property>
328 <property name=
"mnemonic_widget">listbox-fields
</property>
330 <attribute name=
"weight" value=
"bold"/>
334 <property name=
"expand">False
</property>
335 <property name=
"fill">True
</property>
336 <property name=
"position">0</property>
340 <object class=
"sclo-ScPivotLayoutTreeListLabel" id=
"listbox-fields">
341 <property name=
"width_request">180</property>
342 <property name=
"height_request">150</property>
343 <property name=
"visible">True
</property>
344 <property name=
"can_focus">True
</property>
345 <property name=
"hexpand">True
</property>
346 <property name=
"vexpand">True
</property>
347 <child internal-child=
"selection">
348 <object class=
"GtkTreeSelection" id=
"Pivot Table Label List-selection"/>
352 <property name=
"expand">False
</property>
353 <property name=
"fill">True
</property>
354 <property name=
"position">1</property>
359 <property name=
"expand">False
</property>
360 <property name=
"fill">True
</property>
361 <property name=
"position">1</property>
366 <property name=
"expand">False
</property>
367 <property name=
"fill">True
</property>
368 <property name=
"position">0</property>
372 <object class=
"GtkLabel" id=
"label6">
373 <property name=
"visible">True
</property>
374 <property name=
"can_focus">False
</property>
375 <property name=
"hexpand">True
</property>
376 <property name=
"label" translatable=
"yes">Drag the Items into the Desired Position
</property>
378 <attribute name=
"underline" value=
"True"/>
382 <property name=
"expand">False
</property>
383 <property name=
"fill">True
</property>
384 <property name=
"position">1</property>
388 <object class=
"GtkExpander" id=
"options">
389 <property name=
"visible">True
</property>
390 <property name=
"can_focus">True
</property>
392 <object class=
"GtkGrid" id=
"grid5">
393 <property name=
"visible">True
</property>
394 <property name=
"can_focus">False
</property>
395 <property name=
"margin_left">12</property>
396 <property name=
"margin_top">6</property>
397 <property name=
"row_spacing">6</property>
398 <property name=
"column_spacing">12</property>
400 <object class=
"GtkCheckButton" id=
"check-ignore-empty-rows">
401 <property name=
"label" translatable=
"yes">Ignore empty rows
</property>
402 <property name=
"visible">True
</property>
403 <property name=
"can_focus">True
</property>
404 <property name=
"receives_default">False
</property>
405 <property name=
"hexpand">True
</property>
406 <property name=
"xalign">0</property>
407 <property name=
"draw_indicator">True
</property>
410 <property name=
"left_attach">0</property>
411 <property name=
"top_attach">0</property>
415 <object class=
"GtkCheckButton" id=
"check-identify-categories">
416 <property name=
"label" translatable=
"yes">Identify categories
</property>
417 <property name=
"visible">True
</property>
418 <property name=
"can_focus">True
</property>
419 <property name=
"receives_default">False
</property>
420 <property name=
"hexpand">True
</property>
421 <property name=
"xalign">0</property>
422 <property name=
"draw_indicator">True
</property>
425 <property name=
"left_attach">1</property>
426 <property name=
"top_attach">0</property>
430 <object class=
"GtkCheckButton" id=
"check-total-rows">
431 <property name=
"label" translatable=
"yes">Total rows
</property>
432 <property name=
"visible">True
</property>
433 <property name=
"can_focus">True
</property>
434 <property name=
"receives_default">False
</property>
435 <property name=
"hexpand">True
</property>
436 <property name=
"xalign">0</property>
437 <property name=
"draw_indicator">True
</property>
440 <property name=
"left_attach">1</property>
441 <property name=
"top_attach">1</property>
445 <object class=
"GtkCheckButton" id=
"check-total-columns">
446 <property name=
"label" translatable=
"yes">Total columns
</property>
447 <property name=
"visible">True
</property>
448 <property name=
"can_focus">True
</property>
449 <property name=
"receives_default">False
</property>
450 <property name=
"hexpand">True
</property>
451 <property name=
"xalign">0</property>
452 <property name=
"draw_indicator">True
</property>
455 <property name=
"left_attach">0</property>
456 <property name=
"top_attach">1</property>
460 <object class=
"GtkCheckButton" id=
"check-add-filter">
461 <property name=
"label" translatable=
"yes">Add filter
</property>
462 <property name=
"visible">True
</property>
463 <property name=
"can_focus">True
</property>
464 <property name=
"receives_default">False
</property>
465 <property name=
"hexpand">True
</property>
466 <property name=
"xalign">0</property>
467 <property name=
"draw_indicator">True
</property>
470 <property name=
"left_attach">0</property>
471 <property name=
"top_attach">2</property>
475 <object class=
"GtkCheckButton" id=
"check-drill-to-details">
476 <property name=
"label" translatable=
"yes">Enable drill to details
</property>
477 <property name=
"visible">True
</property>
478 <property name=
"can_focus">True
</property>
479 <property name=
"receives_default">False
</property>
480 <property name=
"hexpand">True
</property>
481 <property name=
"xalign">0</property>
482 <property name=
"draw_indicator">True
</property>
485 <property name=
"left_attach">1</property>
486 <property name=
"top_attach">2</property>
492 <object class=
"GtkLabel" id=
"label11">
493 <property name=
"visible">True
</property>
494 <property name=
"can_focus">False
</property>
495 <property name=
"label" translatable=
"yes">Options
</property>
497 <attribute name=
"weight" value=
"bold"/>
503 <property name=
"expand">False
</property>
504 <property name=
"fill">True
</property>
505 <property name=
"position">2</property>
509 <object class=
"GtkExpander" id=
"more">
510 <property name=
"visible">True
</property>
511 <property name=
"can_focus">True
</property>
513 <object class=
"GtkGrid" id=
"grid2">
514 <property name=
"visible">True
</property>
515 <property name=
"can_focus">False
</property>
516 <property name=
"margin_left">12</property>
517 <property name=
"margin_top">6</property>
518 <property name=
"hexpand">True
</property>
519 <property name=
"vexpand">True
</property>
520 <property name=
"row_spacing">6</property>
521 <property name=
"column_spacing">12</property>
523 <object class=
"GtkFrame" id=
"frame1">
524 <property name=
"visible">True
</property>
525 <property name=
"can_focus">False
</property>
526 <property name=
"hexpand">True
</property>
527 <property name=
"vexpand">True
</property>
528 <property name=
"label_xalign">0</property>
529 <property name=
"shadow_type">none
</property>
531 <object class=
"GtkAlignment" id=
"alignment1">
532 <property name=
"visible">True
</property>
533 <property name=
"can_focus">False
</property>
534 <property name=
"top_padding">6</property>
535 <property name=
"left_padding">12</property>
537 <object class=
"GtkGrid" id=
"grid3">
538 <property name=
"visible">True
</property>
539 <property name=
"can_focus">False
</property>
540 <property name=
"hexpand">True
</property>
541 <property name=
"vexpand">True
</property>
542 <property name=
"row_spacing">6</property>
543 <property name=
"column_spacing">12</property>
545 <object class=
"GtkRadioButton" id=
"destination-radio-new-sheet">
546 <property name=
"label" translatable=
"yes">New sheet
</property>
547 <property name=
"visible">True
</property>
548 <property name=
"can_focus">True
</property>
549 <property name=
"receives_default">False
</property>
550 <property name=
"xalign">0</property>
551 <property name=
"draw_indicator">True
</property>
552 <property name=
"group">destination-radio-named-range
</property>
555 <property name=
"left_attach">0</property>
556 <property name=
"top_attach">0</property>
557 <property name=
"width">3</property>
561 <object class=
"GtkRadioButton" id=
"destination-radio-selection">
562 <property name=
"label" translatable=
"yes">Selection
</property>
563 <property name=
"visible">True
</property>
564 <property name=
"can_focus">True
</property>
565 <property name=
"receives_default">False
</property>
566 <property name=
"xalign">0</property>
567 <property name=
"draw_indicator">True
</property>
568 <property name=
"group">destination-radio-new-sheet
</property>
571 <property name=
"left_attach">0</property>
572 <property name=
"top_attach">2</property>
576 <object class=
"foruilo-RefEdit" id=
"destination-edit">
577 <property name=
"visible">True
</property>
578 <property name=
"can_focus">True
</property>
579 <property name=
"hexpand">True
</property>
580 <property name=
"invisible_char">●
</property>
583 <property name=
"left_attach">1</property>
584 <property name=
"top_attach">2</property>
588 <object class=
"foruilo-RefButton" id=
"destination-button">
589 <property name=
"visible">True
</property>
590 <property name=
"can_focus">True
</property>
591 <property name=
"receives_default">True
</property>
594 <property name=
"left_attach">2</property>
595 <property name=
"top_attach">2</property>
599 <object class=
"GtkComboBox" id=
"destination-list">
600 <property name=
"visible">True
</property>
601 <property name=
"can_focus">False
</property>
604 <property name=
"left_attach">1</property>
605 <property name=
"top_attach">1</property>
606 <property name=
"width">2</property>
610 <object class=
"GtkRadioButton" id=
"destination-radio-named-range">
611 <property name=
"label" translatable=
"yes">Named range
</property>
612 <property name=
"visible">True
</property>
613 <property name=
"can_focus">True
</property>
614 <property name=
"receives_default">False
</property>
615 <property name=
"xalign">0</property>
616 <property name=
"draw_indicator">True
</property>
617 <property name=
"group">destination-radio-selection
</property>
620 <property name=
"left_attach">0</property>
621 <property name=
"top_attach">1</property>
629 <object class=
"GtkLabel" id=
"label8">
630 <property name=
"visible">True
</property>
631 <property name=
"can_focus">False
</property>
632 <property name=
"label" translatable=
"yes">Destination
</property>
634 <attribute name=
"weight" value=
"bold"/>
640 <property name=
"left_attach">0</property>
641 <property name=
"top_attach">1</property>
645 <object class=
"GtkFrame" id=
"frame2">
646 <property name=
"visible">True
</property>
647 <property name=
"can_focus">False
</property>
648 <property name=
"hexpand">True
</property>
649 <property name=
"vexpand">True
</property>
650 <property name=
"label_xalign">0</property>
651 <property name=
"shadow_type">none
</property>
653 <object class=
"GtkAlignment" id=
"alignment2">
654 <property name=
"visible">True
</property>
655 <property name=
"can_focus">False
</property>
656 <property name=
"top_padding">6</property>
657 <property name=
"left_padding">12</property>
659 <object class=
"GtkGrid" id=
"grid4">
660 <property name=
"visible">True
</property>
661 <property name=
"can_focus">False
</property>
662 <property name=
"hexpand">True
</property>
663 <property name=
"vexpand">True
</property>
664 <property name=
"row_spacing">6</property>
665 <property name=
"column_spacing">12</property>
667 <object class=
"GtkRadioButton" id=
"source-radio-selection">
668 <property name=
"label" translatable=
"yes">Selection
</property>
669 <property name=
"visible">True
</property>
670 <property name=
"can_focus">True
</property>
671 <property name=
"receives_default">False
</property>
672 <property name=
"xalign">0</property>
673 <property name=
"draw_indicator">True
</property>
674 <property name=
"group">source-radio-named-range
</property>
677 <property name=
"left_attach">0</property>
678 <property name=
"top_attach">1</property>
682 <object class=
"foruilo-RefEdit" id=
"source-edit">
683 <property name=
"visible">True
</property>
684 <property name=
"can_focus">True
</property>
685 <property name=
"hexpand">True
</property>
686 <property name=
"invisible_char">●
</property>
689 <property name=
"left_attach">1</property>
690 <property name=
"top_attach">1</property>
694 <object class=
"foruilo-RefButton" id=
"source-button">
695 <property name=
"visible">True
</property>
696 <property name=
"can_focus">True
</property>
697 <property name=
"receives_default">True
</property>
700 <property name=
"left_attach">2</property>
701 <property name=
"top_attach">1</property>
705 <object class=
"GtkRadioButton" id=
"source-radio-named-range">
706 <property name=
"label" translatable=
"yes">Named range
</property>
707 <property name=
"visible">True
</property>
708 <property name=
"can_focus">True
</property>
709 <property name=
"receives_default">False
</property>
710 <property name=
"xalign">0</property>
711 <property name=
"draw_indicator">True
</property>
712 <property name=
"group">source-radio-selection
</property>
715 <property name=
"left_attach">0</property>
716 <property name=
"top_attach">0</property>
720 <object class=
"GtkComboBox" id=
"source-list">
721 <property name=
"visible">True
</property>
722 <property name=
"can_focus">False
</property>
725 <property name=
"left_attach">1</property>
726 <property name=
"top_attach">0</property>
727 <property name=
"width">2</property>
735 <object class=
"GtkLabel" id=
"label9">
736 <property name=
"visible">True
</property>
737 <property name=
"can_focus">False
</property>
738 <property name=
"label" translatable=
"yes">Source
</property>
740 <attribute name=
"weight" value=
"bold"/>
746 <property name=
"left_attach">0</property>
747 <property name=
"top_attach">0</property>
753 <object class=
"GtkLabel" id=
"label7">
754 <property name=
"visible">True
</property>
755 <property name=
"can_focus">False
</property>
756 <property name=
"label" translatable=
"yes">Source and Destination
</property>
758 <attribute name=
"weight" value=
"bold"/>
764 <property name=
"expand">False
</property>
765 <property name=
"fill">True
</property>
766 <property name=
"position">3</property>
771 <property name=
"expand">False
</property>
772 <property name=
"fill">True
</property>
773 <property name=
"position">1</property>
779 <action-widget response=
"0">ok
</action-widget>
780 <action-widget response=
"0">cancel
</action-widget>