[Libreoffice-bugs] [Bug 99625] TEXTJOIN returns wrongly an array when "text argument" is a CSE array.

[bugzilla-daemon]

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

--- Comment #10 from Eike Rathke  ---
Bug 101134 has some additional attachments that might be of interest:
https://bugs.documentfoundation.org/attachment.cgi?id=126416
https://bugs.documentfoundation.org/attachment.cgi?id=126823

-- 
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 99625] TEXTJOIN returns wrongly an array when "text argument" is a CSE array.

[bugzilla-daemon]

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

--- Comment #9 from Eike Rathke  ---
*** Bug 101134 has been marked as a duplicate of this bug. ***

-- 
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 99625] TEXTJOIN returns wrongly an array when "text argument" is a CSE array.

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 Ever confirmed|0   |1

--- Comment #8 from Eike Rathke  ---
So, can someone with access to the relevant Excel version please come up with a
description of what Excel exactly does when entering CONCAT and TEXTJOIN as
array formulas?  Pointers to the ODF OpenFormula definition don't help here,
CONCAT and TEXTJOIN are not covered there.

-- 
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 99625] TEXTJOIN returns wrongly an array when "text argument" is a CSE array.

[bugzilla-daemon]

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

Wolfgang Jäger  changed:

   What|Removed |Added

 CC||j...@psilosoph.de

--- Comment #7 from Wolfgang Jäger  ---
(In reply to Winfried Donkers from comment #2)
> The TEXTJOIN examples in  attachment 124781 [details] (File with TEXTJOIN
> entered as array formula) and attachment 124785 [details] (Excel Online
> display) are - as the attachment says - entered as array formula. That means
> that the result will be an array.
> 
...
This is simply wrong. Only the evaluated parameter(s) have to be passed to the
functions as arrays. Compare with accumulating numeric functions like PROD or
IMSUM (actually a kind of text-function). The functions will then have to
convert these arrays into sequences (See subchapter 4.11.12 of the mentioned
document). Of course, a function body may omit this and treat these sequences
as arrays for the sake of efficiency, if the results to obtain are not
distorted. Please read subchapter 3.3 of
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.odt . For
the data-parameters (all those of CONCAT and starting with the second one for
TEXTJOIN) we need a data type of "TextSequenceList" which is not yet specified,
but may be assumed in analogy to "NumberSequenceList" or "ComplexSequenceList". 
The examples attached to bug#101137, in specific the reworked newer one should
be taken in account. If you think I should report the errors demonstrated and
explained there using orange background for highlighting as independent bugs
anew, please tell me. Given a few days I may also find the time to suggest a
complete extension to the mentioned specification with respect to this subject.
I may also sketch an implementation for CONCAT and TEXTJOIN in pseudocode or in
BASIC. (I cannot study and train in my late days everything needed to
contribute to the original code myself.)

-- 
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 99625] TEXTJOIN returns wrongly an array when "text argument" is a CSE array.

[bugzilla-daemon]

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

Aron Budea  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=10
   ||1134

-- 
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 99625] TEXTJOIN returns wrongly an array when "text argument" is a CSE array.

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99625
Bug 99625 depends on bug 97831, which changed state.

Bug 97831 Summary: Please add new functions IFS, MAXIFS, MINIFS, SWITCH, 
CONCAT, TEXTJOIN  (new in Excel 2016 Jan16)
https://bugs.documentfoundation.org/show_bug.cgi?id=97831

   What|Removed |Added

 Status|ASSIGNED|RESOLVED
 Resolution|--- |FIXED

-- 
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 99625] TEXTJOIN returns wrongly an array when "text argument" is a CSE array.

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99625
Bug 99625 depends on bug 97831, which changed state.

Bug 97831 Summary: Please add new functions IFS, MAXIFS, MINIFS, SWITCH, 
CONCAT, TEXTJOIN  (new in Excel 2016 Jan16)
https://bugs.documentfoundation.org/show_bug.cgi?id=97831

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|FIXED   |---

-- 
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 99625] TEXTJOIN returns wrongly an array when "text argument" is a CSE array.

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=99625
Bug 99625 depends on bug 97831, which changed state.

Bug 97831 Summary: Please add new functions IFS, MAXIFS, MINIFS, SWITCH, 
CONCAT, TEXTJOIN  (new in Excel 2016 Jan16)
https://bugs.documentfoundation.org/show_bug.cgi?id=97831

   What|Removed |Added

 Status|ASSIGNED|RESOLVED
 Resolution|--- |FIXED

-- 
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 99625] TEXTJOIN returns wrongly an array when "text argument" is a CSE array.

[bugzilla-daemon]

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

--- Comment #6 from Winfried Donkers  ---
(In reply to Dennis Roczek from comment #5)
> 1) Excel Online is crap. I really do not understand how that web app should
> replace the "fat client" (as some managers and CEOs think)
> 
> 2) Excel is crap. I do want to switch to English function names! This is
> such a big plus in LibreOffice Calc!
> 
> 3) You cannot "convert" an existing ODS to an XLSX file. You can save the
> open file under another name (save a copy) but not to save it under a
> different file format. But always a big yellow fat warning about
> incompatibilities... -.-
> 
> 4) Warning that the formula is incorrect. Well ok, but WHAT PART of the
> formula? Errr. Crap.
> 
> 5) I will retry that tomorrow.

Could you offer your findings with Excel to Microsoft? This bug list only
handles LibreOffice bugs/enhancements ;-) 
Looking forward to your results with Excel and this use case of TEXTJOIN.
As soon as I know how Excel handles this I can fix Calc's TEXTJOIN if needed.

-- 
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 99625] TEXTJOIN returns wrongly an array when "text argument" is a CSE array.

[bugzilla-daemon]

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

--- Comment #5 from Dennis Roczek  ---
1) Excel Online is crap. I really do not understand how that web app should
replace the "fat client" (as some managers and CEOs think)

2) Excel is crap. I do want to switch to English function names! This is such a
big plus in LibreOffice Calc!

3) You cannot "convert" an existing ODS to an XLSX file. You can save the open
file under another name (save a copy) but not to save it under a different file
format. But always a big yellow fat warning about incompatibilities... -.-

4) Warning that the formula is incorrect. Well ok, but WHAT PART of the
formula? Errr. Crap.

5) I will retry that tomorrow.

-- 
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 99625] TEXTJOIN returns wrongly an array when "text argument" is a CSE array.

[bugzilla-daemon]

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

GerardF  changed:

   What|Removed |Added

Summary|TEXTEJOIN returns wrongly   |TEXTJOIN returns wrongly an
   |an array when "text |array when "text argument"
   |argument" is a CSE array.   |is a CSE array.

--- Comment #4 from GerardF  ---
(In reply to GerardF from comment #3)

> Dennis, can you try entering this formula in a cell:
> =TEXTJOIN(",
> ",1,INDEX(B:B,N(IF(1,MODE.MULT(IF(A4:A12=D4,{1,1}*ROW(A4:A12)))
> instead of
> =TEXTJOIN(", ",1,INDEX(B:B,MODE.MULT(IF(A4:A12=D4,{1,1}*ROW(A4:A12)
> 
> in Excel and save the file as .xlsx

This formula was to make the same job, but you can test only a simple formula
like :
=TEXTJOIN(",",1,ROW(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