summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sc/qa/unit/data/functions/logical/fods/not.fods60
1 files changed, 55 insertions, 5 deletions
diff --git a/sc/qa/unit/data/functions/logical/fods/not.fods b/sc/qa/unit/data/functions/logical/fods/not.fods
index e755ad36f7a7..1c6d7aad5811 100644
--- a/sc/qa/unit/data/functions/logical/fods/not.fods
+++ b/sc/qa/unit/data/functions/logical/fods/not.fods
@@ -1945,11 +1945,19 @@
<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="ce21"/>
- <table:table-cell table:style-name="ce27"/>
- <table:table-cell table:style-name="ce29"/>
- <table:table-cell table:number-columns-repeated="4"/>
+ <table:table-cell table:style-name="ce11" table:formula="of:=NOT(0)NOT(0)" office:value-type="string" office:string-value="" calcext:value-type="error">
+ <text:p>Chyba:511</text:p>
+ </table:table-cell>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>error</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce21" table:formula="of:=ISERROR([.A11])" 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="ce27" table:formula="of:=FORMULA([.A11])" office:value-type="string" office:string-value="=NOT(0)NOT(0)" calcext:value-type="string">
+ <text:p>=NOT(0)NOT(0)</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="5"/>
<table:table-cell table:formula="of:=PI()" office:value-type="float" office:value="3.14159265358979" calcext:value-type="float">
<text:p>3.1415926536</text:p>
</table:table-cell>
@@ -1957,6 +1965,48 @@
<table:table-cell/>
</table:table-row>
<table:table-row table:style-name="ro2">
+ <table:table-cell table:style-name="ce11" table:formula="of:=NOT(0)NOT(1)" office:value-type="string" office:string-value="" calcext:value-type="error">
+ <text:p>Chyba:511</text:p>
+ </table:table-cell>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>error</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce21" table:formula="of:=ISERROR([.A12])" 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="ce27" table:formula="of:=FORMULA([.A12])" office:value-type="string" office:string-value="=NOT(0)NOT(1)" calcext:value-type="string">
+ <text:p>=NOT(0)NOT(1)</text:p>
+ </table:table-cell>
+ </table:table-row>
+ <table:table-row table:style-name="ro2">
+ <table:table-cell table:style-name="ce11" table:formula="of:=NOT(1)NOT(0)" office:value-type="string" office:string-value="" calcext:value-type="error">
+ <text:p>Chyba:511</text:p>
+ </table:table-cell>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>error</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce21" table:formula="of:=ISERROR([.A13])" 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="ce27" table:formula="of:=FORMULA([.A13])" office:value-type="string" office:string-value="=NOT(1)NOT(0)" calcext:value-type="string">
+ <text:p>=NOT(1)NOT(0)</text:p>
+ </table:table-cell>
+ </table:table-row>
+ <table:table-row table:style-name="ro2">
+ <table:table-cell table:style-name="ce11" table:formula="of:=NOT(1)NOT(1)" office:value-type="string" office:string-value="" calcext:value-type="error">
+ <text:p>Chyba:511</text:p>
+ </table:table-cell>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>error</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce21" table:formula="of:=ISERROR([.A14])" 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="ce27" table:formula="of:=FORMULA([.A14])" office:value-type="string" office:string-value="=NOT(1)NOT(1)" calcext:value-type="string">
+ <text:p>=NOT(1)NOT(1)</text:p>
+ </table:table-cell>
+ </table:table-row>
+ <table:table-row table:style-name="ro2">
<table:table-cell/>
<table:table-cell table:style-name="ce19"/>
<table:table-cell table:style-name="ce21"/>