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

2015-11-07 Thread Lera
В письме от 7 ноября 2015 18:49:22 пользователь Kolbjørn Stuestøl написал:
> LibreOffice master – Helplibo_help/scalc/01.poUnit #92561344
>  .po#unit=92561344>
> 
> =COUNTIF(A1:A10;"<") - when B1 contains
> 2006, 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


-- 
To unsubscribe e-mail to: l10n+unsubscr...@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


[libreoffice-l10n] Error in Help COUNTIF?

2015-11-07 Thread Kolbjørn Stuestøl
LibreOffice master – Helplibo_help/scalc/01.poUnit #92561344 



=COUNTIF(A1:A10;"<") - when B1 contains 
2006, this returns 6

When I try this I get error 509.
What operator am I missing?

Is there a way to count numbers less then or greater the the content of 
a cell?

If yes, the sentence should be corrected.
If not, the sentence should be deleted.

Kolbjørn


--
To unsubscribe e-mail to: l10n+unsubscr...@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