commit d8886a051abcb5abf52038bf3e5bced9f10f28af
author Eike Rathke <erack@redhat.com> Wed Jan 16 21:31:58 2019 +0100
committer Eike Rathke <erack@redhat.com> Thu Jan 17 12:38:18 2019 +0100
tree 8c593c2f5d613c19faa78893fa51b640ea7c00de
parent 09513e0d5bfa00145374d195d605c33a8bc7113b

Add tests for FREQUENCY() ReferenceOrForceArray, ForceArrayReturn, tdf#122301

Change-Id: I36b2bda0fcb0bfd14e62c2529ecb79e11eab34f2
Reviewed-on: https://gerrit.libreoffice.org/66482
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Jenkins

sc/qa/unit/data/functions/array/fods/frequency.fods

diff --git a/sc/qa/unit/data/functions/array/fods/frequency.fods b/sc/qa/unit/data/functions/array/fods/frequency.fods
index 22ad1cf..222c538 100644
--- a/sc/qa/unit/data/functions/array/fods/frequency.fods
+++ b/sc/qa/unit/data/functions/array/fods/frequency.fods
@@ -3475,27 +3475,57 @@
     <table:table-cell table:number-columns-repeated="2"/>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:number-columns-repeated="2"/>
     <table:table-cell table:style-name="ce15"/>
     <table:table-cell table:number-columns-repeated="22"/>
     <table:table-cell table:formula="of:=SUM(ABS(FREQUENCY([.K40:.K59];[.L40:.L46])))" office:value-type="float" office:value="20" calcext:value-type="float">
      <text:p>20</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="float" office:value="20" calcext:value-type="float">
      <text:p>20</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce14" table:formula="of:=ROUND([.A61];12)=ROUND([.B61];12)" 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="ce17" table:formula="of:=FORMULA([.A61])" office:value-type="string" office:string-value="=SUM(ABS(FREQUENCY(K40:K59,L40:L46)))" calcext:value-type="string">
      <text:p>=SUM(ABS(FREQUENCY(K40:K59,L40:L46)))</text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="21"/>
     <table:table-cell office:value-type="float" office:value="57" calcext:value-type="float">
      <text:p>57</text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="2"/>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:number-columns-repeated="2"/>
     <table:table-cell table:style-name="ce15"/>
     <table:table-cell table:number-columns-repeated="22"/>
     <table:table-cell table:formula="of:=SUM(ABS(FREQUENCY([.K40:.K59];[.L40:.L46])+ABS([.M40:.M47])))" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#VALUE!</text:p>
     </table:table-cell>
     <table:table-cell table:formula="of:=#VALUE!" office:value-type="string" office:string-value="" calcext:value-type="error">
      <text:p>#VALUE!</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce14" table:formula="of:=ISERROR([.A62])" 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="ce17" table:formula="of:=FORMULA([.A62])" office:value-type="string" office:string-value="=SUM(ABS(FREQUENCY(K40:K59,L40:L46)+ABS(M40:M47)))" calcext:value-type="string">
      <text:p>=SUM(ABS(FREQUENCY(K40:K59,L40:L46)+ABS(M40:M47)))</text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="21"/>
     <table:table-cell office:value-type="float" office:value="58" calcext:value-type="float">
      <text:p>58</text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="2"/>
    </table:table-row>
    <table:table-row table:style-name="ro2">
     <table:table-cell table:number-columns-repeated="2"/>
     <table:table-cell table:style-name="ce15"/>
     <table:table-cell table:number-columns-repeated="22"/>
     <table:table-cell table:formula="of:=MAX(FREQUENCY(ROW([.K40:.K59]);([.K40:.K59]&lt;12)*ROW([.K40:.K59])))" office:value-type="float" office:value="9" calcext:value-type="float">
      <text:p>9</text:p>
     </table:table-cell>
     <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float">
      <text:p>9</text:p>
     </table:table-cell>
     <table:table-cell table:style-name="ce14" table:formula="of:=ROUND([.A63];12)=ROUND([.B63];12)" 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="ce17" table:formula="of:=FORMULA([.A63])" office:value-type="string" office:string-value="=MAX(FREQUENCY(ROW(K40:K59),(K40:K59&lt;12)*ROW(K40:K59)))" calcext:value-type="string">
      <text:p>=MAX(FREQUENCY(ROW(K40:K59),(K40:K59&lt;12)*ROW(K40:K59)))</text:p>
     </table:table-cell>
     <table:table-cell table:number-columns-repeated="21"/>
     <table:table-cell office:value-type="float" office:value="79" calcext:value-type="float">
      <text:p>79</text:p>
     </table:table-cell>
@@ -8375,4 +8405,4 @@
   </table:named-expressions>
  </office:spreadsheet>
 </office:body>
</office:document>
\ No newline at end of file
</office:document>