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