The help lists it as "regular expressions;list of", so you have to know what a regular expression is to make the correct search. That's not as helpful as it could be. Statistics: Posted by FJCC — Mon May 13, 2024 2:36 pm ..read more

The following works for me Code: =SUMIF(B1:B7; ".*food.*"; A1:A7) Note that the the wild card is .* and that the parts of the formula are separated by semicolons. OpenOffice uses regular expressions as wild cards and .* means "zero or more of any character". You may have to enable regular expression in formulas under OpenOffice -> Preferences -> OpenOffice Calc -> Calculate. i could not find this use of wildcards in any documentation. thanks a lot, problem solved. Statistics: Posted by iddqd — Mon May 13, 2024 1:14 pm ..read more

The following works for me Code: =SUMIF(B1:B7; ".*food.*"; A1:A7) Note that the the wild card is .* and that the parts of the formula are separated by semicolons. OpenOffice uses regular expressions as wild cards and .* means "zero or more of any character". You may have to enable regular expression in formulas under OpenOffice -> Preferences -> OpenOffice Calc -> Calculate. Statistics: Posted by FJCC — Mon May 13, 2024 1:01 pm ..read more

I want to calculate the total values in column A via looking for a part of a string in column B -SUM the A if the values in B contains FOOD -SUM the A if the values in B contains the letter G -SUM the A if the values in B contains the DAY A B 10Monday Food 20Tuesday Gym 30Wednesday Gym 40Thursday Shopping for groceries. also food. 50Friday food 60Saturday gym 70Sunday groceries for example. i tried =SUMIF(B1:B7, "*day*", A1:A7) but it doesn't work. any help are greatly appreciated. Statistics: Posted by iddqd — Mon May 13, 2024 12:47 pm ..read more

I have a presentation that needs a new template. How can I change the entire set fast? Thanks, John Statistics: Posted by jrickert — Sat Apr 27, 2024 6:35 pm ..read more

I believe I've already given enough information. I believe you haven't, as did robleyd, it seems: Perhaps you could upload a sample file that demonstrates the issue so someone can try and offer a solution. Also, can you tell the version of LibreOffice that you are using? After one week of not supplying the information as suggested, you proceed to tell us again how it should work. I am sad to say, but your quack is unchanged. I'm done here. Statistics: Posted by keme — Wed Feb 28, 2024 3:36 pm ..read more

I believe I've already given enough information. I was not referring to your close quote issue (please mind the quote I used). I was referring to your broad comment about you not figuring out how to change the justification parameters. I provided a screenshot showing that it is exactly the same UI between MS Word and Writer. So I wonder what kind of programs you have been using during those forty years. Note that there was no such control 40 years ago when WYSIWYG applications were not yet available... Statistics: Posted by Hagar Delest — Wed Feb 28, 2024 7:03 am ..read more

I believe I've already given enough information. The information given is only a description of the problem. That is not adequate to analyze the problem and determine if it is a bug or something in the document itself. Statistics: Posted by Bill — Wed Feb 28, 2024 1:22 am ..read more

Agreed. It nonetheless deserves answers at least to show those who could find this topic later that there is a lot of nonsense and facts just demonstrate that plainly. Statistics: Posted by Hagar Delest — Thu Feb 22, 2024 1:23 pm ..read more

Ummm ... Denigrating message (twice insisting that "These guys/they [...] don't know [...]") Abundance of expletives (of sorts) and other loaded language ("what the frick", "cringed", "consarn me") Emphasizing own skills/experience ( "[...] I've been using programs like this for nearly forty years.") Minimal supply of actual info. I don't know about appearance or gait, but today our gremlinkurst certainly quacks like a duck troll. FWIW, I can easily reproduce the issue. Insert a space between period and quote characters, as RoryOF mentioned. Without this space, I am unable to make the quote ..read more