Hi Luuk,
>
> I decided not to report this as a bug.
>
> Then only 'bug' i could find is that CONCAT is missing from the help,
>
> where CONCATENATE leads to:
> https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060110.html?System=WIN=CALC=SC_HID_FUNC_VERKETTEN#bm_id3153084
>
>
>
> I
On 2-4-2019 19:33, Robert Großkopf wrote:
Hi Luuk,
In 6.2.0.3 on Windows, the function CONCATENATE(a1:a3) returns the value
of a1
This should be reported a a bug...
So please report this, if you could see the buggy behaviour in LO
6.2.2.2 also. I can't report it, because I couldn't
Hi Jonathon,
>
> It doesn't matter if concat or concatentate is the correct command to
> use. Neither concat(a20:a200) nor concatentate(a20:a200) return the
> expected the result. Both return the value in a20.
I couldn't confirm this with
Version: 6.2.2.2
Build ID:
On Tue, 2 Apr 2019 23:27:16 +0200
Regina Henschel wrote:
> Hi Michael,
>
> Michael H schrieb am 02-Apr-19 um 13:03:
> > CONCATENATE must either fail to accept ranges (with an error), or
> > accept them and provide the combination that acceptance suggests.
> > It is a bug that it accepts ranges,
On 4/2/19 9:27 PM, Regina Henschel wrote:
> Because CONCATENATE expects a list of simple references, it performs an
> "implicit intersection", if instead of a simple reference a range is given.
> http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#ImpliedIntersection
That
Hi Michael,
Michael H schrieb am 02-Apr-19 um 13:03:
CONCATENATE must either fail to accept ranges (with an error), or accept
them and provide the combination that acceptance suggests. It is a bug that
it accepts ranges, but returns something else.
Because CONCATENATE expects a list of
On 4/2/19 2:54 PM, Robert Großkopf wrote:
>> This thread is about CONCATENATE being dysfunctional in that it accepts
>> ranges, but does not act on them correctly. Please stop referring to CONCAT
>> as the reason that CONCATENATE is broken.
>
> Please read the first mail of jonathon.
> "With
Hi Luuk,
> In 6.2.0.3 on Windows, the function CONCATENATE(a1:a3) returns the value
> of a1
>
> This should be reported a a bug...
So please report this, if you could see the buggy behaviour in LO
6.2.2.2 also. I can't report it, because I couldn't reproduce it with LO
6.2.2.2.
Regards
Robert
On 2-4-2019 16:54, Robert Großkopf wrote:
Hi Michael,
This thread is about CONCATENATE being disfunctional in that it accepts
ranges, but does not act on them correctly. Please stop referring to CONCAT
as the reason that CONCATENATE is broken.
Please red the first mail of jonathon.
"With
Hi Michael,
>
> This thread is about CONCATENATE being disfunctional in that it accepts
> ranges, but does not act on them correctly. Please stop referring to CONCAT
> as the reason that CONCATENATE is broken.
Please red the first mail of jonathon.
"With previous versions of LibO,
Howdy,
I believe that the difference is in where the function hails from:
CONCATENATE is defined in the ODF standard.
CONCAT comes by way of Excel support.
I think you have a point about how the system should respond when
erroneously using ranges for the ODF function (not supported) and could be
Why are we defending invalid output of a function?
When I send invalid data like range to a function, say ABS(c1:c4), I expect
it to return an error (#VALUE! comes up in linux).
In linux on LO 6.0.7, I'm getting the 2nd value in the range as a valid
output of the function CONCATENATE(C1:C4).
Hi Michael,
> CONCATENATE must either fail to accept ranges (with an error), or accept
> them and provide the combination that acceptance suggests. It is a bug that
> it accepts ranges, but returns something else.
Have opened Calc and looking for fuction CONCATENATE. Help in the dialog
says:
CONCATENATE must either fail to accept ranges (with an error), or accept
them and provide the combination that acceptance suggests. It is a bug that
it accepts ranges, but returns something else.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
Hi *,
use CONCAT instead of CONCATENATE. CONCAT will accept cell-ranges.
Regards
Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
I am running 6.07 and =CONCATENATE(A2:A4) gives #VALUE
=CONCATENATE(A2,A3,A4) concatenates A2, A3 and A4 correctly.
Steve
On 02/04/2019 14:43, Michael Manning wrote:
> I am running an older version of LibreOffice
> Version: 5.1.6.2
> Build ID: 1:5.1.6~rc2-0ubuntu1~xenial6
> CPU Threads: 2; OS
I am running an older version of LibreOffice
Version: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial6
CPU Threads: 2; OS Version: Linux 4.4; UI Render: default;
Locale: en-AU (en_AU.UTF-8); Calc: group
running on Linux Mint 18.3
the function concatenate(text1:text4) gives the result text1
the
All:
LibreOffice 6.2.2.2
CPU: 8 Threads
OS: Linux 4.2
Locale en_ZA
With previous versions of LibO, concatenate(b1:b200) would concatenate
all cells between b1 and b200.
With LibO 6.2.2.2, concatenate(b1:b200) returns the data in b1.
a) When was this functionality changed?
I didn't come across
18 matches
Mail list logo