I have over 7500 rows in a spreadsheet and need to find any empty cells. So I thought I do a Find and Replace. I selected the A column, opened Find and Replace, clicked on regular expressions, typed ^$ in the Find bar, and hit enter to see if it would find anything. Didn't get anything results even though I know there's a few empty cells in the column. Did a quick search thinking maybe OO.org uses a different expression for an empty cell. And found this:
"Searching for the regular expression '^$' will not find empty cells. This is intentional - the rationale being to avoid performance issues when selecting a huge number of cells. Note that empty cells will not be found even if you are only searching a selection." http://tinyurl.com/94g9n3 That bites. -- Sun, 21 Dec 2008 11:58:45 -0600 --~--~---------~--~----~------------~-------~--~----~ Central West End Linux Users Group (via Google Groups) Main page: http://www.cwelug.org To post: [email protected] To subscribe: [email protected] To unsubscribe: [email protected] More options: http://groups.google.com/group/cwelug -~----------~----~----~----~------~----~------~--~---
