Hi forum,
In my Numbers '09 sheet I have hundreds of (empty) cells with different background colors. I want to replace the (empty) content of these cells with some text. This text will be the same for all these cells.
Is this possible without looking for them manually?
Koen
Hello Koen,
Without a script, the only way I can think of would be to sort the columns one at a time to collect the empty cells together and then Fill the blank ones by Pasting into the range of blanks.
Before you do this, make sure that you have one column that you can later sort on to return the table to it's original order.
Jerry
Hi Jerry,
Sorting on a single does not word, since there are also empty cells which do not need to be edited (those with a white background).
I tried importing the sheet into a Pages table, since I remember in Pages it is easier to find and replace on formatting. However, I cannot find a way to import a Numbers sheet into a Pages table.
Koen
There is no sheet in Pages, just tables.
Tables in Pages are restricted to a smaller number of rows and columns than tables in Numbers.
Yvan KOENIG (VALLAURIS, France) mercredi 25 janvier 2012
iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.2
My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k
Sorry, there's no way to sort on background fill color in either Numbers or Pages. This sort of problem is best addressed in the design phase of your spreadsheet project.
Jerry
Hi Jerrold
Even with a script it would be awful.
There is no way to get the cell's background color with standard AppleScript.
To achieve the wanted goal it would be necessary to use an awful piece of code which I posted some weeks ago in :
https://discussions.apple.com/thread/3651426?answerId=17291847022#17291847022
Yvan KOENIG (VALLAURIS, France) mercredi 25 janvier 2012
iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.2
My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k
find and replace cells with formatting
