=COUNTIF(F16:X21;"8a")+1 - Error:509 ?

users
#1

Hello,

I have installed LO 5.0.0.5, Gentoo official package.
I have setup LINGUAS to hu: hu-HU (hu_HU.utf8).

In one of my old Calc sheet, I have function
=COUNTIF(F16:X21;"8a")+1
In previous LO version this was without error, but now it shows me this
error. Why?

Now, If I remove the '+1' from the end of function, it is OK, but then I get
not the value which I want.
Now, how can I increase with '1' the value of the function:
=COUNTIF(F16:X21;"8a")

#2

I tried it using 5.0.1.2 on windows 7. Local set to Norwegian nynorsk (nn).

Set A1= 1a, A2=2a ... A8=8a and B1=1b, B2=2b ... B8=8b.

=COUNTIF(A1:B8;"8a")+1 returned 2 as espected.

Perhaps an error in version 5.0.0.5. In that case it does not matter as it works fine in 5.1.
So perhaps the solution is to upgrade to 5.1?
Kolbjørn

Den 31.08.2015 21:06, csanyipal skreiv:

#3

Kolbjørn Stuestøl wrote

I tried it using 5.0.1.2 on windows 7. Local set to Norwegian nynorsk
(nn).

Set A1= 1a, A2=2a ... A8=8a and B1=1b, B2=2b ... B8=8b.

=COUNTIF(A1:B8;"8a")+1 returned 2 as espected.

Perhaps an error in version 5.0.0.5. In that case it does not matter as it
works fine in 5.1.
So perhaps the solution is to upgrade to 5.1?
Kolbjørn

Indeed, I tried the function in the same document on my Arch linux, where I
have installed LO version: 5.0.1.2.0+ and the function works out there too.
So this is a Gentoo issue. Thanks!

#4

Den 01.09.2015 17:22, csanyipal skreiv:

Kolbjørn Stuestøl wrote

I tried it using 5.0.1.2 on windows 7. Local set to Norwegian nynorsk
(nn).

Set A1= 1a, A2=2a ... A8=8a and B1=1b, B2=2b ... B8=8b.

=COUNTIF(A1:B8;"8a")+1 returned 2 as espected.

Perhaps an error in version 5.0.0.5. In that case it does not matter as it
works fine in 5.1.
So perhaps the solution is to upgrade to 5.1?
Kolbjørn

Indeed, I tried the function in the same document on my Arch linux, where I
have installed LO version: 5.0.1.2.0+ and the function works out there too.
So this is a Gentoo issue. Thanks!

-----
Best Regards from
Pál
--
View this message in context: http://nabble.documentfoundation.org/COUNTIF-F16-X21-8a-1-Error-509-tp4158926p4159009.html
Sent from the Users mailing list archive at Nabble.com.

OK
Kolbjørn