LibO 5.2 or higher: TEXJOIN and CONCAT behaviour
Posted: Thu Apr 20, 2017 3:21 am
Can someone with access to Excel 2016 test as described in this thread of the askbot site mimicking an official forum for LibreOffice:
https://ask.libreoffice.org/en/question/91825 .
The example attached there under the "2. bump" also contains a link to a youtube explanation concerning the two mentioned functions which were introduced with Excel 2016 first and then also implemented in LibreOffice as of V5.2.
There is a bug report tdf#99625 (https://bugs.documentfoundation.org/sho ... i?id=99625) complaining that the behaviour of both the mentioned functions in cases where a parameter is calculated under array evaluation is wrong. Another claim (as I understand it) is that the behaviour is the same as in Excel 2016. Since there is no specification of the functions in OpenFormula, compatibility with Excel 2016 is said to be the only raison d'etre of the new functions.
The discussion of the bug stopped, and I did not get reliable results from the above linked askbot thread. Thus I try it here now. I also tried to get access to an Excel 2016 for testing myself, but I failed.
https://ask.libreoffice.org/en/question/91825 .
The example attached there under the "2. bump" also contains a link to a youtube explanation concerning the two mentioned functions which were introduced with Excel 2016 first and then also implemented in LibreOffice as of V5.2.
There is a bug report tdf#99625 (https://bugs.documentfoundation.org/sho ... i?id=99625) complaining that the behaviour of both the mentioned functions in cases where a parameter is calculated under array evaluation is wrong. Another claim (as I understand it) is that the behaviour is the same as in Excel 2016. Since there is no specification of the functions in OpenFormula, compatibility with Excel 2016 is said to be the only raison d'etre of the new functions.
The discussion of the bug stopped, and I did not get reliable results from the above linked askbot thread. Thus I try it here now. I also tried to get access to an Excel 2016 for testing myself, but I failed.