Red Hat Bugzilla – Bug 476215
Find and replace doesn't work in calc
Last modified: 2009-01-16 07:20:06 EST
Description of problem:
Multi cell find and replace doesn't work in open-office calc.
Version-Release number of selected component (if applicable):
$ yum list openoffice.org-calc*
Loaded plugins: downloadonly, kmdl, priorities, refresh-packagekit
0 packages excluded due to repository priority protections
openoffice.org-calc.i386 1:3.0.0-9.10.fc10 installed
openoffice.org-calc-core.i386 1:3.0.0-9.10.fc10 installed
I have not been able to make it work once.
Steps to Reproduce:
1. Import data with a format that uses commas instead of periods. It imports correctly.
2. Select a bunch of cells. Select Find and Replace
3. Set Search for "," and Replace with ".". Press Find or Replace or Replace all.
Nothing happens. Nothing gets replaced.
If you close the Find and Replace dialog window and open it again, it keeps the ",", but loses the "."
It should replace all the ","s with "."s. I have to do it by hand now.
I got the data by copying and pasting the motor data table from here:
I suggest that you attach a sample .ods of the state before search & replace for me to have a look at it.
i.e. in my locale the decimal mark is "." so strings like 88,5 will import as "text" and so I can easily search and replace them with the dialog.
But if your locale is one that uses "," instead of "." then I would definitely expect that the search and replaces wouldn't do anything as the "," isn't really there to be replaced, instead if is just the way that decimals are displayed in that locale.
So I can't be sure if the problem here is one of "I can't search and replace , to be . in a text cell" or if its is "I want to change what is displayed for decimal separators". If it was the second, then e.g. format cell language and change it to an English locale would change the , to .
It works for me, too. I tried it in Czech locale (cs_CZ.utf8) that uses comma as decimal mark. I selected the table on the HTML page and inserted it into an empty sheet; the numbers were correctly imported as numbers. Then I selected body of the table and performed the replace; all numbers containing a comma were converted to text and the commas were replaced by dots.
Created attachment 327253 [details]
State before 'Search and Replace'
Created attachment 327254 [details]
State after 'Search and Replace'
Created attachment 327364 [details]
calc file with numbers using the comma format
Try searching the voltage, current and efficiency columns and replacing the "," with "."s.
It does work for me, in both English and Czech locale. Have you got any 'unusual' language settings? Have you got any field checked under 'More options' it the Search and Replace dialog?
It just worked for me. I have no idea why it didn't work before.
I am working in English. I don't have any unusual language settings. I didn't have anything selected under "More options".
I think there is a bug here, but I can't replicate it now. I'll play around with it later and see if I can get it to do it again.
Lets close it for now then