commit d6886c340d1c940a4b3ab7e7ca499fff63183845
author Xisco Fauli <xiscofauli@libreoffice.org> Fri Mar 05 00:49:50 2021 +0100
committer Xisco Fauli <xiscofauli@libreoffice.org> Fri Mar 05 11:45:16 2021 +0100
tree 937d2b4f93f52ebeb8a103cbe541c34367473720
parent 41dd2d810f0535f85cbaaefbf7ce9f81d4da1609

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>

sc/qa/unit/data/functions/logical/fods/not.fods

diff --git a/sc/qa/unit/data/functions/logical/fods/not.fods b/sc/qa/unit/data/functions/logical/fods/not.fods
index e755ad3..1c6d7aa 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"/>