tdf#115879: sc_logical_functions: Add function test

Change-Id: Ia6b230564911f05b1d19669f4137fc3892619a4a
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/111983
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofauli@libreoffice.org>

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"/>