tdf#154285 Check upper bound of arguments in SbRtl_Minute function
[LibreOffice.git] / sc / qa / unit / data / functions / database / fods / dcounta.fods
blobbecc5759664f045731f92e3741909a23e369daa5
1 <?xml version="1.0" encoding="UTF-8"?>
3 <office:document xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:presentation="urn:oasis:names:tc:opendocument:xmlns:presentation:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" xmlns:math="http://www.w3.org/1998/Math/MathML" xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:config="urn:oasis:names:tc:opendocument:xmlns:config:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:rpt="http://openoffice.org/2005/report" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:grddl="http://www.w3.org/2003/g/data-view#" xmlns:tableooo="http://openoffice.org/2009/table" xmlns:drawooo="http://openoffice.org/2010/draw" xmlns:calcext="urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0" xmlns:loext="urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0" xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0" xmlns:formx="urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0" xmlns:css3t="http://www.w3.org/TR/css3-text/" office:version="1.2" office:mimetype="application/vnd.oasis.opendocument.spreadsheet">
4 <office:styles>
5 <style:default-style style:family="table-cell">
6 <style:paragraph-properties style:tab-stop-distance="12.7mm"/>
7 <style:text-properties style:font-name="Liberation Sans" fo:language="en" fo:country="US" style:font-name-asian="DejaVu Sans" style:language-asian="zh" style:country-asian="CN" style:font-name-complex="DejaVu Sans" style:language-complex="hi" style:country-complex="IN"/>
8 </style:default-style>
9 <number:number-style style:name="N0">
10 <number:number number:min-integer-digits="1"/>
11 </number:number-style>
12 <number:currency-style style:name="N108P0" style:volatile="true">
13 <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
14 <number:text> </number:text>
15 <number:currency-symbol number:language="cs" number:country="CZ"></number:currency-symbol>
16 </number:currency-style>
17 <number:currency-style style:name="N108">
18 <style:text-properties fo:color="#ff0000"/>
19 <number:text>-</number:text>
20 <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
21 <number:text> </number:text>
22 <number:currency-symbol number:language="cs" number:country="CZ"></number:currency-symbol>
23 <style:map style:condition="value()&gt;=0" style:apply-style-name="N108P0"/>
24 </number:currency-style>
25 <number:currency-style style:name="N110P0" style:volatile="true">
26 <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
27 <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
28 </number:currency-style>
29 <number:currency-style style:name="N110">
30 <number:text>-</number:text>
31 <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
32 <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
33 <style:map style:condition="value()&gt;=0" style:apply-style-name="N110P0"/>
34 </number:currency-style>
35 <number:currency-style style:name="N112P0" style:volatile="true">
36 <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
37 <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
38 </number:currency-style>
39 <number:currency-style style:name="N112">
40 <number:text>-</number:text>
41 <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
42 <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
43 <style:map style:condition="value()&gt;=0" style:apply-style-name="N112P0"/>
44 </number:currency-style>
45 <number:currency-style style:name="N113P0" style:volatile="true">
46 <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
47 <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
48 </number:currency-style>
49 <number:currency-style style:name="N113">
50 <style:text-properties fo:color="#ff0000"/>
51 <number:text>-</number:text>
52 <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
53 <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
54 <style:map style:condition="value()&gt;=0" style:apply-style-name="N113P0"/>
55 </number:currency-style>
56 <number:currency-style style:name="N114P0" style:volatile="true">
57 <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
58 <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
59 </number:currency-style>
60 <number:currency-style style:name="N114">
61 <style:text-properties fo:color="#ff0000"/>
62 <number:text>-</number:text>
63 <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
64 <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
65 <style:map style:condition="value()&gt;=0" style:apply-style-name="N114P0"/>
66 </number:currency-style>
67 <number:currency-style style:name="N116P0" style:volatile="true">
68 <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
69 <number:number number:decimal-places="2" loext:min-decimal-places="0" number:min-integer-digits="1" number:decimal-replacement="--" number:grouping="true"/>
70 </number:currency-style>
71 <number:currency-style style:name="N116">
72 <style:text-properties fo:color="#ff0000"/>
73 <number:text>-</number:text>
74 <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
75 <number:number number:decimal-places="2" loext:min-decimal-places="0" number:min-integer-digits="1" number:decimal-replacement="--" number:grouping="true"/>
76 <style:map style:condition="value()&gt;=0" style:apply-style-name="N116P0"/>
77 </number:currency-style>
78 <number:number-style style:name="N118P0" style:volatile="true">
79 <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
80 <number:text> </number:text>
81 </number:number-style>
82 <number:number-style style:name="N118">
83 <number:text>(</number:text>
84 <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
85 <number:text>)</number:text>
86 <style:map style:condition="value()&gt;=0" style:apply-style-name="N118P0"/>
87 </number:number-style>
88 <number:number-style style:name="N120P0" style:volatile="true">
89 <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
90 <number:text> </number:text>
91 </number:number-style>
92 <number:number-style style:name="N120">
93 <number:text>(</number:text>
94 <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
95 <number:text>)</number:text>
96 <style:map style:condition="value()&gt;=0" style:apply-style-name="N120P0"/>
97 </number:number-style>
98 <number:currency-style style:name="N122P0" style:volatile="true">
99 <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
100 <loext:fill-character> </loext:fill-character>
101 <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
102 </number:currency-style>
103 <number:currency-style style:name="N122">
104 <number:text>-</number:text>
105 <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
106 <loext:fill-character> </loext:fill-character>
107 <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
108 <style:map style:condition="value()&gt;=0" style:apply-style-name="N122P0"/>
109 </number:currency-style>
110 <number:currency-style style:name="N124P0" style:volatile="true">
111 <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
112 <loext:fill-character> </loext:fill-character>
113 <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
114 </number:currency-style>
115 <number:currency-style style:name="N124">
116 <number:text>-</number:text>
117 <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
118 <loext:fill-character> </loext:fill-character>
119 <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
120 <style:map style:condition="value()&gt;=0" style:apply-style-name="N124P0"/>
121 </number:currency-style>
122 <number:currency-style style:name="N126P0" style:volatile="true">
123 <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
124 <number:text> </number:text>
125 <number:currency-symbol number:language="cs" number:country="CZ"></number:currency-symbol>
126 </number:currency-style>
127 <number:currency-style style:name="N126">
128 <number:text>-</number:text>
129 <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
130 <number:text> </number:text>
131 <number:currency-symbol number:language="cs" number:country="CZ"></number:currency-symbol>
132 <style:map style:condition="value()&gt;=0" style:apply-style-name="N126P0"/>
133 </number:currency-style>
134 <number:currency-style style:name="N127P0" style:volatile="true">
135 <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
136 <number:text> </number:text>
137 <number:currency-symbol number:language="cs" number:country="CZ"></number:currency-symbol>
138 </number:currency-style>
139 <number:currency-style style:name="N127">
140 <number:text>-</number:text>
141 <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
142 <number:text> </number:text>
143 <number:currency-symbol number:language="cs" number:country="CZ"></number:currency-symbol>
144 <style:map style:condition="value()&gt;=0" style:apply-style-name="N127P0"/>
145 </number:currency-style>
146 <number:currency-style style:name="N128P0" style:volatile="true">
147 <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
148 <number:text> </number:text>
149 <number:currency-symbol number:language="cs" number:country="CZ"></number:currency-symbol>
150 </number:currency-style>
151 <number:currency-style style:name="N128">
152 <style:text-properties fo:color="#ff0000"/>
153 <number:text>-</number:text>
154 <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
155 <number:text> </number:text>
156 <number:currency-symbol number:language="cs" number:country="CZ"></number:currency-symbol>
157 <style:map style:condition="value()&gt;=0" style:apply-style-name="N128P0"/>
158 </number:currency-style>
159 <number:currency-style style:name="N130P0" style:volatile="true">
160 <number:number number:decimal-places="2" loext:min-decimal-places="0" number:min-integer-digits="1" number:decimal-replacement="--" number:grouping="true"/>
161 <number:text> </number:text>
162 <number:currency-symbol number:language="cs" number:country="CZ"></number:currency-symbol>
163 </number:currency-style>
164 <number:currency-style style:name="N130">
165 <style:text-properties fo:color="#ff0000"/>
166 <number:text>-</number:text>
167 <number:number number:decimal-places="2" loext:min-decimal-places="0" number:min-integer-digits="1" number:decimal-replacement="--" number:grouping="true"/>
168 <number:text> </number:text>
169 <number:currency-symbol number:language="cs" number:country="CZ"></number:currency-symbol>
170 <style:map style:condition="value()&gt;=0" style:apply-style-name="N130P0"/>
171 </number:currency-style>
172 <number:currency-style style:name="N132P0" style:volatile="true">
173 <number:currency-symbol number:language="en" number:country="US">$</number:currency-symbol>
174 <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
175 </number:currency-style>
176 <number:currency-style style:name="N132">
177 <style:text-properties fo:color="#ff0000"/>
178 <number:text>-</number:text>
179 <number:currency-symbol number:language="en" number:country="US">$</number:currency-symbol>
180 <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
181 <style:map style:condition="value()&gt;=0" style:apply-style-name="N132P0"/>
182 </number:currency-style>
183 <number:number-style style:name="N133">
184 <number:number number:decimal-places="9" loext:min-decimal-places="9" number:min-integer-digits="1"/>
185 </number:number-style>
186 <number:number-style style:name="N134">
187 <number:number number:decimal-places="8" loext:min-decimal-places="8" number:min-integer-digits="1"/>
188 </number:number-style>
189 <number:number-style style:name="N135">
190 <number:number number:decimal-places="10" loext:min-decimal-places="10" number:min-integer-digits="1"/>
191 </number:number-style>
192 <number:number-style style:name="N136">
193 <number:number number:decimal-places="11" loext:min-decimal-places="11" number:min-integer-digits="1"/>
194 </number:number-style>
195 <number:number-style style:name="N137">
196 <number:number number:decimal-places="12" loext:min-decimal-places="12" number:min-integer-digits="1"/>
197 </number:number-style>
198 <number:number-style style:name="N138">
199 <number:number number:decimal-places="13" loext:min-decimal-places="13" number:min-integer-digits="1"/>
200 </number:number-style>
201 <number:number-style style:name="N139">
202 <number:number number:decimal-places="14" loext:min-decimal-places="14" number:min-integer-digits="1"/>
203 </number:number-style>
204 <number:number-style style:name="N140">
205 <number:number number:decimal-places="15" loext:min-decimal-places="15" number:min-integer-digits="1"/>
206 </number:number-style>
207 <number:number-style style:name="N141">
208 <number:number number:decimal-places="16" loext:min-decimal-places="16" number:min-integer-digits="1"/>
209 </number:number-style>
210 <number:number-style style:name="N142">
211 <number:number number:decimal-places="17" loext:min-decimal-places="17" number:min-integer-digits="1"/>
212 </number:number-style>
213 <number:number-style style:name="N143">
214 <number:number number:decimal-places="18" loext:min-decimal-places="18" number:min-integer-digits="1"/>
215 </number:number-style>
216 <style:style style:name="Default" style:family="table-cell">
217 <style:text-properties style:font-name-asian="Droid Sans Fallback" style:font-family-asian="&apos;Droid Sans Fallback&apos;" style:font-family-generic-asian="system" style:font-pitch-asian="variable" style:font-name-complex="Droid Sans Devanagari" style:font-family-complex="&apos;Droid Sans Devanagari&apos;" style:font-family-generic-complex="system" style:font-pitch-complex="variable"/>
218 </style:style>
219 <style:style style:name="Result" style:family="table-cell" style:parent-style-name="Default">
220 <style:text-properties fo:font-style="italic" style:text-underline-style="solid" style:text-underline-width="auto" style:text-underline-color="font-color" fo:font-weight="bold"/>
221 </style:style>
222 <style:style style:name="Result2" style:family="table-cell" style:parent-style-name="Result" style:data-style-name="N108"/>
223 <style:style style:name="Heading" style:family="table-cell" style:parent-style-name="Default">
224 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
225 <style:paragraph-properties fo:text-align="center"/>
226 <style:text-properties fo:font-size="16pt" fo:font-style="italic" fo:font-weight="bold"/>
227 </style:style>
228 <style:style style:name="Heading1" style:family="table-cell" style:parent-style-name="Heading">
229 <style:table-cell-properties style:rotation-angle="90"/>
230 </style:style>
231 <style:style style:name="Untitled1" style:family="table-cell" style:parent-style-name="Default">
232 <style:table-cell-properties fo:background-color="#ff3333"/>
233 </style:style>
234 <style:style style:name="Untitled2" style:family="table-cell" style:parent-style-name="Default">
235 <style:table-cell-properties fo:background-color="#99ff66"/>
236 </style:style>
237 </office:styles>
238 <office:automatic-styles>
239 <style:style style:name="co1" style:family="table-column">
240 <style:table-column-properties fo:break-before="auto" style:column-width="65.51mm"/>
241 </style:style>
242 <style:style style:name="co2" style:family="table-column">
243 <style:table-column-properties fo:break-before="auto" style:column-width="89.08mm"/>
244 </style:style>
245 <style:style style:name="co3" style:family="table-column">
246 <style:table-column-properties fo:break-before="auto" style:column-width="22.58mm"/>
247 </style:style>
248 <style:style style:name="co4" style:family="table-column">
249 <style:table-column-properties fo:break-before="auto" style:column-width="24.85mm"/>
250 </style:style>
251 <style:style style:name="co5" style:family="table-column">
252 <style:table-column-properties fo:break-before="auto" style:column-width="25.65mm"/>
253 </style:style>
254 <style:style style:name="co6" style:family="table-column">
255 <style:table-column-properties fo:break-before="auto" style:column-width="26.18mm"/>
256 </style:style>
257 <style:style style:name="co7" style:family="table-column">
258 <style:table-column-properties fo:break-before="auto" style:column-width="62.95mm"/>
259 </style:style>
260 <style:style style:name="co8" style:family="table-column">
261 <style:table-column-properties fo:break-before="auto" style:column-width="17.97mm"/>
262 </style:style>
263 <style:style style:name="co9" style:family="table-column">
264 <style:table-column-properties fo:break-before="auto" style:column-width="5.8mm"/>
265 </style:style>
266 <style:style style:name="ro1" style:family="table-row">
267 <style:table-row-properties style:row-height="8.63mm" fo:break-before="auto" style:use-optimal-row-height="true"/>
268 </style:style>
269 <style:style style:name="ro2" style:family="table-row">
270 <style:table-row-properties style:row-height="4.52mm" fo:break-before="auto" style:use-optimal-row-height="true"/>
271 </style:style>
272 <style:style style:name="ro3" style:family="table-row">
273 <style:table-row-properties style:row-height="6.12mm" fo:break-before="auto" style:use-optimal-row-height="true"/>
274 </style:style>
275 <style:style style:name="ro4" style:family="table-row">
276 <style:table-row-properties style:row-height="5.29mm" fo:break-before="auto" style:use-optimal-row-height="true"/>
277 </style:style>
278 <style:style style:name="ro5" style:family="table-row">
279 <style:table-row-properties style:row-height="4.66mm" fo:break-before="auto" style:use-optimal-row-height="true"/>
280 </style:style>
281 <style:style style:name="ta1" style:family="table" style:master-page-name="Default">
282 <style:table-properties table:display="true" style:writing-mode="lr-tb"/>
283 </style:style>
284 <number:boolean-style style:name="N99">
285 <number:boolean/>
286 </number:boolean-style>
287 <style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default"/>
288 <style:style style:name="ce2" style:family="table-cell" style:parent-style-name="Default">
289 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
290 <style:paragraph-properties fo:text-align="start" fo:margin-left="0mm"/>
291 <style:text-properties fo:font-size="20pt" fo:font-weight="bold" style:font-size-asian="20pt" style:font-weight-asian="bold" style:font-size-complex="20pt" style:font-weight-complex="bold"/>
292 </style:style>
293 <style:style style:name="ce3" style:family="table-cell" style:parent-style-name="Default">
294 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
295 <style:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/>
296 <style:text-properties fo:font-size="14pt" fo:font-weight="bold" style:font-size-asian="14pt" style:font-weight-asian="bold" style:font-size-complex="14pt" style:font-weight-complex="bold"/>
297 </style:style>
298 <style:style style:name="ce4" style:family="table-cell" style:parent-style-name="Default">
299 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
300 <style:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/>
301 <style:text-properties fo:font-size="12pt" fo:font-weight="bold" style:font-size-asian="12pt" style:font-weight-asian="bold" style:font-size-complex="12pt" style:font-weight-complex="bold"/>
302 </style:style>
303 <style:style style:name="ce5" style:family="table-cell" style:parent-style-name="Default">
304 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
305 <style:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/>
306 </style:style>
307 <style:style style:name="ce6" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
308 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
309 <style:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/>
310 <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B3"/>
311 <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B3"/>
312 <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B3"/>
313 </style:style>
314 <style:style style:name="ce7" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
315 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
316 <style:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/>
317 <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
318 <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
319 <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
320 </style:style>
321 <style:style style:name="ce8" style:family="table-cell" style:parent-style-name="Default">
322 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
323 <style:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/>
324 <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
325 <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
326 <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
327 </style:style>
328 <style:style style:name="ce9" style:family="table-cell" style:parent-style-name="Default">
329 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
330 <style:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/>
331 <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
332 </style:style>
333 <style:style style:name="ce10" style:family="table-cell" style:parent-style-name="Default">
334 <style:text-properties style:font-name-asian="Microsoft YaHei" style:font-name-complex="Mangal"/>
335 </style:style>
336 <style:style style:name="ce11" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
337 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
338 <style:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/>
339 <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/>
340 <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/>
341 <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/>
342 </style:style>
343 <style:style style:name="ce12" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
344 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
345 <style:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/>
346 <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C6"/>
347 <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C6"/>
348 <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C6"/>
349 </style:style>
350 <style:style style:name="ce13" style:family="table-cell" style:parent-style-name="Default">
351 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
352 <style:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/>
353 <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/>
354 <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/>
355 <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/>
356 </style:style>
357 <style:style style:name="ce14" style:family="table-cell" style:parent-style-name="Default">
358 <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
359 </style:style>
360 <style:style style:name="ce15" style:family="table-cell" style:parent-style-name="Default">
361 <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Courier New" fo:font-size="10pt" fo:language="en" fo:country="US" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:text-underline-mode="continuous" style:text-overline-mode="continuous" style:text-line-through-mode="continuous" style:font-size-asian="10pt" style:language-asian="en" style:country-asian="US" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:language-complex="en" style:country-complex="US" style:font-style-complex="normal" style:font-weight-complex="normal" style:text-emphasize="none" style:font-relief="none" style:text-overline-style="none" style:text-overline-color="font-color"/>
362 </style:style>
363 <style:style style:name="ce16" style:family="table-cell" style:parent-style-name="Default">
364 <style:table-cell-properties fo:background-color="#ffff00"/>
365 <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
366 </style:style>
367 <style:style style:name="ce17" style:family="table-cell" style:parent-style-name="Default">
368 <style:table-cell-properties fo:background-color="#ffff00"/>
369 </style:style>
370 <style:style style:name="ta_extref" style:family="table">
371 <style:table-properties table:display="false"/>
372 </style:style>
373 <style:page-layout style:name="pm1">
374 <style:page-layout-properties style:writing-mode="lr-tb"/>
375 <style:header-style>
376 <style:header-footer-properties fo:min-height="7.5mm" fo:margin-left="0mm" fo:margin-right="0mm" fo:margin-bottom="2.5mm"/>
377 </style:header-style>
378 <style:footer-style>
379 <style:header-footer-properties fo:min-height="7.5mm" fo:margin-left="0mm" fo:margin-right="0mm" fo:margin-top="2.5mm"/>
380 </style:footer-style>
381 </style:page-layout>
382 <style:page-layout style:name="pm2">
383 <style:page-layout-properties style:writing-mode="lr-tb"/>
384 <style:header-style>
385 <style:header-footer-properties fo:min-height="7.5mm" fo:margin-left="0mm" fo:margin-right="0mm" fo:margin-bottom="2.5mm" fo:border="2.49pt solid #000000" fo:padding="0.18mm" fo:background-color="#c0c0c0">
386 <style:background-image/>
387 </style:header-footer-properties>
388 </style:header-style>
389 <style:footer-style>
390 <style:header-footer-properties fo:min-height="7.5mm" fo:margin-left="0mm" fo:margin-right="0mm" fo:margin-top="2.5mm" fo:border="2.49pt solid #000000" fo:padding="0.18mm" fo:background-color="#c0c0c0">
391 <style:background-image/>
392 </style:header-footer-properties>
393 </style:footer-style>
394 </style:page-layout>
395 <style:style style:name="T1" style:family="text">
396 <style:text-properties style:font-name-asian="Microsoft YaHei" style:font-name-complex="Mangal"/>
397 </style:style>
398 <style:style style:name="T2" style:family="text">
399 <style:text-properties style:font-name-asian="Microsoft YaHei" style:font-name-complex="Mangal" fo:color="#0000ff"/>
400 </style:style>
401 <style:style style:name="T3" style:family="text">
402 <style:text-properties style:font-name-asian="Microsoft YaHei" style:font-name-complex="Mangal" fo:color="#ff0000"/>
403 </style:style>
404 <style:style style:name="T4" style:family="text">
405 <style:text-properties fo:color="#0000ff" style:font-name-asian="Microsoft YaHei" style:font-name-complex="Mangal"/>
406 </style:style>
407 <style:style style:name="T5" style:family="text">
408 <style:text-properties fo:color="#0000ff"/>
409 </style:style>
410 <style:style style:name="T6" style:family="text">
411 <style:text-properties fo:color="#ff0000"/>
412 </style:style>
413 </office:automatic-styles>
414 <office:master-styles>
415 <style:master-page style:name="Default" style:page-layout-name="pm1">
416 <style:header>
417 <text:p><text:sheet-name>???</text:sheet-name></text:p>
418 </style:header>
419 <style:header-left style:display="false"/>
420 <style:footer>
421 <text:p>Page <text:page-number>1</text:page-number></text:p>
422 </style:footer>
423 <style:footer-left style:display="false"/>
424 </style:master-page>
425 <style:master-page style:name="Report" style:page-layout-name="pm2">
426 <style:header>
427 <style:region-left>
428 <text:p><text:sheet-name>???</text:sheet-name> (<text:title>???</text:title>)</text:p>
429 </style:region-left>
430 <style:region-right>
431 <text:p><text:date style:data-style-name="N2" text:date-value="2016-05-20">00.00.0000</text:date>, <text:time style:data-style-name="N2" text:time-value="15:18:12.687346294">00:00:00</text:time></text:p>
432 </style:region-right>
433 </style:header>
434 <style:header-left style:display="false"/>
435 <style:footer>
436 <text:p>Page <text:page-number>1</text:page-number> / <text:page-count>99</text:page-count></text:p>
437 </style:footer>
438 <style:footer-left style:display="false"/>
439 </style:master-page>
440 </office:master-styles>
441 <office:body>
442 <office:spreadsheet>
443 <table:calculation-settings table:automatic-find-labels="false"/>
444 <table:table table:name="Sheet1" table:style-name="ta1">
445 <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
446 <table:table-column table:style-name="co1" table:default-cell-style-name="ce5"/>
447 <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/>
448 <table:table-row table:style-name="ro1">
449 <table:table-cell table:style-name="ce2" office:value-type="string" calcext:value-type="string">
450 <text:p>DCOUNTA Function</text:p>
451 </table:table-cell>
452 <table:table-cell table:number-columns-repeated="2"/>
453 </table:table-row>
454 <table:table-row table:style-name="ro2">
455 <table:table-cell table:number-columns-repeated="3"/>
456 </table:table-row>
457 <table:table-row table:style-name="ro3">
458 <table:table-cell table:style-name="ce3" office:value-type="string" calcext:value-type="string">
459 <text:p>Result</text:p>
460 </table:table-cell>
461 <table:table-cell table:style-name="ce6" table:formula="of:=AND([.B8:.B95])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
462 <text:p>PRAVDA</text:p>
463 </table:table-cell>
464 <table:table-cell/>
465 </table:table-row>
466 <table:table-row table:style-name="ro2" table:number-rows-repeated="3">
467 <table:table-cell table:number-columns-repeated="3"/>
468 </table:table-row>
469 <table:table-row table:style-name="ro4">
470 <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string">
471 <text:p>Sheet</text:p>
472 </table:table-cell>
473 <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string">
474 <text:p>Result</text:p>
475 </table:table-cell>
476 <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string">
477 <text:p>Description</text:p>
478 </table:table-cell>
479 </table:table-row>
480 <table:table-row table:style-name="ro2">
481 <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float">
482 <text:p>1</text:p>
483 </table:table-cell>
484 <table:table-cell table:style-name="ce7" table:formula="of:=AND([Sheet2.C2:.C100])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
485 <text:p>PRAVDA</text:p>
486 </table:table-cell>
487 <table:table-cell office:value-type="string" calcext:value-type="string">
488 <text:p>Simple DCOUNTA formulas with local references and values</text:p>
489 </table:table-cell>
490 </table:table-row>
491 <table:table-row table:style-name="ro2" table:number-rows-repeated="30">
492 <table:table-cell/>
493 <table:table-cell table:style-name="ce8"/>
494 <table:table-cell/>
495 </table:table-row>
496 <table:table-row table:style-name="ro2" table:number-rows-repeated="1048537">
497 <table:table-cell table:number-columns-repeated="3"/>
498 </table:table-row>
499 <table:table-row table:style-name="ro2">
500 <table:table-cell table:number-columns-repeated="3"/>
501 </table:table-row>
502 <calcext:conditional-formats>
503 <calcext:conditional-format calcext:target-range-address="Sheet1.B8:Sheet1.B38">
504 <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet1.B8"/>
505 <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet1.B8"/>
506 <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet1.B8"/>
507 </calcext:conditional-format>
508 <calcext:conditional-format calcext:target-range-address="Sheet1.B3:Sheet1.B3">
509 <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet1.B3"/>
510 <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet1.B3"/>
511 <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet1.B3"/>
512 </calcext:conditional-format>
513 </calcext:conditional-formats>
514 </table:table>
515 <table:table table:name="Sheet2" table:style-name="ta1" table:print="false">
516 <table:table-column table:style-name="co4" table:default-cell-style-name="Default"/>
517 <table:table-column table:style-name="co5" table:default-cell-style-name="Default"/>
518 <table:table-column table:style-name="co6" table:default-cell-style-name="ce5"/>
519 <table:table-column table:style-name="co7" table:default-cell-style-name="Default"/>
520 <table:table-column table:style-name="co8" table:default-cell-style-name="Default"/>
521 <table:table-column table:style-name="co9" table:number-columns-repeated="4" table:default-cell-style-name="Default"/>
522 <table:table-column table:style-name="co3" table:number-columns-repeated="6" table:default-cell-style-name="Default"/>
523 <table:table-row table:style-name="ro2">
524 <table:table-cell table:style-name="ce9" office:value-type="string" calcext:value-type="string">
525 <text:p>Function</text:p>
526 </table:table-cell>
527 <table:table-cell table:style-name="ce9" office:value-type="string" calcext:value-type="string">
528 <text:p>Expected</text:p>
529 </table:table-cell>
530 <table:table-cell table:style-name="ce9" office:value-type="string" calcext:value-type="string">
531 <text:p>Correct</text:p>
532 </table:table-cell>
533 <table:table-cell table:style-name="ce9" office:value-type="string" calcext:value-type="string">
534 <text:p>FunctionString</text:p>
535 </table:table-cell>
536 <table:table-cell table:style-name="ce9" office:value-type="string" calcext:value-type="string">
537 <text:p>Comment</text:p>
538 </table:table-cell>
539 <table:table-cell table:number-columns-repeated="4"/>
540 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
541 <text:p>Name</text:p>
542 </table:table-cell>
543 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
544 <text:p>Grade</text:p>
545 </table:table-cell>
546 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
547 <text:p>Age</text:p>
548 </table:table-cell>
549 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
550 <text:p>Distance to School</text:p>
551 </table:table-cell>
552 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
553 <text:p>Weight</text:p>
554 </table:table-cell>
555 <table:table-cell/>
556 </table:table-row>
557 <table:table-row table:style-name="ro5">
558 <table:table-cell table:style-name="ce10" table:formula="of:=DCOUNTA([.J1:.N10];&quot;Weight&quot;;[.J44:.N45])" office:value-type="float" office:value="2" calcext:value-type="float">
559 <text:p>2</text:p>
560 </table:table-cell>
561 <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
562 <text:p>2</text:p>
563 </table:table-cell>
564 <table:table-cell table:style-name="ce11" table:formula="of:=[.A2]=[.B2]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
565 <text:p>PRAVDA</text:p>
566 </table:table-cell>
567 <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string"><text:p><text:span text:style-name="T1">DCOUNTA(</text:span><text:span text:style-name="T2">J1:N10</text:span><text:span text:style-name="T1">;&quot;Weight&quot;;</text:span><text:span text:style-name="T3">J44:N45</text:span><text:span text:style-name="T1">)</text:span></text:p>
568 </table:table-cell>
569 <table:table-cell table:number-columns-repeated="5"/>
570 <table:table-cell office:value-type="string" calcext:value-type="string">
571 <text:p>Andy</text:p>
572 </table:table-cell>
573 <table:table-cell office:value-type="float" office:value="3" calcext:value-type="float">
574 <text:p>3</text:p>
575 </table:table-cell>
576 <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float">
577 <text:p>9</text:p>
578 </table:table-cell>
579 <table:table-cell office:value-type="float" office:value="150" calcext:value-type="float">
580 <text:p>150</text:p>
581 </table:table-cell>
582 <table:table-cell office:value-type="float" office:value="40" calcext:value-type="float">
583 <text:p>40</text:p>
584 </table:table-cell>
585 <table:table-cell/>
586 </table:table-row>
587 <table:table-row table:style-name="ro5">
588 <table:table-cell table:formula="of:=DCOUNTA([.J1:.N10];&quot;Weight&quot;;[.J13:.N15])" office:value-type="float" office:value="4" calcext:value-type="float">
589 <text:p>4</text:p>
590 </table:table-cell>
591 <table:table-cell office:value-type="float" office:value="4" calcext:value-type="float">
592 <text:p>4</text:p>
593 </table:table-cell>
594 <table:table-cell table:style-name="ce11" table:formula="of:=[.A3]=[.B3]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
595 <text:p>PRAVDA</text:p>
596 </table:table-cell>
597 <table:table-cell office:value-type="string" calcext:value-type="string"><text:p><text:span text:style-name="T4">DCOUNTA(</text:span><text:span text:style-name="T5">J1:N10</text:span>;&quot;Weight&quot;;<text:span text:style-name="T6">J13:N15</text:span>)</text:p>
598 </table:table-cell>
599 <table:table-cell table:number-columns-repeated="5"/>
600 <table:table-cell office:value-type="string" calcext:value-type="string">
601 <text:p>Betty</text:p>
602 </table:table-cell>
603 <table:table-cell office:value-type="float" office:value="4" calcext:value-type="float">
604 <text:p>4</text:p>
605 </table:table-cell>
606 <table:table-cell office:value-type="float" office:value="10" calcext:value-type="float">
607 <text:p>10</text:p>
608 </table:table-cell>
609 <table:table-cell office:value-type="float" office:value="1000" calcext:value-type="float">
610 <text:p>1000</text:p>
611 </table:table-cell>
612 <table:table-cell office:value-type="float" office:value="42" calcext:value-type="float">
613 <text:p>42</text:p>
614 </table:table-cell>
615 <table:table-cell/>
616 </table:table-row>
617 <table:table-row table:style-name="ro5">
618 <table:table-cell table:formula="of:=DCOUNTA([.J1:.N10];&quot;Weight&quot;;[.J17:.N18])" office:value-type="float" office:value="2" calcext:value-type="float">
619 <text:p>2</text:p>
620 </table:table-cell>
621 <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
622 <text:p>2</text:p>
623 </table:table-cell>
624 <table:table-cell table:style-name="ce11" table:formula="of:=[.A4]=[.B4]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
625 <text:p>PRAVDA</text:p>
626 </table:table-cell>
627 <table:table-cell office:value-type="string" calcext:value-type="string"><text:p><text:span text:style-name="T1">DCOUNTA</text:span>(<text:span text:style-name="T5">J1:N10</text:span>;&quot;Weight&quot;;<text:span text:style-name="T6">J17:N18</text:span>)</text:p>
628 </table:table-cell>
629 <table:table-cell table:number-columns-repeated="5"/>
630 <table:table-cell office:value-type="string" calcext:value-type="string">
631 <text:p>Clara</text:p>
632 </table:table-cell>
633 <table:table-cell office:value-type="float" office:value="3" calcext:value-type="float">
634 <text:p>3</text:p>
635 </table:table-cell>
636 <table:table-cell office:value-type="float" office:value="10" calcext:value-type="float">
637 <text:p>10</text:p>
638 </table:table-cell>
639 <table:table-cell office:value-type="float" office:value="300" calcext:value-type="float">
640 <text:p>300</text:p>
641 </table:table-cell>
642 <table:table-cell office:value-type="float" office:value="51" calcext:value-type="float">
643 <text:p>51</text:p>
644 </table:table-cell>
645 <table:table-cell/>
646 </table:table-row>
647 <table:table-row table:style-name="ro5">
648 <table:table-cell table:formula="of:=DCOUNTA([.J1:.N10];&quot;Weight&quot;;[.J20:.N21])" office:value-type="float" office:value="5" calcext:value-type="float">
649 <text:p>5</text:p>
650 </table:table-cell>
651 <table:table-cell office:value-type="float" office:value="5" calcext:value-type="float">
652 <text:p>5</text:p>
653 </table:table-cell>
654 <table:table-cell table:style-name="ce11" table:formula="of:=[.A5]=[.B5]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
655 <text:p>PRAVDA</text:p>
656 </table:table-cell>
657 <table:table-cell office:value-type="string" calcext:value-type="string"><text:p><text:span text:style-name="T1">DCOUNTA</text:span>(<text:span text:style-name="T5">J1:N10</text:span>;&quot;Weight&quot;;<text:span text:style-name="T6">J20:N21</text:span>)</text:p>
658 </table:table-cell>
659 <table:table-cell table:number-columns-repeated="5"/>
660 <table:table-cell office:value-type="string" calcext:value-type="string">
661 <text:p>Daniel</text:p>
662 </table:table-cell>
663 <table:table-cell office:value-type="float" office:value="5" calcext:value-type="float">
664 <text:p>5</text:p>
665 </table:table-cell>
666 <table:table-cell office:value-type="float" office:value="11" calcext:value-type="float">
667 <text:p>11</text:p>
668 </table:table-cell>
669 <table:table-cell office:value-type="float" office:value="1200" calcext:value-type="float">
670 <text:p>1200</text:p>
671 </table:table-cell>
672 <table:table-cell office:value-type="float" office:value="48" calcext:value-type="float">
673 <text:p>48</text:p>
674 </table:table-cell>
675 <table:table-cell/>
676 </table:table-row>
677 <table:table-row table:style-name="ro5">
678 <table:table-cell table:formula="of:=DCOUNTA([.J1:.N10];&quot;Weight&quot;;[.J56:.N57])" office:value-type="float" office:value="2" calcext:value-type="float">
679 <text:p>2</text:p>
680 </table:table-cell>
681 <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
682 <text:p>2</text:p>
683 </table:table-cell>
684 <table:table-cell table:style-name="ce12" table:formula="of:=[.A6]=[.B6]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
685 <text:p>PRAVDA</text:p>
686 </table:table-cell>
687 <table:table-cell office:value-type="string" calcext:value-type="string"><text:p><text:span text:style-name="T1">DCOUNTA</text:span>(J1:N10;&quot;Weight&quot;;J56:N57)</text:p>
688 </table:table-cell>
689 <table:table-cell table:number-columns-repeated="5"/>
690 <table:table-cell office:value-type="string" calcext:value-type="string">
691 <text:p>Eva</text:p>
692 </table:table-cell>
693 <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
694 <text:p>2</text:p>
695 </table:table-cell>
696 <table:table-cell office:value-type="float" office:value="8" calcext:value-type="float">
697 <text:p>8</text:p>
698 </table:table-cell>
699 <table:table-cell office:value-type="float" office:value="650" calcext:value-type="float">
700 <text:p>650</text:p>
701 </table:table-cell>
702 <table:table-cell office:value-type="float" office:value="33" calcext:value-type="float">
703 <text:p>33</text:p>
704 </table:table-cell>
705 <table:table-cell/>
706 </table:table-row>
707 <table:table-row table:style-name="ro5">
708 <table:table-cell table:formula="of:=DCOUNTA(database;&quot;Weight&quot;;criteria)" office:value-type="float" office:value="9" calcext:value-type="float">
709 <text:p>9</text:p>
710 </table:table-cell>
711 <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float">
712 <text:p>9</text:p>
713 </table:table-cell>
714 <table:table-cell table:style-name="ce12" table:formula="of:=[.A7]=[.B7]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
715 <text:p>PRAVDA</text:p>
716 </table:table-cell>
717 <table:table-cell office:value-type="string" calcext:value-type="string">
718 <text:p>DCOUNTA(database;&quot;Weight&quot;;criteria)</text:p>
719 </table:table-cell>
720 <table:table-cell table:number-columns-repeated="5"/>
721 <table:table-cell office:value-type="string" calcext:value-type="string">
722 <text:p>Frank</text:p>
723 </table:table-cell>
724 <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
725 <text:p>2</text:p>
726 </table:table-cell>
727 <table:table-cell office:value-type="float" office:value="7" calcext:value-type="float">
728 <text:p>7</text:p>
729 </table:table-cell>
730 <table:table-cell office:value-type="float" office:value="300" calcext:value-type="float">
731 <text:p>300</text:p>
732 </table:table-cell>
733 <table:table-cell office:value-type="float" office:value="42" calcext:value-type="float">
734 <text:p>42</text:p>
735 </table:table-cell>
736 <table:table-cell/>
737 </table:table-row>
738 <table:table-row table:style-name="ro2">
739 <table:table-cell table:formula="of:=DCOUNTA([.J1:.N10];;[.J41:.N42])" office:value-type="float" office:value="2" calcext:value-type="float">
740 <text:p>2</text:p>
741 </table:table-cell>
742 <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
743 <text:p>2</text:p>
744 </table:table-cell>
745 <table:table-cell table:style-name="ce29" table:formula="of:=[.A8]=[.B8]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
746 <text:p>TRUE</text:p>
747 </table:table-cell>
748 <table:table-cell table:formula="of:=FORMULA([.A8])" office:value-type="string" office:string-value="=DCOUNTA(J1:N10,,J41:N42)" calcext:value-type="string">
749 <text:p>=DCOUNTA(J1:N10,,J41:N42)</text:p>
750 </table:table-cell>
751 <table:table-cell office:value-type="string" calcext:value-type="string">
752 <text:p>Tdf#13353</text:p>
753 </table:table-cell>
754 <table:table-cell table:number-columns-repeated="4"/>
755 <table:table-cell office:value-type="string" calcext:value-type="string">
756 <text:p>Greta</text:p>
757 </table:table-cell>
758 <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float">
759 <text:p>1</text:p>
760 </table:table-cell>
761 <table:table-cell office:value-type="float" office:value="7" calcext:value-type="float">
762 <text:p>7</text:p>
763 </table:table-cell>
764 <table:table-cell office:value-type="float" office:value="200" calcext:value-type="float">
765 <text:p>200</text:p>
766 </table:table-cell>
767 <table:table-cell office:value-type="float" office:value="36" calcext:value-type="float">
768 <text:p>36</text:p>
769 </table:table-cell>
770 <table:table-cell/>
771 </table:table-row>
772 <table:table-row table:style-name="ro2">
773 <table:table-cell table:number-columns-repeated="2"/>
774 <table:table-cell table:style-name="ce13"/>
775 <table:table-cell table:number-columns-repeated="6"/>
776 <table:table-cell office:value-type="string" calcext:value-type="string">
777 <text:p>Harry</text:p>
778 </table:table-cell>
779 <table:table-cell office:value-type="float" office:value="3" calcext:value-type="float">
780 <text:p>3</text:p>
781 </table:table-cell>
782 <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float">
783 <text:p>9</text:p>
784 </table:table-cell>
785 <table:table-cell office:value-type="float" office:value="1200" calcext:value-type="float">
786 <text:p>1200</text:p>
787 </table:table-cell>
788 <table:table-cell office:value-type="float" office:value="44" calcext:value-type="float">
789 <text:p>44</text:p>
790 </table:table-cell>
791 <table:table-cell/>
792 </table:table-row>
793 <table:table-row table:style-name="ro2">
794 <table:table-cell table:number-columns-repeated="2"/>
795 <table:table-cell table:style-name="ce13"/>
796 <table:table-cell table:number-columns-repeated="6"/>
797 <table:table-cell office:value-type="string" calcext:value-type="string">
798 <text:p>Irene</text:p>
799 </table:table-cell>
800 <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
801 <text:p>2</text:p>
802 </table:table-cell>
803 <table:table-cell office:value-type="float" office:value="8" calcext:value-type="float">
804 <text:p>8</text:p>
805 </table:table-cell>
806 <table:table-cell office:value-type="float" office:value="1000" calcext:value-type="float">
807 <text:p>1000</text:p>
808 </table:table-cell>
809 <table:table-cell office:value-type="float" office:value="42" calcext:value-type="float">
810 <text:p>42</text:p>
811 </table:table-cell>
812 <table:table-cell/>
813 </table:table-row>
814 <table:table-row table:style-name="ro2" table:number-rows-repeated="2">
815 <table:table-cell table:number-columns-repeated="2"/>
816 <table:table-cell table:style-name="ce13"/>
817 <table:table-cell table:number-columns-repeated="12"/>
818 </table:table-row>
819 <table:table-row table:style-name="ro2">
820 <table:table-cell table:number-columns-repeated="2"/>
821 <table:table-cell table:style-name="ce13"/>
822 <table:table-cell table:number-columns-repeated="6"/>
823 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
824 <text:p>Name</text:p>
825 </table:table-cell>
826 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
827 <text:p>Grade</text:p>
828 </table:table-cell>
829 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
830 <text:p>Age</text:p>
831 </table:table-cell>
832 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
833 <text:p>Distance to School</text:p>
834 </table:table-cell>
835 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
836 <text:p>Weight</text:p>
837 </table:table-cell>
838 <table:table-cell/>
839 </table:table-row>
840 <table:table-row table:style-name="ro2">
841 <table:table-cell table:number-columns-repeated="2"/>
842 <table:table-cell table:style-name="ce13"/>
843 <table:table-cell table:number-columns-repeated="8"/>
844 <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float">
845 <text:p>9</text:p>
846 </table:table-cell>
847 <table:table-cell table:number-columns-repeated="3"/>
848 </table:table-row>
849 <table:table-row table:style-name="ro2">
850 <table:table-cell table:number-columns-repeated="2"/>
851 <table:table-cell table:style-name="ce13"/>
852 <table:table-cell table:number-columns-repeated="8"/>
853 <table:table-cell office:value-type="float" office:value="10" calcext:value-type="float">
854 <text:p>10</text:p>
855 </table:table-cell>
856 <table:table-cell table:number-columns-repeated="3"/>
857 </table:table-row>
858 <table:table-row table:style-name="ro2">
859 <table:table-cell table:number-columns-repeated="2"/>
860 <table:table-cell table:style-name="ce13"/>
861 <table:table-cell table:number-columns-repeated="12"/>
862 </table:table-row>
863 <table:table-row table:style-name="ro2">
864 <table:table-cell table:number-columns-repeated="2"/>
865 <table:table-cell table:style-name="ce13"/>
866 <table:table-cell table:number-columns-repeated="6"/>
867 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
868 <text:p>Name</text:p>
869 </table:table-cell>
870 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
871 <text:p>Grade</text:p>
872 </table:table-cell>
873 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
874 <text:p>Age</text:p>
875 </table:table-cell>
876 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
877 <text:p>Distance to School</text:p>
878 </table:table-cell>
879 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
880 <text:p>Weight</text:p>
881 </table:table-cell>
882 <table:table-cell/>
883 </table:table-row>
884 <table:table-row table:style-name="ro2">
885 <table:table-cell table:number-columns-repeated="2"/>
886 <table:table-cell table:style-name="ce13"/>
887 <table:table-cell table:number-columns-repeated="7"/>
888 <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
889 <text:p>2</text:p>
890 </table:table-cell>
891 <table:table-cell office:value-type="string" calcext:value-type="string">
892 <text:p>&gt;7</text:p>
893 </table:table-cell>
894 <table:table-cell table:number-columns-repeated="3"/>
895 </table:table-row>
896 <table:table-row table:style-name="ro2">
897 <table:table-cell table:number-columns-repeated="2"/>
898 <table:table-cell table:style-name="ce13"/>
899 <table:table-cell table:number-columns-repeated="12"/>
900 </table:table-row>
901 <table:table-row table:style-name="ro2">
902 <table:table-cell table:number-columns-repeated="2"/>
903 <table:table-cell table:style-name="ce13"/>
904 <table:table-cell table:number-columns-repeated="6"/>
905 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
906 <text:p>Name</text:p>
907 </table:table-cell>
908 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
909 <text:p>Grade</text:p>
910 </table:table-cell>
911 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
912 <text:p>Age</text:p>
913 </table:table-cell>
914 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
915 <text:p>Distance to School</text:p>
916 </table:table-cell>
917 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
918 <text:p>Weight</text:p>
919 </table:table-cell>
920 <table:table-cell/>
921 </table:table-row>
922 <table:table-row table:style-name="ro2">
923 <table:table-cell table:number-columns-repeated="2"/>
924 <table:table-cell table:style-name="ce13"/>
925 <table:table-cell table:number-columns-repeated="6"/>
926 <table:table-cell table:style-name="ce15" office:value-type="string" calcext:value-type="string">
927 <text:p>&gt;=E</text:p>
928 </table:table-cell>
929 <table:table-cell table:number-columns-repeated="5"/>
930 </table:table-row>
931 <table:table-row table:style-name="ro2">
932 <table:table-cell table:number-columns-repeated="2"/>
933 <table:table-cell table:style-name="ce13"/>
934 <table:table-cell table:number-columns-repeated="12"/>
935 </table:table-row>
936 <table:table-row table:style-name="ro2">
937 <table:table-cell table:number-columns-repeated="2"/>
938 <table:table-cell table:style-name="ce13"/>
939 <table:table-cell table:number-columns-repeated="6"/>
940 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
941 <text:p>Name</text:p>
942 </table:table-cell>
943 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
944 <text:p>Grade</text:p>
945 </table:table-cell>
946 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
947 <text:p>Age</text:p>
948 </table:table-cell>
949 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
950 <text:p>Distance to School</text:p>
951 </table:table-cell>
952 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
953 <text:p>Weight</text:p>
954 </table:table-cell>
955 <table:table-cell/>
956 </table:table-row>
957 <table:table-row table:style-name="ro2">
958 <table:table-cell table:number-columns-repeated="2"/>
959 <table:table-cell table:style-name="ce13"/>
960 <table:table-cell table:number-columns-repeated="6"/>
961 <table:table-cell office:value-type="string" calcext:value-type="string">
962 <text:p>Frank</text:p>
963 </table:table-cell>
964 <table:table-cell table:number-columns-repeated="5"/>
965 </table:table-row>
966 <table:table-row table:style-name="ro2">
967 <table:table-cell table:number-columns-repeated="2"/>
968 <table:table-cell table:style-name="ce13"/>
969 <table:table-cell table:number-columns-repeated="12"/>
970 </table:table-row>
971 <table:table-row table:style-name="ro2">
972 <table:table-cell table:number-columns-repeated="2"/>
973 <table:table-cell table:style-name="ce13"/>
974 <table:table-cell table:number-columns-repeated="6"/>
975 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
976 <text:p>Name</text:p>
977 </table:table-cell>
978 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
979 <text:p>Grade</text:p>
980 </table:table-cell>
981 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
982 <text:p>Age</text:p>
983 </table:table-cell>
984 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
985 <text:p>Distance to School</text:p>
986 </table:table-cell>
987 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
988 <text:p>Weight</text:p>
989 </table:table-cell>
990 <table:table-cell/>
991 </table:table-row>
992 <table:table-row table:style-name="ro2">
993 <table:table-cell table:number-columns-repeated="2"/>
994 <table:table-cell table:style-name="ce13"/>
995 <table:table-cell table:number-columns-repeated="7"/>
996 <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float">
997 <text:p>1</text:p>
998 </table:table-cell>
999 <table:table-cell table:number-columns-repeated="4"/>
1000 </table:table-row>
1001 <table:table-row table:style-name="ro2">
1002 <table:table-cell table:number-columns-repeated="2"/>
1003 <table:table-cell table:style-name="ce13"/>
1004 <table:table-cell table:number-columns-repeated="7"/>
1005 <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
1006 <text:p>2</text:p>
1007 </table:table-cell>
1008 <table:table-cell table:number-columns-repeated="4"/>
1009 </table:table-row>
1010 <table:table-row table:style-name="ro2">
1011 <table:table-cell table:number-columns-repeated="2"/>
1012 <table:table-cell table:style-name="ce13"/>
1013 <table:table-cell table:number-columns-repeated="7"/>
1014 <table:table-cell office:value-type="float" office:value="3" calcext:value-type="float">
1015 <text:p>3</text:p>
1016 </table:table-cell>
1017 <table:table-cell table:number-columns-repeated="4"/>
1018 </table:table-row>
1019 <table:table-row table:style-name="ro2">
1020 <table:table-cell table:number-columns-repeated="2"/>
1021 <table:table-cell table:style-name="ce13"/>
1022 <table:table-cell table:number-columns-repeated="7"/>
1023 <table:table-cell office:value-type="float" office:value="4" calcext:value-type="float">
1024 <text:p>4</text:p>
1025 </table:table-cell>
1026 <table:table-cell table:number-columns-repeated="4"/>
1027 </table:table-row>
1028 <table:table-row table:style-name="ro2">
1029 <table:table-cell table:number-columns-repeated="2"/>
1030 <table:table-cell table:style-name="ce13"/>
1031 <table:table-cell table:number-columns-repeated="7"/>
1032 <table:table-cell office:value-type="float" office:value="5" calcext:value-type="float">
1033 <text:p>5</text:p>
1034 </table:table-cell>
1035 <table:table-cell table:number-columns-repeated="4"/>
1036 </table:table-row>
1037 <table:table-row table:style-name="ro2">
1038 <table:table-cell table:number-columns-repeated="2"/>
1039 <table:table-cell table:style-name="ce13"/>
1040 <table:table-cell table:number-columns-repeated="12"/>
1041 </table:table-row>
1042 <table:table-row table:style-name="ro2">
1043 <table:table-cell table:number-columns-repeated="2"/>
1044 <table:table-cell table:style-name="ce13"/>
1045 <table:table-cell table:number-columns-repeated="6"/>
1046 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1047 <text:p>Name</text:p>
1048 </table:table-cell>
1049 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1050 <text:p>Grade</text:p>
1051 </table:table-cell>
1052 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1053 <text:p>Age</text:p>
1054 </table:table-cell>
1055 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1056 <text:p>Distance to School</text:p>
1057 </table:table-cell>
1058 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1059 <text:p>Weight</text:p>
1060 </table:table-cell>
1061 <table:table-cell/>
1062 </table:table-row>
1063 <table:table-row table:style-name="ro2">
1064 <table:table-cell table:number-columns-repeated="2"/>
1065 <table:table-cell table:style-name="ce13"/>
1066 <table:table-cell table:number-columns-repeated="7"/>
1067 <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float">
1068 <text:p>1</text:p>
1069 </table:table-cell>
1070 <table:table-cell table:number-columns-repeated="4"/>
1071 </table:table-row>
1072 <table:table-row table:style-name="ro2">
1073 <table:table-cell table:number-columns-repeated="2"/>
1074 <table:table-cell table:style-name="ce13"/>
1075 <table:table-cell table:number-columns-repeated="7"/>
1076 <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
1077 <text:p>2</text:p>
1078 </table:table-cell>
1079 <table:table-cell table:number-columns-repeated="4"/>
1080 </table:table-row>
1081 <table:table-row table:style-name="ro2">
1082 <table:table-cell table:number-columns-repeated="2"/>
1083 <table:table-cell table:style-name="ce13"/>
1084 <table:table-cell table:number-columns-repeated="7"/>
1085 <table:table-cell office:value-type="float" office:value="3" calcext:value-type="float">
1086 <text:p>3</text:p>
1087 </table:table-cell>
1088 <table:table-cell table:number-columns-repeated="4"/>
1089 </table:table-row>
1090 <table:table-row table:style-name="ro2">
1091 <table:table-cell table:number-columns-repeated="2"/>
1092 <table:table-cell table:style-name="ce13"/>
1093 <table:table-cell table:number-columns-repeated="12"/>
1094 </table:table-row>
1095 <table:table-row table:style-name="ro2">
1096 <table:table-cell table:number-columns-repeated="2"/>
1097 <table:table-cell table:style-name="ce13"/>
1098 <table:table-cell table:number-columns-repeated="6"/>
1099 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1100 <text:p>Name</text:p>
1101 </table:table-cell>
1102 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1103 <text:p>Grade</text:p>
1104 </table:table-cell>
1105 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1106 <text:p>Age</text:p>
1107 </table:table-cell>
1108 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1109 <text:p>Distance to School</text:p>
1110 </table:table-cell>
1111 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1112 <text:p>Weight</text:p>
1113 </table:table-cell>
1114 <table:table-cell/>
1115 </table:table-row>
1116 <table:table-row table:style-name="ro2">
1117 <table:table-cell table:number-columns-repeated="2"/>
1118 <table:table-cell table:style-name="ce13"/>
1119 <table:table-cell table:number-columns-repeated="7"/>
1120 <table:table-cell office:value-type="float" office:value="3" calcext:value-type="float">
1121 <text:p>3</text:p>
1122 </table:table-cell>
1123 <table:table-cell table:number-columns-repeated="4"/>
1124 </table:table-row>
1125 <table:table-row table:style-name="ro2">
1126 <table:table-cell table:number-columns-repeated="2"/>
1127 <table:table-cell table:style-name="ce13"/>
1128 <table:table-cell table:number-columns-repeated="12"/>
1129 </table:table-row>
1130 <table:table-row table:style-name="ro2">
1131 <table:table-cell table:number-columns-repeated="2"/>
1132 <table:table-cell table:style-name="ce13"/>
1133 <table:table-cell table:number-columns-repeated="6"/>
1134 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1135 <text:p>Name</text:p>
1136 </table:table-cell>
1137 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1138 <text:p>Grade</text:p>
1139 </table:table-cell>
1140 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1141 <text:p>Age</text:p>
1142 </table:table-cell>
1143 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1144 <text:p>Distance to School</text:p>
1145 </table:table-cell>
1146 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1147 <text:p>Weight</text:p>
1148 </table:table-cell>
1149 <table:table-cell/>
1150 </table:table-row>
1151 <table:table-row table:style-name="ro2">
1152 <table:table-cell table:number-columns-repeated="2"/>
1153 <table:table-cell table:style-name="ce13"/>
1154 <table:table-cell table:number-columns-repeated="8"/>
1155 <table:table-cell office:value-type="float" office:value="10" calcext:value-type="float">
1156 <text:p>10</text:p>
1157 </table:table-cell>
1158 <table:table-cell table:number-columns-repeated="3"/>
1159 </table:table-row>
1160 <table:table-row table:style-name="ro2">
1161 <table:table-cell table:number-columns-repeated="15"/>
1162 </table:table-row>
1163 <table:table-row table:style-name="ro2">
1164 <table:table-cell table:number-columns-repeated="9"/>
1165 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1166 <text:p>Name</text:p>
1167 </table:table-cell>
1168 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1169 <text:p>Grade</text:p>
1170 </table:table-cell>
1171 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1172 <text:p>Age</text:p>
1173 </table:table-cell>
1174 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1175 <text:p>Distance to School</text:p>
1176 </table:table-cell>
1177 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1178 <text:p>Weight</text:p>
1179 </table:table-cell>
1180 <table:table-cell/>
1181 </table:table-row>
1182 <table:table-row table:style-name="ro2">
1183 <table:table-cell table:number-columns-repeated="11"/>
1184 <table:table-cell office:value-type="float" office:value="7" calcext:value-type="float">
1185 <text:p>7</text:p>
1186 </table:table-cell>
1187 <table:table-cell table:number-columns-repeated="3"/>
1188 </table:table-row>
1189 <table:table-row table:style-name="ro2">
1190 <table:table-cell table:number-columns-repeated="15"/>
1191 </table:table-row>
1192 <table:table-row table:style-name="ro2">
1193 <table:table-cell table:number-columns-repeated="9"/>
1194 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1195 <text:p>Name</text:p>
1196 </table:table-cell>
1197 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1198 <text:p>Grade</text:p>
1199 </table:table-cell>
1200 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1201 <text:p>Age</text:p>
1202 </table:table-cell>
1203 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1204 <text:p>Distance to School</text:p>
1205 </table:table-cell>
1206 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1207 <text:p>Weight</text:p>
1208 </table:table-cell>
1209 <table:table-cell/>
1210 </table:table-row>
1211 <table:table-row table:style-name="ro2">
1212 <table:table-cell table:number-columns-repeated="11"/>
1213 <table:table-cell office:value-type="float" office:value="8" calcext:value-type="float">
1214 <text:p>8</text:p>
1215 </table:table-cell>
1216 <table:table-cell table:number-columns-repeated="3"/>
1217 </table:table-row>
1218 <table:table-row table:style-name="ro2">
1219 <table:table-cell table:number-columns-repeated="15"/>
1220 </table:table-row>
1221 <table:table-row table:style-name="ro2">
1222 <table:table-cell table:number-columns-repeated="9"/>
1223 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1224 <text:p>Name</text:p>
1225 </table:table-cell>
1226 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1227 <text:p>Grade</text:p>
1228 </table:table-cell>
1229 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1230 <text:p>Age</text:p>
1231 </table:table-cell>
1232 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1233 <text:p>Distance to School</text:p>
1234 </table:table-cell>
1235 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1236 <text:p>Weight</text:p>
1237 </table:table-cell>
1238 <table:table-cell/>
1239 </table:table-row>
1240 <table:table-row table:style-name="ro2">
1241 <table:table-cell table:number-columns-repeated="10"/>
1242 <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float">
1243 <text:p>2</text:p>
1244 </table:table-cell>
1245 <table:table-cell table:number-columns-repeated="4"/>
1246 </table:table-row>
1247 <table:table-row table:style-name="ro2">
1248 <table:table-cell table:number-columns-repeated="15"/>
1249 </table:table-row>
1250 <table:table-row table:style-name="ro2">
1251 <table:table-cell table:number-columns-repeated="9"/>
1252 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1253 <text:p>Name</text:p>
1254 </table:table-cell>
1255 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1256 <text:p>Grade</text:p>
1257 </table:table-cell>
1258 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1259 <text:p>Age</text:p>
1260 </table:table-cell>
1261 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1262 <text:p>Distance to School</text:p>
1263 </table:table-cell>
1264 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1265 <text:p>Weight</text:p>
1266 </table:table-cell>
1267 <table:table-cell/>
1268 </table:table-row>
1269 <table:table-row table:style-name="ro2">
1270 <table:table-cell table:number-columns-repeated="11"/>
1271 <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float">
1272 <text:p>9</text:p>
1273 </table:table-cell>
1274 <table:table-cell table:number-columns-repeated="3"/>
1275 </table:table-row>
1276 <table:table-row table:style-name="ro2">
1277 <table:table-cell table:number-columns-repeated="15"/>
1278 </table:table-row>
1279 <table:table-row table:style-name="ro2">
1280 <table:table-cell table:number-columns-repeated="9"/>
1281 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1282 <text:p>Name</text:p>
1283 </table:table-cell>
1284 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1285 <text:p>Grade</text:p>
1286 </table:table-cell>
1287 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1288 <text:p>Age</text:p>
1289 </table:table-cell>
1290 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1291 <text:p>Distance to School</text:p>
1292 </table:table-cell>
1293 <table:table-cell table:style-name="ce14" office:value-type="string" calcext:value-type="string">
1294 <text:p>Weight</text:p>
1295 </table:table-cell>
1296 <table:table-cell/>
1297 </table:table-row>
1298 <table:table-row table:style-name="ro2">
1299 <table:table-cell table:number-columns-repeated="9"/>
1300 <table:table-cell office:value-type="string" calcext:value-type="string">
1301 <text:p>[E-F].*</text:p>
1302 </table:table-cell>
1303 <table:table-cell table:number-columns-repeated="5"/>
1304 </table:table-row>
1305 <table:table-row table:style-name="ro2">
1306 <table:table-cell table:number-columns-repeated="15"/>
1307 </table:table-row>
1308 <table:table-row table:style-name="ro2">
1309 <table:table-cell table:number-columns-repeated="9"/>
1310 <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
1311 <text:p>Name</text:p>
1312 </table:table-cell>
1313 <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
1314 <text:p>Grade</text:p>
1315 </table:table-cell>
1316 <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
1317 <text:p>Age</text:p>
1318 </table:table-cell>
1319 <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
1320 <text:p>Distance to School</text:p>
1321 </table:table-cell>
1322 <table:table-cell table:style-name="ce16" office:value-type="string" calcext:value-type="string">
1323 <text:p>Weight</text:p>
1324 </table:table-cell>
1325 <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string">
1326 <text:p>Age</text:p>
1327 </table:table-cell>
1328 </table:table-row>
1329 <table:table-row table:style-name="ro2">
1330 <table:table-cell table:number-columns-repeated="9"/>
1331 <table:table-cell table:style-name="ce17" table:number-columns-repeated="2"/>
1332 <table:table-cell table:style-name="ce17" office:value-type="string" calcext:value-type="string">
1333 <text:p>&gt;0</text:p>
1334 </table:table-cell>
1335 <table:table-cell table:style-name="ce17" table:number-columns-repeated="3"/>
1336 </table:table-row>
1337 <table:table-row table:style-name="ro2">
1338 <table:table-cell table:number-columns-repeated="9"/>
1339 <table:table-cell table:style-name="ce17" table:number-columns-repeated="6"/>
1340 </table:table-row>
1341 <table:table-row table:style-name="ro2" table:number-rows-repeated="1048514">
1342 <table:table-cell table:number-columns-repeated="15"/>
1343 </table:table-row>
1344 <table:table-row table:style-name="ro2">
1345 <table:table-cell table:number-columns-repeated="15"/>
1346 </table:table-row>
1347 <calcext:conditional-formats>
1348 <calcext:conditional-format calcext:target-range-address="Sheet2.C8:Sheet2.C42 Sheet2.C2:Sheet2.C5">
1349 <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C2"/>
1350 <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C2"/>
1351 <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C2"/>
1352 </calcext:conditional-format>
1353 <calcext:conditional-format calcext:target-range-address="Sheet2.C6:Sheet2.C7">
1354 <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C6"/>
1355 <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C6"/>
1356 <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C6"/>
1357 </calcext:conditional-format>
1358 </calcext:conditional-formats>
1359 </table:table>
1360 <table:table table:name="&apos;file:///home/zdenek/lodev/libreoffice/sc/qa/unit/data/functions/fods/function_based_test_Example.fods/function_based_test_Example_reference.fods&apos;#Sheet2" table:print="false" table:style-name="ta_extref">
1361 <table:table-source xlink:type="simple" xlink:href="function_based_test_Example.fods/function_based_test_Example_reference.fods" table:table-name="Sheet2" table:mode="copy-results-only"/>
1362 <table:table-column table:number-columns-repeated="8"/>
1363 <table:table-row table:number-rows-repeated="2">
1364 <table:table-cell table:number-columns-repeated="8"/>
1365 </table:table-row>
1366 <table:table-row>
1367 <table:table-cell table:number-columns-repeated="7"/>
1368 <table:table-cell table:style-name="ce1" office:value-type="float" office:value="4">
1369 <text:p>4</text:p>
1370 </table:table-cell>
1371 </table:table-row>
1372 </table:table>
1373 <table:named-expressions>
1374 <table:named-range table:name="criteria" table:base-cell-address="$Sheet2.$J$59" table:cell-range-address="$Sheet2.$J$59:.$O$61"/>
1375 <table:named-range table:name="database" table:base-cell-address="$Sheet2.$J$1" table:cell-range-address="$Sheet2.$J$1:.$N$10"/>
1376 </table:named-expressions>
1377 </office:spreadsheet>
1378 </office:body>
1379 </office:document>