diff options
author | Andras Timar <andras.timar@collabora.com> | 2025-02-03 14:44:10 +0100 |
---|---|---|
committer | Andras Timar <andras.timar@collabora.com> | 2025-02-03 17:46:27 +0100 |
commit | a6c1ed0e9c3bbd87d483ecb7c5d667418ffb650e (patch) | |
tree | 8025b9eaedd9be10f70faed28c9b9173607b3042 /sc | |
parent | afc90ce5850249bfb043ab274e6838c0c0010e06 (diff) |
Fixed WEEKNUMBER test sheet, ISERROR(a13ú) did not seem right
Change-Id: I01ccd512d38c887bfcf834ef2fbfcf46a2e98246
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/181047
Tested-by: Jenkins
Reviewed-by: Andras Timar <andras.timar@collabora.com>
Diffstat (limited to 'sc')
-rw-r--r-- | sc/qa/unit/data/functions/date_time/fods/weeknum.fods | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/sc/qa/unit/data/functions/date_time/fods/weeknum.fods b/sc/qa/unit/data/functions/date_time/fods/weeknum.fods index a4e1c08ebbd6..655ca400fef9 100644 --- a/sc/qa/unit/data/functions/date_time/fods/weeknum.fods +++ b/sc/qa/unit/data/functions/date_time/fods/weeknum.fods @@ -825,7 +825,7 @@ <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>Err</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" table:formula="of:=ISERROR(a13ú)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce23" table:formula="of:=ISERROR([.A12])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>PRAVDA</text:p> </table:table-cell> <table:table-cell table:style-name="ce24" table:formula="of:=FORMULA([.A12])" office:value-type="string" office:string-value="=WEEKNUM(K10;K1:K2)" calcext:value-type="string"> @@ -840,7 +840,7 @@ <table:table-cell office:value-type="float" office:value="30" calcext:value-type="float"> <text:p>30</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" table:formula="of:=ISERROR(a13ú)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce23" table:formula="of:=[.A13]=[.B13]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>PRAVDA</text:p> </table:table-cell> <table:table-cell table:style-name="ce24" table:formula="of:=FORMULA([.A13])" office:value-type="string" office:string-value="=WEEKNUM($K$9;11)" calcext:value-type="string"> @@ -855,7 +855,7 @@ <table:table-cell office:value-type="float" office:value="30" calcext:value-type="float"> <text:p>30</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" table:formula="of:=ISERROR(a13ú)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce23" table:formula="of:=[.A14]=[.B14]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>PRAVDA</text:p> </table:table-cell> <table:table-cell table:style-name="ce24" table:formula="of:=FORMULA([.A14])" office:value-type="string" office:string-value="=WEEKNUM($K$9;12)" calcext:value-type="string"> @@ -871,7 +871,7 @@ <table:table-cell office:value-type="float" office:value="30" calcext:value-type="float"> <text:p>30</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" table:formula="of:=ISERROR(a13ú)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce23" table:formula="of:=[.A15]=[.B15]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>PRAVDA</text:p> </table:table-cell> <table:table-cell table:style-name="ce24" table:formula="of:=FORMULA([.A15])" office:value-type="string" office:string-value="=WEEKNUM($K$9;13)" calcext:value-type="string"> @@ -886,7 +886,7 @@ <table:table-cell office:value-type="float" office:value="30" calcext:value-type="float"> <text:p>30</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" table:formula="of:=ISERROR(a13ú)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce23" table:formula="of:=[.A16]=[.B16]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>PRAVDA</text:p> </table:table-cell> <table:table-cell table:style-name="ce24" table:formula="of:=FORMULA([.A16])" office:value-type="string" office:string-value="=WEEKNUM($K$9;14)" calcext:value-type="string"> @@ -901,7 +901,7 @@ <table:table-cell office:value-type="float" office:value="30" calcext:value-type="float"> <text:p>30</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" table:formula="of:=ISERROR(a13ú)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce23" table:formula="of:=[.A17]=[.B17]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>PRAVDA</text:p> </table:table-cell> <table:table-cell table:style-name="ce24" table:formula="of:=FORMULA([.A17])" office:value-type="string" office:string-value="=WEEKNUM($K$9;15)" calcext:value-type="string"> @@ -919,7 +919,7 @@ <table:table-cell office:value-type="float" office:value="31" calcext:value-type="float"> <text:p>31</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" table:formula="of:=ISERROR(a13ú)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce23" table:formula="of:=[.A18]=[.B18]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>PRAVDA</text:p> </table:table-cell> <table:table-cell table:style-name="ce24" table:formula="of:=FORMULA([.A18])" office:value-type="string" office:string-value="=WEEKNUM($K$9;16)" calcext:value-type="string"> @@ -934,7 +934,7 @@ <table:table-cell office:value-type="float" office:value="31" calcext:value-type="float"> <text:p>31</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" table:formula="of:=ISERROR(a13ú)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce23" table:formula="of:=[.A19]=[.B19]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>PRAVDA</text:p> </table:table-cell> <table:table-cell table:style-name="ce24" table:formula="of:=FORMULA([.A19])" office:value-type="string" office:string-value="=WEEKNUM($K$9;17)" calcext:value-type="string"> @@ -949,7 +949,7 @@ <table:table-cell office:value-type="float" office:value="29" calcext:value-type="float"> <text:p>29</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" table:formula="of:=ISERROR(a13ú)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce23" table:formula="of:=[.A20]=[.B20]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>PRAVDA</text:p> </table:table-cell> <table:table-cell table:style-name="ce24" table:formula="of:=FORMULA([.A20])" office:value-type="string" office:string-value="=WEEKNUM($K$9;21)" calcext:value-type="string"> @@ -964,7 +964,7 @@ <table:table-cell office:value-type="float" office:value="29" calcext:value-type="float"> <text:p>29</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" table:formula="of:=ISERROR(a13ú)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce23" table:formula="of:=[.A21]=[.B21]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>PRAVDA</text:p> </table:table-cell> <table:table-cell table:style-name="ce24" table:formula="of:=FORMULA([.A21])" office:value-type="string" office:string-value="=WEEKNUM($K$9;150)" calcext:value-type="string"> @@ -1008,4 +1008,4 @@ </table:named-expressions> </office:spreadsheet> </office:body> -</office:document>
\ No newline at end of file +</office:document> |