Re: [libreoffice-l10n] Error in Help COUNTIF?

Den 07.11.2015 20:44, Lera skreiv:
> В письме от 7 ноября 2015 18:49:22 пользователь Kolbjørn Stuestøl написал:
> > LibreOffice master – Helplibo_help/scalc/01.poUnit #92561344
> > <https://translations.documentfoundation.org/nn/libo_help/translate/scalc/01
> > .po#unit=92561344>
> >
> > <item type="input">=COUNTIF(A1:A10;"<"&B1)</item> - when B1 contains
> > <item type="input">2006</item>, this returns 6
> This example returns 6.
> I made the example for you
> https://www.dropbox.com/s/ln7608vv0hmzs69/example.ods?dl=0 . You can download
> the file and verify this.
>
> > When I try this I get error 509.
> > What operator am I missing?
> The error 509 indicates that you missed an operator.  Perhaps, your
> localization options do not use the semicolons in formulas.
> See: Tool -> Options.. -> LibreOffice Calc -> Formula
>
> Best regards,
> Lera
Thank you.
My fault. I had written "$" instead of "&" in COUNTIF(A1:A10;"<"&B1).
I apologize for wasting your time.
Kolbjørn


--
To unsubscribe e-mail to: l10n+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/l10n/
All messages sent to this list will be publicly archived and cannot be deleted