[Libreoffice-bugs] [Bug 123001] A little improvement to CONCATENATE/CONCAT, please?
https://bugs.documentfoundation.org/show_bug.cgi?id=123001 Olivier Hallot changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |DUPLICATE --- Comment #6 from Olivier Hallot --- *** This bug has been marked as a duplicate of bug 99517 *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123001] A little improvement to CONCATENATE/CONCAT, please?
https://bugs.documentfoundation.org/show_bug.cgi?id=123001 Xisco FaulĂ changed: What|Removed |Added CC||olivier.hallot@libreoffice. ||org, ||xiscofa...@libreoffice.org Component|Calc|Documentation --- Comment #5 from Xisco FaulĂ --- (In reply to TBeholder from comment #4) > (In reply to Eike Rathke from comment #3) > > sounds like you want to use the TEXTJOIN() function where you can specify a > > separator and whether empty cells/strings should be concatenated > That does it, indeed. Thanks! > "TEXTJOIN" is not be found in help (Version: 6.1.2.1), however. Though there > are tips for it in Function Wizard. > > I guess the bug should be changed to "please add basic documentation for > TEXTJOIN()" now. Changing it to Documentation then... -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123001] A little improvement to CONCATENATE/CONCAT, please?
https://bugs.documentfoundation.org/show_bug.cgi?id=123001 --- Comment #4 from TBeholder --- (In reply to Eike Rathke from comment #3) > sounds like you want to use the TEXTJOIN() function where you can specify a > separator and whether empty cells/strings should be concatenated That does it, indeed. Thanks! "TEXTJOIN" is not be found in help (Version: 6.1.2.1), however. Though there are tips for it in Function Wizard. I guess the bug should be changed to "please add basic documentation for TEXTJOIN()" now. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123001] A little improvement to CONCATENATE/CONCAT, please?
https://bugs.documentfoundation.org/show_bug.cgi?id=123001 --- Comment #3 from Eike Rathke --- I don't get what you want in "Expected Results", but your description sounds like you want to use the TEXTJOIN() function where you can specify a separator and whether empty cells/strings should be concatenated using the separator as well, for example =TEXTJOIN(CHAR(10),TRUE(),A1:A3) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123001] A little improvement to CONCATENATE/CONCAT, please?
https://bugs.documentfoundation.org/show_bug.cgi?id=123001 --- Comment #2 from TBeholder --- Correction: concatenation-with-separator itself, of course, can be done, but even this requires a lot of conditionals and either an impenetrable construct using CURRENT() in dodgy ways, or use of many columns as an array of temporary variables just to easily check arguments. While inside the cycle that does CONCAT() this would be trivial (a single "if X and Y then Z"). -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123001] A little improvement to CONCATENATE/CONCAT, please?
https://bugs.documentfoundation.org/show_bug.cgi?id=123001 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||108827 CC||79045_79...@mail.ru, ||er...@redhat.com --- Comment #1 from Roman Kuznetsov <79045_79...@mail.ru> --- Eike, please take a look at this Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108827 [Bug 108827] [META] Calc functions bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs