I'm working with a decent-size spreadsheet -- nothing astronomical, but it's probably got 20 or 30,000 cells.
I need to do some systematic search-and-replaces to get a handle on the data. It's probably about 20 or 30 searches, and it's taking me about five minutes for EVERY SEARCH. This is unfathomable on a modern spreadsheet app. I could have done it faster on Excel with a Mac Plus in 1987.
What's more, there's no way to specify a search range -- you either search and replace the entire document (even through multiple spreadsheets on the same document) or nothing.
If I want to search and replace in a specified range, I have to copy the data to a new file, do the search there, then copy back.
FIX this, Apple!
</rant>
I need to do some systematic search-and-replaces to get a handle on the data. It's probably about 20 or 30 searches, and it's taking me about five minutes for EVERY SEARCH. This is unfathomable on a modern spreadsheet app. I could have done it faster on Excel with a Mac Plus in 1987.
What's more, there's no way to specify a search range -- you either search and replace the entire document (even through multiple spreadsheets on the same document) or nothing.
If I want to search and replace in a specified range, I have to copy the data to a new file, do the search there, then copy back.
FIX this, Apple!
</rant>