summaryrefslogtreecommitdiff
path: root/sc
diff options
context:
space:
mode:
authorXisco Fauli <xiscofauli@libreoffice.org>2021-10-20 16:18:11 +0200
committerXisco Fauli <xiscofauli@libreoffice.org>2021-10-20 18:26:32 +0200
commit56d750a5c0f857aedf036f0cd49cfad2de9238ae (patch)
tree0bfe7c5af0c9e482ac26833826af0d1894f67bcb /sc
parent5d05355039ee11f4ba6429d4781d030900c3a829 (diff)
tdf#145235: sc_text_functions_test: Add unittest
Change-Id: I27e04ab776923c300831062bbeede8d831a54245 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/123895 Tested-by: Jenkins Reviewed-by: Xisco Fauli <xiscofauli@libreoffice.org>
Diffstat (limited to 'sc')
-rw-r--r--sc/qa/unit/data/functions/text/fods/textjoin.fods25
1 files changed, 25 insertions, 0 deletions
diff --git a/sc/qa/unit/data/functions/text/fods/textjoin.fods b/sc/qa/unit/data/functions/text/fods/textjoin.fods
index 0a0d93393e22..3f8062bb5802 100644
--- a/sc/qa/unit/data/functions/text/fods/textjoin.fods
+++ b/sc/qa/unit/data/functions/text/fods/textjoin.fods
@@ -1419,6 +1419,31 @@
<table:table-cell table:style-name="ce9"/>
<table:table-cell table:number-columns-repeated="5"/>
</table:table-row>
+ <table:table-row table:style-name="ro2">
+ <table:table-cell table:style-name="ce19" table:formula="of:=COM.MICROSOFT.TEXTJOIN(&quot;-&quot;;1;I13:K13)" office:value-type="string" office:string-value="A-C" calcext:value-type="string">
+ <text:p>A-C</text:p>
+ </table:table-cell>
+ <table:table-cell office:value-type="string" calcext:value-type="string">
+ <text:p>A-C</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce32" table:formula="of:=[.A13]=[.B13]" 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="ce11" table:formula="of:=FORMULA([.A13])" office:value-type="string" office:string-value="=TEXTJOIN(&quot;-&quot;,1,I13:K13)" calcext:value-type="string">
+ <text:p>=TEXTJOIN(&quot;-&quot;,1,I13:K13)</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="4"/>
+ <table:table-cell table:style-name="ce9" office:value-type="string" calcext:value-type="string">
+ <text:p>A</text:p>
+ </table:table-cell>
+ <table:table-cell table:formula="of:=[.F13]" 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="ce9" office:value-type="string" calcext:value-type="string">
+ <text:p>C</text:p>
+ </table:table-cell>
+ <table:table-cell/>
+ </table:table-row>
<table:table-row table:style-name="ro7">
<table:table-cell/>
<table:table-cell table:style-name="ce17"/>