sc/qa/unit/data/functions/addin/fods/dec2bin.fods | 52 ++++++++++++++++++++++
sc/qa/unit/data/functions/addin/fods/dec2oct.fods | 52 ++++++++++++++++++++++
2 files changed, 104 insertions(+)
New commits:
commit ef1b6642feb39aab502c90436286aeee9a7fa241
Author: Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Fri Jan 8 15:03:46 2021 +0100
Commit: Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Fri Jan 8 21:29:12 2021 +0100
tdf#139173: sc_addin_functions_test: Add dec2bin and dec2oct functions
Change-Id: Ic5cf78dc82bf68d8b406b85619ef79e94d56f079
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/108979
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofa...@libreoffice.org>
diff --git a/sc/qa/unit/data/functions/addin/fods/dec2bin.fods
b/sc/qa/unit/data/functions/addin/fods/dec2bin.fods
index 164c42ef83a7..a44bbc6b2d7c 100644
--- a/sc/qa/unit/data/functions/addin/fods/dec2bin.fods
+++ b/sc/qa/unit/data/functions/addin/fods/dec2bin.fods
@@ -3920,6 +3920,58 @@
<table:table-cell table:style-name="ce12"
table:number-columns-repeated="4"/>
<table:table-cell table:number-columns-repeated="2"/>
</table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell table:style-name="ce10"
table:formula="of:=DEC2BIN(2^9)" office:value-type="string"
office:string-value="" calcext:value-type="error">
+ <text:p>Err:502</text:p>
+ </table:table-cell>
+ <table:table-cell table:formula="of:#ERR502!" office:value-type="string"
office:string-value="" calcext:value-type="error">
+ <text:p>Err:502</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce28"
table:formula="of:=ISERROR([.A19])" 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="ce32"
table:formula="of:=FORMULA([.A19])" office:value-type="string"
office:string-value="=DEC2BIN(2^9)" calcext:value-type="string">
+ <text:p>=DEC2BIN(2^9)</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="4"/>
+ <table:table-cell table:style-name="ce14"/>
+ <table:table-cell table:style-name="ce22"/>
+ <table:table-cell table:style-name="ce47"
table:number-columns-repeated="2"/>
+ <table:table-cell table:style-name="ce14"/>
+ <table:table-cell table:style-name="ce55"/>
+ <table:table-cell/>
+ <table:table-cell table:style-name="ce12"
table:number-columns-repeated="2"/>
+ <table:table-cell table:number-columns-repeated="3"/>
+ <table:table-cell table:style-name="ce55"/>
+ <table:table-cell table:style-name="ce12"
table:number-columns-repeated="4"/>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell table:style-name="ce10" table:formula="of:=DEC2BIN(-2^9
- 1)" office:value-type="string" office:string-value=""
calcext:value-type="error">
+ <text:p>Err:502</text:p>
+ </table:table-cell>
+ <table:table-cell table:formula="of:#ERR502!" office:value-type="string"
office:string-value="" calcext:value-type="error">
+ <text:p>Err:502</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce28"
table:formula="of:=ISERROR([.A20])" 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="ce32"
table:formula="of:=FORMULA([.A20])" office:value-type="string"
office:string-value="=DEC2BIN(-2^9 - 1)" calcext:value-type="string">
+ <text:p>=DEC2BIN(-2^9 - 1)</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="4"/>
+ <table:table-cell table:style-name="ce14"/>
+ <table:table-cell table:style-name="ce22"/>
+ <table:table-cell table:style-name="ce47"
table:number-columns-repeated="2"/>
+ <table:table-cell table:style-name="ce14"/>
+ <table:table-cell table:style-name="ce55"/>
+ <table:table-cell/>
+ <table:table-cell table:style-name="ce12"
table:number-columns-repeated="2"/>
+ <table:table-cell table:number-columns-repeated="3"/>
+ <table:table-cell table:style-name="ce55"/>
+ <table:table-cell table:style-name="ce12"
table:number-columns-repeated="4"/>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
<table:table-row table:style-name="ro5">
<table:table-cell table:style-name="ce10"/>
<table:table-cell/>
diff --git a/sc/qa/unit/data/functions/addin/fods/dec2oct.fods
b/sc/qa/unit/data/functions/addin/fods/dec2oct.fods
index da4b08abeb6c..b9a9fd5303a4 100644
--- a/sc/qa/unit/data/functions/addin/fods/dec2oct.fods
+++ b/sc/qa/unit/data/functions/addin/fods/dec2oct.fods
@@ -4180,6 +4180,58 @@
<table:table-cell table:style-name="ce12"
table:number-columns-repeated="4"/>
<table:table-cell table:number-columns-repeated="2"/>
</table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell table:style-name="ce10"
table:formula="of:=DEC2OCT(2^29)" office:value-type="string"
office:string-value="" calcext:value-type="error">
+ <text:p>Err:502</text:p>
+ </table:table-cell>
+ <table:table-cell table:formula="of:#ERR502!" office:value-type="string"
office:string-value="" calcext:value-type="error">
+ <text:p>Err:502</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce28"
table:formula="of:=ISERROR([.A29])" 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="ce32"
table:formula="of:=FORMULA([.A29])" office:value-type="string"
office:string-value="=DEC2OCT(2^29)" calcext:value-type="string">
+ <text:p>=DEC2OCT(2^29)</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="4"/>
+ <table:table-cell table:style-name="ce14"/>
+ <table:table-cell table:style-name="ce22"/>
+ <table:table-cell table:style-name="ce49"
table:number-columns-repeated="2"/>
+ <table:table-cell table:style-name="ce14"/>
+ <table:table-cell table:style-name="ce55"/>
+ <table:table-cell/>
+ <table:table-cell table:style-name="ce12"
table:number-columns-repeated="2"/>
+ <table:table-cell table:number-columns-repeated="3"/>
+ <table:table-cell table:style-name="ce55"/>
+ <table:table-cell table:style-name="ce12"
table:number-columns-repeated="4"/>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
+ <table:table-row table:style-name="ro5">
+ <table:table-cell table:style-name="ce10"
table:formula="of:=DEC2OCT(-2^29 - 1)" office:value-type="string"
office:string-value="" calcext:value-type="error">
+ <text:p>Err:502</text:p>
+ </table:table-cell>
+ <table:table-cell table:formula="of:#ERR502!" office:value-type="string"
office:string-value="" calcext:value-type="error">
+ <text:p>Err:502</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce28"
table:formula="of:=ISERROR([.A30])" 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="ce32"
table:formula="of:=FORMULA([.A30])" office:value-type="string"
office:string-value="=DEC2OCT(-2^29 - 1)" calcext:value-type="string">
+ <text:p>=DEC2OCT(-2^29 - 1)</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="4"/>
+ <table:table-cell table:style-name="ce14"/>
+ <table:table-cell table:style-name="ce22"/>
+ <table:table-cell table:style-name="ce49"
table:number-columns-repeated="2"/>
+ <table:table-cell table:style-name="ce14"/>
+ <table:table-cell table:style-name="ce55"/>
+ <table:table-cell/>
+ <table:table-cell table:style-name="ce12"
table:number-columns-repeated="2"/>
+ <table:table-cell table:number-columns-repeated="3"/>
+ <table:table-cell table:style-name="ce55"/>
+ <table:table-cell table:style-name="ce12"
table:number-columns-repeated="4"/>
+ <table:table-cell table:number-columns-repeated="2"/>
+ </table:table-row>
<table:table-row table:style-name="ro5" table:number-rows-repeated="5">
<table:table-cell table:style-name="ce12"/>
<table:table-cell/>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
