I am new to open office, so maybe I am doing something wrong. I have a
spread sheet from MS-Excel that my company stores all of our IP's and other
info. Using the Find & Replace in Open Office doesn't find the the ip
address about 90% of the time. The document is 20 sheets long, and I would
like to be able to search all fields, and all sheets at once. I have even
opened a new OpenOffice Calc spreadsheet and put 10.220.0.0 and a few other
10.*.0.0 address. If I then run find on this new spreadsheet searching for
10.220 it says: searched to end, continue at beginning, then after clicking
yes, Search Key not found. I have set it to search in formulas, checked
Search in all sheets, tried Similarity Search, and unchecked Entire Cell. I
am running Windows Server 2003 through remote desktop, OpenOffice 2.0.2. I
wanted to see if anyone else was having a similar problem?
Thanks
Scott
