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">
5 <style:default-style style:
family=
"table-cell">
6 <style:paragraph-properties style:
tab-stop-distance=
"36pt"/>
7 <style:text-properties style:
font-name=
"Liberation Sans" fo:
language=
"en" fo:
country=
"US" style:
font-name-asian=
"DejaVu Sans" style:
language-asian=
"zh" style:
country-asian=
"CN" style:
font-name-complex=
"DejaVu Sans" style:
language-complex=
"hi" style:
country-complex=
"IN"/>
9 <number:number-style style:
name=
"N0">
10 <number:number number:
min-integer-digits=
"1"/>
11 </number:number-style>
12 <number:currency-style style:
name=
"N122P0" style:
volatile=
"true">
13 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
14 <number:text> </number:text>
15 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
16 </number:currency-style>
17 <number:currency-style style:
name=
"N122">
18 <style:text-properties fo:
color=
"#ff0000"/>
19 <number:text>-
</number:text>
20 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
21 <number:text> </number:text>
22 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
23 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N122P0"/>
24 </number:currency-style>
25 <number:currency-style style:
name=
"N124P0" style:
volatile=
"true">
26 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
27 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
28 </number:currency-style>
29 <number:currency-style style:
name=
"N124">
30 <number:text>-
</number:text>
31 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
32 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
33 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N124P0"/>
34 </number:currency-style>
35 <number:currency-style style:
name=
"N126P0" style:
volatile=
"true">
36 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
37 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
38 </number:currency-style>
39 <number:currency-style style:
name=
"N126">
40 <number:text>-
</number:text>
41 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
42 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
43 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N126P0"/>
44 </number:currency-style>
45 <number:currency-style style:
name=
"N127P0" style:
volatile=
"true">
46 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
47 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
48 </number:currency-style>
49 <number:currency-style style:
name=
"N127">
50 <style:text-properties fo:
color=
"#ff0000"/>
51 <number:text>-
</number:text>
52 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
53 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
54 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N127P0"/>
55 </number:currency-style>
56 <number:currency-style style:
name=
"N128P0" style:
volatile=
"true">
57 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
58 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
59 </number:currency-style>
60 <number:currency-style style:
name=
"N128">
61 <style:text-properties fo:
color=
"#ff0000"/>
62 <number:text>-
</number:text>
63 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
64 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
65 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N128P0"/>
66 </number:currency-style>
67 <number:currency-style style:
name=
"N130P0" style:
volatile=
"true">
68 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
69 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
decimal-replacement=
"--" number:
grouping=
"true"/>
70 </number:currency-style>
71 <number:currency-style style:
name=
"N130">
72 <style:text-properties fo:
color=
"#ff0000"/>
73 <number:text>-
</number:text>
74 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
75 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
decimal-replacement=
"--" number:
grouping=
"true"/>
76 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N130P0"/>
77 </number:currency-style>
78 <number:number-style style:
name=
"N132P0" style:
volatile=
"true">
79 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
80 <number:text> </number:text>
81 </number:number-style>
82 <number:number-style style:
name=
"N132">
83 <number:text>(
</number:text>
84 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
85 <number:text>)
</number:text>
86 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N132P0"/>
87 </number:number-style>
88 <number:number-style style:
name=
"N134P0" style:
volatile=
"true">
89 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
90 <number:text> </number:text>
91 </number:number-style>
92 <number:number-style style:
name=
"N134">
93 <number:text>(
</number:text>
94 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
95 <number:text>)
</number:text>
96 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N134P0"/>
97 </number:number-style>
98 <number:currency-style style:
name=
"N136P0" style:
volatile=
"true">
99 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
100 <loext:fill-character> </loext:fill-character>
101 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
102 </number:currency-style>
103 <number:currency-style style:
name=
"N136">
104 <number:text>-
</number:text>
105 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
106 <loext:fill-character> </loext:fill-character>
107 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
108 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N136P0"/>
109 </number:currency-style>
110 <number:currency-style style:
name=
"N138P0" style:
volatile=
"true">
111 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
112 <loext:fill-character> </loext:fill-character>
113 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
114 </number:currency-style>
115 <number:currency-style style:
name=
"N138">
116 <number:text>-
</number:text>
117 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
118 <loext:fill-character> </loext:fill-character>
119 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
120 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N138P0"/>
121 </number:currency-style>
122 <number:currency-style style:
name=
"N140P0" style:
volatile=
"true">
123 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
124 <number:text> </number:text>
125 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
126 </number:currency-style>
127 <number:currency-style style:
name=
"N140">
128 <number:text>-
</number:text>
129 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
130 <number:text> </number:text>
131 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
132 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N140P0"/>
133 </number:currency-style>
134 <number:currency-style style:
name=
"N141P0" style:
volatile=
"true">
135 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
136 <number:text> </number:text>
137 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
138 </number:currency-style>
139 <number:currency-style style:
name=
"N141">
140 <number:text>-
</number:text>
141 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
142 <number:text> </number:text>
143 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
144 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N141P0"/>
145 </number:currency-style>
146 <number:currency-style style:
name=
"N142P0" style:
volatile=
"true">
147 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
148 <number:text> </number:text>
149 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
150 </number:currency-style>
151 <number:currency-style style:
name=
"N142">
152 <style:text-properties fo:
color=
"#ff0000"/>
153 <number:text>-
</number:text>
154 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
155 <number:text> </number:text>
156 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
157 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N142P0"/>
158 </number:currency-style>
159 <number:currency-style style:
name=
"N144P0" style:
volatile=
"true">
160 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
decimal-replacement=
"--" number:
grouping=
"true"/>
161 <number:text> </number:text>
162 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
163 </number:currency-style>
164 <number:currency-style style:
name=
"N144">
165 <style:text-properties fo:
color=
"#ff0000"/>
166 <number:text>-
</number:text>
167 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
decimal-replacement=
"--" number:
grouping=
"true"/>
168 <number:text> </number:text>
169 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
170 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N144P0"/>
171 </number:currency-style>
172 <number:number-style style:
name=
"N145">
173 <number:number number:
decimal-places=
"9" loext:
min-decimal-places=
"9" number:
min-integer-digits=
"1"/>
174 </number:number-style>
175 <number:number-style style:
name=
"N146">
176 <number:number number:
decimal-places=
"8" loext:
min-decimal-places=
"8" number:
min-integer-digits=
"1"/>
177 </number:number-style>
178 <number:number-style style:
name=
"N147">
179 <number:number number:
decimal-places=
"10" loext:
min-decimal-places=
"10" number:
min-integer-digits=
"1"/>
180 </number:number-style>
181 <number:number-style style:
name=
"N148">
182 <number:number number:
decimal-places=
"11" loext:
min-decimal-places=
"11" number:
min-integer-digits=
"1"/>
183 </number:number-style>
184 <number:number-style style:
name=
"N149">
185 <number:number number:
decimal-places=
"12" loext:
min-decimal-places=
"12" number:
min-integer-digits=
"1"/>
186 </number:number-style>
187 <number:number-style style:
name=
"N150">
188 <number:number number:
decimal-places=
"13" loext:
min-decimal-places=
"13" number:
min-integer-digits=
"1"/>
189 </number:number-style>
190 <number:number-style style:
name=
"N151">
191 <number:number number:
decimal-places=
"14" loext:
min-decimal-places=
"14" number:
min-integer-digits=
"1"/>
192 </number:number-style>
193 <number:number-style style:
name=
"N152">
194 <number:number number:
decimal-places=
"15" loext:
min-decimal-places=
"15" number:
min-integer-digits=
"1"/>
195 </number:number-style>
196 <number:number-style style:
name=
"N153">
197 <number:number number:
decimal-places=
"16" loext:
min-decimal-places=
"16" number:
min-integer-digits=
"1"/>
198 </number:number-style>
199 <number:number-style style:
name=
"N154">
200 <number:number number:
decimal-places=
"17" loext:
min-decimal-places=
"17" number:
min-integer-digits=
"1"/>
201 </number:number-style>
202 <number:number-style style:
name=
"N155">
203 <number:number number:
decimal-places=
"18" loext:
min-decimal-places=
"18" number:
min-integer-digits=
"1"/>
204 </number:number-style>
205 <style:style style:
name=
"Default" style:
family=
"table-cell">
206 <style:text-properties style:
font-name-asian=
"Droid Sans Fallback" style:
font-family-asian=
"'Droid Sans Fallback'" style:
font-family-generic-asian=
"system" style:
font-pitch-asian=
"variable" style:
font-name-complex=
"Droid Sans Devanagari" style:
font-family-complex=
"'Droid Sans Devanagari'" style:
font-family-generic-complex=
"system" style:
font-pitch-complex=
"variable"/>
208 <style:style style:
name=
"Result" style:
family=
"table-cell" style:
parent-style-name=
"Default">
209 <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"/>
211 <style:style style:
name=
"Result2" style:
family=
"table-cell" style:
parent-style-name=
"Result" style:
data-style-name=
"N122"/>
212 <style:style style:
name=
"Heading" style:
family=
"table-cell" style:
parent-style-name=
"Default">
213 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
214 <style:paragraph-properties fo:
text-align=
"center"/>
215 <style:text-properties fo:
font-size=
"16pt" fo:
font-style=
"italic" fo:
font-weight=
"bold"/>
217 <style:style style:
name=
"Heading1" style:
family=
"table-cell" style:
parent-style-name=
"Heading">
218 <style:table-cell-properties style:
rotation-angle=
"90"/>
220 <style:style style:
name=
"Untitled1" style:
family=
"table-cell" style:
parent-style-name=
"Default">
221 <style:table-cell-properties fo:
background-color=
"#ff3333"/>
223 <style:style style:
name=
"Untitled2" style:
family=
"table-cell" style:
parent-style-name=
"Default">
224 <style:table-cell-properties fo:
background-color=
"#99ff66"/>
227 <office:automatic-styles>
228 <style:style style:
name=
"co1" style:
family=
"table-column">
229 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"185.7pt"/>
231 <style:style style:
name=
"co2" style:
family=
"table-column">
232 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"252.51pt"/>
234 <style:style style:
name=
"co3" style:
family=
"table-column">
235 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"64.01pt"/>
237 <style:style style:
name=
"co4" style:
family=
"table-column">
238 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"70.44pt"/>
240 <style:style style:
name=
"co5" style:
family=
"table-column">
241 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"72.71pt"/>
243 <style:style style:
name=
"co6" style:
family=
"table-column">
244 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"74.21pt"/>
246 <style:style style:
name=
"co7" style:
family=
"table-column">
247 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"178.44pt"/>
249 <style:style style:
name=
"co8" style:
family=
"table-column">
250 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"80.25pt"/>
252 <style:style style:
name=
"co9" style:
family=
"table-column">
253 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"16.44pt"/>
255 <style:style style:
name=
"co10" style:
family=
"table-column">
256 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"110.35pt"/>
258 <style:style style:
name=
"ro1" style:
family=
"table-row">
259 <style:table-row-properties style:
row-height=
"24.46pt" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
261 <style:style style:
name=
"ro2" style:
family=
"table-row">
262 <style:table-row-properties style:
row-height=
"12.81pt" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
264 <style:style style:
name=
"ro3" style:
family=
"table-row">
265 <style:table-row-properties style:
row-height=
"17.35pt" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
267 <style:style style:
name=
"ro4" style:
family=
"table-row">
268 <style:table-row-properties style:
row-height=
"15pt" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
270 <style:style style:
name=
"ta1" style:
family=
"table" style:
master-page-name=
"Default">
271 <style:table-properties table:
display=
"true" style:
writing-mode=
"lr-tb"/>
273 <number:date-style style:
name=
"N50" number:
automatic-order=
"true" number:
format-source=
"language">
275 <number:text>/
</number:text>
277 <number:text>/
</number:text>
279 <number:text> </number:text>
280 <number:hours number:
style=
"long"/>
281 <number:text>:
</number:text>
282 <number:minutes number:
style=
"long"/>
283 <number:text> </number:text>
286 <number:date-style style:
name=
"N84">
287 <number:year number:
style=
"long"/>
288 <number:text>-
</number:text>
289 <number:month number:
style=
"long"/>
290 <number:text>-
</number:text>
291 <number:day number:
style=
"long"/>
293 <number:boolean-style style:
name=
"N99">
295 </number:boolean-style>
296 <style:style style:
name=
"ce1" style:
family=
"table-cell" style:
parent-style-name=
"Default"/>
297 <style:style style:
name=
"ce2" style:
family=
"table-cell" style:
parent-style-name=
"Default">
298 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
299 <style:paragraph-properties fo:
text-align=
"start" fo:
margin-left=
"0pt"/>
300 <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"/>
302 <style:style style:
name=
"ce3" style:
family=
"table-cell" style:
parent-style-name=
"Default">
303 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
304 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
305 <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"/>
307 <style:style style:
name=
"ce4" style:
family=
"table-cell" style:
parent-style-name=
"Default">
308 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
309 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
310 <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"/>
312 <style:style style:
name=
"ce5" style:
family=
"table-cell" style:
parent-style-name=
"Default">
313 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
314 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
316 <style:style style:
name=
"ce6" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N99">
317 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
318 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
319 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet1.B3"/>
320 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet1.B3"/>
321 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet1.B3"/>
323 <style:style style:
name=
"ce7" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N99">
324 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
325 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
326 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet1.B8"/>
327 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet1.B8"/>
328 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet1.B8"/>
330 <style:style style:
name=
"ce8" style:
family=
"table-cell" style:
parent-style-name=
"Default">
331 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
332 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
333 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet1.B8"/>
334 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet1.B8"/>
335 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet1.B8"/>
337 <style:style style:
name=
"ce9" style:
family=
"table-cell" style:
parent-style-name=
"Default">
338 <style:table-cell-properties fo:
wrap-option=
"wrap"/>
339 <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=
"Liberation Serif" 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=
"zh" style:
country-asian=
"CN" style:
font-style-asian=
"normal" style:
font-weight-asian=
"normal" style:
font-size-complex=
"10pt" style:
language-complex=
"hi" style:
country-complex=
"IN" 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"/>
341 <style:style style:
name=
"ce10" style:
family=
"table-cell" style:
parent-style-name=
"Default">
342 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
343 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
344 <style:text-properties fo:
font-weight=
"bold" style:
font-weight-asian=
"bold" style:
font-weight-complex=
"bold"/>
346 <style:style style:
name=
"ce11" style:
family=
"table-cell" style:
parent-style-name=
"Default">
347 <style:text-properties style:
font-name-asian=
"Microsoft YaHei" style:
font-name-complex=
"Mangal"/>
349 <style:style style:
name=
"ce12" style:
family=
"table-cell" style:
parent-style-name=
"Default">
350 <style:table-cell-properties fo:
background-color=
"transparent"/>
352 <style:style style:
name=
"ce13" style:
family=
"table-cell" style:
parent-style-name=
"Default">
353 <style:table-cell-properties fo:
background-color=
"transparent"/>
354 <style:text-properties fo:
font-weight=
"bold" style:
font-weight-asian=
"bold" style:
font-weight-complex=
"bold"/>
356 <style:style style:
name=
"ce14" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N99">
357 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
358 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
359 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet2.C2"/>
360 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet2.C2"/>
361 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet2.C2"/>
363 <style:style style:
name=
"ce15" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N99">
364 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
365 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
366 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet2.C2"/>
367 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet2.C2"/>
368 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet2.C2"/>
370 <style:style style:
name=
"ce16" style:
family=
"table-cell" style:
parent-style-name=
"Default">
371 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
372 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
373 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet2.C2"/>
374 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet2.C2"/>
375 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet2.C2"/>
377 <style:style style:
name=
"ce17" style:
family=
"table-cell" style:
parent-style-name=
"Default">
378 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false" fo:
background-color=
"transparent"/>
379 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
380 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet2.C2"/>
381 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet2.C2"/>
382 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet2.C2"/>
384 <style:style style:
name=
"ce18" style:
family=
"table-cell" style:
parent-style-name=
"Default">
385 <style:text-properties fo:
font-weight=
"bold" style:
font-weight-asian=
"bold" style:
font-weight-complex=
"bold"/>
387 <style:style style:
name=
"ce19" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N84"/>
388 <style:style style:
name=
"ce20" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N50"/>
389 <style:style style:
name=
"ce21" style:
family=
"table-cell" style:
parent-style-name=
"Default">
390 <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"/>
392 <style:style style:
name=
"ce22" style:
family=
"table-cell" style:
parent-style-name=
"Default">
393 <style:table-cell-properties fo:
background-color=
"#ffff00"/>
394 <style:text-properties fo:
font-weight=
"bold" style:
font-weight-asian=
"bold" style:
font-weight-complex=
"bold"/>
396 <style:style style:
name=
"ce23" style:
family=
"table-cell" style:
parent-style-name=
"Default">
397 <style:table-cell-properties fo:
background-color=
"#ffff00"/>
399 <style:style style:
name=
"ta_extref" style:
family=
"table">
400 <style:table-properties table:
display=
"false"/>
402 <style:page-layout style:
name=
"pm1">
403 <style:page-layout-properties style:
writing-mode=
"lr-tb"/>
405 <style:header-footer-properties fo:
min-height=
"21.26pt" fo:
margin-left=
"0pt" fo:
margin-right=
"0pt" fo:
margin-bottom=
"7.09pt"/>
406 </style:header-style>
408 <style:header-footer-properties fo:
min-height=
"21.26pt" fo:
margin-left=
"0pt" fo:
margin-right=
"0pt" fo:
margin-top=
"7.09pt"/>
409 </style:footer-style>
411 <style:page-layout style:
name=
"pm2">
412 <style:page-layout-properties style:
writing-mode=
"lr-tb"/>
414 <style:header-footer-properties fo:
min-height=
"21.26pt" fo:
margin-left=
"0pt" fo:
margin-right=
"0pt" fo:
margin-bottom=
"7.09pt" fo:
border=
"2.49pt solid #000000" fo:
padding=
"0.51pt" fo:
background-color=
"#c0c0c0">
415 <style:background-image/>
416 </style:header-footer-properties>
417 </style:header-style>
419 <style:header-footer-properties fo:
min-height=
"21.26pt" fo:
margin-left=
"0pt" fo:
margin-right=
"0pt" fo:
margin-top=
"7.09pt" fo:
border=
"2.49pt solid #000000" fo:
padding=
"0.51pt" fo:
background-color=
"#c0c0c0">
420 <style:background-image/>
421 </style:header-footer-properties>
422 </style:footer-style>
424 </office:automatic-styles>
425 <office:master-styles>
426 <style:master-page style:
name=
"Default" style:
page-layout-name=
"pm1">
428 <text:p><text:sheet-name>???
</text:sheet-name></text:p>
430 <style:header-left style:
display=
"false"/>
432 <text:p>Page
<text:page-number>1</text:page-number></text:p>
434 <style:footer-left style:
display=
"false"/>
436 <style:master-page style:
name=
"Report" style:
page-layout-name=
"pm2">
439 <text:p><text:sheet-name>???
</text:sheet-name> (
<text:title>???
</text:title>)
</text:p>
442 <text:p><text:date style:
data-style-name=
"N2" text:
date-value=
"2016-07-16">00/
00/
0000</text:date>,
<text:time style:
data-style-name=
"N2" text:
time-value=
"16:32:26.756588628">00:
00:
00</text:time></text:p>
443 </style:region-right>
445 <style:header-left style:
display=
"false"/>
447 <text:p>Page
<text:page-number>1</text:page-number> /
<text:page-count>99</text:page-count></text:p>
449 <style:footer-left style:
display=
"false"/>
451 </office:master-styles>
454 <table:calculation-settings table:
automatic-find-labels=
"false"/>
455 <table:table table:
name=
"Sheet1" table:
style-name=
"ta1">
456 <office:forms form:
automatic-focus=
"false" form:
apply-design-mode=
"false"/>
457 <table:table-column table:
style-name=
"co1" table:
default-cell-style-name=
"Default"/>
458 <table:table-column table:
style-name=
"co1" table:
default-cell-style-name=
"ce5"/>
459 <table:table-column table:
style-name=
"co2" table:
default-cell-style-name=
"Default"/>
460 <table:table-row table:
style-name=
"ro1">
461 <table:table-cell table:
style-name=
"ce2" office:
value-type=
"string" calcext:
value-type=
"string">
462 <text:p>MONTHS Function
</text:p>
464 <table:table-cell table:
number-columns-repeated=
"2"/>
466 <table:table-row table:
style-name=
"ro2">
467 <table:table-cell table:
number-columns-repeated=
"3"/>
469 <table:table-row table:
style-name=
"ro3">
470 <table:table-cell table:
style-name=
"ce3" office:
value-type=
"string" calcext:
value-type=
"string">
471 <text:p>Result
</text:p>
473 <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">
474 <text:p>TRUE
</text:p>
478 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"3">
479 <table:table-cell table:
number-columns-repeated=
"3"/>
481 <table:table-row table:
style-name=
"ro4">
482 <table:table-cell table:
style-name=
"ce4" office:
value-type=
"string" calcext:
value-type=
"string">
483 <text:p>Sheet
</text:p>
485 <table:table-cell table:
style-name=
"ce4" office:
value-type=
"string" calcext:
value-type=
"string">
486 <text:p>Result
</text:p>
488 <table:table-cell table:
style-name=
"ce4" office:
value-type=
"string" calcext:
value-type=
"string">
489 <text:p>Description
</text:p>
492 <table:table-row table:
style-name=
"ro2">
493 <table:table-cell office:
value-type=
"float" office:
value=
"1" calcext:
value-type=
"float">
496 <table:table-cell table:
style-name=
"ce7" table:
formula=
"of:=AND([Sheet2.C2:.C99])" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
497 <text:p>TRUE
</text:p>
499 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
500 <text:p>Simple MONTHS formulas with local references and values
</text:p>
503 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"3">
505 <table:table-cell table:
style-name=
"ce8"/>
508 <table:table-row table:
style-name=
"ro2">
510 <table:table-cell table:
style-name=
"ce8"/>
511 <table:table-cell table:
style-name=
"ce9"/>
513 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"26">
515 <table:table-cell table:
style-name=
"ce8"/>
518 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"1048537">
519 <table:table-cell table:
number-columns-repeated=
"3"/>
521 <table:table-row table:
style-name=
"ro2">
522 <table:table-cell table:
number-columns-repeated=
"3"/>
524 <calcext:conditional-formats>
525 <calcext:conditional-format calcext:
target-range-address=
"Sheet1.B8:Sheet1.B38">
526 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet1.B8"/>
527 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet1.B8"/>
528 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet1.B8"/>
529 </calcext:conditional-format>
530 <calcext:conditional-format calcext:
target-range-address=
"Sheet1.B3:Sheet1.B3">
531 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet1.B3"/>
532 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet1.B3"/>
533 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet1.B3"/>
534 </calcext:conditional-format>
535 </calcext:conditional-formats>
537 <table:table table:
name=
"Sheet2" table:
style-name=
"ta1" table:
print=
"false">
538 <office:forms form:
automatic-focus=
"false" form:
apply-design-mode=
"false"/>
539 <table:table-column table:
style-name=
"co4" table:
default-cell-style-name=
"Default"/>
540 <table:table-column table:
style-name=
"co5" table:
default-cell-style-name=
"Default"/>
541 <table:table-column table:
style-name=
"co6" table:
default-cell-style-name=
"ce5"/>
542 <table:table-column table:
style-name=
"co7" table:
default-cell-style-name=
"Default"/>
543 <table:table-column table:
style-name=
"co8" table:
default-cell-style-name=
"Default"/>
544 <table:table-column table:
style-name=
"co9" table:
number-columns-repeated=
"4" table:
default-cell-style-name=
"Default"/>
545 <table:table-column table:
style-name=
"co10" table:
default-cell-style-name=
"Default"/>
546 <table:table-column table:
style-name=
"co3" table:
number-columns-repeated=
"5" table:
default-cell-style-name=
"Default"/>
547 <table:table-row table:
style-name=
"ro2">
548 <table:table-cell table:
style-name=
"ce10" office:
value-type=
"string" calcext:
value-type=
"string">
549 <text:p>Function
</text:p>
551 <table:table-cell table:
style-name=
"ce10" office:
value-type=
"string" calcext:
value-type=
"string">
552 <text:p>Expected
</text:p>
554 <table:table-cell table:
style-name=
"ce10" office:
value-type=
"string" calcext:
value-type=
"string">
555 <text:p>Correct
</text:p>
557 <table:table-cell table:
style-name=
"ce10" office:
value-type=
"string" calcext:
value-type=
"string">
558 <text:p>FunctionString
</text:p>
560 <table:table-cell table:
style-name=
"ce10" office:
value-type=
"string" calcext:
value-type=
"string">
561 <text:p>Comment
</text:p>
563 <table:table-cell table:
number-columns-repeated=
"4"/>
564 <table:table-cell table:
style-name=
"ce18" table:
number-columns-repeated=
"5"/>
567 <table:table-row table:
style-name=
"ro2">
568 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=ORG.OPENOFFICE.MONTHS("2010-04-03"; "2011-06-17"; 0)" office:
value-type=
"float" office:
value=
"14" calcext:
value-type=
"float">
571 <table:table-cell office:
value-type=
"float" office:
value=
"14" calcext:
value-type=
"float">
574 <table:table-cell table:
style-name=
"ce14" table:
formula=
"of:=[.A2]=[.B2]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
575 <text:p>TRUE
</text:p>
577 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=FORMULA([.A2])" office:
value-type=
"string" office:
string-value=
"=MONTHS("2010-04-03", "2011-06-17", 0)" calcext:
value-type=
"string">
578 <text:p>=MONTHS(
"2010-
04-
03",
"2011-
06-
17",
0)
</text:p>
580 <table:table-cell table:
number-columns-repeated=
"11"/>
582 <table:table-row table:
style-name=
"ro2">
583 <table:table-cell table:
style-name=
"ce12" table:
formula=
"of:=ORG.OPENOFFICE.MONTHS("2010-03-31"; "2010-04-30"; 0)" office:
value-type=
"float" office:
value=
"0" calcext:
value-type=
"float">
586 <table:table-cell office:
value-type=
"float" office:
value=
"0" calcext:
value-type=
"float">
589 <table:table-cell table:
style-name=
"ce14" table:
formula=
"of:=[.A3]=[.B3]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
590 <text:p>TRUE
</text:p>
592 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=FORMULA([.A3])" office:
value-type=
"string" office:
string-value=
"=MONTHS("2010-03-31", "2010-04-30", 0)" calcext:
value-type=
"string">
593 <text:p>=MONTHS(
"2010-
03-
31",
"2010-
04-
30",
0)
</text:p>
595 <table:table-cell table:
number-columns-repeated=
"5"/>
596 <table:table-cell office:
value-type=
"float" office:
value=
"33333.33" calcext:
value-type=
"float">
597 <text:p>33333.33</text:p>
599 <table:table-cell table:
number-columns-repeated=
"5"/>
601 <table:table-row table:
style-name=
"ro2">
602 <table:table-cell table:
formula=
"of:=ORG.OPENOFFICE.MONTHS("2010-03-31"; "2010-06-30"; 0)" office:
value-type=
"float" office:
value=
"2" calcext:
value-type=
"float">
605 <table:table-cell office:
value-type=
"float" office:
value=
"2" calcext:
value-type=
"float">
608 <table:table-cell table:
style-name=
"ce14" table:
formula=
"of:=[.A4]=[.B4]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
609 <text:p>TRUE
</text:p>
611 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=FORMULA([.A4])" office:
value-type=
"string" office:
string-value=
"=MONTHS("2010-03-31", "2010-06-30", 0)" calcext:
value-type=
"string">
612 <text:p>=MONTHS(
"2010-
03-
31",
"2010-
06-
30",
0)
</text:p>
614 <table:table-cell table:
number-columns-repeated=
"6"/>
615 <table:table-cell office:
value-type=
"float" office:
value=
"1" calcext:
value-type=
"float">
618 <table:table-cell table:
number-columns-repeated=
"4"/>
620 <table:table-row table:
style-name=
"ro2">
621 <table:table-cell table:
formula=
"of:=ORG.OPENOFFICE.MONTHS("2010-04-03"; "2011-06-17"; 1)" office:
value-type=
"float" office:
value=
"14" calcext:
value-type=
"float">
624 <table:table-cell office:
value-type=
"float" office:
value=
"14" calcext:
value-type=
"float">
627 <table:table-cell table:
style-name=
"ce15" table:
formula=
"of:=[.A5]=[.B5]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
628 <text:p>TRUE
</text:p>
630 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=FORMULA([.A5])" office:
value-type=
"string" office:
string-value=
"=MONTHS("2010-04-03", "2011-06-17", 1)" calcext:
value-type=
"string">
631 <text:p>=MONTHS(
"2010-
04-
03",
"2011-
06-
17",
1)
</text:p>
633 <table:table-cell table:
number-columns-repeated=
"11"/>
635 <table:table-row table:
style-name=
"ro2">
636 <table:table-cell table:
formula=
"of:=ORG.OPENOFFICE.MONTHS("2010-03-31"; "2010-04-01"; 1)" office:
value-type=
"float" office:
value=
"1" calcext:
value-type=
"float">
639 <table:table-cell office:
value-type=
"float" office:
value=
"1" calcext:
value-type=
"float">
642 <table:table-cell table:
style-name=
"ce14" table:
formula=
"of:=[.A6]=[.B6]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
643 <text:p>TRUE
</text:p>
645 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=FORMULA([.A6])" office:
value-type=
"string" office:
string-value=
"=MONTHS("2010-03-31", "2010-04-01", 1)" calcext:
value-type=
"string">
646 <text:p>=MONTHS(
"2010-
03-
31",
"2010-
04-
01",
1)
</text:p>
648 <table:table-cell table:
number-columns-repeated=
"11"/>
650 <table:table-row table:
style-name=
"ro2">
651 <table:table-cell table:
formula=
"of:=ORG.OPENOFFICE.MONTHS([.J7]; [.K7]; 1)" office:
value-type=
"float" office:
value=
"1" calcext:
value-type=
"float">
654 <table:table-cell office:
value-type=
"float" office:
value=
"1" calcext:
value-type=
"float">
657 <table:table-cell table:
style-name=
"ce14" table:
formula=
"of:=[.A7]=[.B7]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
658 <text:p>TRUE
</text:p>
660 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=FORMULA([.A7])" office:
value-type=
"string" office:
string-value=
"=MONTHS(J7, K7, 1)" calcext:
value-type=
"string">
661 <text:p>=MONTHS(J7, K7,
1)
</text:p>
663 <table:table-cell table:
number-columns-repeated=
"5"/>
664 <table:table-cell table:
style-name=
"ce19" office:
value-type=
"date" office:
date-value=
"2010-03-31" calcext:
value-type=
"date">
665 <text:p>2010-
03-
31</text:p>
667 <table:table-cell table:
style-name=
"ce19" office:
value-type=
"date" office:
date-value=
"2010-04-01" calcext:
value-type=
"date">
668 <text:p>2010-
04-
01</text:p>
670 <table:table-cell table:
number-columns-repeated=
"4"/>
672 <table:table-row table:
style-name=
"ro2">
673 <table:table-cell table:
formula=
"of:=ORG.OPENOFFICE.MONTHS(day1ref; day2ref; 1)" office:
value-type=
"float" office:
value=
"1" calcext:
value-type=
"float">
676 <table:table-cell office:
value-type=
"float" office:
value=
"1" calcext:
value-type=
"float">
679 <table:table-cell table:
style-name=
"ce14" table:
formula=
"of:=[.A8]=[.B8]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
680 <text:p>TRUE
</text:p>
682 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=FORMULA([.A8])" office:
value-type=
"string" office:
string-value=
"=MONTHS(day1ref, day2ref, 1)" calcext:
value-type=
"string">
683 <text:p>=MONTHS(day1ref, day2ref,
1)
</text:p>
685 <table:table-cell table:
number-columns-repeated=
"5"/>
686 <table:table-cell table:
style-name=
"ce20"/>
687 <table:table-cell table:
number-columns-repeated=
"5"/>
689 <table:table-row table:
style-name=
"ro2">
690 <table:table-cell table:
formula=
"of:=ORG.OPENOFFICE.MONTHS(day1ref; day2ref; 8999)" office:
value-type=
"string" office:
string-value=
"" calcext:
value-type=
"error">
691 <text:p>Err:
502</text:p>
693 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
694 <text:p>error
</text:p>
696 <table:table-cell table:
style-name=
"ce14" table:
formula=
"of:=ISERROR([.A9])" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
697 <text:p>TRUE
</text:p>
699 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=FORMULA([.A9])" office:
value-type=
"string" office:
string-value=
"=MONTHS(day1ref, day2ref, 8999)" calcext:
value-type=
"string">
700 <text:p>=MONTHS(day1ref, day2ref,
8999)
</text:p>
702 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
703 <text:p>Tdf#
100440 </text:p>
705 <table:table-cell table:
number-columns-repeated=
"10"/>
707 <table:table-row table:
style-name=
"ro2">
708 <table:table-cell table:
number-columns-repeated=
"2"/>
709 <table:table-cell table:
style-name=
"ce14"/>
710 <table:table-cell table:
style-name=
"ce11"/>
711 <table:table-cell table:
number-columns-repeated=
"11"/>
713 <table:table-row table:
style-name=
"ro2">
714 <table:table-cell table:
number-columns-repeated=
"2"/>
715 <table:table-cell table:
style-name=
"ce16"/>
716 <table:table-cell table:
number-columns-repeated=
"12"/>
718 <table:table-row table:
style-name=
"ro2">
719 <table:table-cell table:
number-columns-repeated=
"2"/>
720 <table:table-cell table:
style-name=
"ce16"/>
721 <table:table-cell table:
number-columns-repeated=
"6"/>
722 <table:table-cell table:
style-name=
"ce18" table:
number-columns-repeated=
"5"/>
725 <table:table-row table:
style-name=
"ro2">
726 <table:table-cell table:
number-columns-repeated=
"2"/>
727 <table:table-cell table:
style-name=
"Default"/>
728 <table:table-cell table:
number-columns-repeated=
"12"/>
730 <table:table-row table:
style-name=
"ro2">
731 <table:table-cell table:
style-name=
"ce12" table:
number-columns-repeated=
"2"/>
732 <table:table-cell table:
style-name=
"ce17"/>
733 <table:table-cell table:
number-columns-repeated=
"12"/>
735 <table:table-row table:
style-name=
"ro2">
736 <table:table-cell table:
style-name=
"ce12" table:
number-columns-repeated=
"2"/>
737 <table:table-cell table:
style-name=
"ce17"/>
738 <table:table-cell table:
style-name=
"ce12" table:
number-columns-repeated=
"2"/>
739 <table:table-cell table:
number-columns-repeated=
"10"/>
741 <table:table-row table:
style-name=
"ro2">
742 <table:table-cell table:
style-name=
"ce13" table:
number-columns-repeated=
"3"/>
743 <table:table-cell table:
style-name=
"ce12" table:
number-columns-repeated=
"2"/>
744 <table:table-cell table:
number-columns-repeated=
"4"/>
745 <table:table-cell table:
style-name=
"ce18" table:
number-columns-repeated=
"6"/>
747 <table:table-row table:
style-name=
"ro2">
748 <table:table-cell table:
style-name=
"ce12" table:
number-columns-repeated=
"5"/>
749 <table:table-cell table:
number-columns-repeated=
"10"/>
751 <table:table-row table:
style-name=
"ro2">
752 <table:table-cell table:
style-name=
"ce12" table:
number-columns-repeated=
"2"/>
753 <table:table-cell table:
style-name=
"ce17"/>
754 <table:table-cell table:
style-name=
"ce12" table:
number-columns-repeated=
"2"/>
755 <table:table-cell table:
number-columns-repeated=
"10"/>
757 <table:table-row table:
style-name=
"ro2">
758 <table:table-cell table:
style-name=
"ce12" table:
number-columns-repeated=
"2"/>
759 <table:table-cell table:
style-name=
"ce17"/>
760 <table:table-cell table:
style-name=
"ce12" table:
number-columns-repeated=
"2"/>
761 <table:table-cell table:
number-columns-repeated=
"4"/>
762 <table:table-cell table:
style-name=
"ce18" table:
number-columns-repeated=
"5"/>
765 <table:table-row table:
style-name=
"ro2">
766 <table:table-cell table:
number-columns-repeated=
"2"/>
767 <table:table-cell table:
style-name=
"ce16"/>
768 <table:table-cell table:
number-columns-repeated=
"6"/>
769 <table:table-cell table:
style-name=
"ce21"/>
770 <table:table-cell table:
number-columns-repeated=
"5"/>
772 <table:table-row table:
style-name=
"ro2">
773 <table:table-cell table:
number-columns-repeated=
"2"/>
774 <table:table-cell table:
style-name=
"ce16"/>
775 <table:table-cell table:
number-columns-repeated=
"12"/>
777 <table:table-row table:
style-name=
"ro2">
778 <table:table-cell table:
number-columns-repeated=
"2"/>
779 <table:table-cell table:
style-name=
"ce16"/>
780 <table:table-cell table:
number-columns-repeated=
"6"/>
781 <table:table-cell table:
style-name=
"ce18" table:
number-columns-repeated=
"5"/>
784 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"2">
785 <table:table-cell table:
number-columns-repeated=
"2"/>
786 <table:table-cell table:
style-name=
"ce16"/>
787 <table:table-cell table:
number-columns-repeated=
"12"/>
789 <table:table-row table:
style-name=
"ro2">
790 <table:table-cell table:
number-columns-repeated=
"2"/>
791 <table:table-cell table:
style-name=
"ce16"/>
792 <table:table-cell table:
number-columns-repeated=
"6"/>
793 <table:table-cell table:
style-name=
"ce18" table:
number-columns-repeated=
"5"/>
796 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"6">
797 <table:table-cell table:
number-columns-repeated=
"2"/>
798 <table:table-cell table:
style-name=
"ce16"/>
799 <table:table-cell table:
number-columns-repeated=
"12"/>
801 <table:table-row table:
style-name=
"ro2">
802 <table:table-cell table:
number-columns-repeated=
"2"/>
803 <table:table-cell table:
style-name=
"ce16"/>
804 <table:table-cell table:
number-columns-repeated=
"6"/>
805 <table:table-cell table:
style-name=
"ce18" table:
number-columns-repeated=
"5"/>
808 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"4">
809 <table:table-cell table:
number-columns-repeated=
"2"/>
810 <table:table-cell table:
style-name=
"ce16"/>
811 <table:table-cell table:
number-columns-repeated=
"12"/>
813 <table:table-row table:
style-name=
"ro2">
814 <table:table-cell table:
number-columns-repeated=
"2"/>
815 <table:table-cell table:
style-name=
"ce16"/>
816 <table:table-cell table:
number-columns-repeated=
"6"/>
817 <table:table-cell table:
style-name=
"ce18" table:
number-columns-repeated=
"5"/>
820 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"2">
821 <table:table-cell table:
number-columns-repeated=
"2"/>
822 <table:table-cell table:
style-name=
"ce16"/>
823 <table:table-cell table:
number-columns-repeated=
"12"/>
825 <table:table-row table:
style-name=
"ro2">
826 <table:table-cell table:
number-columns-repeated=
"2"/>
827 <table:table-cell table:
style-name=
"ce16"/>
828 <table:table-cell table:
number-columns-repeated=
"6"/>
829 <table:table-cell table:
style-name=
"ce18" table:
number-columns-repeated=
"5"/>
832 <table:table-row table:
style-name=
"ro2">
833 <table:table-cell table:
number-columns-repeated=
"2"/>
834 <table:table-cell table:
style-name=
"ce16"/>
835 <table:table-cell table:
number-columns-repeated=
"12"/>
837 <table:table-row table:
style-name=
"ro2">
838 <table:table-cell table:
number-columns-repeated=
"15"/>
840 <table:table-row table:
style-name=
"ro2">
841 <table:table-cell table:
number-columns-repeated=
"9"/>
842 <table:table-cell table:
style-name=
"ce18" table:
number-columns-repeated=
"5"/>
845 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"2">
846 <table:table-cell table:
number-columns-repeated=
"15"/>
848 <table:table-row table:
style-name=
"ro2">
849 <table:table-cell table:
number-columns-repeated=
"9"/>
850 <table:table-cell table:
style-name=
"ce18" table:
number-columns-repeated=
"5"/>
853 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"2">
854 <table:table-cell table:
number-columns-repeated=
"15"/>
856 <table:table-row table:
style-name=
"ro2">
857 <table:table-cell table:
number-columns-repeated=
"9"/>
858 <table:table-cell table:
style-name=
"ce18" table:
number-columns-repeated=
"5"/>
861 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"2">
862 <table:table-cell table:
number-columns-repeated=
"15"/>
864 <table:table-row table:
style-name=
"ro2">
865 <table:table-cell table:
number-columns-repeated=
"9"/>
866 <table:table-cell table:
style-name=
"ce18" table:
number-columns-repeated=
"5"/>
869 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"2">
870 <table:table-cell table:
number-columns-repeated=
"15"/>
872 <table:table-row table:
style-name=
"ro2">
873 <table:table-cell table:
number-columns-repeated=
"9"/>
874 <table:table-cell table:
style-name=
"ce18" table:
number-columns-repeated=
"5"/>
877 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"2">
878 <table:table-cell table:
number-columns-repeated=
"15"/>
880 <table:table-row table:
style-name=
"ro2">
881 <table:table-cell table:
number-columns-repeated=
"9"/>
882 <table:table-cell table:
style-name=
"ce22" table:
number-columns-repeated=
"5"/>
883 <table:table-cell table:
style-name=
"ce23" office:
value-type=
"string" calcext:
value-type=
"string">
887 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"2">
888 <table:table-cell table:
number-columns-repeated=
"9"/>
889 <table:table-cell table:
style-name=
"ce23" table:
number-columns-repeated=
"6"/>
891 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"1048515">
892 <table:table-cell table:
number-columns-repeated=
"15"/>
894 <table:table-row table:
style-name=
"ro2">
895 <table:table-cell table:
number-columns-repeated=
"15"/>
897 <calcext:conditional-formats>
898 <calcext:conditional-format calcext:
target-range-address=
"Sheet2.C18:Sheet2.C41 Sheet2.C14:Sheet2.C15 Sheet2.C2:Sheet2.C12">
899 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet2.C2"/>
900 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet2.C2"/>
901 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet2.C2"/>
902 </calcext:conditional-format>
903 <calcext:conditional-format calcext:
target-range-address=
"Sheet2.C5:Sheet2.C5">
904 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet2.C5"/>
905 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet2.C5"/>
906 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet2.C5"/>
907 </calcext:conditional-format>
908 </calcext:conditional-formats>
910 <table:table table:
name=
"'file:///home/zdenek/Dokumenty/LO/sc-unit-test/Project%20Calc%20functions%20tests/fods/months.fods/months.fods/months.fods/months.fods/months.fods/month.fods/minute.fods/year.fods/function_based_test_Example.fods/function_based_test_Example_reference.fods'#Sheet2" table:
print=
"false" table:
style-name=
"ta_extref">
911 <table:table-source xlink:
type=
"simple" xlink:
href=
"months.fods/months.fods/months.fods/months.fods/month.fods/minute.fods/year.fods/function_based_test_Example.fods/function_based_test_Example_reference.fods" table:
table-name=
"Sheet2" table:
mode=
"copy-results-only"/>
912 <table:table-column table:
number-columns-repeated=
"8"/>
913 <table:table-row table:
number-rows-repeated=
"2">
914 <table:table-cell table:
number-columns-repeated=
"8"/>
917 <table:table-cell table:
number-columns-repeated=
"7"/>
918 <table:table-cell table:
style-name=
"ce1" office:
value-type=
"float" office:
value=
"4">
923 <table:named-expressions>
924 <table:named-range table:
name=
"day1ref" table:
base-cell-address=
"$Sheet2.$J$7" table:
cell-range-address=
"$Sheet2.$J$7"/>
925 <table:named-range table:
name=
"day2ref" table:
base-cell-address=
"$Sheet2.$K$7" table:
cell-range-address=
"$Sheet2.$K$7"/>
926 </table:named-expressions>
927 </office:spreadsheet>