diff options
| author | Xisco Fauli <xiscofauli@libreoffice.org> | 2021-03-05 00:49:50 +0100 |
|---|---|---|
| committer | Xisco Fauli <xiscofauli@libreoffice.org> | 2021-03-05 11:45:16 +0100 |
| commit | d6886c340d1c940a4b3ab7e7ca499fff63183845 (patch) | |
| tree | 937d2b4f93f52ebeb8a103cbe541c34367473720 /sc | |
| parent | 41dd2d810f0535f85cbaaefbf7ce9f81d4da1609 (diff) | |
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>
Diffstat (limited to 'sc')
| -rw-r--r-- | sc/qa/unit/data/functions/logical/fods/not.fods | 60 |
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"/> |