[Libreoffice-bugs] [Bug 99625] CONCAT and TEXTJOIN return (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|NEW |ASSIGNED
   Assignee|libreoffice-b...@lists.free |er...@redhat.com
   |desktop.org |

--- Comment #21 from Eike Rathke  ---
I'll take care of this.

-- 
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] CONCAT and TEXTJOIN return (wrongly?) an array when " text argument" is a CSE array.

[bugzilla-daemon]

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

--- Comment #20 from Eike Rathke  ---
Finally something that sheds light.. there you linked an .xlsx
https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1307-1311.xlsx (why
didn't you post that link here as well?) which when opened without
recalculation on sheet '(1309an)' in cell D5 has a TEXTJOIN in array context
that delivers result in one cell and when recalculated spreads over several
rows. The Excel behaviour makes sense and we should do the same.

Btw, your comment there
> Developers persist in denying evidence.
really pisses me off. No one denied evidence here, it's just that nobody came
up with any evidence so far.

-- 
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] CONCAT and TEXTJOIN return (wrongly?) an array when " text argument" is a CSE array.

[bugzilla-daemon]

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

--- Comment #19 from GerardF  ---
(In reply to Dennis Roczek from comment #18)
> Hi Gerald,
> 
> did you miss to paste the url?

Oops, sorry.
here it is :
https://forum.openoffice.org/en/forum/viewtopic.php?f=9=88407

-- 
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] CONCAT and TEXTJOIN return (wrongly?) an array when " text argument" is a CSE array.

[bugzilla-daemon]

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

--- Comment #18 from Dennis Roczek  ---
Hi Gerald,

did you miss to paste the url?

-- 
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] CONCAT and TEXTJOIN return (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

 Status|NEEDINFO|NEW

--- Comment #17 from GerardF  ---
See this thread in OpenOffice forum and the links provided.

-- 
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] CONCAT and TEXTJOIN return (wrongly?) an array when " text argument" is a CSE array.

[bugzilla-daemon]

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

--- Comment #16 from Winfried Donkers  ---
(In reply to Wolfgang Jäger from comment #15)

Comment #13 states the currently needed information. Until that information is
present, no substantive statements with respect to the filed bug report are
possible.

-- 
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] CONCAT and TEXTJOIN return (wrongly?) an array when " text argument" is a CSE array.

[bugzilla-daemon]

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

--- Comment #15 from Wolfgang Jäger  ---
(In reply to Winfried Donkers from comment #14)
>...
> AFAICS relevant Excel version is Excel365-2016.
> 
> Useless versions are:
> Excel Online does support TEXTJOIN, but does not support arrays.
> Excel 2016 offline doesn't support TEXTJOIN (unless Microsoft puts it in a
> future update).

Still insisting: If Excel (365-2016 or whatever version) is returning an array
in the mentioned case this is surely a bug and will be fixed by them with one
of the next updates.

-- 
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] CONCAT and TEXTJOIN return (wrongly?) an array when " text argument" is a CSE array.

[bugzilla-daemon]

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

--- Comment #14 from Winfried Donkers  ---
(In reply to Eike Rathke from comment #13)

AFAICS relevant Excel version is Excel365-2016.

Useless versions are:
Excel Online does support TEXTJOIN, but does not support arrays.
Excel 2016 offline doesn't support TEXTJOIN (unless Microsoft puts it in a
future update).

-- 
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] CONCAT and TEXTJOIN return (wrongly?) an array when " text argument" is a CSE array.

[bugzilla-daemon]

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

--- Comment #12 from Wolfgang Jäger  ---
No harm meant! 

(In reply to Eike Rathke from comment #8)
> ...  Pointers to the ODF OpenFormula definition
> don't help here, CONCAT and TEXTJOIN are not covered there.

Pointers to the OpenFormula document cannot help with a specification for
CONCAT and TEXTJOIN. 

However, they can help to understand that the actual behaviour under
array-evaluation is improper with respect to general mandatory requirements
(subchapter 3.3). This would apply even if Excel 2016 did it otherwise - and
also was not based on any specification of the new functions in advance. In
addition: If Excel 2016 actually returns an array of identical elements under
the mentioned conditions, It will most likely also be in disorder concerning
general principles applying to Excel itself. Thus MS will have to fix a bug
themselves in that case. 

Is somebody capable of checking for my above claim referring  to the (should-be
existing) SPECIFICATIONS concerning array-evaluation in Excel (XLSX defining
documents)? I found not to be. I though feel sure that the authors of
OpenFormula did not fail to be compatible with Excel concerning the
fundamentals of array-evaluation.

Or - does somebody assume an accumulating function might be declared to return
1-1-array in the standard case? In this case subchapter 3.3, statement 2.2.1)
of OpenFormula would apply. Also consider the analogy with SUM.

To get finally convinced, try something like
{=TEXTJOIN(", ";FALSE();A1;A1:B4;A7:B8)} 

(Appologies for my stubbornness. This touches a relevant question of priniples,
imo.)

-- 
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] CONCAT and TEXTJOIN return (wrongly?) an array when " text argument" is a CSE array.

[bugzilla-daemon]

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

--- Comment #13 from Eike Rathke  ---
Can please someone with access to the relevant Excel version check the results
instead we cluttering up this bug with assumptions whatsoever? Thank you.

-- 
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] CONCAT and TEXTJOIN return (wrongly?) an array when " text argument" is a CSE array.

[bugzilla-daemon]

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

--- Comment #11 from Wolfgang Jäger  ---
(Just a silly workaround.)
Meanwhile you will get the expected scalar results with CONCAT and TEXTJOIN
entered for evaluation in array mode using formulae like
{=INDEX(CONCAT(A1:A10:B10);1} or
{=INDEX(TEXTJOIN(", ";TRUE();A1:A10:B10);1)}

This is not avoiding bad results due to bugs concerning the array-evaluation of
the concatenation operator & (e.g. A1:A10:B10) as discussed in bug#101137.

-- 
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] CONCAT and TEXTJOIN return (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

Summary|TEXTJOIN returns wrongly an |CONCAT and TEXTJOIN return
   |array when "text argument"  |(wrongly?) an array when
   |is a CSE array. |"text argument" is a CSE
   ||array.

-- 
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