Brian McKee wrote:
In (cough) other spreadsheet software I'm used to starting find and
replace, hitting the 'entire cell' check box and leaving the find box
blank, thus I can find (and fill) all the empty cells quickly and
easily in a range. You can't do that in Calc, the find button won't
activate until you put something in there. Turning on regular
expressions and using ^$ doesn't work either -
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressions_in_Calc
says that's deliberate.
How the heck to I find all the empty cells in a range and put a - in them?
And I really need that hyphen, formatting won't do - the output here
is plain text.
Suggestions appreciated,
Brian
It's not as pretty as being able to do a find and replace, but this is a
workaround. Suppose your data is in A1:A10. Select that. Select B1 (or
somewhere else unused) and enter:
=IF(A1:A10="";"-";A1:A10)
and confirm with CTRL-SHIFT-ENTER, rather than just with ENTER, to make
it an array calculation.
That will give a column (B) with the hyphen in each previously empty
cell. But of course that column consists of formulas. You can use them,
though, in other calculations. But if you want the original column to
end up with "real" hyphens, then do Edit|Copy (given that B1:B10 is
already highlighted), then select A1 and do Edit|Paste Special... and
select only text and numbers. Allow the overwrite.
--
Bob Long
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org