В письме от 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 -- 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