Home Articles Forums Gallery Marketplace Videos

WoodCentral Forums

Knowledge You Can Build On — Est. 1998

Rare Exotic & Domestic Hardwoods, Milled In-House in Oregon. Browse Unique Stock.

Any OpenOffice gurus? Spread sheet department.

Posts

Any OpenOffice gurus? Spread sheet department.

#1

Any OpenOffice gurus? Spread sheet department.

Rod Peterson * Ormond Beach

>I have an Excel spreadsheet in which I've used the formula:

=COUNTIF(B4:B64;"*")-1

to test the cited cells for the presence of text (and subracting 1 because of a header cell within the range). Excel treats "*" as a wildcard for any text, but OO seems to treat it as a literal and not finding any *s in the range returns -1 in the cell with the formula.

I'm only a novice at writing formulas in Excel (or OO), so my original may be suspect. Can anyone help me either write a formula to test for the existence of content or fix mine to work in OO?

Thanks.

Rod

Re: Any OpenOffice gurus? Spread sheet department.

#2

Jason Roehl in Lafayette, IN

Re: Any OpenOffice gurus? Spread sheet department. *LINK*

Jason Roehl in Lafayette, IN

>I'm far from a guru, but I did a little internet search, and it appears that you may have to add a . in front of the * and lose the quotes. I googled "open office spreadsheet wildcard", and among the results was this:

http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressions_in_Calc

Jason


OO Wiki

Re: Any OpenOffice gurus? Spread sheet department.

#3

Re: Any OpenOffice gurus? Spread sheet department.

Mark Brennan

>Are you trying to get a count those that contain text? Excel has a function =counta(range), which will count the number of cells that are not blank. You might check to see if OO has a similar function.

Re: Any OpenOffice gurus? Spread sheet department.

#4

Re: Any OpenOffice gurus? Spread sheet department.

Guy

>Does OO have the "Istext" function? In Excel the Istext function returns a Boolean True(1) or False(0). This array formula comes at the problem from another angle and may be a work-around. =SUM(ISTEXT(B4:B64)*1)-1