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 <xiscofauli@libreoffice.org>

2 files changed, 104 insertions, 0 deletions

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
@@ -3921,6 +3921,58 @@
      <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/>
      <table:table-cell table:style-name="ce28"/>
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/>