diff options
author | Winfried Donkers <winfrieddonkers@libreoffice.org> | 2016-09-28 16:34:36 +0200 |
---|---|---|
committer | Eike Rathke <erack@redhat.com> | 2016-10-13 19:46:43 +0000 |
commit | d8257535e348fa0b0a5c269d1aafa710585421d6 (patch) | |
tree | 7048bde85839461055a419db0c2bf5f1356f6c5c | |
parent | 1c9096dad7dc2ee25d9ebe16ab02d5caba5f8a79 (diff) |
tdf#102742 fix wrong results for MOD function
ScInterpreter::ScMod has been largely rewritten and
a constraint check has been added (numerator != 0).
It appears that integer values of arguments cannot accurately
determined nor converterd accurately to int values, so no simpler
(faster) treatment for integer values.
Updated test document.
Change-Id: I3af60d93019b212ce7c03eea48b509bfbc713cf7
Reviewed-on: https://gerrit.libreoffice.org/29365
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Eike Rathke <erack@redhat.com>
-rw-r--r-- | sc/qa/unit/data/functions/fods/mod.fods | 1702 | ||||
-rw-r--r-- | sc/source/core/tool/interpr2.cxx | 23 |
2 files changed, 1169 insertions, 556 deletions
diff --git a/sc/qa/unit/data/functions/fods/mod.fods b/sc/qa/unit/data/functions/fods/mod.fods index 48ab478ce023..7a3bc65d806e 100644 --- a/sc/qa/unit/data/functions/fods/mod.fods +++ b/sc/qa/unit/data/functions/fods/mod.fods @@ -1,13 +1,13 @@ <?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:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:config="urn:oasis:names:tc:opendocument:xmlns:config:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:rpt="http://openoffice.org/2005/report" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:grddl="http://www.w3.org/2003/g/data-view#" xmlns:tableooo="http://openoffice.org/2009/table" xmlns:drawooo="http://openoffice.org/2010/draw" xmlns:calcext="urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0" xmlns:loext="urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0" xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0" xmlns:formx="urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0" xmlns:css3t="http://www.w3.org/TR/css3-text/" office:version="1.2" office:mimetype="application/vnd.oasis.opendocument.spreadsheet"> - <office:meta><meta:creation-date>2016-06-25T07:16:38.437590147</meta:creation-date><meta:editing-duration>P0D</meta:editing-duration><meta:editing-cycles>1</meta:editing-cycles><meta:generator>LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/a2c557d80ac68c06ea59586245a7431e061938f0</meta:generator><meta:document-statistic meta:table-count="3" meta:cell-count="292" meta:object-count="0"/></office:meta> + <office:meta><meta:creation-date>2016-06-25T07:16:38.437590147</meta:creation-date><meta:editing-duration>P0D</meta:editing-duration><meta:editing-cycles>1</meta:editing-cycles><meta:generator>LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/66b67f40a7785f08ae214e62b669e001148b474c</meta:generator><meta:document-statistic meta:table-count="3" meta:cell-count="333" meta:object-count="0"/></office:meta> <office:settings> <config:config-item-set config:name="ooo:view-settings"> <config:config-item config:name="VisibleAreaTop" config:type="int">0</config:config-item> <config:config-item config:name="VisibleAreaLeft" config:type="int">0</config:config-item> - <config:config-item config:name="VisibleAreaWidth" config:type="int">22082</config:config-item> - <config:config-item config:name="VisibleAreaHeight" config:type="int">14449</config:config-item> + <config:config-item config:name="VisibleAreaWidth" config:type="int">22013</config:config-item> + <config:config-item config:name="VisibleAreaHeight" config:type="int">19233</config:config-item> <config:config-item-map-indexed config:name="Views"> <config:config-item-map-entry> <config:config-item config:name="ViewId" config:type="string">view1</config:config-item> @@ -31,8 +31,8 @@ <config:config-item config:name="AnchoredTextOverflowLegacy" config:type="boolean">false</config:config-item> </config:config-item-map-entry> <config:config-item-map-entry config:name="Sheet2"> - <config:config-item config:name="CursorPositionX" config:type="int">4</config:config-item> - <config:config-item config:name="CursorPositionY" config:type="int">22</config:config-item> + <config:config-item config:name="CursorPositionX" config:type="int">0</config:config-item> + <config:config-item config:name="CursorPositionY" config:type="int">37</config:config-item> <config:config-item config:name="HorizontalSplitMode" config:type="short">0</config:config-item> <config:config-item config:name="VerticalSplitMode" config:type="short">0</config:config-item> <config:config-item config:name="HorizontalSplitPosition" config:type="int">0</config:config-item> @@ -67,8 +67,8 @@ <config:config-item config:name="AnchoredTextOverflowLegacy" config:type="boolean">false</config:config-item> </config:config-item-map-entry> </config:config-item-map-named> - <config:config-item config:name="ActiveTable" config:type="string">tdf86219</config:config-item> - <config:config-item config:name="HorizontalScrollbarWidth" config:type="int">1241</config:config-item> + <config:config-item config:name="ActiveTable" config:type="string">Sheet2</config:config-item> + <config:config-item config:name="HorizontalScrollbarWidth" config:type="int">1857</config:config-item> <config:config-item config:name="ZoomType" config:type="short">0</config:config-item> <config:config-item config:name="ZoomValue" config:type="int">95</config:config-item> <config:config-item config:name="PageViewZoomValue" config:type="int">60</config:config-item> @@ -81,7 +81,7 @@ <config:config-item config:name="HasColumnRowHeaders" config:type="boolean">true</config:config-item> <config:config-item config:name="HasSheetTabs" config:type="boolean">true</config:config-item> <config:config-item config:name="IsOutlineSymbolsSet" config:type="boolean">true</config:config-item> - <config:config-item config:name="IsValueHighlightingEnabled" config:type="boolean">false</config:config-item> + <config:config-item config:name="IsValueHighlightingEnabled" config:type="boolean">true</config:config-item> <config:config-item config:name="IsSnapToRaster" config:type="boolean">false</config:config-item> <config:config-item config:name="RasterIsVisible" config:type="boolean">false</config:config-item> <config:config-item config:name="RasterResolutionX" config:type="int">1270</config:config-item> @@ -109,10 +109,12 @@ <config:config-item config:name="ShowPageBreaks" config:type="boolean">true</config:config-item> <config:config-item config:name="ShowGrid" config:type="boolean">true</config:config-item> <config:config-item config:name="ShowNotes" config:type="boolean">true</config:config-item> + <config:config-item config:name="IsOutlineSymbolsSet" config:type="boolean">true</config:config-item> + <config:config-item config:name="ShowZeroValues" config:type="boolean">true</config:config-item> <config:config-item config:name="SaveVersionOnClose" config:type="boolean">false</config:config-item> <config:config-item config:name="GridColor" config:type="long">12632256</config:config-item> <config:config-item config:name="RasterIsVisible" config:type="boolean">false</config:config-item> - <config:config-item config:name="PrinterName" config:type="string">Lexmark-E352dn</config:config-item> + <config:config-item config:name="PrinterName" config:type="string">Generic Printer</config:config-item> <config:config-item-map-indexed config:name="ForbiddenCharacters"> <config:config-item-map-entry> <config:config-item config:name="Language" config:type="string">en</config:config-item> @@ -122,14 +124,12 @@ <config:config-item config:name="EndLine" config:type="string"/> </config:config-item-map-entry> </config:config-item-map-indexed> - <config:config-item config:name="IsOutlineSymbolsSet" config:type="boolean">true</config:config-item> - <config:config-item config:name="ShowZeroValues" config:type="boolean">true</config:config-item> <config:config-item config:name="LinkUpdateMode" config:type="short">3</config:config-item> <config:config-item config:name="RasterSubdivisionX" config:type="int">1</config:config-item> <config:config-item config:name="HasColumnRowHeaders" config:type="boolean">true</config:config-item> <config:config-item config:name="RasterSubdivisionY" config:type="int">1</config:config-item> <config:config-item config:name="AutoCalculate" config:type="boolean">true</config:config-item> - <config:config-item config:name="PrinterSetup" config:type="base64Binary">qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY=</config:config-item> + <config:config-item config:name="PrinterSetup" config:type="base64Binary">kQH+/0dlbmVyaWMgUHJpbnRlcgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAU0dFTlBSVAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWAAMAsgAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9R2VuZXJpYyBQcmludGVyCm9yaWVudGF0aW9uPVBvcnRyYWl0CmNvcGllcz0xCm1hcmdpbmRhanVzdG1lbnQ9MCwwLDAsMApjb2xvcmRlcHRoPTI0CnBzbGV2ZWw9MApwZGZkZXZpY2U9MApjb2xvcmRldmljZT0wClBQRENvbnRleERhdGEKUGFnZVNpemU6QTQARHVwbGV4Ok5vbmUAABIAQ09NUEFUX0RVUExFWF9NT0RFDwBEdXBsZXhNb2RlOjpPZmY=</config:config-item> <config:config-item config:name="ApplyUserData" config:type="boolean">false</config:config-item> <config:config-item config:name="CharacterCompressionType" config:type="short">0</config:config-item> </config:config-item-set> @@ -143,7 +143,10 @@ </office:scripts> <office:font-face-decls> <style:font-face style:name="Arial1" svg:font-family="Arial"/> + <style:font-face style:name="Liberation Sans1" svg:font-family="'Liberation Sans'" style:font-adornments="Liberation Sans"/> + <style:font-face style:name="Tahoma" svg:font-family="Tahoma" style:font-adornments="Tahoma"/> <style:font-face style:name="Arial" svg:font-family="Arial" style:font-family-generic="swiss"/> + <style:font-face style:name="Liberation Sans2" svg:font-family="'Liberation Sans'" style:font-pitch="variable"/> <style:font-face style:name="Liberation Serif" svg:font-family="'Liberation Serif'" style:font-family-generic="roman" style:font-pitch="variable"/> <style:font-face style:name="DejaVu Sans" svg:font-family="'DejaVu Sans'" style:font-family-generic="swiss" style:font-pitch="variable"/> <style:font-face style:name="Liberation Sans" svg:font-family="'Liberation Sans'" style:font-family-generic="swiss" style:font-pitch="variable"/> @@ -473,7 +476,7 @@ <number:text> </number:text> </number:number-style> <number:number-style style:name="N178P2" style:volatile="true"> - <number:text> -</number:text> + <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> @@ -494,7 +497,7 @@ <number:text> € </number:text> </number:number-style> <number:number-style style:name="N182P2" style:volatile="true"> - <number:text> -</number:text> + <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> @@ -890,250 +893,245 @@ <number:text>-</number:text> <number:month number:style="long"/> </number:date-style> - <number:date-style style:name="N244"> - <number:month number:style="long"/> - <number:text>-</number:text> - <number:year/> - </number:date-style> - <number:currency-style style:name="N246P0" style:volatile="true"> + <number:currency-style style:name="N245P0" style:volatile="true"> <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> <number:text> </number:text> <number:currency-symbol number:language="de" number:country="DE">€</number:currency-symbol> </number:currency-style> - <number:currency-style style:name="N246"> + <number:currency-style style:name="N245"> <style:text-properties fo:color="#ff0000"/> <number:text>-</number:text> <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> <number:text> </number:text> <number:currency-symbol number:language="de" number:country="DE">€</number:currency-symbol> - <style:map style:condition="value()>=0" style:apply-style-name="N246P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N245P0"/> </number:currency-style> - <number:date-style style:name="N247"> + <number:date-style style:name="N246"> <number:month number:style="long"/> <number:text>.</number:text> <number:year number:style="long"/> </number:date-style> - <number:date-style style:name="N248"> + <number:date-style style:name="N247"> <number:month number:style="long"/> <number:text>/</number:text> <number:year number:style="long"/> </number:date-style> - <number:currency-style style:name="N250P0" style:volatile="true"> + <number:currency-style style:name="N249P0" style:volatile="true"> <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/> <number:text> </number:text> <number:currency-symbol number:language="de" number:country="DE">€</number:currency-symbol> </number:currency-style> - <number:currency-style style:name="N250"> + <number:currency-style style:name="N249"> <style:text-properties fo:color="#ff0000"/> <number:text>-</number:text> <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/> <number:text> </number:text> <number:currency-symbol number:language="de" number:country="DE">€</number:currency-symbol> - <style:map style:condition="value()>=0" style:apply-style-name="N250P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N249P0"/> </number:currency-style> - <number:date-style style:name="N251"> + <number:date-style style:name="N250"> <number:year number:style="long"/> </number:date-style> - <number:date-style style:name="N252"> + <number:date-style style:name="N251"> <number:text>⌀ </number:text> <number:year number:style="long"/> </number:date-style> - <number:currency-style style:name="N254P0" style:volatile="true"> + <number:currency-style style:name="N253P0" style:volatile="true"> <number:currency-symbol number:language="es" number:country="MX">$</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="N254"> + <number:currency-style style:name="N253"> <style:text-properties fo:color="#ff0000"/> <number:text>-</number:text> <number:currency-symbol number:language="es" number:country="MX">$</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="N254P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N253P0"/> </number:currency-style> - <number:number-style style:name="N257P0" style:volatile="true"> + <number:number-style style:name="N256P0" style:volatile="true"> <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/> <number:text> </number:text> </number:number-style> - <number:number-style style:name="N257P1" style:volatile="true"> + <number:number-style style:name="N256P1" 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="N257P2" style:volatile="true"> + <number:number-style style:name="N256P2" style:volatile="true"> <number:text> - </number:text> </number:number-style> - <number:text-style style:name="N257"> + <number:text-style style:name="N256"> <number:text-content/> <number:text> </number:text> - <style:map style:condition="value()>0" style:apply-style-name="N257P0"/> - <style:map style:condition="value()<0" style:apply-style-name="N257P1"/> - <style:map style:condition="value()=0" style:apply-style-name="N257P2"/> + <style:map style:condition="value()>0" style:apply-style-name="N256P0"/> + <style:map style:condition="value()<0" style:apply-style-name="N256P1"/> + <style:map style:condition="value()=0" style:apply-style-name="N256P2"/> </number:text-style> - <number:number-style style:name="N261P0" style:volatile="true"> + <number:number-style style:name="N260P0" 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="N261P1" style:volatile="true"> + <number:number-style style:name="N260P1" 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="N261P2" style:volatile="true"> + <number:number-style style:name="N260P2" style:volatile="true"> <number:text> $- </number:text> </number:number-style> - <number:text-style style:name="N261"> + <number:text-style style:name="N260"> <number:text-content/> <number:text> </number:text> - <style:map style:condition="value()>0" style:apply-style-name="N261P0"/> - <style:map style:condition="value()<0" style:apply-style-name="N261P1"/> - <style:map style:condition="value()=0" style:apply-style-name="N261P2"/> + <style:map style:condition="value()>0" style:apply-style-name="N260P0"/> + <style:map style:condition="value()<0" style:apply-style-name="N260P1"/> + <style:map style:condition="value()=0" style:apply-style-name="N260P2"/> </number:text-style> - <number:number-style style:name="N264P0" style:volatile="true"> + <number:number-style style:name="N263P0" style:volatile="true"> <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> <number:text> </number:text> </number:number-style> - <number:number-style style:name="N264P1" style:volatile="true"> + <number:number-style style:name="N263P1" style:volatile="true"> <number:text> (</number:text> <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> <number:text>)</number:text> </number:number-style> - <number:number-style style:name="N264P2" style:volatile="true"> - <number:text> -</number:text> + <number:number-style style:name="N263P2" style:volatile="true"> + <number:text>-</number:text> <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="0"/> <number:text> </number:text> </number:number-style> - <number:text-style style:name="N264"> + <number:text-style style:name="N263"> <number:text-content/> <number:text> </number:text> - <style:map style:condition="value()>0" style:apply-style-name="N264P0"/> - <style:map style:condition="value()<0" style:apply-style-name="N264P1"/> - <style:map style:condition="value()=0" style:apply-style-name="N264P2"/> + <style:map style:condition="value()>0" style:apply-style-name="N263P0"/> + <style:map style:condition="value()<0" style:apply-style-name="N263P1"/> + <style:map style:condition="value()=0" style:apply-style-name="N263P2"/> </number:text-style> - <number:number-style style:name="N265"> + <number:number-style style:name="N264"> <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="1" loext:forced-exponent-sign="true"/> </number:number-style> - <number:number-style style:name="N266"> + <number:number-style style:name="N265"> <number:text>$</number:text> <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> </number:number-style> - <number:number-style style:name="N267"> + <number:number-style style:name="N266"> <number:scientific-number number:decimal-places="1" loext:min-decimal-places="1" number:min-integer-digits="1" number:min-exponent-digits="1" loext:exponent-interval="3" loext:forced-exponent-sign="true"/> </number:number-style> - <number:currency-style style:name="N269P0" style:volatile="true"> + <number:currency-style style:name="N268P0" style:volatile="true"> <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> <number:text> </number:text> <number:currency-symbol number:language="fr" number:country="FR">€</number:currency-symbol> </number:currency-style> - <number:currency-style style:name="N269"> + <number:currency-style style:name="N268"> <style:text-properties fo:color="#ff0000"/> <number:text>-</number:text> <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> <number:text> </number:text> <number:currency-symbol number:language="fr" number:country="FR">€</number:currency-symbol> - <style:map style:condition="value()>=0" style:apply-style-name="N269P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N268P0"/> </number:currency-style> - <number:date-style style:name="N270"> + <number:date-style style:name="N269"> <number:day number:style="long"/> <number:text>.</number:text> <number:month number:style="long"/> <number:text>.</number:text> <number:year number:style="long"/> </number:date-style> - <number:number-style style:name="N272P0" style:volatile="true"> + <number:number-style style:name="N271P0" style:volatile="true"> <number:text>WAHR</number:text> </number:number-style> - <number:number-style style:name="N272P1" style:volatile="true"> + <number:number-style style:name="N271P1" style:volatile="true"> <number:text>WAHR</number:text> </number:number-style> - <number:number-style style:name="N272"> + <number:number-style style:name="N271"> <number:text>FALSCH</number:text> - <style:map style:condition="value()>0" style:apply-style-name="N272P0"/> - <style:map style:condition="value()<0" style:apply-style-name="N272P1"/> + <style:map style:condition="value()>0" style:apply-style-name="N271P0"/> + <style:map style:condition="value()<0" style:apply-style-name="N271P1"/> </number:number-style> - <number:number-style style:name="N273"> + <number:number-style style:name="N272"> <number:number number:decimal-places="20" loext:min-decimal-places="20" number:min-integer-digits="1"/> </number:number-style> - <number:number-style style:name="N275P0" style:volatile="true"> + <number:number-style style:name="N274P0" style:volatile="true"> <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/> <number:text> </number:text> </number:number-style> - <number:number-style style:name="N275"> + <number:number-style style:name="N274"> <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="N275P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N274P0"/> </number:number-style> - <number:number-style style:name="N276P0" style:volatile="true"> + <number:number-style style:name="N275P0" style:volatile="true"> <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/> <number:text> </number:text> </number:number-style> - <number:number-style style:name="N276"> + <number:number-style style:name="N275"> <style:text-properties fo:color="#ff0000"/> <number:text>-</number:text> <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/> <number:text> </number:text> - <style:map style:condition="value()>=0" style:apply-style-name="N276P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N275P0"/> </number:number-style> - <number:number-style style:name="N278P0" style:volatile="true"> + <number:number-style style:name="N277P0" style:volatile="true"> <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> <number:text> </number:text> </number:number-style> - <number:number-style style:name="N278"> + <number:number-style style:name="N277"> <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="N278P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N277P0"/> </number:number-style> - <number:number-style style:name="N279P0" style:volatile="true"> + <number:number-style style:name="N278P0" style:volatile="true"> <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> <number:text> </number:text> </number:number-style> - <number:number-style style:name="N279"> + <number:number-style style:name="N278"> <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="N279P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N278P0"/> </number:number-style> - <number:number-style style:name="N280"> + <number:number-style style:name="N279"> <number:number number:decimal-places="19" loext:min-decimal-places="19" number:min-integer-digits="1"/> </number:number-style> - <number:date-style style:name="N281"> + <number:date-style style:name="N280"> <number:month number:textual="true"/> <number:text> </number:text> <number:year number:style="long"/> </number:date-style> - <number:percentage-style style:name="N282"> + <number:percentage-style style:name="N281"> <number:number number:decimal-places="4" loext:min-decimal-places="4" number:min-integer-digits="1"/> <number:text>%</number:text> </number:percentage-style> - <number:number-style style:name="N283P0" style:volatile="true"> + <number:number-style style:name="N282P0" style:volatile="true"> <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1"/> </number:number-style> - <number:number-style style:name="N283"> + <number:number-style style:name="N282"> <style:text-properties fo:color="#ff0000"/> <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1"/> - <style:map style:condition="value()>=0" style:apply-style-name="N283P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N282P0"/> </number:number-style> - <number:number-style style:name="N284"> + <number:number-style style:name="N283"> <number:scientific-number number:decimal-places="16" loext:min-decimal-places="16" number:min-integer-digits="1" number:min-exponent-digits="2" loext:exponent-interval="1" loext:forced-exponent-sign="true"/> </number:number-style> - <number:number-style style:name="N286P0" style:volatile="true"> + <number:number-style style:name="N285P0" style:volatile="true"> <number:number number:decimal-places="16" loext:min-decimal-places="16" number:min-integer-digits="1" number:grouping="true"/> <number:text> €</number:text> </number:number-style> - <number:number-style style:name="N286"> + <number:number-style style:name="N285"> <style:text-properties fo:color="#ff0000"/> <number:text>-</number:text> <number:number number:decimal-places="16" loext:min-decimal-places="16" number:min-integer-digits="1" number:grouping="true"/> <number:text> €</number:text> - <style:map style:condition="value()>=0" style:apply-style-name="N286P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N285P0"/> </number:number-style> - <number:percentage-style style:name="N287"> + <number:percentage-style style:name="N286"> <number:number number:decimal-places="16" loext:min-decimal-places="16" number:min-integer-digits="1"/> <number:text>%</number:text> </number:percentage-style> - <number:time-style style:name="N288"> + <number:time-style style:name="N287"> <number:hours/> <number:text>:</number:text> <number:minutes number:style="long"/> @@ -1142,148 +1140,182 @@ <number:text> </number:text> <number:am-pm/> </number:time-style> - <number:time-style style:name="N289"> + <number:time-style style:name="N288"> <number:hours number:style="long"/> <number:text>:</number:text> <number:minutes number:style="long"/> <number:text>:</number:text> <number:seconds number:style="long" number:decimal-places="1"/> </number:time-style> - <number:currency-style style:name="N291P0" style:volatile="true"> + <number:currency-style style:name="N290P0" style:volatile="true"> <number:currency-symbol>€</number:currency-symbol> <number:text> </number:text> <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/> </number:currency-style> - <number:currency-style style:name="N291"> + <number:currency-style style:name="N290"> <style:text-properties fo:color="#ff0000"/> <number:text>-</number:text> <number:currency-symbol>€</number:currency-symbol> <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="N291P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N290P0"/> </number:currency-style> - <number:currency-style style:name="N293P0" style:volatile="true"> + <number:currency-style style:name="N292P0" style:volatile="true"> <number:currency-symbol>€</number:currency-symbol> <number:text> </number:text> <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> </number:currency-style> - <number:currency-style style:name="N293"> + <number:currency-style style:name="N292"> <style:text-properties fo:color="#ff0000"/> <number:text>-</number:text> <number:currency-symbol>€</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="N293P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N292P0"/> </number:currency-style> - <number:number-style style:name="N294"> + <number:number-style style:name="N293"> <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="12"/> </number:number-style> - <number:number-style style:name="N295P0" style:volatile="true"> + <number:number-style style:name="N294P0" style:volatile="true"> <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="N295"> + <number:number-style style:name="N294"> <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="N295P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N294P0"/> </number:number-style> - <number:number-style style:name="N296P0" style:volatile="true"> + <number:number-style style:name="N295P0" style:volatile="true"> <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="N296"> + <number:number-style style:name="N295"> <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="N296P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N295P0"/> </number:number-style> - <number:number-style style:name="N297P0" style:volatile="true"> + <number:number-style style:name="N296P0" 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> - <number:number-style style:name="N297"> + <number:number-style style:name="N296"> <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="N297P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N296P0"/> </number:number-style> - <number:number-style style:name="N298P0" style:volatile="true"> + <number:number-style style:name="N297P0" 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> - <number:number-style style:name="N298"> + <number:number-style style:name="N297"> <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="N298P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N297P0"/> </number:number-style> - <number:number-style style:name="N300P0" style:volatile="true"> + <number:number-style style:name="N299P0" style:volatile="true"> <number:text>t$</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="N300"> + <number:number-style style:name="N299"> <number:text>(t$</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="N300P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N299P0"/> </number:number-style> - <number:number-style style:name="N301P0" style:volatile="true"> + <number:number-style style:name="N300P0" style:volatile="true"> <number:text>t$</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="N301"> + <number:number-style style:name="N300"> <style:text-properties fo:color="#ff0000"/> <number:text>(t$</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="N301P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N300P0"/> </number:number-style> - <number:number-style style:name="N303P0" style:volatile="true"> + <number:number-style style:name="N302P0" style:volatile="true"> <number:text>t$</number:text> <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> <number:text> </number:text> </number:number-style> - <number:number-style style:name="N303"> + <number:number-style style:name="N302"> <number:text>(t$</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="N303P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N302P0"/> </number:number-style> - <number:number-style style:name="N304P0" style:volatile="true"> + <number:number-style style:name="N303P0" style:volatile="true"> <number:text>t$</number:text> <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> <number:text> </number:text> </number:number-style> - <number:number-style style:name="N304"> + <number:number-style style:name="N303"> <style:text-properties fo:color="#ff0000"/> <number:text>(t$</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="N304P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N303P0"/> </number:number-style> - <number:number-style style:name="N305"> + <number:number-style style:name="N304"> <number:text>t</number:text> <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="2"/> </number:number-style> - <number:currency-style style:name="N307P0" style:volatile="true"> + <number:currency-style style:name="N306P0" style:volatile="true"> <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> <number:currency-symbol number:language="tr" number:country="TR">YTL</number:currency-symbol> </number:currency-style> - <number:currency-style style:name="N307"> + <number:currency-style style:name="N306"> <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:currency-symbol number:language="tr" number:country="TR">YTL</number:currency-symbol> - <style:map style:condition="value()>=0" style:apply-style-name="N307P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N306P0"/> </number:currency-style> - <number:currency-style style:name="N309P0" style:volatile="true"> + <number:currency-style style:name="N308P0" style:volatile="true"> <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> <number:currency-symbol number:language="tr" number:country="TR">TL</number:currency-symbol> </number:currency-style> - <number:currency-style style:name="N309"> + <number:currency-style style:name="N308"> <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:currency-symbol number:language="tr" number:country="TR">TL</number:currency-symbol> - <style:map style:condition="value()>=0" style:apply-style-name="N309P0"/> + <style:map style:condition="value()>=0" style:apply-style-name="N308P0"/> + </number:currency-style> + <number:currency-style style:name="N311P0" style:volatile="true"> + <number:currency-symbol number:language="nl" number:country="NL">€</number:currency-symbol> + <number:text> </number:text> + <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> + </number:currency-style> + <number:currency-style style:name="N311"> + <style:text-properties fo:color="#ff0000"/> + <number:currency-symbol number:language="nl" number:country="NL">€</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:text>-</number:text> + <style:map style:condition="value()>=0" style:apply-style-name="N311P0"/> </number:currency-style> + <number:number-style style:name="N312"> + <number:scientific-number number:decimal-places="15" loext:min-decimal-places="15" number:min-integer-digits="1" number:min-exponent-digits="3" loext:exponent-interval="1" loext:forced-exponent-sign="true"/> + </number:number-style> + <number:number-style style:name="N313"> + <number:scientific-number number:decimal-places="16" loext:min-decimal-places="16" number:min-integer-digits="1" number:min-exponent-digits="3" loext:exponent-interval="1" loext:forced-exponent-sign="true"/> + </number:number-style> + <number:number-style style:name="N314"> + <number:scientific-number number:decimal-places="17" loext:min-decimal-places="17" number:min-integer-digits="1" number:min-exponent-digits="3" loext:exponent-interval="1" loext:forced-exponent-sign="true"/> + </number:number-style> + <number:number-style style:name="N315"> + <number:scientific-number number:decimal-places="18" loext:min-decimal-places="18" number:min-integer-digits="1" number:min-exponent-digits="3" loext:exponent-interval="1" loext:forced-exponent-sign="true"/> + </number:number-style> + <number:number-style style:name="N316"> + <number:scientific-number number:decimal-places="19" loext:min-decimal-places="19" number:min-integer-digits="1" number:min-exponent-digits="3" loext:exponent-interval="1" loext:forced-exponent-sign="true"/> + </number:number-style> + <number:number-style style:name="N317"> + <number:scientific-number number:decimal-places="20" loext:min-decimal-places="20" number:min-integer-digits="1" number:min-exponent-digits="3" loext:exponent-interval="1" loext:forced-exponent-sign="true"/> + </number:number-style> + <number:number-style style:name="N318"> + <number:scientific-number number:decimal-places="43" loext:min-decimal-places="43" number:min-integer-digits="1" number:min-exponent-digits="3" loext:exponent-interval="1" loext:forced-exponent-sign="true"/> + </number:number-style> <number:date-style style:name="N10121" number:language="en" number:country="US"> <number:month/> <number:text>/</number:text> @@ -1853,10 +1885,6 @@ <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"/> @@ -1865,6 +1893,95 @@ <style:style style:name="Heading1" style:family="table-cell" style:parent-style-name="Heading"> <style:table-cell-properties style:rotation-angle="90"/> </style:style> + <style:style style:name="Heading2" 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.06pt solid #000000"/> + <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="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="Accent1" 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="Accent2" 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="Accent3" style:family="table-cell" style:parent-style-name="Accent"> + <style:table-cell-properties fo:background-color="#dddddd"/> + </style:style> + <style:style style:name="Name1" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties fo:background-color="#feffcc" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border="0.06pt dotted #ffcc12"/> + </style:style> + <style:style style:name="Name2" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties fo:border-bottom="1.7pt solid #aeee11" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="0.71pt solid #11ee11" fo:border-right="0.2pt dash-dot-dot #05ee11" fo:border-top="0.71pt solid #ffee11"/> + </style:style> + <style:style style:name="Name3" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties fo:border-bottom="none" style:diagonal-bl-tr="1.7pt dashed #ffccee" style:diagonal-tl-br="0.71pt dash-dot #120000" fo:border-left="none" fo:border-right="0.71pt dotted #000000" fo:border-top="none"/> + </style:style> + <style:style style:name="Name4" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties fo:border-bottom="none" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="0.71pt solid #000000" fo:border-right="0.71pt dotted #000000" fo:border-top="0.71pt solid #000000"/> + </style:style> + <style:style style:name="Name5" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties style:cell-protect="hidden-and-protected" style:print-content="false"/> + </style:style> + <style:style style:name="Name6" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties style:cell-protect="protected formula-hidden" style:print-content="true"/> + </style:style> + <style:style style:name="Name7" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties style:cell-protect="none" style:print-content="false"/> + </style:style> + <style:style style:name="Name8" style:family="table-cell" style:parent-style-name="Default"> + <style:text-properties fo:color="#808080" style:font-name="Liberation Sans1" fo:font-family="'Liberation Sans'" style:font-style-name="Liberation Sans" fo:font-size="24pt" fo:font-style="italic" style:text-underline-style="solid" style:text-underline-width="auto" style:text-underline-color="#808080" fo:font-weight="bold"/> + </style:style> + <style:style style:name="Name9" style:family="table-cell" style:parent-style-name="Default"> + <style:text-properties fo:color="#000000" style:font-name="Tahoma" fo:font-family="Tahoma" style:font-style-name="Tahoma" fo:font-size="1pt" fo:font-style="normal" style:text-underline-style="dash" style:text-underline-width="auto" style:text-underline-color="#1856ff" fo:font-weight="bold"/> + </style:style> + <style:style style:name="Name20" style:family="table-cell" style:parent-style-name="Default"> + <style:text-properties style:text-line-through-style="solid" style:text-line-through-type="single"/> + </style:style> + <style:style style:name="Name21" style:family="table-cell" style:parent-style-name="Default"> + <style:text-properties style:text-line-through-style="solid" style:text-line-through-type="single" style:text-line-through-width="bold"/> + </style:style> + <style:style style:name="Name22" style:family="table-cell" style:parent-style-name="Default"> + <style:text-properties style:text-line-through-style="solid" style:text-line-through-type="single" style:text-line-through-text="/"/> + </style:style> + <style:style style:name="Name23" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false" style:vertical-align="middle"/> + <style:paragraph-properties fo:text-align="start"/> + </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> @@ -1888,24 +2005,27 @@ <style:table-column-properties fo:break-before="auto" style:column-width="64.01pt"/> </style:style> <style:style style:name="co4" style:family="table-column"> - <style:table-column-properties fo:break-before="auto" style:column-width="123.99pt"/> + <style:table-column-properties fo:break-before="auto" style:column-width="136.91pt"/> </style:style> <style:style style:name="co5" style:family="table-column"> - <style:table-column-properties fo:break-before="auto" style:column-width="74.21pt"/> + <style:table-column-properties fo:break-before="auto" style:column-width="85.75pt"/> </style:style> <style:style style:name="co6" style:family="table-column"> - <style:table-column-properties fo:break-before="auto" style:column-width="136.6pt"/> + <style:table-column-properties fo:break-before="auto" style:column-width="74.21pt"/> </style:style> <style:style style:name="co7" style:family="table-column"> - <style:table-column-properties fo:break-before="auto" style:column-width="100.35pt"/> + <style:table-column-properties fo:break-before="auto" style:column-width="159.99pt"/> </style:style> <style:style style:name="co8" style:family="table-column"> - <style:table-column-properties fo:break-before="auto" style:column-width="50.34pt"/> + <style:table-column-properties fo:break-before="auto" style:column-width="100.35pt"/> </style:style> <style:style style:name="co9" style:family="table-column"> - <style:table-column-properties fo:break-before="auto" style:column-width="16.44pt"/> + <style:table-column-properties fo:break-before="auto" style:column-width="50.34pt"/> </style:style> <style:style style:name="co10" style:family="table-column"> + <style:table-column-properties fo:break-before="auto" style:column-width="16.44pt"/> + </style:style> + <style:style style:name="co11" style:family="table-column"> <style:table-column-properties fo:break-before="auto" style:column-width="110.35pt"/> </style:style> <style:style style:name="ro1" style:family="table-row"> @@ -1920,6 +2040,9 @@ <style:style style:name="ro4" style:family="table-row"> <style:table-row-properties style:row-height="15pt" fo:break-before="auto" style:use-optimal-row-height="true"/> </style:style> + <style:style style:name="ro5" style:family="table-row"> + <style:table-row-properties style:row-height="13.41pt" 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> @@ -1990,47 +2113,47 @@ <number:boolean/> </number:boolean-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="ce55" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> <style:paragraph-properties fo:text-align="start" fo:margin-left="0pt"/> <style:text-properties fo:font-size="20pt" fo:font-weight="bold" style:font-size-asian="20pt" style:font-weight-asian="bold" style:font-size-complex="20pt" style:font-weight-complex="bold"/> </style:style> - <style:style style:name="ce3" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce56" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> <style:text-properties fo:font-size="14pt" fo:font-weight="bold" style:font-size-asian="14pt" style:font-weight-asian="bold" style:font-size-complex="14pt" style:font-weight-complex="bold"/> </style:style> - <style:style style:name="ce4" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce57" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> <style:text-properties fo:font-size="12pt" fo:font-weight="bold" style:font-size-asian="12pt" style:font-weight-asian="bold" style:font-size-complex="12pt" style:font-weight-complex="bold"/> </style:style> - <style:style style:name="ce5" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce58" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> </style:style> - <style:style style:name="ce6" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:style style:name="ce59" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet1.B3"/> <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B3"/> <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B3"/> </style:style> - <style:style style:name="ce7" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:style style:name="ce60" 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="ce61" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/> <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/> <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/> </style:style> - <style:style style:name="ce9" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce62" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:wrap-option="wrap"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Liberation Serif" fo:font-size="10pt" fo:language="en" fo:country="US" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:text-underline-mode="continuous" style:text-overline-mode="continuous" style:text-line-through-mode="continuous" style:font-size-asian="10pt" style:language-asian="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:language-complex="hi" style:country-complex="IN" style:font-style-complex="normal" style:font-weight-complex="normal" style:text-emphasize="none" style:font-relief="none" style:text-overline-style="none" style:text-overline-color="font-color"/> </style:style> @@ -2039,69 +2162,182 @@ <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/> </style:style> - <style:style style:name="ce11" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N0"/> - <style:style style:name="ce12" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N158"> - <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="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> + <style:style style:name="ce14" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N127"/> + <style:style style:name="ce15" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N127"> + <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 Sans2" 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="ce16" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N127"> + <style:text-properties style:font-name="Liberation Sans" style:font-name-asian="Droid Sans Fallback" style:font-name-complex="Droid Sans Devanagari"/> + </style:style> + <style:style style:name="ce17" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N127"> + <style:text-properties style:font-name="Liberation Sans2"/> + </style:style> + <style:style style:name="ce23" style:family="table-cell" style:parent-style-name="Default"> + <style:text-properties style:font-name="Liberation Sans" style:font-name-asian="Droid Sans Fallback" style:font-name-complex="Droid Sans Devanagari"/> + </style:style> + <style:style style:name="ce67" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N0"> + <style:table-cell-properties fo:background-color="transparent"/> + </style:style> + <style:style style:name="ce68" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties fo:background-color="transparent"/> </style:style> <style:style style:name="ce13" style:family="table-cell" style:parent-style-name="Default"> <style:text-properties style:font-name="DejaVu Sans"/> </style:style> - <style:style style:name="ce14" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:style style:name="ce41" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/> <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/> <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/> </style:style> - <style:style style:name="ce15" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:style style:name="ce42" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> - <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/> - <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/> - <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/> </style:style> - <style:style style:name="ce16" style:family="table-cell" style:parent-style-name="Default"> - <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="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> - <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:name="ce70" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> + <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/> </style:style> - <style:style style:name="ce17" 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:name="ce71" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> + <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/> </style:style> - <style:style style:name="ce18" style:family="table-cell" style:parent-style-name="Default"> - <style:text-properties style:font-name="DejaVu Sans"/> - <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:name="ce72" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> + <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/> + </style:style> + <style:style style:name="ce73" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> + <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/> + </style:style> + <style:style style:name="ce74" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> + <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/> + </style:style> + <style:style style:name="ce75" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> + <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/> + </style:style> + <style:style style:name="ce76" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> + <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/> + </style:style> + <style:style style:name="ce77" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> + <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/> + </style:style> + <style:style style:name="ce78" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> + <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/> + </style:style> + <style:style style:name="ce79" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> + <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/> + </style:style> + <style:style style:name="ce80" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> + <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/> + </style:style> + <style:style style:name="ce81" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> + <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/> + </style:style> + <style:style style:name="ce82" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> + <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/> + </style:style> + <style:style style:name="ce83" 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.C3"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/> </style:style> <style:style style:name="ce19" 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="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:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/> </style:style> <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="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:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C3"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C3"/> + </style:style> + <style:style style:name="ce58" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> + <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> </style:style> <style:style style:name="ce21" 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="ce22" style:family="table-cell" style:parent-style-name="Default"> - <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="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> + <style:style style:name="ce87" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false" style:vertical-align="middle"/> + <style:paragraph-properties fo:text-align="center"/> </style:style> - <style:style style:name="ce23" style:family="table-cell" style:parent-style-name="Default"> - <style:text-properties style:font-name="Liberation Sans" style:font-name-asian="Droid Sans Fallback" style:font-name-complex="Droid Sans Devanagari"/> + <style:style style:name="ce94" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false" fo:wrap-option="wrap" style:vertical-align="middle"/> + <style:paragraph-properties fo:text-align="center"/> + <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="ce62" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties fo:wrap-option="wrap"/> + <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Liberation Serif" fo:font-size="10pt" fo:language="en" fo:country="US" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:text-underline-mode="continuous" style:text-overline-mode="continuous" style:text-line-through-mode="continuous" style:font-size-asian="10pt" style:language-asian="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:language-complex="hi" style:country-complex="IN" style:font-style-complex="normal" style:font-weight-complex="normal" style:text-emphasize="none" style:font-relief="none" style:text-overline-style="none" style:text-overline-color="font-color"/> + </style:style> + <style:style style:name="ce89" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false" style:vertical-align="middle"/> + <style:paragraph-properties fo:text-align="start" fo:margin-left="0pt"/> </style:style> <style:style style:name="ce24" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N10099"/> - <style:style style:name="ce25" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"/> + <style:style style:name="ce91" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"/> + <style:style style:name="ce22" style:family="table-cell" style:parent-style-name="Default"> + <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="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> + </style:style> <style:style style:name="ce26" style:family="table-cell" style:parent-style-name="Excel_5f_BuiltIn_5f_Currency"> <style:table-cell-properties style:glyph-orientation-vertical="0" fo:border-bottom="none" style:cell-protect="protected" style:print-content="true" style:text-align-source="value-type" style:repeat-content="false" fo:background-color="transparent" fo:wrap-option="no-wrap" fo:border-left="0.06pt solid #000000" style:direction="ltr" fo:border-right="0.06pt solid #000000" style:rotation-angle="0" style:rotation-align="none" style:shrink-to-fit="false" fo:border-top="none" style:vertical-align="automatic"/> <style:paragraph-properties fo:margin-left="0pt" style:writing-mode="page"/> @@ -2114,7 +2350,7 @@ <style:table-cell-properties style:cell-protect="none" style:print-content="true"/> <style:text-properties fo:font-weight="normal" style:font-weight-asian="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce31" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce98" 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> <style:style style:name="ce32" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N104"/> @@ -2127,14 +2363,14 @@ <style:style style:name="ce37" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N42"/> <style:style style:name="ce38" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N41"/> <style:style style:name="ce39" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N40"/> - <style:style style:name="ce40" style:family="table-cell" style:parent-style-name="Default"> - <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false" style:vertical-align="middle"/> - <style:paragraph-properties fo:text-align="center"/> + <style:style style:name="ce98" 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> - <style:style style:name="ce41" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce91" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"/> + <style:style style:name="ce107" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:background-color="#ffffcc"/> </style:style> - <style:style style:name="ce42" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce108" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:background-color="#dddddd"/> </style:style> <style:style style:name="ta_extref" style:family="table"> @@ -2180,7 +2416,7 @@ <text:p><text:sheet-name>???</text:sheet-name> (<text:title>???</text:title>)</text:p> </style:region-left> <style:region-right> - <text:p><text:date style:data-style-name="N2" text:date-value="2016-07-21">00/00/0000</text:date>, <text:time style:data-style-name="N2" text:time-value="20:12:29.698879909">00:00:00</text:time></text:p> + <text:p><text:date style:data-style-name="N2" text:date-value="2016-10-13">00/00/0000</text:date>, <text:time style:data-style-name="N2" text:time-value="21:41:09.362929754">00:00:00</text:time></text:p> </style:region-right> </style:header> <style:header-left style:display="false"/> @@ -2196,10 +2432,10 @@ <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="ce58"/> <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="ce55" office:value-type="string" calcext:value-type="string"> <text:p>MOD Function</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="2"/> @@ -2208,10 +2444,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="ce56" 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="ce59" table:formula="of:=AND([.B8:.B95])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> <table:table-cell/> @@ -2220,13 +2456,13 @@ <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="ce57" 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="ce57" 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="ce57" office:value-type="string" calcext:value-type="string"> <text:p>Description</text:p> </table:table-cell> </table:table-row> @@ -2234,7 +2470,7 @@ <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:.C92])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce60" table:formula="of:=AND([Sheet2.C2:.C92])" 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"> @@ -2243,7 +2479,7 @@ </table:table-row> <table:table-row table:style-name="ro2"> <table:table-cell/> - <table:table-cell table:style-name="ce7" table:formula="of:=AND([tdf86219.A22:.A92])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce60" table:formula="of:=AND([tdf86219.A22:.A92])" 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"> @@ -2252,17 +2488,17 @@ </table:table-row> <table:table-row table:style-name="ro2" table:number-rows-repeated="2"> <table:table-cell/> - <table:table-cell table:style-name="ce8"/> + <table:table-cell table:style-name="ce61"/> <table:table-cell/> </table:table-row> <table:table-row table:style-name="ro2"> <table:table-cell/> - <table:table-cell table:style-name="ce8"/> - <table:table-cell table:style-name="ce9"/> + <table:table-cell table:style-name="ce61"/> + <table:table-cell table:style-name="ce62"/> </table:table-row> <table:table-row table:style-name="ro2" table:number-rows-repeated="26"> <table:table-cell/> - <table:table-cell table:style-name="ce8"/> + <table:table-cell table:style-name="ce61"/> <table:table-cell/> </table:table-row> <table:table-row table:style-name="ro2" table:number-rows-repeated="1048537"> @@ -2286,13 +2522,14 @@ </table:table> <table:table table:name="Sheet2" table:style-name="ta1" table:print="false"> <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="ce5"/> - <table:table-column table:style-name="co6" 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="co5" table:default-cell-style-name="Default"/> + <table:table-column table:style-name="co6" table:default-cell-style-name="ce58"/> <table:table-column table:style-name="co7" table:default-cell-style-name="Default"/> <table:table-column table:style-name="co8" table:default-cell-style-name="Default"/> - <table:table-column table:style-name="co9" table:number-columns-repeated="3" table:default-cell-style-name="Default"/> - <table:table-column table:style-name="co10" table:default-cell-style-name="Default"/> + <table:table-column table:style-name="co9" table:default-cell-style-name="Default"/> + <table:table-column table:style-name="co10" table:number-columns-repeated="3" table:default-cell-style-name="Default"/> + <table:table-column table:style-name="co11" table:default-cell-style-name="Default"/> <table:table-column table:style-name="co3" table:number-columns-repeated="5" table:default-cell-style-name="Default"/> <table:table-row table:style-name="ro2"> <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string"> @@ -2313,83 +2550,83 @@ <table:table-cell table:style-name="ce10"/> <table:table-cell table:number-columns-repeated="9"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:style-name="ce11" table:formula="of:=MOD(22;3)" office:value-type="float" office:value="1" calcext:value-type="float"> - <text:p>1</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD(22;3)" office:value-type="float" office:value="1" calcext:value-type="float"> + <text:p>1.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell table:style-name="ce11" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce67" 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="ce14" table:formula="of:=ROUND([.A2];12)=ROUND([.B2];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce41" table:formula="of:=ROUND([Sheet2.A2];12)=ROUND([Sheet2.B2];12)" 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="ce21" table:formula="of:=FORMULA([.A2])" office:value-type="string" office:string-value="=MOD(22,3)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A2])" office:value-type="string" office:string-value="=MOD(22,3)" calcext:value-type="string"> <text:p>=MOD(22,3)</text:p> </table:table-cell> <table:table-cell/> <table:table-cell table:style-name="ce24"/> <table:table-cell table:number-columns-repeated="9"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:style-name="ce11" table:formula="of:=MOD(11.25;2.5)" office:value-type="float" office:value="1.25" calcext:value-type="float"> - <text:p>1.25</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD(11.25;2.5)" office:value-type="float" office:value="1.25" calcext:value-type="float"> + <text:p>1.25000000000000E+000</text:p> </table:table-cell> - <table:table-cell table:style-name="ce11" office:value-type="float" office:value="1.25" calcext:value-type="float"> + <table:table-cell table:style-name="ce67" office:value-type="float" office:value="1.25" calcext:value-type="float"> <text:p>1.25</text:p> </table:table-cell> - <table:table-cell table:style-name="ce14" table:formula="of:=ROUND([.A3];12)=ROUND([.B3];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce42" table:formula="of:=ROUND([Sheet2.A3];12)=ROUND([Sheet2.B3];12)" 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="ce21" table:formula="of:=FORMULA([.A3])" office:value-type="string" office:string-value="=MOD(11.25,2.5)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A3])" office:value-type="string" office:string-value="=MOD(11.25,2.5)" calcext:value-type="string"> <text:p>=MOD(11.25,2.5)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="11"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:style-name="ce9" table:formula="of:=MOD(3; 2)" office:value-type="float" office:value="1" calcext:value-type="float"> - <text:p>1</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce15" table:formula="of:=MOD(3; 2)" office:value-type="float" office:value="1" calcext:value-type="float"> + <text:p>1.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce68" 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="ce14" table:formula="of:=ROUND([.A4];12)=ROUND([.B4];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce42" table:formula="of:=ROUND([Sheet2.A4];12)=ROUND([Sheet2.B4];12)" 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="ce21" table:formula="of:=FORMULA([.A4])" office:value-type="string" office:string-value="=MOD(3, 2)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A4])" office:value-type="string" office:string-value="=MOD(3, 2)" calcext:value-type="string"> <text:p>=MOD(3, 2)</text:p> </table:table-cell> <table:table-cell table:style-name="ce23"/> - <table:table-cell table:style-name="ce25"/> + <table:table-cell table:style-name="ce91"/> <table:table-cell table:number-columns-repeated="9"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:style-name="ce9" table:formula="of:=MOD(-3; 2)" office:value-type="float" office:value="1" calcext:value-type="float"> - <text:p>1</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce15" table:formula="of:=MOD(-3; 2)" office:value-type="float" office:value="1" calcext:value-type="float"> + <text:p>1.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce68" 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="ce14" table:formula="of:=ROUND([.A5];12)=ROUND([.B5];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce42" table:formula="of:=ROUND([Sheet2.A5];12)=ROUND([Sheet2.B5];12)" 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="ce21" table:formula="of:=FORMULA([.A5])" office:value-type="string" office:string-value="=MOD(-3, 2)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A5])" office:value-type="string" office:string-value="=MOD(-3, 2)" calcext:value-type="string"> <text:p>=MOD(-3, 2)</text:p> </table:table-cell> <table:table-cell table:style-name="ce23"/> - <table:table-cell table:style-name="ce25"/> + <table:table-cell table:style-name="ce91"/> <table:table-cell table:number-columns-repeated="9"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:style-name="ce12" table:formula="of:=MOD(3; -2)" office:value-type="float" office:value="-1" calcext:value-type="float"> - <text:p>-1.0000000000000000</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce15" table:formula="of:=MOD(3; -2)" office:value-type="float" office:value="-1" calcext:value-type="float"> + <text:p>-1.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="-1" calcext:value-type="float"> + <table:table-cell table:style-name="ce68" 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="ce14" table:formula="of:=ROUND([.A6];12)=ROUND([.B6];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce42" table:formula="of:=ROUND([Sheet2.A6];12)=ROUND([Sheet2.B6];12)" 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="ce21" table:formula="of:=FORMULA([.A6])" office:value-type="string" office:string-value="=MOD(3, -2)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A6])" office:value-type="string" office:string-value="=MOD(3, -2)" calcext:value-type="string"> <text:p>=MOD(3, -2)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="2"/> @@ -2398,17 +2635,17 @@ <table:table-cell table:style-name="ce27"/> <table:table-cell table:number-columns-repeated="5"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:style-name="ce9" table:formula="of:=MOD(-3; -2)" office:value-type="float" office:value="-1" calcext:value-type="float"> - <text:p>-1</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce15" table:formula="of:=MOD(-3; -2)" office:value-type="float" office:value="-1" calcext:value-type="float"> + <text:p>-1.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="-1" calcext:value-type="float"> + <table:table-cell table:style-name="ce68" 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="ce14" table:formula="of:=ROUND([.A7];12)=ROUND([.B7];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce42" table:formula="of:=ROUND([Sheet2.A7];12)=ROUND([Sheet2.B7];12)" 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="ce21" table:formula="of:=FORMULA([.A7])" office:value-type="string" office:string-value="=MOD(-3, -2)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A7])" office:value-type="string" office:string-value="=MOD(-3, -2)" calcext:value-type="string"> <text:p>=MOD(-3, -2)</text:p> </table:table-cell> <table:table-cell/> @@ -2417,17 +2654,17 @@ <table:table-cell table:style-name="ce27"/> <table:table-cell table:number-columns-repeated="5"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:style-name="ce12" table:formula="of:=MOD((3^31)-1;2)" office:value-type="float" office:value="0" calcext:value-type="float"> - <text:p>0.0000000000000000</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce15" table:formula="of:=MOD((3^31)-1;2)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce14" table:formula="of:=ROUND([.A8];12)=ROUND([.B8];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce42" table:formula="of:=ROUND([Sheet2.A8];12)=ROUND([Sheet2.B8];12)" 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="ce21" table:formula="of:=FORMULA([.A8])" office:value-type="string" office:string-value="=MOD((3^31)-1,2)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A8])" office:value-type="string" office:string-value="=MOD((3^31)-1,2)" calcext:value-type="string"> <text:p>=MOD((3^31)-1,2)</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -2438,20 +2675,20 @@ <table:table-cell table:style-name="ce28"/> <table:table-cell table:number-columns-repeated="5"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD([.F9]*1000;5)" office:value-type="float" office:value="0.000000000000227373675443232" calcext:value-type="float"> - <text:p>2.27373675443232E-13</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD([Sheet2.F9]*1000;5)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0.000000000000227373675443232" calcext:value-type="float"> - <text:p>2.27373675443232E-13</text:p> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce14" table:formula="of:=ROUND([.A9];12)=ROUND([.B9];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce42" table:formula="of:=ROUND([Sheet2.A9];12)=ROUND([Sheet2.B9];12)" 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="ce21" table:formula="of:=FORMULA([.A9])" office:value-type="string" office:string-value="=MOD(F9*1000,5)" calcext:value-type="string"> - <text:p>=MOD(F9*1000,5)</text:p> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A9])" office:value-type="string" office:string-value="=MOD(Sheet2.F9*1000,5)" calcext:value-type="string"> + <text:p>=MOD(Sheet2.F9*1000,5)</text:p> </table:table-cell> - <table:table-cell office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce87" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="1" table:number-rows-spanned="5"> <text:p>AOO#54529</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="1.41" calcext:value-type="float"> @@ -2460,82 +2697,82 @@ <table:table-cell table:style-name="ce22"/> <table:table-cell table:number-columns-repeated="8"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD([.F10]*1000;5)" office:value-type="float" office:value="0.000000000000227373675443232" calcext:value-type="float"> - <text:p>2.27373675443232E-13</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD([Sheet2.F10]*1000;5)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0.000000000000227373675443232" calcext:value-type="float"> - <text:p>2.27373675443232E-13</text:p> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce14" table:formula="of:=ROUND([.A10];12)=ROUND([.B10];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce42" table:formula="of:=ROUND([Sheet2.A10];12)=ROUND([Sheet2.B10];12)" 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="ce21" table:formula="of:=FORMULA([.A10])" office:value-type="string" office:string-value="=MOD(F10*1000,5)" calcext:value-type="string"> - <text:p>=MOD(F10*1000,5)</text:p> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A10])" office:value-type="string" office:string-value="=MOD(Sheet2.F10*1000,5)" calcext:value-type="string"> + <text:p>=MOD(Sheet2.F10*1000,5)</text:p> </table:table-cell> - <table:table-cell/> + <table:covered-table-cell/> <table:table-cell office:value-type="float" office:value="1.575" calcext:value-type="float"> <text:p>1.575</text:p> </table:table-cell> <table:table-cell table:style-name="ce22"/> <table:table-cell table:number-columns-repeated="8"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD([.F11]*1000;5)" office:value-type="float" office:value="4.99999999999977" calcext:value-type="float"> - <text:p>4.99999999999977</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD([Sheet2.F11]*1000;5)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="4.99999999999977" calcext:value-type="float"> - <text:p>4.99999999999977</text:p> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce14" table:formula="of:=ROUND([.A11];12)=ROUND([.B11];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce42" table:formula="of:=ROUND([Sheet2.A11];12)=ROUND([Sheet2.B11];12)" 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="ce21" table:formula="of:=FORMULA([.A11])" office:value-type="string" office:string-value="=MOD(F11*1000,5)" calcext:value-type="string"> - <text:p>=MOD(F11*1000,5)</text:p> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A11])" office:value-type="string" office:string-value="=MOD(Sheet2.F11*1000,5)" calcext:value-type="string"> + <text:p>=MOD(Sheet2.F11*1000,5)</text:p> </table:table-cell> - <table:table-cell/> + <table:covered-table-cell/> <table:table-cell office:value-type="float" office:value="1.485" calcext:value-type="float"> <text:p>1.485</text:p> </table:table-cell> <table:table-cell table:style-name="ce22"/> <table:table-cell table:number-columns-repeated="3"/> - <table:table-cell table:style-name="ce31" table:number-columns-repeated="4"/> + <table:table-cell table:style-name="ce98" table:number-columns-repeated="4"/> <table:table-cell/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD([.F12]*1000;5)" office:value-type="float" office:value="0.000000000000227373675443232" calcext:value-type="float"> - <text:p>2.27373675443232E-13</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD([Sheet2.F12]*1000;5)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0.000000000000227373675443232" calcext:value-type="float"> - <text:p>2.27373675443232E-13</text:p> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce14" table:formula="of:=ROUND([.A12];12)=ROUND([.B12];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce42" table:formula="of:=ROUND([Sheet2.A12];12)=ROUND([Sheet2.B12];12)" 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="ce21" table:formula="of:=FORMULA([.A12])" office:value-type="string" office:string-value="=MOD(F12*1000,5)" calcext:value-type="string"> - <text:p>=MOD(F12*1000,5)</text:p> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A12])" office:value-type="string" office:string-value="=MOD(Sheet2.F12*1000,5)" calcext:value-type="string"> + <text:p>=MOD(Sheet2.F12*1000,5)</text:p> </table:table-cell> - <table:table-cell/> + <table:covered-table-cell/> <table:table-cell office:value-type="float" office:value="1.555" calcext:value-type="float"> <text:p>1.555</text:p> </table:table-cell> <table:table-cell table:style-name="ce22"/> <table:table-cell table:number-columns-repeated="8"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD([.F13]*1000;5)" office:value-type="float" office:value="0.00000000000727595761418343" calcext:value-type="float"> - <text:p>7.27595761418343E-12</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD([Sheet2.F13]*1000;5)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0.00000000000727595761418343" calcext:value-type="float"> - <text:p>7.27595761418343E-12</text:p> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce14" table:formula="of:=ROUND([.A13];12)=ROUND([.B13];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce42" table:formula="of:=ROUND([Sheet2.A13];12)=ROUND([Sheet2.B13];12)" 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="ce21" table:formula="of:=FORMULA([.A13])" office:value-type="string" office:string-value="=MOD(F13*1000,5)" calcext:value-type="string"> - <text:p>=MOD(F13*1000,5)</text:p> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A13])" office:value-type="string" office:string-value="=MOD(Sheet2.F13*1000,5)" calcext:value-type="string"> + <text:p>=MOD(Sheet2.F13*1000,5)</text:p> </table:table-cell> - <table:table-cell/> + <table:covered-table-cell/> <table:table-cell office:value-type="float" office:value="64.555" calcext:value-type="float"> <text:p>64.555</text:p> </table:table-cell> @@ -2544,18 +2781,18 @@ <table:table-cell table:style-name="ce29"/> <table:table-cell table:number-columns-repeated="5"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD(COLUMN([.I13:.N13]);2)" office:value-type="float" office:value="1" calcext:value-type="float"> - <text:p>1</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD(COLUMN([Sheet2.I13:.N13]);2)" office:value-type="float" office:value="1" calcext:value-type="float"> + <text:p>1.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce68" 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="ce14" table:formula="of:=ROUND([.A14];12)=ROUND([.B14];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce42" table:formula="of:=ROUND([Sheet2.A14];12)=ROUND([Sheet2.B14];12)" 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="ce21" table:formula="of:=FORMULA([.A14])" office:value-type="string" office:string-value="=MOD(COLUMN(I13:N13),2)" calcext:value-type="string"> - <text:p>=MOD(COLUMN(I13:N13),2)</text:p> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A14])" office:value-type="string" office:string-value="=MOD(COLUMN(Sheet2.I13:N13),2)" calcext:value-type="string"> + <text:p>=MOD(COLUMN(Sheet2.I13:N13),2)</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>AOO#19765</text:p> @@ -2566,160 +2803,159 @@ <table:table-cell table:style-name="ce30"/> <table:table-cell table:number-columns-repeated="5"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD(COLUMN([.N13]);2)" office:value-type="float" office:value="0" calcext:value-type="float"> - <text:p>0</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD(COLUMN([Sheet2.N13]);2)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce14" table:formula="of:=ROUND([.A15];12)=ROUND([.B15];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce42" table:formula="of:=ROUND([Sheet2.A15];12)=ROUND([Sheet2.B15];12)" 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="ce21" table:formula="of:=FORMULA([.A15])" office:value-type="string" office:string-value="=MOD(COLUMN(N13),2)" calcext:value-type="string"> - <text:p>=MOD(COLUMN(N13),2)</text:p> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A15])" office:value-type="string" office:string-value="=MOD(COLUMN(Sheet2.N13),2)" calcext:value-type="string"> + <text:p>=MOD(COLUMN(Sheet2.N13),2)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce31" table:number-columns-repeated="5"/> + <table:table-cell table:style-name="ce98" table:number-columns-repeated="5"/> </table:table-row> <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD(26^15;77)" office:value-type="float" office:value="9" calcext:value-type="float"> - <text:p>9</text:p> - </table:table-cell> - <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float"> - <text:p>9</text:p> - </table:table-cell> - <table:table-cell table:style-name="ce14" table:formula="of:=ROUND([.A16];12)=ROUND([.B16];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> - <text:p>TRUE</text:p> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD(26^15;77)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A16])" office:value-type="string" office:string-value="=MOD(26^15,77)" calcext:value-type="string"> + <table:table-cell table:style-name="ce68"/> + <table:table-cell table:style-name="ce70"/> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A16])" office:value-type="string" office:string-value="=MOD(26^15,77)" calcext:value-type="string"> <text:p>=MOD(26^15,77)</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> - <text:p>Tdf#44117</text:p> + <text:p>Tdf#44117, wontfix, value is too large for exact calculation</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="10"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD([.F17]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> - <text:p>0</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD([Sheet2.F17]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce14" table:formula="of:=ROUND([.A17];12)=ROUND([.B17];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce42" table:formula="of:=ROUND([Sheet2.A17];12)=ROUND([Sheet2.B17];12)" 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="ce21" table:formula="of:=FORMULA([.A17])" office:value-type="string" office:string-value="=MOD(F17*100, 10)" calcext:value-type="string"> - <text:p>=MOD(F17*100, 10)</text:p> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A17])" office:value-type="string" office:string-value="=MOD(Sheet2.F17*100, 10)" calcext:value-type="string"> + <text:p>=MOD(Sheet2.F17*100, 10)</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce94" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="1" table:number-rows-spanned="11"> + <text:p>Tdf#50299</text:p> </table:table-cell> - <table:table-cell/> <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="3"/> - <table:table-cell table:style-name="ce31"/> + <table:table-cell table:style-name="ce98"/> <table:table-cell table:number-columns-repeated="5"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD([.F18]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> - <text:p>0</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD([Sheet2.F18]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A18];12)=ROUND([.B18];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce71" table:formula="of:=ROUND([Sheet2.A18];12)=ROUND([Sheet2.B18];12)" 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="ce21" table:formula="of:=FORMULA([.A18])" office:value-type="string" office:string-value="=MOD(F18*100, 10)" calcext:value-type="string"> - <text:p>=MOD(F18*100, 10)</text:p> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A18])" office:value-type="string" office:string-value="=MOD(Sheet2.F18*100, 10)" calcext:value-type="string"> + <text:p>=MOD(Sheet2.F18*100, 10)</text:p> </table:table-cell> - <table:table-cell/> + <table:covered-table-cell table:style-name="ce62"/> <table:table-cell office:value-type="float" office:value="0.1" calcext:value-type="float"> <text:p>0.1</text:p> </table:table-cell> <table:table-cell table:style-name="ce22"/> <table:table-cell table:number-columns-repeated="3"/> - <table:table-cell table:style-name="ce31" table:number-columns-repeated="4"/> + <table:table-cell table:style-name="ce98" table:number-columns-repeated="4"/> <table:table-cell/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD([.F19]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> - <text:p>0</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD([Sheet2.F19]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A19];12)=ROUND([.B19];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce71" table:formula="of:=ROUND([Sheet2.A19];12)=ROUND([Sheet2.B19];12)" 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="ce21" table:formula="of:=FORMULA([.A19])" office:value-type="string" office:string-value="=MOD(F19*100, 10)" calcext:value-type="string"> - <text:p>=MOD(F19*100, 10)</text:p> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A19])" office:value-type="string" office:string-value="=MOD(Sheet2.F19*100, 10)" calcext:value-type="string"> + <text:p>=MOD(Sheet2.F19*100, 10)</text:p> </table:table-cell> - <table:table-cell/> + <table:covered-table-cell table:style-name="ce62"/> <table:table-cell office:value-type="float" office:value="0.2" calcext:value-type="float"> <text:p>0.2</text:p> </table:table-cell> <table:table-cell table:style-name="ce22"/> <table:table-cell table:number-columns-repeated="8"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD([.F21]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> - <text:p>0</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD([Sheet2.F20]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A20];12)=ROUND([.B20];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce72" table:formula="of:=ROUND([Sheet2.A20];12)=ROUND([Sheet2.B20];12)" 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="ce21" table:formula="of:=FORMULA([.A20])" office:value-type="string" office:string-value="=MOD(F21*100, 10)" calcext:value-type="string"> - <text:p>=MOD(F21*100, 10)</text:p> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A20])" office:value-type="string" office:string-value="=MOD(Sheet2.F20*100, 10)" calcext:value-type="string"> + <text:p>=MOD(Sheet2.F20*100, 10)</text:p> </table:table-cell> - <table:table-cell/> + <table:covered-table-cell table:style-name="ce62"/> <table:table-cell office:value-type="float" office:value="0.3" calcext:value-type="float"> <text:p>0.3</text:p> </table:table-cell> - <table:table-cell table:style-name="ce25"/> + <table:table-cell table:style-name="ce22"/> <table:table-cell table:number-columns-repeated="8"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD([.F22]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> - <text:p>0</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD([Sheet2.F21]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A21];12)=ROUND([.B21];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce71" table:formula="of:=ROUND([Sheet2.A21];12)=ROUND([Sheet2.B21];12)" 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="ce21" table:formula="of:=FORMULA([.A21])" office:value-type="string" office:string-value="=MOD(F22*100, 10)" calcext:value-type="string"> - <text:p>=MOD(F22*100, 10)</text:p> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A21])" office:value-type="string" office:string-value="=MOD(Sheet2.F21*100, 10)" calcext:value-type="string"> + <text:p>=MOD(Sheet2.F21*100, 10)</text:p> </table:table-cell> - <table:table-cell/> + <table:covered-table-cell table:style-name="ce62"/> <table:table-cell office:value-type="float" office:value="0.4" calcext:value-type="float"> <text:p>0.4</text:p> </table:table-cell> - <table:table-cell table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce91"/> + <table:table-cell table:number-columns-repeated="2"/> <table:table-cell table:style-name="ce32"/> <table:table-cell/> - <table:table-cell table:style-name="ce31" table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce98" table:number-columns-repeated="3"/> <table:table-cell/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD([.F24]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> - <text:p>0</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD([Sheet2.F22]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A22];12)=ROUND([.B22];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce71" table:formula="of:=ROUND([Sheet2.A22];12)=ROUND([Sheet2.B22];12)" 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="ce21" table:formula="of:=FORMULA([.A22])" office:value-type="string" office:string-value="=MOD(F24*100, 10)" calcext:value-type="string"> - <text:p>=MOD(F24*100, 10)</text:p> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A22])" office:value-type="string" office:string-value="=MOD(Sheet2.F22*100, 10)" calcext:value-type="string"> + <text:p>=MOD(Sheet2.F22*100, 10)</text:p> </table:table-cell> - <table:table-cell/> + <table:covered-table-cell table:style-name="ce62"/> <table:table-cell office:value-type="float" office:value="0.5" calcext:value-type="float"> <text:p>0.5</text:p> </table:table-cell> @@ -2727,20 +2963,20 @@ <table:table-cell table:style-name="ce33"/> <table:table-cell table:number-columns-repeated="5"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD([.F25]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> - <text:p>0</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD([Sheet2.F23]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A23];12)=ROUND([.B23];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce73" table:formula="of:=ROUND([Sheet2.A23];12)=ROUND([Sheet2.B23];12)" 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="ce21" table:formula="of:=FORMULA([.A23])" office:value-type="string" office:string-value="=MOD(F25*100, 10)" calcext:value-type="string"> - <text:p>=MOD(F25*100, 10)</text:p> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A23])" office:value-type="string" office:string-value="=MOD(Sheet2.F23*100, 10)" calcext:value-type="string"> + <text:p>=MOD(Sheet2.F23*100, 10)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce22"/> + <table:covered-table-cell table:style-name="ce62"/> <table:table-cell office:value-type="float" office:value="0.6" calcext:value-type="float"> <text:p>0.6</text:p> </table:table-cell> @@ -2748,69 +2984,89 @@ <table:table-cell table:style-name="ce34"/> <table:table-cell table:number-columns-repeated="5"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD([.F26]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> - <text:p>0</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD([Sheet2.F24]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A24];12)=ROUND([.B24];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce71" table:formula="of:=ROUND([Sheet2.A24];12)=ROUND([Sheet2.B24];12)" 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="ce21" table:formula="of:=FORMULA([.A24])" office:value-type="string" office:string-value="=MOD(F26*100, 10)" calcext:value-type="string"> - <text:p>=MOD(F26*100, 10)</text:p> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A24])" office:value-type="string" office:string-value="=MOD(Sheet2.F24*100, 10)" calcext:value-type="string"> + <text:p>=MOD(Sheet2.F24*100, 10)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce22"/> + <table:covered-table-cell table:style-name="ce62"/> <table:table-cell office:value-type="float" office:value="0.7" calcext:value-type="float"> <text:p>0.7</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="3"/> <table:table-cell table:style-name="ce35"/> <table:table-cell/> - <table:table-cell table:style-name="ce31" table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce98" table:number-columns-repeated="3"/> <table:table-cell/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD([.F27]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> - <text:p>0</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD([Sheet2.F25]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A25];12)=ROUND([.B25];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce71" table:formula="of:=ROUND([Sheet2.A25];12)=ROUND([Sheet2.B25];12)" 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="ce21" table:formula="of:=FORMULA([.A25])" office:value-type="string" office:string-value="=MOD(F27*100, 10)" calcext:value-type="string"> - <text:p>=MOD(F27*100, 10)</text:p> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([Sheet2.A25])" office:value-type="string" office:string-value="=MOD(Sheet2.F25*100, 10)" calcext:value-type="string"> + <text:p>=MOD(Sheet2.F25*100, 10)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce22"/> + <table:covered-table-cell table:style-name="ce62"/> <table:table-cell office:value-type="float" office:value="0.8" calcext:value-type="float"> <text:p>0.8</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="3"/> <table:table-cell table:style-name="ce35"/> <table:table-cell/> - <table:table-cell table:style-name="ce31" table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce98" table:number-columns-repeated="3"/> <table:table-cell/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce16"/> - <table:table-cell table:style-name="ce22" table:number-columns-repeated="2"/> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD([Sheet2.F26]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce71" table:formula="of:=ROUND([Sheet2.A26];12)=ROUND([Sheet2.B26];12)" 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="ce21" table:formula="of:=FORMULA([Sheet2.A26])" office:value-type="string" office:string-value="=MOD(Sheet2.F26*100, 10)" calcext:value-type="string"> + <text:p>=MOD(Sheet2.F26*100, 10)</text:p> + </table:table-cell> + <table:covered-table-cell table:style-name="ce62"/> <table:table-cell office:value-type="float" office:value="0.9" calcext:value-type="float"> <text:p>0.9</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="3"/> <table:table-cell table:style-name="ce35"/> <table:table-cell/> - <table:table-cell table:style-name="ce31" table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce98" table:number-columns-repeated="3"/> <table:table-cell/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce17"/> - <table:table-cell table:number-columns-repeated="2"/> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD([Sheet2.F27]*100; 10)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce71" table:formula="of:=ROUND([Sheet2.A27];12)=ROUND([Sheet2.B27];12)" 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="ce21" table:formula="of:=FORMULA([Sheet2.A27])" office:value-type="string" office:string-value="=MOD(Sheet2.F27*100, 10)" calcext:value-type="string"> + <text:p>=MOD(Sheet2.F27*100, 10)</text:p> + </table:table-cell> + <table:covered-table-cell table:style-name="ce62"/> <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> @@ -2818,103 +3074,202 @@ <table:table-cell table:style-name="ce36"/> <table:table-cell table:number-columns-repeated="5"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce17"/> - <table:table-cell table:number-columns-repeated="6"/> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD((3^31);14)" office:value-type="float" office:value="3" calcext:value-type="float"> + <text:p>3.00000000000000E+000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="3" calcext:value-type="float"> + <text:p>3</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce74" table:formula="of:=ROUND([Sheet2.A28];12)=ROUND([Sheet2.B28];12)" 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="ce21" table:formula="of:=FORMULA([Sheet2.A28])" office:value-type="string" office:string-value="=MOD((3^31),14)" calcext:value-type="string"> + <text:p>=MOD((3^31),14)</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce89" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="1" table:number-rows-spanned="4"><text:p>Variation of </text:p><text:p>AOO#12446,</text:p><text:p>less than 2^53, </text:p><text:p>Should work?</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="4"/> <table:table-cell table:style-name="ce37"/> <table:table-cell/> - <table:table-cell table:style-name="ce31" table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce98" table:number-columns-repeated="3"/> <table:table-cell/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce18"/> - <table:table-cell table:number-columns-repeated="6"/> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce16" table:formula="of:=MOD((3^31)-1;14)" office:value-type="float" office:value="2" calcext:value-type="float"> + <text:p>2.00000000000000E+000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="2" calcext:value-type="float"> + <text:p>2</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce75" table:formula="of:=ROUND([Sheet2.A29];12)=ROUND([Sheet2.B29];12)" 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="ce21" table:formula="of:=FORMULA([Sheet2.A29])" office:value-type="string" office:string-value="=MOD((3^31)-1,14)" calcext:value-type="string"> + <text:p>=MOD((3^31)-1,14)</text:p> + </table:table-cell> + <table:covered-table-cell/> + <table:table-cell table:number-columns-repeated="4"/> <table:table-cell table:style-name="ce38"/> <table:table-cell table:number-columns-repeated="5"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:style-name="ce13" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce18"/> - <table:table-cell table:style-name="ce21"/> - <table:table-cell table:style-name="ce9"/> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce16" table:formula="of:=MOD((3^31)-2;14)" office:value-type="float" office:value="1" calcext:value-type="float"> + <text:p>1.00000000000000E+000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce68" 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="ce76" table:formula="of:=ROUND([Sheet2.A30];12)=ROUND([Sheet2.B30];12)" 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="ce21" table:formula="of:=FORMULA([Sheet2.A30])" office:value-type="string" office:string-value="=MOD((3^31)-2,14)" calcext:value-type="string"> + <text:p>=MOD((3^31)-2,14)</text:p> + </table:table-cell> + <table:covered-table-cell/> <table:table-cell table:number-columns-repeated="4"/> <table:table-cell table:style-name="ce39"/> <table:table-cell table:number-columns-repeated="5"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD([.F20]*100; 10)" office:value-type="float" office:value="3.5527136788005E-015" calcext:value-type="float"> - <text:p>3.5527136788005E-15</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce16" table:formula="of:=MOD((3^31)-3;14)" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.00000000000000E+000</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce68" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18"/> - <table:table-cell table:style-name="ce21"/> - <table:table-cell table:style-name="ce9" office:value-type="string" calcext:value-type="string"> - <text:p>Tdf#50299</text:p> + <table:table-cell table:style-name="ce77" table:formula="of:=ROUND([Sheet2.A31];12)=ROUND([Sheet2.B31];12)" 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="ce21" table:formula="of:=FORMULA([Sheet2.A31])" office:value-type="string" office:string-value="=MOD((3^31)-3,14)" calcext:value-type="string"> + <text:p>=MOD((3^31)-3,14)</text:p> + </table:table-cell> + <table:covered-table-cell/> <table:table-cell table:number-columns-repeated="4"/> - <table:table-cell table:style-name="ce25"/> + <table:table-cell table:style-name="ce91"/> <table:table-cell table:number-columns-repeated="5"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=MOD([.F23]*100; 10)" office:value-type="float" office:value="7.105427357601E-015" calcext:value-type="float"> - <text:p>7.105427357601E-15</text:p> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce17" table:formula="of:=MOD(5310866044487;128)" office:value-type="float" office:value="71" calcext:value-type="float"> + <text:p>7.10000000000000E+001</text:p> </table:table-cell> - <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> - <text:p>0</text:p> + <table:table-cell table:style-name="ce13" office:value-type="float" office:value="71" calcext:value-type="float"> + <text:p>71</text:p> </table:table-cell> - <table:table-cell table:style-name="ce17"/> - <table:table-cell table:number-columns-repeated="12"/> + <table:table-cell table:style-name="ce78" table:formula="of:=ROUND([Sheet2.A32];12)=ROUND([Sheet2.B32];12)" 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="ce21" table:formula="of:=FORMULA([Sheet2.A32])" office:value-type="string" office:string-value="=MOD(5310866044487,128)" calcext:value-type="string"> + <text:p>=MOD(5310866044487,128)</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce94" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="1" table:number-rows-spanned="2"> + <text:p>Tdf#71131</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="10"/> </table:table-row> - <table:table-row table:style-name="ro2"> - <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce17"/> - <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce31" table:number-columns-repeated="5"/> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD(40595547922587;128)" office:value-type="float" office:value="27" calcext:value-type="float"> + <text:p>2.70000000000000E+001</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="27" calcext:value-type="float"> + <text:p>27</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce79" table:formula="of:=ROUND([Sheet2.A33];12)=ROUND([Sheet2.B33];12)" 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="ce21" table:formula="of:=FORMULA([Sheet2.A33])" office:value-type="string" office:string-value="=MOD(40595547922587,128)" calcext:value-type="string"> + <text:p>=MOD(40595547922587,128)</text:p> + </table:table-cell> + <table:covered-table-cell table:style-name="ce62"/> + <table:table-cell table:number-columns-repeated="4"/> + <table:table-cell table:style-name="ce98" table:number-columns-repeated="5"/> <table:table-cell/> </table:table-row> - <table:table-row table:style-name="ro2" table:number-rows-repeated="2"> - <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce17"/> - <table:table-cell table:number-columns-repeated="12"/> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD(7;2.1)" office:value-type="float" office:value="0.699999999999999" calcext:value-type="float"> + <text:p>6.99999999999999E-001</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="0.7" calcext:value-type="float"> + <text:p>0.7</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce80" table:formula="of:=ROUND([Sheet2.A34];12)=ROUND([Sheet2.B34];12)" 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="ce21" table:formula="of:=FORMULA([Sheet2.A34])" office:value-type="string" office:string-value="=MOD(7,2.1)" calcext:value-type="string"> + <text:p>=MOD(7,2.1)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="11"/> + </table:table-row> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce14" table:formula="of:=MOD(2;7.1)" office:value-type="float" office:value="2" calcext:value-type="float"> + <text:p>2.00000000000000E+000</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="2" calcext:value-type="float"> + <text:p>2</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce81" table:formula="of:=ROUND([Sheet2.A35];12)=ROUND([Sheet2.B35];12)" 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="ce21" table:formula="of:=FORMULA([Sheet2.A35])" office:value-type="string" office:string-value="=MOD(2,7.1)" calcext:value-type="string"> + <text:p>=MOD(2,7.1)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="11"/> + </table:table-row> + <table:table-row table:style-name="ro5"> + <table:table-cell table:formula="of:=MOD(25.4;0)" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>Err:502</text:p> + </table:table-cell> + <table:table-cell office:value-type="string" calcext:value-type="string"> + <text:p>Err502</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce82" table:formula="of:=ISERROR([.A36])" 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="ce21" table:formula="of:=FORMULA([Sheet2.A36])" office:value-type="string" office:string-value="=MOD(25.4,0)" calcext:value-type="string"> + <text:p>=MOD(25.4,0)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="5"/> + <table:table-cell table:style-name="ce98" table:number-columns-repeated="5"/> + <table:table-cell/> </table:table-row> <table:table-row table:style-name="ro2"> - <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce17"/> - <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce31" table:number-columns-repeated="5"/> + <table:table-cell table:style-name="ce23"/> <table:table-cell/> + <table:table-cell table:style-name="ce83"/> + <table:table-cell table:style-name="ce21"/> + <table:table-cell table:number-columns-repeated="11"/> </table:table-row> - <table:table-row table:style-name="ro2" table:number-rows-repeated="2"> + <table:table-row table:style-name="ro2"> <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce17"/> + <table:table-cell table:style-name="ce83"/> <table:table-cell table:number-columns-repeated="12"/> </table:table-row> <table:table-row table:style-name="ro2"> <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce17"/> + <table:table-cell table:style-name="ce83"/> <table:table-cell table:number-columns-repeated="8"/> - <table:table-cell table:style-name="ce31" table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce98" table:number-columns-repeated="3"/> <table:table-cell/> </table:table-row> <table:table-row table:style-name="ro2"> <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce17"/> + <table:table-cell table:style-name="ce83"/> <table:table-cell table:number-columns-repeated="12"/> </table:table-row> <table:table-row table:style-name="ro2"> <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce19"/> - <table:table-cell table:number-columns-repeated="12"/> + <table:table-cell table:style-name="ce83"/> + <table:table-cell table:style-name="ce21"/> + <table:table-cell table:style-name="ce68" office:value-type="string" calcext:value-type="string"> + <text:p>Tdf#86219 is about arrays as argument, see sheet tdf86219</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="10"/> </table:table-row> <table:table-row table:style-name="ro2"> <table:table-cell table:number-columns-repeated="2"/> <table:table-cell table:style-name="ce19"/> <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce31" table:number-columns-repeated="5"/> + <table:table-cell table:style-name="ce98" table:number-columns-repeated="5"/> <table:table-cell/> </table:table-row> <table:table-row table:style-name="ro2" table:number-rows-repeated="2"> @@ -2926,7 +3281,7 @@ <table:table-cell table:number-columns-repeated="2"/> <table:table-cell table:style-name="ce19"/> <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce31" table:number-columns-repeated="5"/> + <table:table-cell table:style-name="ce98" table:number-columns-repeated="5"/> <table:table-cell/> </table:table-row> <table:table-row table:style-name="ro2" table:number-rows-repeated="2"> @@ -2938,7 +3293,7 @@ <table:table-cell table:number-columns-repeated="2"/> <table:table-cell table:style-name="ce19"/> <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce31" table:number-columns-repeated="5"/> + <table:table-cell table:style-name="ce98" table:number-columns-repeated="5"/> <table:table-cell/> </table:table-row> <table:table-row table:style-name="ro2" table:number-rows-repeated="52"> @@ -2958,44 +3313,303 @@ <table:table-cell table:number-columns-repeated="15"/> </table:table-row> <calcext:conditional-formats> - <calcext:conditional-format calcext:target-range-address="Sheet2.C18:Sheet2.C100 Sheet2.C2:Sheet2.C25"> + <calcext:conditional-format calcext:target-range-address="Sheet2.C3:Sheet2.C100"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C3"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C3"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C3"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C3:Sheet2.C1100"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C3"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C3"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C3"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C3:Sheet2.C100"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C3"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C3"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C3"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C3:Sheet2.C100"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C3"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C3"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C3"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C37:Sheet2.C41 Sheet2.C24:Sheet2.C27 Sheet2.C17:Sheet2.C19 Sheet2.C21:Sheet2.C22 Sheet2.C2:Sheet2.C15"> <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C2"/> <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C2"/> <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C2"/> </calcext:conditional-format> - <calcext:conditional-format calcext:target-range-address="Sheet2.C18:Sheet2.C1100 Sheet2.C2:Sheet2.C25"> + <calcext:conditional-format calcext:target-range-address="Sheet2.C37:Sheet2.C41 Sheet2.C24:Sheet2.C27 Sheet2.C17:Sheet2.C19 Sheet2.C21:Sheet2.C22 Sheet2.C2:Sheet2.C15"> <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C2"/> <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C2"/> <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C2"/> </calcext:conditional-format> - <calcext:conditional-format calcext:target-range-address="Sheet2.C18:Sheet2.C100"> + <calcext:conditional-format calcext:target-range-address="Sheet2.C37:Sheet2.C41 Sheet2.C24:Sheet2.C27 Sheet2.C18:Sheet2.C19 Sheet2.C21:Sheet2.C22"> <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C18"/> <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C18"/> <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C18"/> </calcext:conditional-format> - <calcext:conditional-format calcext:target-range-address="Sheet2.C18:Sheet2.C100"> + <calcext:conditional-format calcext:target-range-address="Sheet2.C37:Sheet2.C41 Sheet2.C24:Sheet2.C27 Sheet2.C18:Sheet2.C19 Sheet2.C21:Sheet2.C22"> <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C18"/> <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C18"/> <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C18"/> </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C28:Sheet2.C28"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C28"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C28"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C28"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C28:Sheet2.C28"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C28"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C28"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C28"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C28:Sheet2.C28"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C28"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C28"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C28"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C28:Sheet2.C28"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C28"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C28"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C28"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C29:Sheet2.C29"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C29"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C29"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C29"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C29:Sheet2.C29"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C29"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C29"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C29"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C29:Sheet2.C29"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C29"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C29"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C29"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C29:Sheet2.C29"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C29"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C29"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C29"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C30:Sheet2.C30"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C30"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C30"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C30"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C30:Sheet2.C30"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C30"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C30"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C30"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C30:Sheet2.C30"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C30"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C30"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C30"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C30:Sheet2.C30"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C30"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C30"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C30"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C31:Sheet2.C31"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C31"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C31"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C31"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C31:Sheet2.C31"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C31"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C31"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C31"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C31:Sheet2.C31"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C31"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C31"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C31"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C31:Sheet2.C31"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C31"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C31"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C31"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C20:Sheet2.C20"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C20"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C20"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C20"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C20:Sheet2.C20"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C20"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C20"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C20"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C20:Sheet2.C20"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C20"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C20"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C20"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C20:Sheet2.C20"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C20"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C20"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C20"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C23:Sheet2.C23"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C23"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C23"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C23"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C23:Sheet2.C23"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C23"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C23"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C23"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C23:Sheet2.C23"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C23"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C23"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C23"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C23:Sheet2.C23"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C23"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C23"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C23"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C32:Sheet2.C32"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C32"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C32"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C32"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C32:Sheet2.C32"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C32"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C32"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C32"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C32:Sheet2.C32"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C32"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C32"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C32"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C32:Sheet2.C32"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C32"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C32"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C32"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C33:Sheet2.C33"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C33"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C33"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C33"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C33:Sheet2.C33"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C33"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C33"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C33"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C33:Sheet2.C33"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C33"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C33"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C33"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C33:Sheet2.C33"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C33"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C33"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C33"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C34:Sheet2.C34"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C34"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C34"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C34"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C34:Sheet2.C34"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C34"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C34"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C34"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C34:Sheet2.C34"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C34"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C34"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C34"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C34:Sheet2.C34"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C34"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C34"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C34"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C35:Sheet2.C35"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C35"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C35"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C35"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C35:Sheet2.C35"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C35"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C35"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C35"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C35:Sheet2.C35"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C35"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C35"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C35"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C35:Sheet2.C35"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C35"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C35"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C35"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C36:Sheet2.C36"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C36"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C36"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C36"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C36:Sheet2.C36"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C36"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C36"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C36"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C36:Sheet2.C36"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C36"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C36"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C36"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C36:Sheet2.C36"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C36"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C36"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C36"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C16:Sheet2.C16"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C16"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C16"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C16"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C16:Sheet2.C16"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C16"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C16"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C16"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C16:Sheet2.C16"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C16"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C16"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C16"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C16:Sheet2.C16"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C16"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C16"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C16"/> + </calcext:conditional-format> </calcext:conditional-formats> </table:table> <table:table table:name="tdf86219" table:style-name="ta1" table:print="false"> - <office:forms form:automatic-focus="false" form:apply-design-mode="false"/> - <table:table-column table:style-name="co3" table:default-cell-style-name="ce25"/> + <table:table-column table:style-name="co3" table:default-cell-style-name="ce91"/> <table:table-column table:style-name="co3" table:number-columns-repeated="12" table:default-cell-style-name="Default"/> <table:table-row table:style-name="ro2"> - <table:table-cell table:style-name="ce40" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="2" table:number-rows-spanned="1"> + <table:table-cell table:style-name="ce87" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="2" table:number-rows-spanned="1"> <text:p>MOD(array;array)</text:p> </table:table-cell> <table:covered-table-cell/> <table:table-cell table:number-columns-repeated="3"/> - <table:table-cell table:style-name="ce40" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="4" table:number-rows-spanned="1"> + <table:table-cell table:style-name="ce87" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="4" table:number-rows-spanned="1"> <text:p>MOD(scalar;scalar) to see expected results</text:p> </table:table-cell> <table:covered-table-cell table:number-columns-repeated="3"/> <table:table-cell/> - <table:table-cell table:style-name="ce40" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="2" table:number-rows-spanned="1"> + <table:table-cell table:style-name="ce87" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="2" table:number-rows-spanned="1"> <text:p>Other functions fails also</text:p> </table:table-cell> <table:covered-table-cell/> @@ -3034,33 +3648,33 @@ <table:table-cell office:value-type="float" office:value="7" calcext:value-type="float"> <text:p>7</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="3" table:formula="of:=MOD([.B4:.B6];[.C3:.D3])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="3" table:formula="of:=MOD([.B4:.B6];[.C3:.D3])" 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="ce41" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> <table:table-cell/> <table:table-cell office:value-type="float" office:value="7" calcext:value-type="float"> <text:p>7</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" table:formula="of:=MOD([.$F4];[.G$3])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" table:formula="of:=MOD([.$F4];[.G$3])" 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="ce41" table:formula="of:=MOD([.$F4];[.H$3])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" table:formula="of:=MOD([.$F4];[.H$3])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce40" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="1" table:number-rows-spanned="3"> + <table:table-cell table:style-name="ce87" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="1" table:number-rows-spanned="3"> <text:p>CEILING</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="7" calcext:value-type="float"> <text:p>7</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="3" table:formula="of:=CEILING([.K4:.K6];[.L3:.M3])" office:value-type="float" office:value="8" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="3" table:formula="of:=CEILING([.K4:.K6];[.L3:.M3])" office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="9" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="9" calcext:value-type="float"> <text:p>9</text:p> </table:table-cell> </table:table-row> @@ -3069,20 +3683,20 @@ <table:table-cell office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> <table:table-cell/> <table:table-cell office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" table:formula="of:=MOD([.$F5];[.G$3])" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" table:formula="of:=MOD([.$F5];[.G$3])" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" table:formula="of:=MOD([.$F5];[.H$3])" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" table:formula="of:=MOD([.$F5];[.H$3])" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> <table:table-cell/> @@ -3090,10 +3704,10 @@ <table:table-cell office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="8" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="9" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="9" calcext:value-type="float"> <text:p>9</text:p> </table:table-cell> </table:table-row> @@ -3102,20 +3716,20 @@ <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float"> <text:p>9</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" 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="ce41" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> <table:table-cell/> <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float"> <text:p>9</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" table:formula="of:=MOD([.$F6];[.G$3])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" table:formula="of:=MOD([.$F6];[.G$3])" 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="ce41" table:formula="of:=MOD([.$F6];[.H$3])" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" table:formula="of:=MOD([.$F6];[.H$3])" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> <table:table-cell/> @@ -3123,10 +3737,10 @@ <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float"> <text:p>9</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="10" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="10" calcext:value-type="float"> <text:p>10</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="9" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="9" calcext:value-type="float"> <text:p>9</text:p> </table:table-cell> </table:table-row> @@ -3135,12 +3749,12 @@ <table:table-cell table:number-columns-repeated="12"/> </table:table-row> <table:table-row table:style-name="ro2"> - <table:table-cell table:style-name="ce40" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="2" table:number-rows-spanned="1"> + <table:table-cell table:style-name="ce87" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="2" table:number-rows-spanned="1"> <text:p>MOD(array;scalar)</text:p> </table:table-cell> <table:covered-table-cell/> <table:table-cell table:number-columns-repeated="3"/> - <table:table-cell table:style-name="ce40" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="2" table:number-rows-spanned="1"> + <table:table-cell table:style-name="ce87" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="2" table:number-rows-spanned="1"> <text:p>Workarround with INT()</text:p> </table:table-cell> <table:covered-table-cell/> @@ -3166,16 +3780,16 @@ <text:p>3</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce40" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="1" table:number-rows-spanned="3"> + <table:table-cell table:style-name="ce87" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="1" table:number-rows-spanned="3"> <text:p>FLOOR</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="7" calcext:value-type="float"> <text:p>7</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="3" table:formula="of:=FLOOR([.K9:.K11];[.L8:.M8])" office:value-type="float" office:value="6" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="3" table:formula="of:=FLOOR([.K9:.K11];[.L8:.M8])" office:value-type="float" office:value="6" calcext:value-type="float"> <text:p>6</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="6" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="6" calcext:value-type="float"> <text:p>6</text:p> </table:table-cell> </table:table-row> @@ -3184,17 +3798,17 @@ <table:table-cell office:value-type="float" office:value="7" calcext:value-type="float"> <text:p>7</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" table:number-matrix-columns-spanned="1" table:number-matrix-rows-spanned="3" table:formula="of:=MOD([.B10:.B12];[.C9])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" table:number-matrix-columns-spanned="1" table:number-matrix-rows-spanned="3" table:formula="of:=MOD([.B10:.B12];[.C9])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="2"/> <table:table-cell office:value-type="float" office:value="7" calcext:value-type="float"> <text:p>7</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="3" table:formula="of:=[.F10:.F12]-[.G9:.H9]*INT([.F10:.F12]/[.G9:.H9])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="3" table:formula="of:=[.F10:.F12]-[.G9:.H9]*INT([.F10:.F12]/[.G9:.H9])" 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="ce41" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> <table:table-cell/> @@ -3202,10 +3816,10 @@ <table:table-cell office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="8" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="6" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="6" calcext:value-type="float"> <text:p>6</text:p> </table:table-cell> </table:table-row> @@ -3214,17 +3828,17 @@ <table:table-cell office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="2"/> <table:table-cell office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> <table:table-cell/> @@ -3232,10 +3846,10 @@ <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float"> <text:p>9</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="8" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="9" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="9" calcext:value-type="float"> <text:p>9</text:p> </table:table-cell> </table:table-row> @@ -3244,17 +3858,17 @@ <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float"> <text:p>9</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="2"/> <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float"> <text:p>9</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" 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="ce41" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="5"/> @@ -3270,21 +3884,21 @@ </table:table-cell> </table:table-row> <table:table-row table:style-name="ro2"> - <table:table-cell table:style-name="ce40" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="2" table:number-rows-spanned="1"> + <table:table-cell table:style-name="ce87" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="2" table:number-rows-spanned="1"> <text:p>MOD(scalar;array)</text:p> </table:table-cell> <table:covered-table-cell/> <table:table-cell table:number-columns-repeated="7"/> - <table:table-cell table:style-name="ce40" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="1" table:number-rows-spanned="3"> + <table:table-cell table:style-name="ce87" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="1" table:number-rows-spanned="3"> <text:p>QUOTIENT</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="7" calcext:value-type="float"> <text:p>7</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="3" table:formula="of:=QUOTIENT([.K14:.K16];[.L13:.M13])" office:value-type="float" office:value="3" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="3" table:formula="of:=QUOTIENT([.K14:.K16];[.L13:.M13])" office:value-type="float" office:value="3" calcext:value-type="float"> <text:p>3</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> </table:table-row> @@ -3302,10 +3916,10 @@ <table:table-cell office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="4" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="4" calcext:value-type="float"> <text:p>4</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> </table:table-row> @@ -3314,10 +3928,10 @@ <table:table-cell office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="1" table:formula="of:=MOD([.B16];[.C15:.D15])" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" table:number-matrix-columns-spanned="2" table:number-matrix-rows-spanned="1" table:formula="of:=MOD([.B16];[.C15:.D15])" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="5"/> @@ -3325,10 +3939,10 @@ <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float"> <text:p>9</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="4" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="4" calcext:value-type="float"> <text:p>4</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41" office:value-type="float" office:value="3" calcext:value-type="float"> + <table:table-cell table:style-name="ce107" office:value-type="float" office:value="3" calcext:value-type="float"> <text:p>3</text:p> </table:table-cell> </table:table-row> @@ -3339,7 +3953,7 @@ <table:table-row table:style-name="ro2"> <table:table-cell table:style-name="Default"/> <table:table-cell table:number-columns-repeated="9"/> - <table:table-cell table:style-name="ce40" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="2" table:number-rows-spanned="1"> + <table:table-cell table:style-name="ce87" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="2" table:number-rows-spanned="1"> <text:p>Non-exaustive list…</text:p> </table:table-cell> <table:covered-table-cell/> @@ -3350,7 +3964,7 @@ <table:table-cell table:number-columns-repeated="12"/> </table:table-row> <table:table-row table:style-name="ro2"> - <table:table-cell table:style-name="ce31" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce98" office:value-type="string" calcext:value-type="string"> <text:p>Correct</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="12"/> @@ -3360,7 +3974,7 @@ <text:p>TRUE</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:number-columns-repeated="2" table:style-name="ce42" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:number-columns-repeated="2" table:style-name="ce108" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="9"/> @@ -3370,10 +3984,10 @@ <text:p>TRUE</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="9"/> @@ -3383,10 +3997,10 @@ <text:p>TRUE</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" 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="ce42" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="9"/> @@ -3516,10 +4130,10 @@ <text:p>TRUE</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="8" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="9" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="9" calcext:value-type="float"> <text:p>9</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="9"/> @@ -3529,10 +4143,10 @@ <text:p>TRUE</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="8" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="9" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="9" calcext:value-type="float"> <text:p>9</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="9"/> @@ -3542,10 +4156,10 @@ <text:p>TRUE</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="10" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="10" calcext:value-type="float"> <text:p>10</text:p> </table:table-cell> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="9" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="9" calcext:value-type="float"> <text:p>9</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="9"/> @@ -3573,7 +4187,7 @@ <text:p>TRUE</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:number-columns-repeated="2" table:style-name="ce42" office:value-type="float" office:value="6" calcext:value-type="float"> + <table:table-cell table:number-columns-repeated="2" table:style-name="ce108" office:value-type="float" office:value="6" calcext:value-type="float"> <text:p>6</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="9"/> @@ -3583,10 +4197,10 @@ <text:p>TRUE</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="8" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="6" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="6" calcext:value-type="float"> <text:p>6</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="9"/> @@ -3596,10 +4210,10 @@ <text:p>TRUE</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="8" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="9" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="9" calcext:value-type="float"> <text:p>9</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="9"/> @@ -3627,10 +4241,10 @@ <text:p>TRUE</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="3" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="3" calcext:value-type="float"> <text:p>3</text:p> </table:table-cell> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="9"/> @@ -3640,10 +4254,10 @@ <text:p>TRUE</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="4" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="4" calcext:value-type="float"> <text:p>4</text:p> </table:table-cell> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="9"/> @@ -3653,10 +4267,10 @@ <text:p>TRUE</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="4" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="4" calcext:value-type="float"> <text:p>4</text:p> </table:table-cell> - <table:table-cell table:style-name="ce42" office:value-type="float" office:value="3" calcext:value-type="float"> + <table:table-cell table:style-name="ce108" office:value-type="float" office:value="3" calcext:value-type="float"> <text:p>3</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="9"/> @@ -3681,7 +4295,7 @@ </table:table-row> </table:table> <table:table table:name="'file:///home/zdenek/Dokumenty/LO/sc-unit-test/Project%20Calc%20functions%20tests/fods/mod.fods/mod.fods/log10.fods/log.fods/ln.fods/bitxor.fods/bitxor.fods/bitor.fods/bitand.fods/bitand.fods/atan.fods/asinh.fods/asin.fods/acos.fods/abs.fods/abs.fods/xor.fods/xor.fods/not.fods/ifna.fods/ifna.fods/iferror.fods/iferror.fods/if.fods/and.fods/and.fods/and.fods/and.fods/type.fods/isna.fods/isna.fods/islogical.fods/isformula.fods/iserr.fods/isblank.fods/info.fods/formula.fods/formula.fods/current.fods/cell.fods/cell.fods/minute.fods/minute.fods/year.fods/function_based_test_Example.fods/function_based_test_Example_reference.fods'#Sheet2" table:print="false" table:style-name="ta_extref"> - <table:table-source xlink:type="simple" xlink:href="mod.fods/log10.fods/log.fods/ln.fods/bitxor.fods/bitxor.fods/bitor.fods/bitand.fods/bitand.fods/atan.fods/asinh.fods/asin.fods/acos.fods/abs.fods/abs.fods/xor.fods/xor.fods/not.fods/ifna.fods/ifna.fods/iferror.fods/iferror.fods/if.fods/and.fods/and.fods/and.fods/and.fods/type.fods/isna.fods/isna.fods/islogical.fods/isformula.fods/iserr.fods/isblank.fods/info.fods/formula.fods/formula.fods/current.fods/cell.fods/cell.fods/minute.fods/minute.fods/year.fods/function_based_test_Example.fods/function_based_test_Example_reference.fods" table:table-name="Sheet2" table:mode="copy-results-only"/> + <table:table-source xlink:type="simple" xlink:href="/home/zdenek/Dokumenty/LO/sc-unit-test/Project%20Calc%20functions%20tests/fods/mod.fods/mod.fods/log10.fods/log.fods/ln.fods/bitxor.fods/bitxor.fods/bitor.fods/bitand.fods/bitand.fods/atan.fods/asinh.fods/asin.fods/acos.fods/abs.fods/abs.fods/xor.fods/xor.fods/not.fods/ifna.fods/ifna.fods/iferror.fods/iferror.fods/if.fods/and.fods/and.fods/and.fods/and.fods/type.fods/isna.fods/isna.fods/islogical.fods/isformula.fods/iserr.fods/isblank.fods/info.fods/formula.fods/formula.fods/current.fods/cell.fods/cell.fods/minute.fods/minute.fods/year.fods/function_based_test_Example.fods/function_based_test_Example_reference.fods" table:table-name="Sheet2" table:mode="copy-results-only"/> <table:table-column table:number-columns-repeated="8"/> <table:table-row table:number-rows-repeated="2"> <table:table-cell table:number-columns-repeated="8"/> @@ -3694,7 +4308,7 @@ </table:table-row> </table:table> <table:table table:name="'file:///home/zdenek/Dokumenty/LO/sc-unit-test/Project%20Calc%20functions%20tests/fods/mod.fods/mod.fods/log10.fods/log.fods/ln.fods/bitxor.fods/bitxor.fods/bitor.fods/bitand.fods/bitand.fods/atan.fods/asinh.fods/asin.fods/acos.fods/abs.fods/abs.fods/xor.fods/xor.fods/not.fods/ifna.fods/ifna.fods/iferror.fods/iferror.fods/if.fods/and.fods/and.fods/and.fods/and.fods/type.fods/isna.fods/isna.fods/islogical.fods/isformula.fods/sc-unit-test/information-functions.ods'#Information" table:print="false" table:style-name="ta_extref"> - <table:table-source xlink:type="simple" xlink:href="mod.fods/log10.fods/log.fods/ln.fods/bitxor.fods/bitxor.fods/bitor.fods/bitand.fods/bitand.fods/atan.fods/asinh.fods/asin.fods/acos.fods/abs.fods/abs.fods/xor.fods/xor.fods/not.fods/ifna.fods/ifna.fods/iferror.fods/iferror.fods/if.fods/and.fods/and.fods/and.fods/and.fods/type.fods/isna.fods/isna.fods/islogical.fods/isformula.fods/sc-unit-test/information-functions.ods" table:table-name="Information" table:mode="copy-results-only"/> + <table:table-source xlink:type="simple" xlink:href="/home/zdenek/Dokumenty/LO/sc-unit-test/Project%20Calc%20functions%20tests/fods/mod.fods/mod.fods/log10.fods/log.fods/ln.fods/bitxor.fods/bitxor.fods/bitor.fods/bitand.fods/bitand.fods/atan.fods/asinh.fods/asin.fods/acos.fods/abs.fods/abs.fods/xor.fods/xor.fods/not.fods/ifna.fods/ifna.fods/iferror.fods/iferror.fods/if.fods/and.fods/and.fods/and.fods/and.fods/type.fods/isna.fods/isna.fods/islogical.fods/isformula.fods/sc-unit-test/information-functions.ods" table:table-name="Information" table:mode="copy-results-only"/> <table:table-column table:number-columns-repeated="15"/> <table:table-row table:number-rows-repeated="6"> <table:table-cell table:number-columns-repeated="15"/> diff --git a/sc/source/core/tool/interpr2.cxx b/sc/source/core/tool/interpr2.cxx index 19a68ac74ce2..62627c330e88 100644 --- a/sc/source/core/tool/interpr2.cxx +++ b/sc/source/core/tool/interpr2.cxx @@ -2333,21 +2333,20 @@ void ScInterpreter::ScMod() { if ( MustHaveParamCount( GetByte(), 2 ) ) { - double fVal2 = GetDouble(); // Denominator - double fVal1 = GetDouble(); // Numerator - if (fVal2 == floor(fVal2)) // a pure integral number stored in double + double fDenom = GetDouble(); // Denominator + if ( fDenom == 0.0 ) { - double fResult = fmod(fVal1,fVal2); - if ( (fResult != 0.0) && - ((fVal1 > 0.0 && fVal2 < 0.0) || (fVal1 < 0.0 && fVal2 > 0.0))) - fResult += fVal2 ; - PushDouble( fResult ); + PushIllegalArgument(); + return; } + double fNum = GetDouble(); // Numerator + double fRes = ::rtl::math::approxSub( fNum, + ::rtl::math::approxFloor( fNum / fDenom ) * fDenom ); + if ( ( fDenom > 0 && fRes >= 0 && fRes < fDenom ) || + ( fDenom < 0 && fRes <= 0 && fRes > fDenom ) ) + PushDouble( fRes ); else - { - PushDouble( ::rtl::math::approxSub( fVal1, - ::rtl::math::approxFloor(fVal1 / fVal2) * fVal2)); - } + PushError( FormulaError::NoValue ); } } |