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. Brian --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
