commit a062bceb2509d227cec86845af680a4b69d42df3
author Eike Rathke <erack@redhat.com> Sat Apr 15 18:53:20 2023 +0200
committer Eike Rathke <erack@redhat.com> Sat Apr 15 21:14:35 2023 +0200
tree a39adc5a427c948137b777a292ecc66242d17a2a
parent e68cd91651c53c5c228d84582b1062d8fb9a7077

Add ROUNDSIG samples to unit test, tdf#138220 tdf#105931

Change-Id: I0bab920c78ff6d02382b9a314982a2f3d436b35a
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/150442
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Jenkins

sc/qa/unit/data/functions/mathematical/fods/roundsig.fods

diff --git a/sc/qa/unit/data/functions/mathematical/fods/roundsig.fods b/sc/qa/unit/data/functions/mathematical/fods/roundsig.fods
index 8656625..148cd2c 100644
--- a/sc/qa/unit/data/functions/mathematical/fods/roundsig.fods
+++ b/sc/qa/unit/data/functions/mathematical/fods/roundsig.fods
@@ -4605,12 +4605,27 @@
     <table:table-cell table:style-name="ce70"/>
     <table:table-cell table:number-columns-repeated="5"/>
    </table:table-row>
    <table:table-row table:style-name="ro6" table:number-rows-repeated="3">
     <table:table-cell table:style-name="ce70"/>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:formula="of:=ORG.LIBREOFFICE.ROUNDSIG([.F27];[.G27])" office:value-type="float" office:value="-999.13" calcext:value-type="float">
      <text:p>-999.13</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="float" office:value="-999.13" calcext:value-type="float">
      <text:p>-999.13</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce92" table:formula="of:=[.A27]=[.B27]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>TRUE</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=FORMULA([.A27])" office:value-type="string" office:string-value="=ROUNDSIG(F27;G27)" calcext:value-type="string">
      <text:p>=ROUNDSIG(F27;G27)</text:p>
     </table:table-cell>
     <table:table-cell/>
     <table:table-cell table:style-name="ce73"/>
     <table:table-cell table:style-name="ce75" table:number-columns-repeated="2"/>
     <table:table-cell table:number-columns-repeated="6"/>
     <table:table-cell office:value-type="float" office:value="-999.13" calcext:value-type="float">
      <text:p>-999.13</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="float" office:value="12" calcext:value-type="float">
      <text:p>12</text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="4"/>
     <table:table-cell table:style-name="ce81"/>
     <table:table-cell/>
     <table:table-cell table:style-name="ce82"/>
@@ -4623,12 +4638,27 @@
     <table:table-cell table:style-name="ce70"/>
     <table:table-cell table:number-columns-repeated="5"/>
    </table:table-row>
    <table:table-row table:style-name="ro6" table:number-rows-repeated="3">
     <table:table-cell table:style-name="ce70"/>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:formula="of:=ORG.LIBREOFFICE.RAWSUBTRACT(ORG.LIBREOFFICE.ROUNDSIG([.F28];[.G28]);[.F28])" office:value-type="float" office:value="0" calcext:value-type="float">
      <text:p>0</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float">
      <text:p>0</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce92" table:formula="of:=[.A28]=[.B28]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
      <text:p>TRUE</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=FORMULA([.A28])" office:value-type="string" office:string-value="=RAWSUBTRACT(ROUNDSIG(F28;G28);F28)" calcext:value-type="string">
      <text:p>=RAWSUBTRACT(ROUNDSIG(F28;G28);F28)</text:p>
     </table:table-cell>
     <table:table-cell/>
     <table:table-cell table:style-name="ce72"/>
     <table:table-cell table:style-name="ce75" table:number-columns-repeated="2"/>
     <table:table-cell table:number-columns-repeated="6"/>
     <table:table-cell office:value-type="float" office:value="-999.13" calcext:value-type="float">
      <text:p>-999.13</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="float" office:value="12" calcext:value-type="float">
      <text:p>12</text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="4"/>
     <table:table-cell table:style-name="ce81"/>
     <table:table-cell/>
     <table:table-cell table:style-name="ce82"/>