Brian McKee wrote:
On Thu, Feb 18, 2010 at 6:43 PM, Twayne <twa...@twaynesdomain.com> wrote:
In news:cc77dabe1002181306g79aaa2a4w491e279f95eb5...@mail.gmail.com,
Brian McKee <brian.mc...@gmail.com> typed:
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.
Could you do a search for LEN=0? Looks like NULL can't be found, but I think
a 0 length data probably can.
I don't see how you can put a formula in the Find box - am I missing something?
Brian
Hello Brian,
It is one of Calc's well known extravagances that find&replace is unable
to find empty cells nor empty strings.
Use a filter. Select the column in question, Data>Filter>Standard...
<column X> = <-empty-> [OK]
Hope this helps,
Andreas
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
