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=
"GtkDialog" id=
"FormulaCalculationOptions">
6 <property name=
"can_focus">False
</property>
7 <property name=
"vexpand">True
</property>
8 <property name=
"border_width">6</property>
9 <property name=
"title" translatable=
"yes" context=
"formulacalculationoptions|FormulaCalculationOptions">Detailed Calculation Settings
</property>
10 <property name=
"modal">True
</property>
11 <property name=
"default_width">0</property>
12 <property name=
"default_height">0</property>
13 <property name=
"type_hint">dialog
</property>
14 <child internal-child=
"vbox">
15 <object class=
"GtkBox" id=
"dialog-vbox1">
16 <property name=
"can_focus">False
</property>
17 <property name=
"orientation">vertical
</property>
18 <property name=
"spacing">12</property>
19 <child internal-child=
"action_area">
20 <object class=
"GtkButtonBox" id=
"dialog-action_area1">
21 <property name=
"can_focus">False
</property>
22 <property name=
"layout_style">end
</property>
24 <object class=
"GtkButton" id=
"help">
25 <property name=
"label" translatable=
"yes" context=
"stock">_Help
</property>
26 <property name=
"visible">True
</property>
27 <property name=
"can_focus">True
</property>
28 <property name=
"receives_default">True
</property>
29 <property name=
"use-underline">True
</property>
32 <property name=
"expand">True
</property>
33 <property name=
"fill">True
</property>
34 <property name=
"position">0</property>
35 <property name=
"secondary">True
</property>
39 <object class=
"GtkButton" id=
"ok">
40 <property name=
"label" translatable=
"yes" context=
"stock">_OK
</property>
41 <property name=
"visible">True
</property>
42 <property name=
"can_focus">True
</property>
43 <property name=
"can_default">True
</property>
44 <property name=
"has_default">True
</property>
45 <property name=
"receives_default">True
</property>
46 <property name=
"use-underline">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=
"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>
63 <property name=
"expand">False
</property>
64 <property name=
"fill">True
</property>
65 <property name=
"position">2</property>
70 <property name=
"expand">False
</property>
71 <property name=
"fill">True
</property>
72 <property name=
"pack_type">end
</property>
73 <property name=
"position">0</property>
77 <object class=
"GtkFrame" id=
"frame1">
78 <property name=
"visible">True
</property>
79 <property name=
"can_focus">False
</property>
80 <property name=
"label_xalign">0</property>
81 <property name=
"shadow_type">none
</property>
83 <!-- n-columns=1 n-rows=1 -->
84 <object class=
"GtkGrid" id=
"grid7">
85 <property name=
"visible">True
</property>
86 <property name=
"can_focus">False
</property>
87 <property name=
"row_spacing">6</property>
88 <property name=
"column_spacing">12</property>
89 <property name=
"margin-start">12</property>
90 <property name=
"margin-top">6</property>
92 <object class=
"GtkLabel" id=
"labelConvT2N">
93 <property name=
"visible">True
</property>
94 <property name=
"can_focus">False
</property>
95 <property name=
"label" translatable=
"yes" context=
"formulacalculationoptions|labelConvT2N">Conversion from text to number:
</property>
96 <property name=
"use_underline">True
</property>
97 <property name=
"mnemonic_widget">comboConversion
</property>
98 <property name=
"xalign">0</property>
101 <property name=
"left_attach">0</property>
102 <property name=
"top_attach">0</property>
106 <object class=
"GtkCheckButton" id=
"checkEmptyAsZero">
107 <property name=
"label" translatable=
"yes" context=
"formulacalculationoptions|checkEmptyAsZero">Treat _empty string as zero
</property>
108 <property name=
"visible">True
</property>
109 <property name=
"can_focus">True
</property>
110 <property name=
"receives_default">False
</property>
111 <property name=
"use_underline">True
</property>
112 <property name=
"draw_indicator">True
</property>
115 <property name=
"left_attach">0</property>
116 <property name=
"top_attach">1</property>
117 <property name=
"width">2</property>
121 <object class=
"GtkLabel" id=
"labelSyntaxRef">
122 <property name=
"visible">True
</property>
123 <property name=
"can_focus">False
</property>
124 <property name=
"label" translatable=
"yes" context=
"formulacalculationoptions|labelSyntaxRef">Reference syntax for string reference:
</property>
125 <property name=
"use_underline">True
</property>
126 <property name=
"mnemonic_widget">comboSyntaxRef
</property>
129 <property name=
"left_attach">0</property>
130 <property name=
"top_attach">2</property>
134 <object class=
"GtkComboBoxText" id=
"comboSyntaxRef">
135 <property name=
"visible">True
</property>
136 <property name=
"can_focus">False
</property>
138 <item id=
"0" translatable=
"yes" context=
"formulacalculationoptions|comboSyntaxRef">Use formula syntax
</item>
139 <item id=
"1">Calc A1
</item>
140 <item id=
"2">Excel A1
</item>
141 <item id=
"3">Excel R1C1
</item>
142 <item id=
"4">Calc A1 | Excel A1
</item>
146 <property name=
"left_attach">1</property>
147 <property name=
"top_attach">2</property>
151 <object class=
"GtkComboBoxText" id=
"comboConversion">
152 <property name=
"visible">True
</property>
153 <property name=
"can_focus">False
</property>
155 <item id=
"0" translatable=
"yes" context=
"formulacalculationoptions|comboConversion">Generate #VALUE! error
</item>
156 <item id=
"1" translatable=
"yes" context=
"formulacalculationoptions|comboConversion">Treat as zero
</item>
157 <item id=
"2" translatable=
"yes" context=
"formulacalculationoptions|comboConversion">Convert only if unambiguous
</item>
158 <item id=
"3" translatable=
"yes" context=
"formulacalculationoptions|comboConversion">Convert also locale dependent
</item>
162 <property name=
"left_attach">1</property>
163 <property name=
"top_attach">0</property>
167 <object class=
"GtkCheckButton" id=
"current_doc">
168 <property name=
"label" translatable=
"yes" context=
"formulacalculationoptions|current_doc">Apply those settings to current document only
</property>
169 <property name=
"visible">True
</property>
170 <property name=
"can_focus">True
</property>
171 <property name=
"receives_default">False
</property>
172 <property name=
"use_underline">True
</property>
173 <property name=
"draw_indicator">True
</property>
176 <property name=
"left_attach">0</property>
177 <property name=
"top_attach">3</property>
178 <property name=
"width">2</property>
184 <object class=
"GtkLabel" id=
"label3">
185 <property name=
"visible">True
</property>
186 <property name=
"can_focus">False
</property>
187 <property name=
"label" translatable=
"yes" context=
"formulacalculationoptions|label3">Contents to Numbers
</property>
189 <attribute name=
"weight" value=
"bold"/>
195 <property name=
"expand">False
</property>
196 <property name=
"fill">True
</property>
197 <property name=
"position">0</property>
203 <action-widget response=
"-11">help
</action-widget>
204 <action-widget response=
"-5">ok
</action-widget>
205 <action-widget response=
"-6">cancel
</action-widget>
207 <child type=
"titlebar">
210 <child internal-child=
"accessible">
211 <object class=
"AtkObject" id=
"FormulaCalculationOptions-atkobject">
212 <property name=
"AtkObject::accessible-description" translatable=
"yes" context=
"extended_tip|FormulaCalculationOptions">Sets the rules for conversion from strings values to numeric values, string values to cell references, and strings values to date and time values. This affects built-in functions such as INDIRECT that takes a reference as a string value or date and time functions that takes arguments as string values in local or ISO
8601 formats.
</property>
216 <object class=
"GtkSizeGroup" id=
"sizegroup1">
218 <widget name=
"comboSyntaxRef"/>
219 <widget name=
"comboConversion"/>