Brian McKee wrote:
On Fri, Feb 19, 2010 at 10:49 PM, Bob Long <b...@oblong.com.au> wrote:
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.
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.
Thanks for the suggestion Bob
I can see where that would work, but it sounds kinda clumsy.
A bit hard to explain the complete work flow, but currently I'm
massaging the data with Vim after I export to csv, because that other
spreadsheet mangles a few things Open Office handles correctly. But if
I can't dash fill with OO without doubling all the columns and pasting
them back over themselves, I'm back to hand massaging in Vim. Sure
would be nice not to have to double edit it, or jump extra hoops like
this.
Yes, I agree it's clumsy!
Is the CSV exported from OOo, or imported into OOo?
Anyway, if you already have the file as CSV, can you not then fairly
easily find/replace while in Vim? I don't use Vim, but I imagine you can
do things like changing null fields (,"", or ,, or similar, depending on
how the CSV is output) into ,"-", for example.
--
Bob Long
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
