Ask Your Question

why is find-and-replace grayed out [closed]

asked 2013-06-11 15:38:28 +0100

Lee gravatar image

updated 2015-11-02 21:42:43 +0100

Alex Kemp gravatar image

I am in an .ods document with calc. I have selected a range of cells. I navigate to the Edit dropdown to select 'Find & Replace', but it is grayed out. Why? I can open the 'Find' option, which pops up the little find applet at the bottom of my calc window, and I can then click on the little pencil/magnifying glass icon and lo and behold, up pops the dialog box for replace - which functions as expected. So it is not a problem with permissions (I'm not in read only mode for example) or cell formatting, etc... This happens frequently to me.

Ubuntu 12.04 64-bit, Libre Office

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-02 21:43:04.907873

2 Answers

Sort by » oldest newest most voted

answered 2013-06-12 05:08:01 +0100

oweng gravatar image

You don't mention whether you are running the PPA version of LO or the one from the website. I can't replicate your problem here under Crunchbang 11 running TDF/LO v4.0.3.3. As shown here the menu item is available. Is there any particular type of content in the selected area that is unusual? I would suggest perhaps trawling the Ubuntu forums / bugs if you are using the PPA version, which in my experience is far more buggy that the native TDF one.

edit flag offensive delete link more

answered 2013-06-24 23:30:48 +0100

Lee gravatar image

Thanks much for the followup. I did download the TDF version after reading your reply, although prior to extract/install I did once again fire up the PPA version that I am currently running and, lo and behold, the find & replace option was no longer grayed out for the exact same cell range on that spreadsheet (the cells contain a pretty simple formula. Not certain why it suddenly decided to start working -- I have the TDF version standing by to install should I experience more wierdness. Again, I truly appreciate the reply!

edit flag offensive delete link more

Question Tools


Asked: 2013-06-11 15:38:28 +0100

Seen: 705 times

Last updated: Jun 24 '13