diff options
Diffstat (limited to 'sc')
| -rw-r--r-- | sc/qa/unit/data/functions/text/fods/textjoin.fods | 22 |
1 files changed, 22 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 3f8062bb5802..aab1a8eccafe 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"/> |