Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 10 Jun 2016 21:08:04 +0200Using wildcards in formulashttps://ask.libreoffice.org/en/question/71384/using-wildcards-in-formulas/Hi all,
I'm trying to employ wildcards in formulas in Calc as one can do in Excel but I've not been successful. I'd like to know if there is another way to do that.
The formula I'd like to do is: COUNTIF(A1:A5;"A*"). It would return the number of occurences in this range that a word would start with an A. It works good in Excel and in Google Spreadsheets, but it's not working in Calc. Do you know how can I do that in Calc?
Thanks a lot!Fri, 10 Jun 2016 20:04:35 +0200https://ask.libreoffice.org/en/question/71384/using-wildcards-in-formulas/Answer by erAck for <p>Hi all,</p>
<p>I'm trying to employ wildcards in formulas in Calc as one can do in Excel but I've not been successful. I'd like to know if there is another way to do that.</p>
<p>The formula I'd like to do is: COUNTIF(A1:A5;"A*"). It would return the number of occurences in this range that a word would start with an A. It works good in Excel and in Google Spreadsheets, but it's not working in Calc. Do you know how can I do that in Calc?</p>
<p>Thanks a lot!</p>
https://ask.libreoffice.org/en/question/71384/using-wildcards-in-formulas/?answer=71389#post-id-71389In Calc you can use regular expressions, i.e. `"A.*"` instead of `"A*"`
LibreOffice 5.2 will also support the simple wildcards `*`, `?` and `~`, see the [Release Notes](https://wiki.documentfoundation.org/ReleaseNotes/5.2#Support_wildcards_to_be_compatible_with_XLS.2FXLSX_and_with_ODF_1.2).
Fri, 10 Jun 2016 21:02:25 +0200https://ask.libreoffice.org/en/question/71384/using-wildcards-in-formulas/?answer=71389#post-id-71389Comment by Tales Tomaz for <p>In Calc you can use regular expressions, i.e. <code>"A.*"</code> instead of <code>"A*"</code></p>
<p>LibreOffice 5.2 will also support the simple wildcards <code>*</code>, <code>?</code> and <code>~</code>, see the <a href="https://wiki.documentfoundation.org/ReleaseNotes/5.2#Support_wildcards_to_be_compatible_with_XLS.2FXLSX_and_with_ODF_1.2">Release Notes</a>.</p>
https://ask.libreoffice.org/en/question/71384/using-wildcards-in-formulas/?comment=71392#post-id-71392Thanks! Great news for the next version!Fri, 10 Jun 2016 21:08:04 +0200https://ask.libreoffice.org/en/question/71384/using-wildcards-in-formulas/?comment=71392#post-id-71392