https://bugs.documentfoundation.org/show_bug.cgi?id=145235

            Bug ID: 145235
           Summary: TEXTJOIN Function gives incorrect results
           Product: LibreOffice
           Version: 7.1.6.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
Incorrect result to a textjoin function where one cell is calculated from
another.

Steps to Reproduce:
Create a spreadsheet where...
cell A1 contains A
cell A2 contains formula =B2
cell B2 is empty
cell A3 contains C
cell A4 contains =TEXTJOIN("-",1,A1:A3)


Actual Results:
The result shown in A4 is "A-A-C" 

Expected Results:
It should be "A-C"


Reproducible: Always


User Profile Reset: No



Additional Info:
Give the correct result

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to