tdf#145235: sc_text_functions_test: Add unittest for empty delimiter
Unittest for 45f53338461ba61c53c51a04f99fa281bf5150ae
< Related: tdf#145235 TEXTJOIN() allow empty delimiter of referenced
empty >
Change-Id: I9c23a600ebc6842cccc59c6ac15a6da9d049afdf
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/123905
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofauli@libreoffice.org>
diff --git a/sc/qa/unit/data/functions/text/fods/textjoin.fods b/sc/qa/unit/data/functions/text/fods/textjoin.fods
index 3f8062b..aab1a8e 100644
--- a/sc/qa/unit/data/functions/text/fods/textjoin.fods
+++ b/sc/qa/unit/data/functions/text/fods/textjoin.fods
@@ -1444,6 +1444,28 @@
</table:table-cell>
<table:table-cell/>
</table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:style-name="ce19" table:formula="of:=COM.MICROSOFT.TEXTJOIN(F14;0;I14:J14)" office:value-type="string" office:string-value="AC" calcext:value-type="string">
<text:p>AC</text:p>
</table:table-cell>
<table:table-cell office:value-type="string" calcext:value-type="string">
<text:p>AC</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce32" table:formula="of:=[.A14]=[.B14]" 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([.A14])" office:value-type="string" office:string-value="=TEXTJOIN(F14;0;I14:J14)" calcext:value-type="string">
<text:p>=TEXTJOIN(F14;0;I14:J14)</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: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"/>
