[Libreoffice-commits] core.git: sc/qa

Xisco Fauli (via logerrit) logerrit at kemper.freedesktop.org
Fri Jan 8 20:29:50 UTC 2021


 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 <xiscofauli at libreoffice.org>
AuthorDate: Fri Jan 8 15:03:46 2021 +0100
Commit:     Xisco Fauli <xiscofauli at 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 <xiscofauli at 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/>


More information about the Libreoffice-commits mailing list