On Sat, Jan 22, 2011 at 10:47 PM, Jean Hollis Weber <jeanwe...@gmail.com> wrote: > On Sat, 2011-01-22 at 19:28 +1300, Gareth McMullin wrote: >> On Sat, Jan 22, 2011 at 7:06 PM, Jean Hollis Weber <jeanwe...@gmail.com> >> wrote: >> > >> > Doesn't work for me. Here are all the steps I did: >> > >> > Format the cells as number, select the Regular expressions option, >> > select the cells A1, A2, A3, type .+ in the Search for box, & in the >> > Replace box, and click Replace. >> > >> > No change to any cell. >> > >> > What am I missing? >> > > >> Does "Find" match the cells with contents? > > I'm not sure I understand the question. Find didn't appear to do > anything when the info in the cells was '1, '2, etc. After running F&R, > the cells still contained '1, '2, etc. And the sum was still zero. >
But Find *finds* the cells with contents, if I haven't selected them. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
