sc/qa/unit/data/functions/text/fods/search.fods | 1424 ++++++++++++++++++++++++
1 file changed, 1424 insertions(+)
New commits:
commit 925552f77723271abeab5dec48b5859c0b9927c9
Author: ZdenÄk Crhonek <zcrho...@gmail.com>
Date: Thu Feb 2 19:26:58 2017 +0100
add SEARCH test case
Change-Id: Icf81d4536ecfbdd0c059ca3be595145884b19a99
Reviewed-on: https://gerrit.libreoffice.org/33845
Tested-by: Jenkins <c...@libreoffice.org>
Reviewed-by: Zdenek Crhonek <zcrho...@gmail.com>
diff --git a/sc/qa/unit/data/functions/text/fods/search.fods
b/sc/qa/unit/data/functions/text/fods/search.fods
new file mode 100644
index 0000000..4d1b1a0
--- /dev/null
+++ b/sc/qa/unit/data/functions/text/fods/search.fods
@@ -0,0 +1,1424 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+<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:scr
ipt="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:form
x="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">
+
<office:meta><meta:creation-date>2017-02-02T18:52:02.797049582</meta:creation-date><meta:editing-duration>P0D</meta:editing-duration><meta:editing-cycles>1</meta:editing-cycles><meta:generator>LibreOfficeDev/5.3.0.0.alpha1$Linux_X86_64
LibreOffice_project/883024d657fb45c7da459017d2f936aac5644bfb</meta:generator><meta:document-statistic
meta:table-count="2" meta:cell-count="80" meta:object-count="0"/></office:meta>
+ <office:settings>
+ <config:config-item-set config:name="ooo:view-settings">
+ <config:config-item config:name="VisibleAreaTop"
config:type="int">0</config:config-item>
+ <config:config-item config:name="VisibleAreaLeft"
config:type="int">0</config:config-item>
+ <config:config-item config:name="VisibleAreaWidth"
config:type="int">33104</config:config-item>
+ <config:config-item config:name="VisibleAreaHeight"
config:type="int">13409</config:config-item>
+ <config:config-item-map-indexed config:name="Views">
+ <config:config-item-map-entry>
+ <config:config-item config:name="ViewId"
config:type="string">view1</config:config-item>
+ <config:config-item-map-named config:name="Tables">
+ <config:config-item-map-entry config:name="Sheet1">
+ <config:config-item config:name="CursorPositionX"
config:type="int">2</config:config-item>
+ <config:config-item config:name="CursorPositionY"
config:type="int">8</config:config-item>
+ <config:config-item config:name="HorizontalSplitMode"
config:type="short">0</config:config-item>
+ <config:config-item config:name="VerticalSplitMode"
config:type="short">0</config:config-item>
+ <config:config-item config:name="HorizontalSplitPosition"
config:type="int">0</config:config-item>
+ <config:config-item config:name="VerticalSplitPosition"
config:type="int">0</config:config-item>
+ <config:config-item config:name="ActiveSplitRange"
config:type="short">2</config:config-item>
+ <config:config-item config:name="PositionLeft"
config:type="int">0</config:config-item>
+ <config:config-item config:name="PositionRight"
config:type="int">0</config:config-item>
+ <config:config-item config:name="PositionTop"
config:type="int">0</config:config-item>
+ <config:config-item config:name="PositionBottom"
config:type="int">0</config:config-item>
+ <config:config-item config:name="ZoomType"
config:type="short">0</config:config-item>
+ <config:config-item config:name="ZoomValue"
config:type="int">85</config:config-item>
+ <config:config-item config:name="PageViewZoomValue"
config:type="int">60</config:config-item>
+ <config:config-item config:name="ShowGrid"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="AnchoredTextOverflowLegacy"
config:type="boolean">false</config:config-item>
+ </config:config-item-map-entry>
+ <config:config-item-map-entry config:name="Sheet2">
+ <config:config-item config:name="CursorPositionX"
config:type="int">4</config:config-item>
+ <config:config-item config:name="CursorPositionY"
config:type="int">20</config:config-item>
+ <config:config-item config:name="HorizontalSplitMode"
config:type="short">0</config:config-item>
+ <config:config-item config:name="VerticalSplitMode"
config:type="short">0</config:config-item>
+ <config:config-item config:name="HorizontalSplitPosition"
config:type="int">0</config:config-item>
+ <config:config-item config:name="VerticalSplitPosition"
config:type="int">0</config:config-item>
+ <config:config-item config:name="ActiveSplitRange"
config:type="short">2</config:config-item>
+ <config:config-item config:name="PositionLeft"
config:type="int">0</config:config-item>
+ <config:config-item config:name="PositionRight"
config:type="int">0</config:config-item>
+ <config:config-item config:name="PositionTop"
config:type="int">0</config:config-item>
+ <config:config-item config:name="PositionBottom"
config:type="int">0</config:config-item>
+ <config:config-item config:name="ZoomType"
config:type="short">0</config:config-item>
+ <config:config-item config:name="ZoomValue"
config:type="int">85</config:config-item>
+ <config:config-item config:name="PageViewZoomValue"
config:type="int">60</config:config-item>
+ <config:config-item config:name="ShowGrid"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="AnchoredTextOverflowLegacy"
config:type="boolean">false</config:config-item>
+ </config:config-item-map-entry>
+ </config:config-item-map-named>
+ <config:config-item config:name="ActiveTable"
config:type="string">Sheet2</config:config-item>
+ <config:config-item config:name="HorizontalScrollbarWidth"
config:type="int">1241</config:config-item>
+ <config:config-item config:name="ZoomType"
config:type="short">0</config:config-item>
+ <config:config-item config:name="ZoomValue"
config:type="int">85</config:config-item>
+ <config:config-item config:name="PageViewZoomValue"
config:type="int">60</config:config-item>
+ <config:config-item config:name="ShowPageBreakPreview"
config:type="boolean">false</config:config-item>
+ <config:config-item config:name="ShowZeroValues"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="ShowNotes"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="ShowGrid"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="GridColor"
config:type="long">12632256</config:config-item>
+ <config:config-item config:name="ShowPageBreaks"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="HasColumnRowHeaders"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="HasSheetTabs"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="IsOutlineSymbolsSet"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="IsValueHighlightingEnabled"
config:type="boolean">false</config:config-item>
+ <config:config-item config:name="IsSnapToRaster"
config:type="boolean">false</config:config-item>
+ <config:config-item config:name="RasterIsVisible"
config:type="boolean">false</config:config-item>
+ <config:config-item config:name="RasterResolutionX"
config:type="int">1270</config:config-item>
+ <config:config-item config:name="RasterResolutionY"
config:type="int">1270</config:config-item>
+ <config:config-item config:name="RasterSubdivisionX"
config:type="int">1</config:config-item>
+ <config:config-item config:name="RasterSubdivisionY"
config:type="int">1</config:config-item>
+ <config:config-item config:name="IsRasterAxisSynchronized"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="AnchoredTextOverflowLegacy"
config:type="boolean">false</config:config-item>
+ </config:config-item-map-entry>
+ </config:config-item-map-indexed>
+ </config:config-item-set>
+ <config:config-item-set config:name="ooo:configuration-settings">
+ <config:config-item config:name="SyntaxStringRef"
config:type="short">7</config:config-item>
+ <config:config-item config:name="IsDocumentShared"
config:type="boolean">false</config:config-item>
+ <config:config-item config:name="LoadReadonly"
config:type="boolean">false</config:config-item>
+ <config:config-item config:name="AllowPrintJobCancel"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="UpdateFromTemplate"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="IsKernAsianPunctuation"
config:type="boolean">false</config:config-item>
+ <config:config-item config:name="EmbedFonts"
config:type="boolean">false</config:config-item>
+ <config:config-item config:name="IsSnapToRaster"
config:type="boolean">false</config:config-item>
+ <config:config-item config:name="RasterResolutionX"
config:type="int">1270</config:config-item>
+ <config:config-item config:name="RasterResolutionY"
config:type="int">1270</config:config-item>
+ <config:config-item config:name="HasSheetTabs"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="IsRasterAxisSynchronized"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="ShowPageBreaks"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="ShowGrid"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="ShowNotes"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="SaveVersionOnClose"
config:type="boolean">false</config:config-item>
+ <config:config-item config:name="GridColor"
config:type="long">12632256</config:config-item>
+ <config:config-item config:name="RasterIsVisible"
config:type="boolean">false</config:config-item>
+ <config:config-item config:name="PrinterName"
config:type="string">Lexmark-E352dn</config:config-item>
+ <config:config-item-map-indexed config:name="ForbiddenCharacters">
+ <config:config-item-map-entry>
+ <config:config-item config:name="Language"
config:type="string">en</config:config-item>
+ <config:config-item config:name="Country"
config:type="string">US</config:config-item>
+ <config:config-item config:name="Variant" config:type="string"/>
+ <config:config-item config:name="BeginLine" config:type="string"/>
+ <config:config-item config:name="EndLine" config:type="string"/>
+ </config:config-item-map-entry>
+ <config:config-item-map-entry>
+ <config:config-item config:name="Language"
config:type="string">zh</config:config-item>
+ <config:config-item config:name="Country"
config:type="string">CN</config:config-item>
+ <config:config-item config:name="Variant" config:type="string"/>
+ <config:config-item config:name="BeginLine"
config:type="string">:!),.:;?]}¢'"ãããããããããã︰︱︳ï¹ï½¤ï¹ï¹ï¹ï¹ï¹ï¹ï¹ï¹ï¼ï¼ï¼ï¼ï¼ï¼ï¼ï½ï½ï¸´ï¸¶ï¸¸ï¸ºï¸¼ï¸¾ï¹ï¹ï¹ï¹ï½¤ï½ï¿
ã
ââ¢Â·ËËâ--â²ââ</config:config-item>
+ <config:config-item config:name="EndLine"
config:type="string">([{£¥'"âµãããããããï¼ï¼»ï½ï¿¡ï¿¥ã︵︷︹︻︽︿ï¹ï¹ï¹ï¹ï¹ï¼ï½ââ</config:config-item>
+ </config:config-item-map-entry>
+ </config:config-item-map-indexed>
+ <config:config-item config:name="IsOutlineSymbolsSet"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="ShowZeroValues"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="LinkUpdateMode"
config:type="short">3</config:config-item>
+ <config:config-item config:name="RasterSubdivisionX"
config:type="int">1</config:config-item>
+ <config:config-item config:name="HasColumnRowHeaders"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="RasterSubdivisionY"
config:type="int">1</config:config-item>
+ <config:config-item config:name="AutoCalculate"
config:type="boolean">true</config:config-item>
+ <config:config-item config:name="PrinterSetup"
config:type="base64Binary">rgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg==</config:config-item>
+ <config:config-item config:name="ApplyUserData"
config:type="boolean">false</config:config-item>
+ <config:config-item config:name="CharacterCompressionType"
config:type="short">0</config:config-item>
+ </config:config-item-set>
+ </office:settings>
+ <office:scripts>
+ <office:script script:language="ooo:Basic">
+ <ooo:libraries xmlns:ooo="http://openoffice.org/2004/office";
xmlns:xlink="http://www.w3.org/1999/xlink";>
+ <ooo:library-embedded ooo:name="Standard"/>
+ </ooo:libraries>
+ </office:script>
+ </office:scripts>
+ <office:font-face-decls>
+ <style:font-face style:name="Cumberland" svg:font-family="Cumberland,
'Courier New', 'Bitstream Vera Sans Mono', Courier,
'Lucida Sans Typewriter', 'Lucida Typewriter', Monaco,
Monospaced" style:font-family-generic="modern" style:font-pitch="fixed"/>
+ <style:font-face style:name="Andale Sans UI" svg:font-family="'Andale
Sans UI'" style:font-pitch="variable"/>
+ <style:font-face style:name="Tahoma" svg:font-family="Tahoma"
style:font-pitch="variable"/>
+ <style:font-face style:name="Liberation Serif"
svg:font-family="'Liberation Serif'"
style:font-family-generic="roman" style:font-pitch="variable"/>
+ <style:font-face style:name="Times New Roman" svg:font-family="'Times
New Roman'" style:font-family-generic="roman" style:font-pitch="variable"/>
+ <style:font-face style:name="Arial" svg:font-family="Arial"
style:font-family-generic="swiss" style:font-pitch="variable"/>
+ <style:font-face style:name="Liberation Sans"
svg:font-family="'Liberation Sans'" style:font-family-generic="swiss"
style:font-pitch="variable"/>
+ <style:font-face style:name="DejaVu Sans" svg:font-family="'DejaVu
Sans'" style:font-family-generic="system" style:font-pitch="variable"/>
+ <style:font-face style:name="Droid Sans Devanagari"
svg:font-family="'Droid Sans Devanagari'"
style:font-family-generic="system" style:font-pitch="variable"/>
+ <style:font-face style:name="Droid Sans Fallback"
svg:font-family="'Droid Sans Fallback'"
style:font-family-generic="system" style:font-pitch="variable"/>
+ <style:font-face style:name="Mangal" svg:font-family="Mangal"
style:font-family-generic="system" style:font-pitch="variable"/>
+ <style:font-face style:name="Microsoft YaHei"
svg:font-family="'Microsoft YaHei'"
style:font-family-generic="system" style:font-pitch="variable"/>
+ </office:font-face-decls>
+ <office:styles>
+ <style:default-style style:family="table-cell">
+ <style:paragraph-properties style:tab-stop-distance="36pt"/>
+ <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"/>
+ </style:default-style>
+ <number:number-style style:name="N0">
+ <number:number number:min-integer-digits="1"/>
+ </number:number-style>
+ <number:currency-style style:name="N122P0" style:volatile="true">
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ <number:currency-symbol number:language="cs"
number:country="CZ">KÄ</number:currency-symbol>
+ </number:currency-style>
+ <number:currency-style style:name="N122">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>-</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ <number:currency-symbol number:language="cs"
number:country="CZ">KÄ</number:currency-symbol>
+ <style:map style:condition="value()>=0" style:apply-style-name="N122P0"/>
+ </number:currency-style>
+ <number:currency-style style:name="N124P0" style:volatile="true">
+ <number:currency-symbol number:language="en"
number:country="GB">£</number:currency-symbol>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ </number:currency-style>
+ <number:currency-style style:name="N124">
+ <number:text>-</number:text>
+ <number:currency-symbol number:language="en"
number:country="GB">£</number:currency-symbol>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N124P0"/>
+ </number:currency-style>
+ <number:currency-style style:name="N126P0" style:volatile="true">
+ <number:currency-symbol number:language="en"
number:country="GB">£</number:currency-symbol>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ </number:currency-style>
+ <number:currency-style style:name="N126">
+ <number:text>-</number:text>
+ <number:currency-symbol number:language="en"
number:country="GB">£</number:currency-symbol>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N126P0"/>
+ </number:currency-style>
+ <number:currency-style style:name="N127P0" style:volatile="true">
+ <number:currency-symbol number:language="en"
number:country="GB">£</number:currency-symbol>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ </number:currency-style>
+ <number:currency-style style:name="N127">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>-</number:text>
+ <number:currency-symbol number:language="en"
number:country="GB">£</number:currency-symbol>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N127P0"/>
+ </number:currency-style>
+ <number:currency-style style:name="N128P0" style:volatile="true">
+ <number:currency-symbol number:language="en"
number:country="GB">£</number:currency-symbol>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ </number:currency-style>
+ <number:currency-style style:name="N128">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>-</number:text>
+ <number:currency-symbol number:language="en"
number:country="GB">£</number:currency-symbol>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N128P0"/>
+ </number:currency-style>
+ <number:currency-style style:name="N130P0" style:volatile="true">
+ <number:currency-symbol number:language="en"
number:country="GB">£</number:currency-symbol>
+ <number:number number:decimal-places="2" loext:min-decimal-places="0"
number:min-integer-digits="1" number:decimal-replacement="--"
number:grouping="true"/>
+ </number:currency-style>
+ <number:currency-style style:name="N130">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>-</number:text>
+ <number:currency-symbol number:language="en"
number:country="GB">£</number:currency-symbol>
+ <number:number number:decimal-places="2" loext:min-decimal-places="0"
number:min-integer-digits="1" number:decimal-replacement="--"
number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N130P0"/>
+ </number:currency-style>
+ <number:number-style style:name="N132P0" style:volatile="true">
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N132">
+ <number:text>(</number:text>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text>)</number:text>
+ <style:map style:condition="value()>=0" style:apply-style-name="N132P0"/>
+ </number:number-style>
+ <number:number-style style:name="N134P0" style:volatile="true">
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N134">
+ <number:text>(</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text>)</number:text>
+ <style:map style:condition="value()>=0" style:apply-style-name="N134P0"/>
+ </number:number-style>
+ <number:currency-style style:name="N136P0" style:volatile="true">
+ <number:currency-symbol number:language="en"
number:country="GB">£</number:currency-symbol>
+ <loext:fill-character> </loext:fill-character>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ </number:currency-style>
+ <number:currency-style style:name="N136">
+ <number:text>-</number:text>
+ <number:currency-symbol number:language="en"
number:country="GB">£</number:currency-symbol>
+ <loext:fill-character> </loext:fill-character>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N136P0"/>
+ </number:currency-style>
+ <number:currency-style style:name="N138P0" style:volatile="true">
+ <number:currency-symbol number:language="en"
number:country="GB">£</number:currency-symbol>
+ <loext:fill-character> </loext:fill-character>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ </number:currency-style>
+ <number:currency-style style:name="N138">
+ <number:text>-</number:text>
+ <number:currency-symbol number:language="en"
number:country="GB">£</number:currency-symbol>
+ <loext:fill-character> </loext:fill-character>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N138P0"/>
+ </number:currency-style>
+ <number:number-style style:name="N139">
+ <number:number number:decimal-places="9" loext:min-decimal-places="9"
number:min-integer-digits="1"/>
+ </number:number-style>
+ <number:number-style style:name="N140">
+ <number:number number:decimal-places="8" loext:min-decimal-places="8"
number:min-integer-digits="1"/>
+ </number:number-style>
+ <number:number-style style:name="N141">
+ <number:number number:decimal-places="10" loext:min-decimal-places="10"
number:min-integer-digits="1"/>
+ </number:number-style>
+ <number:number-style style:name="N142">
+ <number:number number:decimal-places="11" loext:min-decimal-places="11"
number:min-integer-digits="1"/>
+ </number:number-style>
+ <number:number-style style:name="N143">
+ <number:number number:decimal-places="12" loext:min-decimal-places="12"
number:min-integer-digits="1"/>
+ </number:number-style>
+ <number:number-style style:name="N144">
+ <number:number number:decimal-places="13" loext:min-decimal-places="13"
number:min-integer-digits="1"/>
+ </number:number-style>
+ <number:number-style style:name="N145">
+ <number:number number:decimal-places="14" loext:min-decimal-places="14"
number:min-integer-digits="1"/>
+ </number:number-style>
+ <number:number-style style:name="N146">
+ <number:number number:decimal-places="15" loext:min-decimal-places="15"
number:min-integer-digits="1"/>
+ </number:number-style>
+ <number:number-style style:name="N147">
+ <number:number number:decimal-places="16" loext:min-decimal-places="16"
number:min-integer-digits="1"/>
+ </number:number-style>
+ <number:number-style style:name="N148">
+ <number:number number:decimal-places="17" loext:min-decimal-places="17"
number:min-integer-digits="1"/>
+ </number:number-style>
+ <number:number-style style:name="N149">
+ <number:number number:decimal-places="18" loext:min-decimal-places="18"
number:min-integer-digits="1"/>
+ </number:number-style>
+ <number:currency-style style:name="N151P0" style:volatile="true">
+ <number:currency-symbol number:language="en"
number:country="IE">â¬</number:currency-symbol>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ </number:currency-style>
+ <number:currency-style style:name="N151">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>-</number:text>
+ <number:currency-symbol number:language="en"
number:country="IE">â¬</number:currency-symbol>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N151P0"/>
+ </number:currency-style>
+ <number:currency-style style:name="N153P0" style:volatile="true">
+ <number:currency-symbol number:language="pt"
number:country="BR">R$</number:currency-symbol>
+ <number:text> </number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ </number:currency-style>
+ <number:currency-style style:name="N153">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>-</number:text>
+ <number:currency-symbol number:language="pt"
number:country="BR">R$</number:currency-symbol>
+ <number:text> </number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N153P0"/>
+ </number:currency-style>
+ <number:currency-style style:name="N155P0" style:volatile="true">
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ <number:currency-symbol number:language="fr"
number:country="FR">â¬</number:currency-symbol>
+ </number:currency-style>
+ <number:currency-style style:name="N155">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>-</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ <number:currency-symbol number:language="fr"
number:country="FR">â¬</number:currency-symbol>
+ <style:map style:condition="value()>=0" style:apply-style-name="N155P0"/>
+ </number:currency-style>
+ <number:number-style style:name="N157P0" style:volatile="true">
+ <number:text>\</number:text>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ </number:number-style>
+ <number:number-style style:name="N157">
+ <number:text>\-</number:text>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N157P0"/>
+ </number:number-style>
+ <number:number-style style:name="N158P0" style:volatile="true">
+ <number:text>\</number:text>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ </number:number-style>
+ <number:number-style style:name="N158">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>\-</number:text>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N158P0"/>
+ </number:number-style>
+ <number:number-style style:name="N160P0" style:volatile="true">
+ <number:text>\</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ </number:number-style>
+ <number:number-style style:name="N160">
+ <number:text>\-</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N160P0"/>
+ </number:number-style>
+ <number:number-style style:name="N161P0" style:volatile="true">
+ <number:text>\</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ </number:number-style>
+ <number:number-style style:name="N161">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>\-</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N161P0"/>
+ </number:number-style>
+ <number:number-style style:name="N163P0" style:volatile="true">
+ <number:text>$</number:text>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N163">
+ <number:text>($</number:text>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text>)</number:text>
+ <style:map style:condition="value()>=0" style:apply-style-name="N163P0"/>
+ </number:number-style>
+ <number:number-style style:name="N164P0" style:volatile="true">
+ <number:text>$</number:text>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N164">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>($</number:text>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text>)</number:text>
+ <style:map style:condition="value()>=0" style:apply-style-name="N164P0"/>
+ </number:number-style>
+ <number:number-style style:name="N166P0" style:volatile="true">
+ <number:text>$</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N166">
+ <number:text>($</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text>)</number:text>
+ <style:map style:condition="value()>=0" style:apply-style-name="N166P0"/>
+ </number:number-style>
+ <number:number-style style:name="N167P0" style:volatile="true">
+ <number:text>$</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N167">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>($</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text>)</number:text>
+ <style:map style:condition="value()>=0" style:apply-style-name="N167P0"/>
+ </number:number-style>
+ <number:number-style style:name="N171P0" style:volatile="true">
+ <loext:text> </loext:text>
+ <loext:fill-character> </loext:fill-character>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N171P1" style:volatile="true">
+ <loext:text> </loext:text>
+ <loext:fill-character> </loext:fill-character>
+ <number:text>-</number:text>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N171P2" style:volatile="true">
+ <loext:text> </loext:text>
+ <loext:fill-character> </loext:fill-character>
+ <number:text>- </number:text>
+ </number:number-style>
+ <number:text-style style:name="N171">
+ <number:text> </number:text>
+ <number:text-content/>
+ <number:text> </number:text>
+ <style:map style:condition="value()>0" style:apply-style-name="N171P0"/>
+ <style:map style:condition="value()<0" style:apply-style-name="N171P1"/>
+ <style:map style:condition="value()=0" style:apply-style-name="N171P2"/>
+ </number:text-style>
+ <number:number-style style:name="N175P0" style:volatile="true">
+ <loext:text> \</loext:text>
+ <loext:fill-character> </loext:fill-character>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N175P1" style:volatile="true">
+ <loext:text> \</loext:text>
+ <loext:fill-character> </loext:fill-character>
+ <number:text>-</number:text>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N175P2" style:volatile="true">
+ <loext:text> \</loext:text>
+ <loext:fill-character> </loext:fill-character>
+ <number:text>- </number:text>
+ </number:number-style>
+ <number:text-style style:name="N175">
+ <number:text> </number:text>
+ <number:text-content/>
+ <number:text> </number:text>
+ <style:map style:condition="value()>0" style:apply-style-name="N175P0"/>
+ <style:map style:condition="value()<0" style:apply-style-name="N175P1"/>
+ <style:map style:condition="value()=0" style:apply-style-name="N175P2"/>
+ </number:text-style>
+ <number:number-style style:name="N179P0" style:volatile="true">
+ <loext:text> </loext:text>
+ <loext:fill-character> </loext:fill-character>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N179P1" style:volatile="true">
+ <loext:text> </loext:text>
+ <loext:fill-character> </loext:fill-character>
+ <number:text>-</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N179P2" style:volatile="true">
+ <loext:text> </loext:text>
+ <loext:fill-character> </loext:fill-character>
+ <number:text>-</number:text>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="0"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:text-style style:name="N179">
+ <number:text> </number:text>
+ <number:text-content/>
+ <number:text> </number:text>
+ <style:map style:condition="value()>0" style:apply-style-name="N179P0"/>
+ <style:map style:condition="value()<0" style:apply-style-name="N179P1"/>
+ <style:map style:condition="value()=0" style:apply-style-name="N179P2"/>
+ </number:text-style>
+ <number:number-style style:name="N183P0" style:volatile="true">
+ <loext:text> \</loext:text>
+ <loext:fill-character> </loext:fill-character>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N183P1" style:volatile="true">
+ <loext:text> \</loext:text>
+ <loext:fill-character> </loext:fill-character>
+ <number:text>-</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N183P2" style:volatile="true">
+ <loext:text> \</loext:text>
+ <loext:fill-character> </loext:fill-character>
+ <number:text>-</number:text>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="0"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:text-style style:name="N183">
+ <number:text> </number:text>
+ <number:text-content/>
+ <number:text> </number:text>
+ <style:map style:condition="value()>0" style:apply-style-name="N183P0"/>
+ <style:map style:condition="value()<0" style:apply-style-name="N183P1"/>
+ <style:map style:condition="value()=0" style:apply-style-name="N183P2"/>
+ </number:text-style>
+ <number:time-style style:name="N184">
+ <number:minutes number:style="long"/>
+ <number:text>:</number:text>
+ <number:seconds number:style="long"/>
+ </number:time-style>
+ <number:time-style style:name="N185" number:truncate-on-overflow="false">
+ <number:hours/>
+ <number:text>:</number:text>
+ <number:minutes number:style="long"/>
+ <number:text>:</number:text>
+ <number:seconds number:style="long"/>
+ </number:time-style>
+ <number:time-style style:name="N186">
+ <number:minutes number:style="long"/>
+ <number:text>:</number:text>
+ <number:seconds number:style="long" number:decimal-places="1"/>
+ </number:time-style>
+ <number:number-style style:name="N187">
+ <number:scientific-number number:decimal-places="1"
loext:min-decimal-places="1" number:min-integer-digits="1"
number:min-exponent-digits="1" loext:exponent-interval="3"
loext:forced-exponent-sign="true"/>
+ </number:number-style>
+ <number:currency-style style:name="N189P0" style:volatile="true">
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ <number:currency-symbol number:language="lt"
number:country="LT">Lt</number:currency-symbol>
+ </number:currency-style>
+ <number:currency-style style:name="N189">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>-</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ <number:currency-symbol number:language="lt"
number:country="LT">Lt</number:currency-symbol>
+ <style:map style:condition="value()>=0" style:apply-style-name="N189P0"/>
+ </number:currency-style>
+ <number:currency-style style:name="N191P0" style:volatile="true">
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ <number:currency-symbol number:language="et"
number:country="EE">kr</number:currency-symbol>
+ </number:currency-style>
+ <number:currency-style style:name="N191">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>-</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ <number:currency-symbol number:language="et"
number:country="EE">kr</number:currency-symbol>
+ <style:map style:condition="value()>=0" style:apply-style-name="N191P0"/>
+ </number:currency-style>
+ <number:currency-style style:name="N193P0" style:volatile="true">
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ <number:currency-symbol number:language="de"
number:country="DE">â¬</number:currency-symbol>
+ </number:currency-style>
+ <number:currency-style style:name="N193">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>-</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ <number:currency-symbol number:language="de"
number:country="DE">â¬</number:currency-symbol>
+ <style:map style:condition="value()>=0" style:apply-style-name="N193P0"/>
+ </number:currency-style>
+ <number:currency-style style:name="N195P0" style:volatile="true">
+ <number:currency-symbol number:language="de"
number:country="CH">SFr.</number:currency-symbol>
+ <number:text> </number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ </number:currency-style>
+ <number:currency-style style:name="N195">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:currency-symbol number:language="de"
number:country="CH">SFr.</number:currency-symbol>
+ <number:text> -</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N195P0"/>
+ </number:currency-style>
+ <number:date-style style:name="N10121" number:language="en"
number:country="US">
+ <number:month/>
+ <number:text>/</number:text>
+ <number:day/>
+ <number:text>/</number:text>
+ <number:year number:style="long"/>
+ </number:date-style>
+ <number:date-style style:name="N10122" number:language="en"
number:country="US">
+ <number:day/>
+ <number:text>-</number:text>
+ <number:month number:textual="true"/>
+ <number:text>-</number:text>
+ <number:year/>
+ </number:date-style>
+ <number:date-style style:name="N10123" number:language="en"
number:country="US">
+ <number:day/>
+ <number:text>-</number:text>
+ <number:month number:textual="true"/>
+ </number:date-style>
+ <number:date-style style:name="N10124" number:language="en"
number:country="US">
+ <number:month number:textual="true"/>
+ <number:text>-</number:text>
+ <number:year/>
+ </number:date-style>
+ <number:time-style style:name="N10125" number:language="en"
number:country="US">
+ <number:hours/>
+ <number:text>:</number:text>
+ <number:minutes number:style="long"/>
+ <number:text> </number:text>
+ <number:am-pm/>
+ </number:time-style>
+ <number:time-style style:name="N10126" number:language="en"
number:country="US">
+ <number:hours/>
+ <number:text>:</number:text>
+ <number:minutes number:style="long"/>
+ <number:text>:</number:text>
+ <number:seconds number:style="long"/>
+ <number:text> </number:text>
+ <number:am-pm/>
+ </number:time-style>
+ <number:time-style style:name="N10127" number:language="en"
number:country="US">
+ <number:hours/>
+ <number:text>:</number:text>
+ <number:minutes number:style="long"/>
+ </number:time-style>
+ <number:time-style style:name="N10128" number:language="en"
number:country="US">
+ <number:hours/>
+ <number:text>:</number:text>
+ <number:minutes number:style="long"/>
+ <number:text>:</number:text>
+ <number:seconds number:style="long"/>
+ </number:time-style>
+ <number:date-style style:name="N10129" number:language="en"
number:country="US">
+ <number:month/>
+ <number:text>/</number:text>
+ <number:day/>
+ <number:text>/</number:text>
+ <number:year number:style="long"/>
+ <number:text> </number:text>
+ <number:hours/>
+ <number:text>:</number:text>
+ <number:minutes number:style="long"/>
+ </number:date-style>
+ <number:number-style style:name="N10131P0" style:volatile="true"
number:language="en" number:country="US">
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N10131" number:language="en"
number:country="US">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>(</number:text>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text>)</number:text>
+ <style:map style:condition="value()>=0"
style:apply-style-name="N10131P0"/>
+ </number:number-style>
+ <number:number-style style:name="N10133P0" style:volatile="true"
number:language="en" number:country="US">
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N10133" number:language="en"
number:country="US">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>(</number:text>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text>)</number:text>
+ <style:map style:condition="value()>=0"
style:apply-style-name="N10133P0"/>
+ </number:number-style>
+ <number:currency-style style:name="N10135P0" style:volatile="true"
number:language="en" number:country="US">
+ <number:currency-symbol/>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:currency-style>
+ <number:currency-style style:name="N10135" number:language="en"
number:country="US">
+ <number:text>(</number:text>
+ <number:currency-symbol/>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text>)</number:text>
+ <style:map style:condition="value()>=0"
style:apply-style-name="N10135P0"/>
+ </number:currency-style>
+ <number:currency-style style:name="N10136P0" style:volatile="true"
number:language="en" number:country="US">
+ <number:currency-symbol/>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:currency-style>
+ <number:currency-style style:name="N10136" number:language="en"
number:country="US">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>(</number:text>
+ <number:currency-symbol/>
+ <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text>)</number:text>
+ <style:map style:condition="value()>=0"
style:apply-style-name="N10136P0"/>
+ </number:currency-style>
+ <number:currency-style style:name="N10138P0" style:volatile="true"
number:language="en" number:country="US">
+ <number:currency-symbol/>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:currency-style>
+ <number:currency-style style:name="N10138" number:language="en"
number:country="US">
+ <number:text>(</number:text>
+ <number:currency-symbol/>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text>)</number:text>
+ <style:map style:condition="value()>=0"
style:apply-style-name="N10138P0"/>
+ </number:currency-style>
+ <number:currency-style style:name="N10139P0" style:volatile="true"
number:language="en" number:country="US">
+ <number:currency-symbol/>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:currency-style>
+ <number:currency-style style:name="N10139" number:language="en"
number:country="US">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>(</number:text>
+ <number:currency-symbol/>
+ <number:number number:decimal-places="2" loext:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text>)</number:text>
+ <style:map style:condition="value()>=0"
style:apply-style-name="N10139P0"/>
+ </number:currency-style>
+ <style:style style:name="Default" style:family="table-cell">
+ <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"/>
+ </style:style>
+ <style:style style:name="Result" style:family="table-cell"
style:parent-style-name="Default">
+ <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"/>
+ </style:style>
+ <style:style style:name="Result2" style:family="table-cell"
style:parent-style-name="Result" style:data-style-name="N122"/>
+ <style:style style:name="Heading" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties style:text-align-source="fix"
style:repeat-content="false"/>
+ <style:paragraph-properties fo:text-align="center"/>
+ <style:text-properties fo:font-size="16pt" fo:font-style="italic"
fo:font-weight="bold"/>
+ </style:style>
+ <style:style style:name="Heading1" style:family="table-cell"
style:parent-style-name="Heading">
+ <style:table-cell-properties style:rotation-angle="90"/>
+ </style:style>
+ <style:style style:name="Untitled1" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties fo:background-color="#ff3333"/>
+ </style:style>
+ <style:style style:name="Untitled2" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties fo:background-color="#99ff66"/>
+ </style:style>
+ </office:styles>
+ <office:automatic-styles>
+ <style:style style:name="co1" style:family="table-column">
+ <style:table-column-properties fo:break-before="auto"
style:column-width="185.7pt"/>
+ </style:style>
+ <style:style style:name="co2" style:family="table-column">
+ <style:table-column-properties fo:break-before="auto"
style:column-width="252.51pt"/>
+ </style:style>
+ <style:style style:name="co3" style:family="table-column">
+ <style:table-column-properties fo:break-before="auto"
style:column-width="64.01pt"/>
+ </style:style>
+ <style:style style:name="co4" style:family="table-column">
+ <style:table-column-properties fo:break-before="auto"
style:column-width="154.54pt"/>
+ </style:style>
+ <style:style style:name="co5" style:family="table-column">
+ <style:table-column-properties fo:break-before="auto"
style:column-width="160.95pt"/>
+ </style:style>
+ <style:style style:name="co6" style:family="table-column">
+ <style:table-column-properties fo:break-before="auto"
style:column-width="50.94pt"/>
+ </style:style>
+ <style:style style:name="co7" style:family="table-column">
+ <style:table-column-properties fo:break-before="auto"
style:column-width="178.44pt"/>
+ </style:style>
+ <style:style style:name="co8" style:family="table-column">
+ <style:table-column-properties fo:break-before="auto"
style:column-width="114.24pt"/>
+ </style:style>
+ <style:style style:name="co9" style:family="table-column">
+ <style:table-column-properties fo:break-before="auto"
style:column-width="16.44pt"/>
+ </style:style>
+ <style:style style:name="co10" style:family="table-column">
+ <style:table-column-properties fo:break-before="auto"
style:column-width="101.91pt"/>
+ </style:style>
+ <style:style style:name="ro1" style:family="table-row">
+ <style:table-row-properties style:row-height="24.46pt"
fo:break-before="auto" style:use-optimal-row-height="true"/>
+ </style:style>
+ <style:style style:name="ro2" style:family="table-row">
+ <style:table-row-properties style:row-height="12.81pt"
fo:break-before="auto" style:use-optimal-row-height="true"/>
+ </style:style>
+ <style:style style:name="ro3" style:family="table-row">
+ <style:table-row-properties style:row-height="17.35pt"
fo:break-before="auto" style:use-optimal-row-height="true"/>
+ </style:style>
+ <style:style style:name="ro4" style:family="table-row">
+ <style:table-row-properties style:row-height="15pt" fo:break-before="auto"
style:use-optimal-row-height="true"/>
+ </style:style>
+ <style:style style:name="ro5" style:family="table-row">
+ <style:table-row-properties style:row-height="14.66pt"
fo:break-before="auto" style:use-optimal-row-height="true"/>
+ </style:style>
+ <style:style style:name="ro6" style:family="table-row">
+ <style:table-row-properties style:row-height="114.69pt"
fo:break-before="auto" style:use-optimal-row-height="true"/>
+ </style:style>
+ <style:style style:name="ta1" style:family="table"
style:master-page-name="Default">
+ <style:table-properties table:display="true" style:writing-mode="lr-tb"/>
+ </style:style>
+ <number:boolean-style style:name="N99">
+ <number:boolean/>
+ </number:boolean-style>
+ <number:text-style style:name="N100">
+ <number:text-content/>
+ </number:text-style>
+ <style:style style:name="ce10" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties style:text-align-source="fix"
style:repeat-content="false"/>
+ <style:paragraph-properties fo:text-align="start" fo:margin-left="0pt"/>
+ <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"/>
+ </style:style>
+ <style:style style:name="ce12" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties style:text-align-source="fix"
style:repeat-content="false"/>
+ <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
+ <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"/>
+ </style:style>
+ <style:style style:name="ce15" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties style:text-align-source="fix"
style:repeat-content="false"/>
+ <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
+ <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"/>
+ </style:style>
+ <style:style style:name="ce16" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties style:text-align-source="fix"
style:repeat-content="false"/>
+ <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
+ </style:style>
+ <style:style style:name="ce19" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N99">
+ <style:table-cell-properties style:text-align-source="fix"
style:repeat-content="false"/>
+ <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
+ <style:map style:condition="cell-content()="""
style:apply-style-name="Default" style:base-cell-address="Sheet1.B3"/>
+ <style:map style:condition="cell-content()=0"
style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B3"/>
+ <style:map style:condition="cell-content()=1"
style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B3"/>
+ </style:style>
+ <style:style style:name="ce29" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N99">
+ <style:table-cell-properties style:text-align-source="fix"
style:repeat-content="false"/>
+ <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
+ <style:map style:condition="cell-content()="""
style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
+ <style:map style:condition="cell-content()=0"
style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
+ <style:map style:condition="cell-content()=1"
style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
+ </style:style>
+ <style:style style:name="ce30" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties style:text-align-source="fix"
style:repeat-content="false"/>
+ <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
+ <style:map style:condition="cell-content()="""
style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
+ <style:map style:condition="cell-content()=0"
style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
+ <style:map style:condition="cell-content()=1"
style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
+ </style:style>
+ <style:style style:name="ce8" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties style:text-align-source="fix"
style:repeat-content="false"/>
+ <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
+ <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold"
style:font-weight-complex="bold"/>
+ </style:style>
+ <style:style style:name="ce9" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties fo:wrap-option="wrap"/>
+ <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"/>
+ </style:style>
+ <style:style style:name="ce20" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties fo:wrap-option="wrap"/>
+ <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="Cumberland"
fo:font-size="10pt" 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-name-asian="Andale Sans
UI" style:font-size-asian="10pt" style:font-style-asian="normal"
style:font-weight-asian="normal" style:font-name-complex="Tahoma"
style:font-size-complex="10pt" style:font-style-complex="normal"
style:font-weight-complex="normal" style:text-emphasize="none"
style:font-relief="none"/>
+ </style:style>
+ <style:style style:name="ce21" style:family="table-cell"
style:parent-style-name="Default">
+ <style:text-properties style:font-name="Liberation Sans"
style:font-name-asian="Droid Sans Fallback" style:font-name-complex="Droid Sans
Devanagari"/>
+ </style:style>
+ <style:style style:name="ce25" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties fo:wrap-option="wrap"/>
+ <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 Sans"
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-name-asian="Droid Sans
Fallback" 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-name-complex="Droid Sans
Devanagari" 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"/>
+ </style:style>
+ <style:style style:name="ce14" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties fo:padding="2.01pt"/>
+ </style:style>
+ <style:style style:name="ce23" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N99"/>
+ <style:style style:name="ce17" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N100">
+ <style:table-cell-properties fo:padding="2.01pt"/>
+ </style:style>
+ <style:style style:name="ce24" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N99">
+ <style:table-cell-properties fo:wrap-option="wrap"/>
+ <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"/>
+ </style:style>
+ <style:style style:name="ce29" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N99">
+ <style:table-cell-properties style:text-align-source="fix"
style:repeat-content="false"/>
+ <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
+ <style:map style:condition="cell-content()="""
style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/>
+ <style:map style:condition="cell-content()=0"
style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/>
+ <style:map style:condition="cell-content()=1"
style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/>
+ </style:style>
+ <style:style style:name="ce19" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N99">
+ <style:table-cell-properties style:text-align-source="fix"
style:repeat-content="false"/>
+ <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
+ <style:map style:condition="cell-content()="""
style:apply-style-name="Default" style:base-cell-address="Sheet2.C18"/>
+ <style:map style:condition="cell-content()=0"
style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C18"/>
+ <style:map style:condition="cell-content()=1"
style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C18"/>
+ </style:style>
+ <style:style style:name="ce16" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties style:text-align-source="fix"
style:repeat-content="false"/>
+ <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
+ </style:style>
+ <style:style style:name="ce11" style:family="table-cell"
style:parent-style-name="Default">
+ <style:text-properties style:font-name-asian="Microsoft YaHei"
style:font-name-complex="Mangal"/>
+ </style:style>
+ <style:style style:name="ce37" style:family="table-cell"
style:parent-style-name="Default">
+ <style:text-properties style:font-name="Arial" style:font-name-asian="Times
New Roman" style:font-size-asian="12pt" style:language-asian="ar"
style:country-asian="SA" style:font-name-complex="DejaVu Sans"
style:font-size-complex="6.80000019073486pt" style:language-complex="none"
style:country-complex="none"/>
+ </style:style>
+ <style:style style:name="ce35" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties fo:wrap-option="wrap"/>
+ <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="bold"
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"/>
+ </style:style>
+ <style:style style:name="ce33" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N0">
+ <style:table-cell-properties fo:background-color="#ffffff"
style:diagonal-bl-tr="none" style:diagonal-tl-br="none"
style:text-align-source="value-type" style:repeat-content="false"
fo:wrap-option="no-wrap" fo:border="none" fo:padding-bottom="0.99pt"
fo:padding-left="2.41pt" fo:padding-right="2.41pt" fo:padding-top="0.99pt"
style:rotation-angle="0" style:rotation-align="none"
style:vertical-align="automatic"/>
+ <style:text-properties fo:color="#000000" style:text-outline="false"
style:text-line-through-style="none" style:text-line-through-type="none"
style:font-name="Arial" fo:font-size="10pt" fo:language="de" fo:country="CH"
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"/>
+ </style:style>
+ <style:page-layout style:name="pm1">
+ <style:page-layout-properties style:writing-mode="lr-tb"/>
+ <style:header-style>
+ <style:header-footer-properties fo:min-height="21.26pt"
fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-bottom="7.09pt"/>
+ </style:header-style>
+ <style:footer-style>
+ <style:header-footer-properties fo:min-height="21.26pt"
fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-top="7.09pt"/>
+ </style:footer-style>
+ </style:page-layout>
+ <style:page-layout style:name="pm2">
+ <style:page-layout-properties style:writing-mode="lr-tb"/>
+ <style:header-style>
+ <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">
+ <style:background-image/>
+ </style:header-footer-properties>
+ </style:header-style>
+ <style:footer-style>
+ <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">
+ <style:background-image/>
+ </style:header-footer-properties>
+ </style:footer-style>
+ </style:page-layout>
+ <style:style style:name="T1" style:family="text">
+ <style:text-properties fo:font-size="10pt" fo:font-weight="bold"
fo:language="en" fo:country="US" style:language-asian="ar"
style:country-asian="SA" style:font-name-asian="Times New Roman"
style:font-size-asian="12pt" style:font-weight-asian="bold"
style:font-weight-complex="bold"/>
+ </style:style>
+ <style:style style:name="T2" style:family="text">
+ <style:text-properties fo:font-size="10pt" fo:language="en" fo:country="US"
style:language-asian="ar" style:country-asian="SA" style:font-name-asian="Times
New Roman" style:font-size-asian="12pt"/>
+ </style:style>
+ </office:automatic-styles>
+ <office:master-styles>
+ <style:master-page style:name="Default" style:page-layout-name="pm1">
+ <style:header>
+ <text:p><text:sheet-name>???</text:sheet-name></text:p>
+ </style:header>
+ <style:header-left style:display="false"/>
+ <style:footer>
+ <text:p>Page <text:page-number>1</text:page-number></text:p>
+ </style:footer>
+ <style:footer-left style:display="false"/>
+ </style:master-page>
+ <style:master-page style:name="Report" style:page-layout-name="pm2">
+ <style:header>
+ <style:region-left>
+ <text:p><text:sheet-name>???</text:sheet-name>
(<text:title>???</text:title>)</text:p>
+ </style:region-left>
+ <style:region-right>
+ <text:p><text:date style:data-style-name="N2"
text:date-value="2017-02-02">00/00/0000</text:date>, <text:time
style:data-style-name="N2"
text:time-value="18:51:14.450537214">00:00:00</text:time></text:p>
+ </style:region-right>
+ </style:header>
+ <style:header-left style:display="false"/>
+ <style:footer>
+ <text:p>Page <text:page-number>1</text:page-number> /
<text:page-count>99</text:page-count></text:p>
+ </style:footer>
+ <style:footer-left style:display="false"/>
+ </style:master-page>
+ </office:master-styles>
+ <office:body>
+ <office:spreadsheet>
+ <table:calculation-settings table:automatic-find-labels="false"/>
+ <table:table table:name="Sheet1" table:style-name="ta1">
+ <table:table-column table:style-name="co1"
table:default-cell-style-name="Default"/>
+ <table:table-column table:style-name="co1"
table:default-cell-style-name="ce16"/>
+ <table:table-column table:style-name="co2"
table:default-cell-style-name="Default"/>
+ <table:table-row table:style-name="ro1">
+ <table:table-cell table:style-name="ce10" office:value-type="string"
calcext:value-type="string">
+ <text:p>SEARCH Function</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro2">
+ <table:table-cell table:number-columns-repeated="3"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro3">
+ <table:table-cell table:style-name="ce12" office:value-type="string"
calcext:value-type="string">
+ <text:p>Result</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce19"
table:formula="of:=AND([.B8:.B95])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <text:p>TRUE</text:p>
+ </table:table-cell>
+ <table:table-cell/>
+ </table:table-row>
+ <table:table-row table:style-name="ro2" table:number-rows-repeated="3">
+ <table:table-cell table:number-columns-repeated="3"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro4">
+ <table:table-cell table:style-name="ce15" office:value-type="string"
calcext:value-type="string">
+ <text:p>Sheet</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce15" office:value-type="string"
calcext:value-type="string">
+ <text:p>Result</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce15" office:value-type="string"
calcext:value-type="string">
+ <text:p>Description</text:p>
+ </table:table-cell>
+ </table:table-row>
+ <table:table-row table:style-name="ro2">
+ <table:table-cell office:value-type="float" office:value="1"
calcext:value-type="float">
+ <text:p>1</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce29"
table:formula="of:=AND([Sheet2.C2:.C100])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <text:p>TRUE</text:p>
+ </table:table-cell>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>Simple SEARCH formulas with local references and values</text:p>
+ </table:table-cell>
+ </table:table-row>
+ <table:table-row table:style-name="ro2" table:number-rows-repeated="30">
+ <table:table-cell/>
+ <table:table-cell table:style-name="ce30"/>
+ <table:table-cell/>
+ </table:table-row>
+ <table:table-row table:style-name="ro2"
table:number-rows-repeated="1048537">
+ <table:table-cell table:number-columns-repeated="3"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro2">
+ <table:table-cell table:number-columns-repeated="3"/>
+ </table:table-row>
+ <calcext:conditional-formats>
+ <calcext:conditional-format
calcext:target-range-address="Sheet1.B8:Sheet1.B38">
+ <calcext:condition calcext:apply-style-name="Default"
calcext:value="=""" calcext:base-cell-address="Sheet1.B8"/>
+ <calcext:condition calcext:apply-style-name="Untitled1"
calcext:value="=0" calcext:base-cell-address="Sheet1.B8"/>
+ <calcext:condition calcext:apply-style-name="Untitled2"
calcext:value="=1" calcext:base-cell-address="Sheet1.B8"/>
+ </calcext:conditional-format>
+ <calcext:conditional-format
calcext:target-range-address="Sheet1.B3:Sheet1.B3">
+ <calcext:condition calcext:apply-style-name="Default"
calcext:value="=""" calcext:base-cell-address="Sheet1.B3"/>
+ <calcext:condition calcext:apply-style-name="Untitled1"
calcext:value="=0" calcext:base-cell-address="Sheet1.B3"/>
+ <calcext:condition calcext:apply-style-name="Untitled2"
calcext:value="=1" calcext:base-cell-address="Sheet1.B3"/>
+ </calcext:conditional-format>
+ </calcext:conditional-formats>
+ </table:table>
+ <table:table table:name="Sheet2" table:style-name="ta1" table:print="false">
+ <table:table-column table:style-name="co4"
table:default-cell-style-name="Default"/>
+ <table:table-column table:style-name="co5"
table:default-cell-style-name="Default"/>
+ <table:table-column table:style-name="co6"
table:default-cell-style-name="ce16"/>
+ <table:table-column table:style-name="co7"
table:default-cell-style-name="Default"/>
+ <table:table-column table:style-name="co8"
table:default-cell-style-name="Default"/>
+ <table:table-column table:style-name="co9"
table:number-columns-repeated="3" table:default-cell-style-name="Default"/>
+ <table:table-column table:style-name="co10"
table:default-cell-style-name="Default"/>
+ <table:table-column table:style-name="co3"
table:number-columns-repeated="2" table:default-cell-style-name="Default"/>
+ <table:table-row table:style-name="ro2">
+ <table:table-cell table:style-name="ce8" office:value-type="string"
calcext:value-type="string">
+ <text:p>Function</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce8" office:value-type="string"
calcext:value-type="string">
+ <text:p>Expected</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce8" office:value-type="string"
calcext:value-type="string">
+ <text:p>Correct</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce8" office:value-type="string"
calcext:value-type="string">
+ <text:p>FunctionString</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce8" office:value-type="string"
calcext:value-type="string">
+ <text:p>Comment</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="3"/>
+ <table:table-cell table:style-name="ce35" office:value-type="string"
calcext:value-type="string">
+ <text:p>LibreOffice</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce35"
table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell table:style-name="ce9"
table:formula="of:=SEARCH(54;998877665544)" office:value-type="float"
office:value="10" calcext:value-type="float">
+ <text:p>10</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce17" office:value-type="float"
office:value="10" calcext:value-type="float">
+ <text:p>10</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce29" table:formula="of:=[.A2]=[.B2]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <text:p>TRUE</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce11"
table:formula="of:=FORMULA([.A2])" office:value-type="string"
office:string-value="=SEARCH(54,998877665544)" calcext:value-type="string">
+ <text:p>=SEARCH(54,998877665544)</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="5"/>
+ <table:table-cell table:style-name="ce9"
table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell
table:formula="of:=IF(ISERROR(SEARCH("Gewinn|Promotion|Replay";[.I5]));"";[.K5])"
office:value-type="float" office:value="6" calcext:value-type="float">
+ <text:p>6</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce17" office:value-type="float"
office:value="6" calcext:value-type="float">
+ <text:p>6</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce29" table:formula="of:=[.A3]=[.B3]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <text:p>TRUE</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce11"
table:formula="of:=FORMULA([.A3])" office:value-type="string"
office:string-value="=IF(ISERROR(SEARCH("Gewinn|Promotion|Replay",I5)),"",K5)"
calcext:value-type="string">
+
<text:p>=IF(ISERROR(SEARCH("Gewinn|Promotion|Replay",I5)),"",K5)</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="5"/>
+ <table:table-cell table:style-name="ce9"
table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell
table:formula="of:=IF(ISERROR(SEARCH("Gewinn|Promotion|Replay";[.I6]));"";[.K6])"
office:value-type="float" office:value="2" calcext:value-type="float">
+ <text:p>2</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce17" office:value-type="float"
office:value="2" calcext:value-type="float">
+ <text:p>2</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce29" table:formula="of:=[.A4]=[.B4]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <text:p>TRUE</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce11"
table:formula="of:=FORMULA([.A4])" office:value-type="string"
office:string-value="=IF(ISERROR(SEARCH("Gewinn|Promotion|Replay",I6)),"",K6)"
calcext:value-type="string">
+
<text:p>=IF(ISERROR(SEARCH("Gewinn|Promotion|Replay",I6)),"",K6)</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="5"/>
+ <table:table-cell table:style-name="ce9"
table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell table:style-name="ce20"
table:number-matrix-columns-spanned="1" table:number-matrix-rows-spanned="1"
table:formula="of:=SUM(IF(ISERROR(SEARCH("Mark";[.I10:.I19]));0;1))"
office:value-type="float" office:value="4" calcext:value-type="float">
+ <text:p>4</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce17" office:value-type="float"
office:value="4" calcext:value-type="float">
+ <text:p>4</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce29" table:formula="of:=[.A5]=[.B5]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <text:p>TRUE</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce11"
table:formula="of:=FORMULA([.A5])" office:value-type="string"
office:string-value="{=SUM(IF(ISERROR(SEARCH("Mark",I10:I19)),0,1))}"
calcext:value-type="string">
+
<text:p>{=SUM(IF(ISERROR(SEARCH("Mark",I10:I19)),0,1))}</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="4"/>
+ <table:table-cell table:style-name="ce33" office:value-type="string"
calcext:value-type="string">
+ <text:p>Gewinn</text:p>
+ </table:table-cell>
+ <table:table-cell/>
+ <table:table-cell office:value-type="float" office:value="6"
calcext:value-type="float">
+ <text:p>6</text:p>
+ </table:table-cell>
+ </table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell table:formula="of:=SEARCH("off";[.I1])"
office:value-type="float" office:value="6" calcext:value-type="float">
+ <text:p>6</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce17" office:value-type="float"
office:value="6" calcext:value-type="float">
+ <text:p>6</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce29" table:formula="of:=[.A6]=[.B6]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <text:p>TRUE</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce11"
table:formula="of:=FORMULA([.A6])" office:value-type="string"
office:string-value="=SEARCH("off",I1)" calcext:value-type="string">
+ <text:p>=SEARCH("off",I1)</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="4"/>
+ <table:table-cell table:style-name="ce33" office:value-type="string"
calcext:value-type="string"><text:p><text:a
xlink:href="https://www.swisslos.ch/wallet/wallethistorydetailshow.do?txId=80765176&d-8048523-p=null";
xlink:type="simple">Gewinn</text:a></text:p>
+ </table:table-cell>
+ <table:table-cell/>
+ <table:table-cell office:value-type="float" office:value="2"
calcext:value-type="float">
+ <text:p>2</text:p>
+ </table:table-cell>
+ </table:table-row>
+ <table:table-row table:style-name="ro2">
+ <table:table-cell table:style-name="ce21"
table:formula="of:=SEARCH("OFf";[.I1])" office:value-type="float"
office:value="6" calcext:value-type="float">
+ <text:p>6</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce9" office:value-type="float"
office:value="6" calcext:value-type="float">
+ <text:p>6</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce29" table:formula="of:=[.A7]=[.B7]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <text:p>TRUE</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce11"
table:formula="of:=FORMULA([.A7])" office:value-type="string"
office:string-value="=SEARCH("OFf",I1)" calcext:value-type="string">
+ <text:p>=SEARCH("OFf",I1)</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="5"/>
+ <table:table-cell table:style-name="ce9"
table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro2">
+ <table:table-cell table:style-name="ce25"
table:formula="of:=SEARCH("off";[.I1];2)" office:value-type="float"
office:value="6" calcext:value-type="float">
+ <text:p>6</text:p>
+ </table:table-cell>
+ <table:table-cell office:value-type="float" office:value="6"
calcext:value-type="float">
+ <text:p>6</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce29" table:formula="of:=[.A8]=[.B8]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <text:p>TRUE</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce11"
table:formula="of:=FORMULA([.A8])" office:value-type="string"
office:string-value="=SEARCH("off",I1,2)" calcext:value-type="string">
+ <text:p>=SEARCH("off",I1,2)</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="5"/>
+ <table:table-cell table:style-name="ce9"
table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell table:style-name="ce25"
table:formula="of:=SEARCH("off";[.I1];7)" office:value-type="string"
office:string-value="" calcext:value-type="error">
+ <text:p>#VALUE!</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce17" table:formula="of:=#VALUE!"
office:value-type="string" office:string-value="" calcext:value-type="error">
+ <text:p>#VALUE!</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce29"
table:formula="of:=ISERROR([.A9])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <text:p>TRUE</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce11"
table:formula="of:=FORMULA([.A9])" office:value-type="string"
office:string-value="=SEARCH("off",I1,7)" calcext:value-type="string">
+ <text:p>=SEARCH("off",I1,7)</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="7"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell table:style-name="ce25"
table:formula="of:=SEARCH("e";[.I1])" office:value-type="float"
office:value="5" calcext:value-type="float">
+ <text:p>5</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce17" office:value-type="float"
office:value="5" calcext:value-type="float">
+ <text:p>5</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce29"
table:formula="of:=[.A10]=[.B10]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <text:p>TRUE</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce11"
table:formula="of:=FORMULA([.A10])" office:value-type="string"
office:string-value="=SEARCH("e",I1)" calcext:value-type="string">
+ <text:p>=SEARCH("e",I1)</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="4"/>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>Mark</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell table:style-name="ce25"
table:formula="of:=SEARCH("e";[.I1];6)" office:value-type="float"
office:value="11" calcext:value-type="float">
+ <text:p>11</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce17" office:value-type="float"
office:value="11" calcext:value-type="float">
+ <text:p>11</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce29"
table:formula="of:=[.A11]=[.B11]" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <text:p>TRUE</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce11"
table:formula="of:=FORMULA([.A11])" office:value-type="string"
office:string-value="=SEARCH("e",I1,6)" calcext:value-type="string">
+ <text:p>=SEARCH("e",I1,6)</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="4"/>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>Julia</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro2">
+ <table:table-cell table:number-columns-repeated="2"/>
+ <table:table-cell table:style-name="Default"/>
+ <table:table-cell table:number-columns-repeated="5"/>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>Wookie</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro2">
+ <table:table-cell table:number-columns-repeated="2"/>
+ <table:table-cell table:style-name="Default"/>
+ <table:table-cell table:number-columns-repeated="5"/>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>Mark</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro2">
+ <table:table-cell table:number-columns-repeated="2"/>
+ <table:table-cell table:style-name="Default"/>
+ <table:table-cell table:number-columns-repeated="5"/>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>Mark</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro2">
+ <table:table-cell table:number-columns-repeated="2"/>
+ <table:table-cell table:style-name="Default"/>
+ <table:table-cell table:number-columns-repeated="5"/>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>Julia</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell table:style-name="ce9"/>
+ <table:table-cell table:style-name="ce17"/>
+ <table:table-cell table:style-name="ce29"/>
+ <table:table-cell table:style-name="ce11"/>
+ <table:table-cell table:number-columns-repeated="4"/>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>Gordon</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell/>
+ <table:table-cell table:style-name="ce17"/>
+ <table:table-cell table:style-name="ce29"/>
+ <table:table-cell table:style-name="ce11"/>
+ <table:table-cell table:number-columns-repeated="4"/>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>Flash</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell table:style-name="ce25"
table:formula="of:=SEARCH("e";[.I1];0)" office:value-type="float"
office:value="5" calcext:value-type="float">
+ <text:p>5</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce17" office:value-type="string"
calcext:value-type="string">
+ <text:p>error</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce19"/>
+ <table:table-cell table:style-name="ce11"
table:formula="of:=FORMULA([.A18])" office:value-type="string"
office:string-value="=SEARCH("e",I1,0)" calcext:value-type="string">
+ <text:p>=SEARCH("e",I1,0)</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce37" office:value-type="string"
calcext:value-type="string"><text:p><text:span
text:style-name="T1">Constraints:</text:span><text:span text:style-name="T2">
Start >= 1</text:span></text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="3"/>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>Andromeda</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell table:style-name="ce9"
table:formula="of:=SEARCH("e";"LibreOffice";0)"
office:value-type="float" office:value="5" calcext:value-type="float">
+ <text:p>5</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce17" office:value-type="string"
calcext:value-type="string">
+ <text:p>error</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce19"/>
+ <table:table-cell table:style-name="ce11"
table:formula="of:=FORMULA([.A19])" office:value-type="string"
office:string-value="=SEARCH("e","LibreOffice",0)"
calcext:value-type="string">
+ <text:p>=SEARCH("e","LibreOffice",0)</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="4"/>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>Mark</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro6">
+ <table:table-cell table:style-name="ce9"
table:formula="of:=SEARCH("e";"LibreOffice";-1)"
office:value-type="float" office:value="5" calcext:value-type="float">
+ <text:p>5</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce17" office:value-type="string"
calcext:value-type="string">
+ <text:p>error</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce19"/>
+ <table:table-cell table:style-name="ce11"
table:formula="of:=FORMULA([.A20])" office:value-type="string"
office:string-value="=SEARCH("e","LibreOffice",-1)"
calcext:value-type="string">
+ <text:p>=SEARCH("e","LibreOffice",-1)</text:p>
+ </table:table-cell>
+ <table:table-cell office:value-type="string"
calcext:value-type="string"><text:p>It is a non-compliance with a purpose to
keep backward compatibility (extract from the source
code):</text:p><text:p/><text:p>// This should use GetStringPositionArgument()
but old versions up</text:p><text:p>// to LibreOffice 4.2.5 allowed and ignored
0 and negative values.</text:p><text:p>// It is unnecessary to break existing
documents that "rely" on</text:p><text:p>// that behavior. Though
ODFF constrains Start to be >=1.</text:p><text:p>/* TODO: fix this and
possibly break those broken documents? */</text:p><text:p/><text:p>Given that
version 4.2.5 dates from June 2014, one could argue that making the code fully
ODFF compliant will not really break backward compatibility (version 5.4.0 is
scheduled for August 2017).</text:p><text:p>OTOH, it doesn't do real harm,
the source code simply replaces the value of argument Start with 1 when the
value passed is 0 or negative. </text:p
>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="6"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell table:style-name="ce9"/>
+ <table:table-cell table:style-name="ce17"/>
+ <table:table-cell table:style-name="ce19"/>
+ <table:table-cell table:style-name="ce11"/>
+ <table:table-cell table:number-columns-repeated="7"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro5" table:number-rows-repeated="4">
+ <table:table-cell table:style-name="ce14"/>
+ <table:table-cell table:style-name="ce17"/>
+ <table:table-cell table:style-name="ce29"/>
+ <table:table-cell table:style-name="ce11"/>
+ <table:table-cell table:number-columns-repeated="7"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro5" table:number-rows-repeated="12">
... etc. - the rest is truncated
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
