sc/qa/unit/data/functions/text/fods/clean.fods | 3438 ++++++++++++++++++-------
sc/source/core/tool/interpr1.cxx | 3
2 files changed, 2532 insertions(+), 909 deletions(-)
New commits:
commit 34412339f863b35508842a3bf20fcc7341a006e7
Author: Winfried Donkers <winfrieddonk...@libreoffice.org>
AuthorDate: Wed Jan 12 17:00:34 2022 +0100
Commit: Eike Rathke <er...@redhat.com>
CommitDate: Mon Jan 24 23:42:05 2022 +0100
tdf#97706 CLEAN is neither ODFF nor OOXML conform.
Patch makes CLEAN 100% compliant with ODFF v1.3 and almost 100% compliant
with actual Excel results (just character 0x7F differs).
co-author: taylorlee...@gmail.com
Change-Id: Icc070ca2560b7ca7640128c5a538d1fbfa1193e9
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/128350
Reviewed-by: Eike Rathke <er...@redhat.com>
Tested-by: Jenkins
diff --git a/sc/qa/unit/data/functions/text/fods/clean.fods
b/sc/qa/unit/data/functions/text/fods/clean.fods
index 58345a7f8ead..0230953d00e5 100644
--- a/sc/qa/unit/data/functions/text/fods/clean.fods
+++ b/sc/qa/unit/data/functions/text/fods/clean.fods
@@ -1,438 +1,440 @@
<?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:document
xmlns:presentation="urn:oasis:names:tc:opendocument:xmlns:presentation:1.0"
xmlns:css3t="http://www.w3.org/TR/css3-text/";
xmlns:grddl="http://www.w3.org/2003/g/data-view#";
xmlns:xhtml="http://www.w3.org/1999/xhtml";
xmlns:formx="urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xmlns:xsd="http://www.w3.org/2001/XMLSchema";
xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0"
xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0"
xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0"
xmlns:oooc="http://openoffice.org/2004/calc";
xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0"
xmlns:ooow="http://openoffice.org/2004/writer";
xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0"
xmlns:dc="http://purl.org/dc/elements/1.1/";
xmlns:rpt="http://openoffice.org/2005/report";
xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0"
xmlns:config="urn:oasis:nam
es:tc:opendocument:xmlns:config:1.0"
xmlns:xlink="http://www.w3.org/1999/xlink";
xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0"
xmlns:ooo="http://openoffice.org/2004/office";
xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0"
xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0"
xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0"
xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0"
xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2"
xmlns:calcext="urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0"
xmlns:tableooo="http://openoffice.org/2009/table";
xmlns:drawooo="http://openoffice.org/2010/draw";
xmlns:loext="urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0"
xmlns:dom="http://www.w3.org/2001/xml-events";
xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0"
xmlns:math="http://www.w3.org/1998/Math/MathML";
xmlns:form="urn:oasis:names:tc:opendocument:xmlns:fo
rm:1.0" xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0"
xmlns:xforms="http://www.w3.org/2002/xforms"; office:version="1.3"
office:mimetype="application/vnd.oasis.opendocument.spreadsheet">
+
<office:meta><meta:creation-date>2016-05-23T19:52:21.032366237</meta:creation-date><meta:editing-duration>P0D</meta:editing-duration><meta:editing-cycles>1</meta:editing-cycles><meta:generator>LibreOfficeDev/7.4.0.0.alpha0$Linux_X86_64
LibreOffice_project/207d202ed2f1f44e5b62157b5a92ee5e8cc2c3e5</meta:generator><meta:document-statistic
meta:table-count="2" meta:cell-count="706"
meta:object-count="0"/></office:meta>
<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:paragraph-properties style:tab-stop-distance="12.7mm"/>
+ <style:text-properties style:font-name="Liberation Sans"
fo:font-size="10pt" fo:language="en" fo:country="US"
style:font-name-asian="DejaVu Sans" style:font-size-asian="10pt"
style:language-asian="zh" style:country-asian="CN"
style:font-name-complex="DejaVu Sans" style:font-size-complex="10pt"
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:number number:decimal-places="2" number: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:number number:decimal-places="2" number: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:number-style style:name="N187">
+ <number:number number:decimal-places="9" number:min-decimal-places="9"
number:min-integer-digits="1"/>
+ </number:number-style>
+ <number:currency-style style:name="N185P0" 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:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
</number:currency-style>
- <number:currency-style style:name="N124">
+ <number:currency-style style:name="N185">
<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:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N185P0"/>
</number:currency-style>
- <number:currency-style style:name="N126P0" style:volatile="true">
+ <number:currency-style style:name="N182P0" 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:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
</number:currency-style>
- <number:currency-style style:name="N126">
+ <number:currency-style style:name="N182">
<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:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N182P0"/>
</number:currency-style>
- <number:currency-style style:name="N127">
- <style:text-properties fo:color="#ff0000"/>
+ <number:number-style style:name="N180">
+ <number:number number:decimal-places="14" number:min-decimal-places="14"
number:min-integer-digits="1"/>
+ </number:number-style>
+ <number:number-style style:name="N179P0" style:volatile="true">
+ <number:text>$</number:text>
+ <number:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N179">
+ <number:text>($</number:text>
+ <number:number number:decimal-places="2" number: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="N179P0"/>
+ </number:number-style>
+ <number:time-style style:name="N177" 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:number-style style:name="N176P0" style:volatile="true">
+ <number:text> \</number:text>
+ <number:fill-character> </number:fill-character>
+ <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N176P1" style:volatile="true">
+ <number:text> \</number:text>
+ <number:fill-character> </number:fill-character>
<number:text>-</number:text>
+ <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N176P2" style:volatile="true">
+ <number:text> \</number:text>
+ <number:fill-character> </number:fill-character>
+ <number:text>- </number:text>
+ </number:number-style>
+ <number:text-style style:name="N176">
+ <number:text> </number:text>
+ <number:text-content/>
+ <number:text> </number:text>
+ <style:map style:condition="value()>0" style:apply-style-name="N176P0"/>
+ <style:map style:condition="value()<0" style:apply-style-name="N176P1"/>
+ <style:map style:condition="value()=0" style:apply-style-name="N176P2"/>
+ </number:text-style>
+ <number:number-style style:name="N172P0" style:volatile="true">
+ <number:text>\</number:text>
+ <number:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ </number:number-style>
+ <number:number-style style:name="N172">
+ <number:text>\-</number:text>
+ <number:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N172P0"/>
+ </number:number-style>
+ <number:currency-style style:name="N133P0" 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"/>
- <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:number number:decimal-places="2" number:min-decimal-places="0"
number:min-integer-digits="1" number:decimal-replacement="--"
number:grouping="true"/>
</number:currency-style>
- <number:currency-style style:name="N128">
+ <number:currency-style style:name="N133">
<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:number number:decimal-places="2" number: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="N133P0"/>
</number:currency-style>
- <number:currency-style style:name="N130">
- <style:text-properties fo:color="#ff0000"/>
+ <number:number-style style:name="N162P0" style:volatile="true">
+ <number:text> </number:text>
+ <number:fill-character> </number:fill-character>
+ <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
+ </number:number-style>
+ <number:number-style style:name="N162P1" style:volatile="true">
+ <number:text> </number:text>
+ <number:fill-character> </number:fill-character>
<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:number number:decimal-places="0" number: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 style:name="N162P2" style:volatile="true">
+ <number:text> </number:text>
+ <number:fill-character> </number:fill-character>
+ <number:text>- </number:text>
+ </number:number-style>
+ <number:text-style style:name="N162">
+ <number:text> </number:text>
+ <number:text-content/>
+ <number:text> </number:text>
+ <style:map style:condition="value()>0" style:apply-style-name="N162P0"/>
+ <style:map style:condition="value()<0" style:apply-style-name="N162P1"/>
+ <style:map style:condition="value()=0" style:apply-style-name="N162P2"/>
+ </number:text-style>
+ <number:number-style style:name="N131">
+ <number:number number:decimal-places="10" number:min-decimal-places="10"
number:min-integer-digits="1"/>
+ </number:number-style>
+ <number:number-style style:name="N130">
+ <number:scientific-number number:decimal-places="1"
number:min-decimal-places="1" number:min-integer-digits="1"
number:min-exponent-digits="1" number:exponent-interval="3"
number:forced-exponent-sign="true"/>
</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:number-style style:name="N142P0" style:volatile="true">
+ <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
<number:text> </number:text>
</number:number-style>
- <number:number-style style:name="N134">
+ <number:number-style style:name="N142">
<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 number:decimal-places="0" number: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="N134P0"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N142P0"/>
</number:number-style>
- <number:currency-style style:name="N136P0" style:volatile="true">
+ <number:currency-style style:name="N171P0" style:volatile="true">
+ <number:number number:decimal-places="2" number: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="N171">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>-</number:text>
+ <number:number number:decimal-places="2" number: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="N171P0"/>
+ </number:currency-style>
+ <number:currency-style style:name="N129P0" 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:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
</number:currency-style>
- <number:currency-style style:name="N136">
+ <number:currency-style style:name="N129">
+ <style:text-properties fo:color="#ff0000"/>
<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:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N129P0"/>
</number:currency-style>
- <number:currency-style style:name="N138P0" style:volatile="true">
+ <number:currency-style style:name="N158P0" 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:fill-character> </number:fill-character>
+ <number:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
</number:currency-style>
- <number:currency-style style:name="N138">
+ <number:currency-style style:name="N158">
<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:fill-character> </number:fill-character>
+ <number:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N158P0"/>
</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 style:name="N140P0" style:volatile="true">
+ <number:text>$</number:text>
+ <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
</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:text>($</number:text>
+ <number:number number:decimal-places="0" number: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="N140P0"/>
</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 style:name="N169">
+ <number:number number:decimal-places="8" number:min-decimal-places="8"
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 style:name="N186">
+ <number:number number:decimal-places="15" number: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 style:name="N127P0" style:volatile="true">
+ <number:text>\</number:text>
+ <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
</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 style:name="N127">
+ <number:text>\-</number:text>
+ <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N127P0"/>
</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 style:name="N156P0" style:volatile="true">
+ <number:text>\</number:text>
+ <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
</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">
+ <number:number-style style:name="N156">
<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:text>\-</number:text>
+ <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N156P0"/>
+ </number:number-style>
+ <number:time-style style:name="N138">
+ <number:minutes number:style="long"/>
+ <number:text>:</number:text>
+ <number:seconds number:style="long"/>
+ </number:time-style>
+ <number:currency-style style:name="N167P0" 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:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
</number:currency-style>
- <number:currency-style style:name="N153">
+ <number:currency-style style:name="N167">
<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:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N167P0"/>
</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 style:name="N184P0" style:volatile="true">
+ <number:currency-symbol number:language="en"
number:country="GB">£</number:currency-symbol>
+ <number:fill-character> </number:fill-character>
+ <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
</number:currency-style>
- <number:currency-style style:name="N155">
- <style:text-properties fo:color="#ff0000"/>
+ <number:currency-style style:name="N184">
<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-symbol number:language="en"
number:country="GB">£</number:currency-symbol>
+ <number:fill-character> </number:fill-character>
+ <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N184P0"/>
</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:time-style style:name="N125">
+ <number:minutes number:style="long"/>
+ <number:text>:</number:text>
+ <number:seconds number:style="long"/>
+ <number:text>.</number:text>
+ </number:time-style>
+ <number:number-style style:name="N154P0" style:volatile="true">
+ <number:text> \</number:text>
+ <number:fill-character> </number:fill-character>
+ <number:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
</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 style:name="N154P1" style:volatile="true">
+ <number:text> \</number:text>
+ <number:fill-character> </number:fill-character>
+ <number:text>-</number:text>
+ <number:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
</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 style:name="N154P2" style:volatile="true">
+ <number:text> \</number:text>
+ <number:fill-character> </number:fill-character>
+ <number:text>-</number:text>
+ <number:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="0"/>
+ <number:text> </number:text>
</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:text-style style:name="N154">
+ <number:text> </number:text>
+ <number:text-content/>
+ <number:text> </number:text>
+ <style:map style:condition="value()>0" style:apply-style-name="N154P0"/>
+ <style:map style:condition="value()<0" style:apply-style-name="N154P1"/>
+ <style:map style:condition="value()=0" style:apply-style-name="N154P2"/>
+ </number:text-style>
+ <number:number-style style:name="N137P0" style:volatile="true">
+ <number:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <number:text> </number:text>
</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 style:name="N137">
+ <number:text>(</number:text>
+ <number:number number:decimal-places="2" number: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="N137P0"/>
</number:number-style>
- <number:number-style style:name="N161P0" style:volatile="true">
+ <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" number:min-decimal-places="0"
number:min-integer-digits="1" number:grouping="true"/>
+ </number:currency-style>
+ <number:currency-style style:name="N124">
+ <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" number: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:number-style style:name="N135P0" 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 number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
</number:number-style>
- <number:number-style style:name="N161">
+ <number:number-style style:name="N135">
<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 number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N135P0"/>
</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 style:name="N164">
+ <number:number number:decimal-places="17" number:min-decimal-places="17"
number:min-integer-digits="1"/>
</number:number-style>
- <number:number-style style:name="N164P0" style:volatile="true">
+ <number:number-style style:name="N181P0" 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 number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
<number:text> </number:text>
</number:number-style>
- <number:number-style style:name="N164">
+ <number:number-style style:name="N181">
<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:number number:decimal-places="2" number: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="N164P0"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N181P0"/>
</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:currency-style style:name="N144P0" style:volatile="true">
+ <number:currency-symbol number:language="en"
number:country="IE">€</number:currency-symbol>
+ <number:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ </number:currency-style>
+ <number:currency-style style:name="N144">
+ <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" number:min-decimal-places="2"
number:min-integer-digits="1" number:grouping="true"/>
+ <style:map style:condition="value()>=0" style:apply-style-name="N144P0"/>
+ </number:currency-style>
+ <number:number-style style:name="N148P0" style:volatile="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:fill-character> </number:fill-character>
+ <number:number number:decimal-places="2" number: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:number-style style:name="N148P1" style:volatile="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:fill-character> </number: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:number number:decimal-places="2" number:min-decimal-places="2"
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:number-style style:name="N148P2" style:volatile="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:fill-character> </number: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:number number:decimal-places="0" number:min-decimal-places="0"
number:min-integer-digits="0"/>
<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-style style:name="N148">
<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"/>
+ <style:map style:condition="value()>0" style:apply-style-name="N148P0"/>
+ <style:map style:condition="value()<0" style:apply-style-name="N148P1"/>
+ <style:map style:condition="value()=0" style:apply-style-name="N148P2"/>
</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 style:name="N149">
+ <number:number number:decimal-places="11" number:min-decimal-places="11"
number:min-integer-digits="1"/>
</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 style:name="N150">
+ <number:number number:decimal-places="12" number:min-decimal-places="12"
number:min-integer-digits="1"/>
</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 style:name="N155">
+ <number:number number:decimal-places="13" number:min-decimal-places="13"
number:min-integer-digits="1"/>
</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 style:name="N163">
+ <number:number number:decimal-places="16" number:min-decimal-places="16"
number:min-integer-digits="1"/>
</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:number-style style:name="N165P0" style:volatile="true">
+ <number:text>$</number:text>
+ <number:number number:decimal-places="0" number:min-decimal-places="0"
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 style:name="N165">
+ <style:text-properties fo:color="#ff0000"/>
+ <number:text>($</number:text>
+ <number:number number:decimal-places="0" number: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="N165P0"/>
</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 style:name="N168">
+ <number:number number:decimal-places="18" number:min-decimal-places="18"
number:min-integer-digits="1"/>
</number:number-style>
- <number:date-style style:name="N10121" number:language="en"
number:country="US">
+ <number:date-style style:name="N10139" 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:date-style style:name="N10138" 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:date-style style:name="N10137" 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:date-style style:name="N10136" 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:time-style style:name="N10135" 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:time-style style:name="N10134" number:language="en"
number:country="US">
<number:hours/>
<number:text>:</number:text>
<number:minutes number:style="long"/>
@@ -441,19 +443,19 @@
<number:text> </number:text>
<number:am-pm/>
</number:time-style>
- <number:time-style style:name="N10127" number:language="en"
number:country="US">
+ <number:time-style style:name="N10133" 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:time-style style:name="N10132" 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:date-style style:name="N10131" number:language="en"
number:country="US">
<number:month/>
<number:text>/</number:text>
<number:day/>
@@ -464,93 +466,141 @@
<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:number-style style:name="N10130P0" style:volatile="true"
number:language="en" number:country="US">
+ <number:number number:decimal-places="0" number: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">
+ <number:number-style style:name="N10130" 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:number number:decimal-places="0" number: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"/>
+ <style:map style:condition="value()>=0"
style:apply-style-name="N10130P0"/>
</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:number-style style:name="N10128P0" style:volatile="true"
number:language="en" number:country="US">
+ <number:number number:decimal-places="2" number: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">
+ <number:number-style style:name="N10128" 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:number number:decimal-places="2" number: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"/>
+ <style:map style:condition="value()>=0"
style:apply-style-name="N10128P0"/>
</number:number-style>
- <number:currency-style style:name="N10135P0" style:volatile="true"
number:language="en" number:country="US">
+ <number:currency-style style:name="N10126P0" 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:number number:decimal-places="0" number: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:currency-style style:name="N10126" 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:number number:decimal-places="0" number: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"/>
+ <style:map style:condition="value()>=0"
style:apply-style-name="N10126P0"/>
</number:currency-style>
- <number:currency-style style:name="N10136P0" style:volatile="true"
number:language="en" number:country="US">
+ <number:currency-style style:name="N10125P0" 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:number number:decimal-places="0" number: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">
+ <number:currency-style style:name="N10125" 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:number number:decimal-places="0" number: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"/>
+ <style:map style:condition="value()>=0"
style:apply-style-name="N10125P0"/>
</number:currency-style>
- <number:currency-style style:name="N10138P0" style:volatile="true"
number:language="en" number:country="US">
+ <number:currency-style style:name="N10123P0" 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:number number:decimal-places="2" number: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:currency-style style:name="N10123" 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:number number:decimal-places="2" number: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"/>
+ <style:map style:condition="value()>=0"
style:apply-style-name="N10123P0"/>
</number:currency-style>
- <number:currency-style style:name="N10139P0" style:volatile="true"
number:language="en" number:country="US">
+ <number:currency-style style:name="N10122P0" 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:number number:decimal-places="2" number: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">
+ <number:currency-style style:name="N10122" 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:number number:decimal-places="2" number: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"/>
+ <style:map style:condition="value()>=0"
style:apply-style-name="N10122P0"/>
</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:style style:name="Heading_20_1" style:display-name="Heading 1"
style:family="table-cell" style:parent-style-name="Heading">
<style:table-cell-properties style:rotation-angle="90"/>
</style:style>
+ <style:style style:name="Heading_20_2" style:display-name="Heading 2"
style:family="table-cell" style:parent-style-name="Heading">
+ <style:text-properties fo:color="#000000" fo:font-size="12pt"
fo:font-style="normal" fo:font-weight="normal"/>
+ </style:style>
+ <style:style style:name="Text" style:family="table-cell"
style:parent-style-name="Default"/>
+ <style:style style:name="Note" style:family="table-cell"
style:parent-style-name="Text">
+ <style:table-cell-properties fo:background-color="#ffffcc"
style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border="0.74pt solid
#808080"/>
+ <style:text-properties fo:color="#333333" fo:font-size="10pt"
fo:font-style="normal" fo:font-weight="normal"/>
+ </style:style>
+ <style:style style:name="Footnote" style:family="table-cell"
style:parent-style-name="Text">
+ <style:text-properties fo:color="#808080" fo:font-size="10pt"
fo:font-style="italic" fo:font-weight="normal"/>
+ </style:style>
+ <style:style style:name="Hyperlink" style:family="table-cell"
style:parent-style-name="Text">
+ <style:text-properties fo:color="#0000ee" fo:font-size="10pt"
fo:font-style="normal" style:text-underline-style="solid"
style:text-underline-width="auto" style:text-underline-color="#0000ee"
fo:font-weight="normal"/>
+ </style:style>
+ <style:style style:name="Status" style:family="table-cell"
style:parent-style-name="Default"/>
+ <style:style style:name="Good" style:family="table-cell"
style:parent-style-name="Status">
+ <style:table-cell-properties fo:background-color="#ccffcc"/>
+ <style:text-properties fo:color="#006600" fo:font-size="10pt"
fo:font-style="normal" fo:font-weight="normal"/>
+ </style:style>
+ <style:style style:name="Neutral" style:family="table-cell"
style:parent-style-name="Status">
+ <style:table-cell-properties fo:background-color="#ffffcc"/>
+ <style:text-properties fo:color="#996600" fo:font-size="10pt"
fo:font-style="normal" fo:font-weight="normal"/>
+ </style:style>
+ <style:style style:name="Bad" style:family="table-cell"
style:parent-style-name="Status">
+ <style:table-cell-properties fo:background-color="#ffcccc"/>
+ <style:text-properties fo:color="#cc0000" fo:font-size="10pt"
fo:font-style="normal" fo:font-weight="normal"/>
+ </style:style>
+ <style:style style:name="Warning" style:family="table-cell"
style:parent-style-name="Status">
+ <style:text-properties fo:color="#cc0000" fo:font-size="10pt"
fo:font-style="normal" fo:font-weight="normal"/>
+ </style:style>
+ <style:style style:name="Error" style:family="table-cell"
style:parent-style-name="Status">
+ <style:table-cell-properties fo:background-color="#cc0000"/>
+ <style:text-properties fo:color="#ffffff" fo:font-size="10pt"
fo:font-style="normal" fo:font-weight="bold"/>
+ </style:style>
+ <style:style style:name="Accent" style:family="table-cell"
style:parent-style-name="Default">
+ <style:text-properties fo:color="#000000" fo:font-size="10pt"
fo:font-style="normal" fo:font-weight="bold"/>
+ </style:style>
+ <style:style style:name="Accent_20_1" style:display-name="Accent 1"
style:family="table-cell" style:parent-style-name="Accent">
+ <style:table-cell-properties fo:background-color="#000000"/>
+ <style:text-properties fo:color="#ffffff" fo:font-size="10pt"
fo:font-style="normal" fo:font-weight="normal"/>
+ </style:style>
+ <style:style style:name="Accent_20_2" style:display-name="Accent 2"
style:family="table-cell" style:parent-style-name="Accent">
+ <style:table-cell-properties fo:background-color="#808080"/>
+ <style:text-properties fo:color="#ffffff" fo:font-size="10pt"
fo:font-style="normal" fo:font-weight="normal"/>
+ </style:style>
+ <style:style style:name="Accent_20_3" style:display-name="Accent 3"
style:family="table-cell" style:parent-style-name="Accent">
+ <style:table-cell-properties fo:background-color="#dddddd"/>
+ </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="Untitled1" style:family="table-cell"
style:parent-style-name="Default">
<style:table-cell-properties fo:background-color="#ff3333"/>
</style:style>
@@ -560,114 +610,121 @@
</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:table-column-properties fo:break-before="auto"
style:column-width="65.51mm"/>
</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:table-column-properties fo:break-before="auto"
style:column-width="89.08mm"/>
</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:table-column-properties fo:break-before="auto"
style:column-width="22.58mm"/>
</style:style>
<style:style style:name="co4" style:family="table-column">
- <style:table-column-properties fo:break-before="auto"
style:column-width="99.35pt"/>
+ <style:table-column-properties fo:break-before="auto"
style:column-width="23.78mm"/>
</style:style>
<style:style style:name="co5" style:family="table-column">
- <style:table-column-properties fo:break-before="auto"
style:column-width="107.09pt"/>
+ <style:table-column-properties fo:break-before="auto"
style:column-width="15.77mm"/>
</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:table-column-properties fo:break-before="auto"
style:column-width="43.25mm"/>
</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:table-column-properties fo:break-before="auto"
style:column-width="21.52mm"/>
</style:style>
<style:style style:name="co8" style:family="table-column">
- <style:table-column-properties fo:break-before="auto"
style:column-width="16.44pt"/>
+ <style:table-column-properties fo:break-before="auto"
style:column-width="18.26mm"/>
</style:style>
<style:style style:name="co9" style:family="table-column">
- <style:table-column-properties fo:break-before="auto"
style:column-width="47.85pt"/>
+ <style:table-column-properties fo:break-before="auto"
style:column-width="50.29mm"/>
</style:style>
<style:style style:name="co10" style:family="table-column">
- <style:table-column-properties fo:break-before="auto"
style:column-width="115.74pt"/>
+ <style:table-column-properties fo:break-before="auto"
style:column-width="5.75mm"/>
</style:style>
<style:style style:name="co11" style:family="table-column">
- <style:table-column-properties fo:break-before="auto"
style:column-width="38.44pt"/>
+ <style:table-column-properties fo:break-before="auto"
style:column-width="9.35mm"/>
+ </style:style>
+ <style:style style:name="co12" style:family="table-column">
+ <style:table-column-properties fo:break-before="auto"
style:column-width="9.03mm"/>
+ </style:style>
+ <style:style style:name="co13" style:family="table-column">
+ <style:table-column-properties fo:break-before="auto"
style:column-width="21.85mm"/>
</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:table-row-properties style:row-height="8.63mm"
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:table-row-properties style:row-height="4.52mm"
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:table-row-properties style:row-height="6.12mm"
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:table-row-properties style:row-height="5.29mm"
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:table-row-properties style:row-height="4.73mm"
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="23.84pt"
fo:break-before="auto" style:use-optimal-row-height="true"/>
+ <style:table-row-properties style:row-height="5.17mm"
fo:break-before="auto" style:use-optimal-row-height="true"/>
+ </style:style>
+ <style:style style:name="ro7" style:family="table-row">
+ <style:table-row-properties style:row-height="8.82mm"
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:number-style style:name="N2">
+ <number:number number:decimal-places="2" number:min-decimal-places="2"
number:min-integer-digits="1"/>
+ </number:number-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="ce1" style:family="table-cell"
style:parent-style-name="Default"/>
- <style:style style:name="ce2" style:family="table-cell"
style:parent-style-name="Default">
+ <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="start" fo:margin-left="0pt"/>
+ <style:paragraph-properties fo:text-align="start" fo:margin-left="0mm"/>
<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="ce3" style:family="table-cell"
style:parent-style-name="Default">
+ <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="center" fo:margin-left="0pt"/>
+ <style:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/>
<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="ce4" style:family="table-cell"
style:parent-style-name="Default">
+ <style:style style:name="ce17" 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:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/>
<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="ce5" style:family="table-cell"
style:parent-style-name="Default">
+ <style:style style:name="ce18" 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:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/>
</style:style>
- <style:style style:name="ce6" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N99">
+ <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:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/>
<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="ce7" 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="ce8" style:family="table-cell"
style:parent-style-name="Default">
+ <style:style style:name="ce20" 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:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/>
+ <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="ce9" 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:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/>
<style:text-properties fo:font-weight="bold" style:font-weight-asian="bold"
style:font-weight-complex="bold"/>
</style:style>
- <style:style style:name="ce10" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N99">
+ <style:style style:name="ce24" style:family="table-cell"
style:parent-style-name="Default">
+ <style:text-properties fo:font-weight="normal"
style:font-weight-asian="normal" style:font-weight-complex="normal"/>
+ </style:style>
+ <style:style style:name="ce22" 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:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/>
<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"/>
@@ -675,12 +732,6 @@
<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="ce12" 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="ce13" style:family="table-cell"
style:parent-style-name="Default">
- <style:table-cell-properties fo:padding="2.01pt"/>
- </style:style>
<style:style style:name="ce14" style:family="table-cell"
style:parent-style-name="Default">
<style:text-properties fo:font-weight="bold" style:font-weight-asian="bold"
style:font-weight-complex="bold"/>
</style:style>
@@ -692,27 +743,36 @@
<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="ta_extref" style:family="table">
- <style:table-properties table:display="false"/>
+ <style:style style:name="ce28" style:family="table-cell"
style:parent-style-name="Default">
+ <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="ce12" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N100">
+ <style:table-cell-properties fo:padding="0.71mm"/>
+ </style:style>
+ <style:style style:name="ce36" style:family="table-cell"
style:parent-style-name="Default" style:data-style-name="N99"/>
+ <style:style style:name="ce13" style:family="table-cell"
style:parent-style-name="Default">
+ <style:table-cell-properties fo:padding="0.71mm"/>
</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-footer-properties fo:min-height="7.5mm" fo:margin-left="0mm"
fo:margin-right="0mm" fo:margin-bottom="2.5mm"/>
</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:header-footer-properties fo:min-height="7.5mm" fo:margin-left="0mm"
fo:margin-right="0mm" fo:margin-top="2.5mm"/>
</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:header-footer-properties fo:min-height="7.5mm" fo:margin-left="0mm"
fo:margin-right="0mm" fo:margin-bottom="2.5mm" fo:border="2.49pt solid #000000"
fo:padding="0.18mm" fo:background-color="#c0c0c0">
<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:header-footer-properties fo:min-height="7.5mm" fo:margin-left="0mm"
fo:margin-right="0mm" fo:margin-top="2.5mm" fo:border="2.49pt solid #000000"
fo:padding="0.18mm" fo:background-color="#c0c0c0">
<style:background-image/>
</style:header-footer-properties>
</style:footer-style>
@@ -724,36 +784,41 @@
<text:p><text:sheet-name>???</text:sheet-name></text:p>
</style:header>
<style:header-left style:display="false"/>
+ <style:header-first 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:footer-first 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>
+
<text:p><text:sheet-name>???</text:sheet-name><text:s/>(<text:title>???</text:title>)</text:p>
</style:region-left>
<style:region-right>
- <text:p><text:date style:data-style-name="N2"
text:date-value="2016-09-24">00/00/0000</text:date>, <text:time
style:data-style-name="N2"
text:time-value="22:07:00.432642201">00:00:00</text:time></text:p>
+ <text:p><text:date style:data-style-name="N2"
text:date-value="2022-01-10">00/00/0000</text:date>, <text:time
style:data-style-name="N2"
text:time-value="16:10:48.094475696">00:00:00</text:time></text:p>
</style:region-right>
</style:header>
<style:header-left style:display="false"/>
+ <style:header-first style:display="false"/>
<style:footer>
- <text:p>Page <text:page-number>1</text:page-number> /
<text:page-count>99</text:page-count></text:p>
+ <text:p>Page <text:page-number>1</text:page-number><text:s/>/
<text:page-count>99</text:page-count></text:p>
</style:footer>
<style:footer-left style:display="false"/>
+ <style:footer-first 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">
+ <office:forms form:automatic-focus="false" form:apply-design-mode="false"/>
<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="ce5"/>
+ <table:table-column table:style-name="co1"
table:default-cell-style-name="ce18"/>
<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="ce2" office:value-type="string"
calcext:value-type="string">
+ <table:table-cell table:style-name="ce8" office:value-type="string"
calcext:value-type="string">
<text:p>CLEAN Function</text:p>
</table:table-cell>
<table:table-cell table:number-columns-repeated="2"/>
@@ -762,10 +827,10 @@
<table:table-cell table:number-columns-repeated="3"/>
</table:table-row>
<table:table-row table:style-name="ro3">
- <table:table-cell table:style-name="ce3" office:value-type="string"
calcext:value-type="string">
+ <table:table-cell table:style-name="ce10" office:value-type="string"
calcext:value-type="string">
<text:p>Result</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce6"
table:formula="of:=AND([.B8:.B95])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce19"
table:formula="of:=AND([.B8:.B94])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
<text:p>TRUE</text:p>
</table:table-cell>
<table:table-cell/>
@@ -774,45 +839,40 @@
<table:table-cell table:number-columns-repeated="3"/>
</table:table-row>
<table:table-row table:style-name="ro4">
- <table:table-cell table:style-name="ce4" office:value-type="string"
calcext:value-type="string">
+ <table:table-cell table:style-name="ce17" office:value-type="string"
calcext:value-type="string">
<text:p>Sheet</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce4" office:value-type="string"
calcext:value-type="string">
+ <table:table-cell table:style-name="ce17" office:value-type="string"
calcext:value-type="string">
<text:p>Result</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce4" office:value-type="string"
calcext:value-type="string">
+ <table:table-cell table:style-name="ce17" 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-row table:style-name="ro5">
<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="ce7"
table:formula="of:=AND([Sheet2.C2:.C100])" office:value-type="boolean"
office:boolean-value="true" calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce19"
table:formula="of:=AND([Sheet2.C2:.C165])" 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 CLEAN 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-row table:style-name="ro2" table:number-rows-repeated="29">
<table:table-cell/>
- <table:table-cell table:style-name="ce8"/>
+ <table:table-cell table:style-name="ce20"/>
<table:table-cell/>
</table:table-row>
- <table:table-row table:style-name="ro2"
table:number-rows-repeated="1048537">
+ <table:table-row table:style-name="ro2"
table:number-rows-repeated="1048538">
<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:conditional-format
calcext:target-range-address="Sheet1.B8:Sheet1.B37 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"/>
@@ -820,17 +880,23 @@
</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="ce5"/>
- <table:table-column table:style-name="co7"
table:default-cell-style-name="Default"/>
+ <office:forms form:automatic-focus="false" form:apply-design-mode="false"/>
+ <table:table-column table:style-name="co4"
table:number-columns-repeated="2" table:default-cell-style-name="Default"/>
+ <table:table-column table:style-name="co5"
table:default-cell-style-name="ce18"/>
<table:table-column table:style-name="co6"
table:default-cell-style-name="Default"/>
- <table:table-column table:style-name="co8"
table:number-columns-repeated="3" table:default-cell-style-name="Default"/>
+ <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="co4"
table:number-columns-repeated="2" 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="co9"
table:default-cell-style-name="Default"/>
- <table:table-column table:style-name="co3"
table:number-columns-repeated="3" table:default-cell-style-name="Default"/>
+ <table:table-column table:style-name="co7"
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="co11"
table:number-columns-repeated="6" table:default-cell-style-name="Default"/>
- <table:table-row table:style-name="ro5">
+ <table:table-column table:style-name="co11"
table:default-cell-style-name="Default"/>
+ <table:table-column table:style-name="co12"
table:default-cell-style-name="Default"/>
+ <table:table-column table:style-name="co13"
table:default-cell-style-name="Default"/>
+ <table:table-column table:style-name="co4"
table:default-cell-style-name="Default"/>
+ <table:table-column table:style-name="co3"
table:default-cell-style-name="Default"/>
+ <table:table-row table:style-name="ro6">
<table:table-cell table:style-name="ce9" office:value-type="string"
calcext:value-type="string">
<text:p>Function</text:p>
</table:table-cell>
@@ -846,1111 +912,2669 @@
<table:table-cell table:style-name="ce9" 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="ce9"/>
+ <table:table-cell table:style-name="ce14" office:value-type="string"
calcext:value-type="string">
+ <text:p>hex</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce15" office:value-type="string"
calcext:value-type="string">
+ <text:p>dec</text:p>
+ </table:table-cell>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>UNICHAR()</text:p>
+ </table:table-cell>
<table:table-cell table:style-name="ce12"/>
- <table:table-cell/>
- <table:table-cell table:style-name="ce15"/>
<table:table-cell office:value-type="string" calcext:value-type="string">
- <text:p>CHAR()</text:p>
+ <text:p>Note</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce12"/>
- <table:table-cell table:number-columns-repeated="6"/>
+ <table:table-cell table:style-name="ce14"/>
+ <table:table-cell table:style-name="ce15"/>
+ <table:table-cell/>
+ <table:table-cell table:style-name="ce12"/>
+ <table:table-cell/>
</table:table-row>
- <table:table-row table:style-name="ro5">
- <table:table-cell table:formula="of:=CLEAN([.M2])"
office:value-type="string" office:string-value="Test text"
calcext:value-type="string">
+ <table:table-row table:style-name="ro6">
+ <table:table-cell table:formula="of:=CLEAN([.J2])"
office:value-type="string" office:string-value="Test text"
calcext:value-type="string">
<text:p>Test text</text:p>
</table:table-cell>
- <table:table-cell office:value-type="string" calcext:value-type="string">
+ <table:table-cell table:formula="of:=IF([.E2]="no clean";
[.$J2];"Test text")" office:value-type="string"
office:string-value="Test text" calcext:value-type="string">
<text:p>Test text</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce10" table:formula="of:=[.A2]=[.B2]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce22" 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="=CLEAN(M2)" calcext:value-type="string">
- <text:p>=CLEAN(M2)</text:p>
+ <table:table-cell table:style-name="ce11"
table:formula="of:=FORMULA([.A2])" office:value-type="string"
office:string-value="=CLEAN(J2)" calcext:value-type="string">
+ <text:p>=CLEAN(J2)</text:p>
+ </table:table-cell>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>Unicode Cc</text:p>
</table:table-cell>
- <table:table-cell table:number-columns-repeated="4"/>
- <table:table-cell table:style-name="ce12"/>
<table:table-cell/>
+ <table:table-cell table:formula="of:=DEC2HEX([.H2])"
office:value-type="string" office:string-value="0" calcext:value-type="string">
+ <text:p>0</text:p>
+ </table:table-cell>
<table:table-cell table:style-name="ce16" office:value-type="float"
office:value="0" calcext:value-type="float">
<text:p>0</text:p>
</table:table-cell>
- <table:table-cell table:formula="of:=CHAR([.K2])"
office:value-type="string" office:string-value="" calcext:value-type="string">
+ <table:table-cell table:style-name="ce28"
table:formula="of:=UNICHAR([.H2])" office:value-type="string"
office:string-value="" calcext:value-type="string">
<text:p/>
</table:table-cell>
- <table:table-cell table:formula="of:=[.L2] & "Test text"
& [.L2]" office:value-type="string" office:string-value="Test text"
calcext:value-type="string">
+ <table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>Test text</text:p>
</table:table-cell>
- <table:table-cell table:number-columns-repeated="6"/>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>hard coded so the file can be used in Excel as well</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce12"/>
+ <table:table-cell/>
+ <table:table-cell table:style-name="ce16"/>
+ <table:table-cell table:number-columns-repeated="3"/>
</table:table-row>
- <table:table-row table:style-name="ro2">
- <table:table-cell table:formula="of:=CLEAN([.M3])"
office:value-type="string" office:string-value="Test text"
calcext:value-type="string">
+ <table:table-row table:style-name="ro5">
+ <table:table-cell table:formula="of:=CLEAN([.J3])"
office:value-type="string" office:string-value="Test text"
calcext:value-type="string">
<text:p>Test text</text:p>
</table:table-cell>
- <table:table-cell office:value-type="string" calcext:value-type="string">
+ <table:table-cell table:formula="of:=IF([.E3]="no clean";
[.$J3];"Test text")" office:value-type="string"
office:string-value="Test text" calcext:value-type="string">
<text:p>Test text</text:p>
</table:table-cell>
- <table:table-cell table:style-name="ce10" table:formula="of:=[.A3]=[.B3]"
office:value-type="boolean" office:boolean-value="true"
calcext:value-type="boolean">
+ <table:table-cell table:style-name="ce22" 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="=CLEAN(M3)" calcext:value-type="string">
... etc. - the rest is truncated
