Change the image of a cell from another cell
Hello
Can you tell me if Big Sur fixed what I call a problem of changing the image in one table cell from another table? What is possible with text.
MA
iMac 21.5″, macOS 11.0
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hello
Can you tell me if Big Sur fixed what I call a problem of changing the image in one table cell from another table? What is possible with text.
MA
iMac 21.5″, macOS 11.0
HI MA,
"And, would there be an error… where you write "Select columns B and B of Table 1 ..."?"
Yes. It should have said "Select columns B and C of table 1.
With columns B and C of Table 1 hidden, and the filter NOT activated, Table ! will display all cells of column A:
(Note that for the example, I did not place an image (as image fill) in any of the other cells in the table, and I removes the text "FIVE" from A6.)
(Note also that the filter does not affect the Header row, which remains visible with the filter active or inactive.)
Checking the box to the right of "Filter" in the Filter pane activates the filter.
Regards,
Barry
HI MA,
"And, would there be an error… where you write "Select columns B and B of Table 1 ..."?"
Yes. It should have said "Select columns B and C of table 1.
With columns B and C of Table 1 hidden, and the filter NOT activated, Table ! will display all cells of column A:
(Note that for the example, I did not place an image (as image fill) in any of the other cells in the table, and I removes the text "FIVE" from A6.)
(Note also that the filter does not affect the Header row, which remains visible with the filter active or inactive.)
Checking the box to the right of "Filter" in the Filter pane activates the filter.
Regards,
Barry
Here's an example of the three column setup:
The formula shown below the table is entered in cell C2, and filled down to the end of that table,
Key values in column B can be words or numbers or short captions for each image.
After entering them, I selected rows 2 to 10 of this column, then in the Format inspector, chose Cell and set the Data format to Pop up Menu. That format was applied to all the cells, making each a pop up menu cell containing all of the values, and set to the one that is displayed.
That made it possible to Copy cell C2, then Paste to cell A2 in the Key table, putting the same pop up menu into the key table (Table 2), where it could be used to select which row (and image) to display.
On the larger table, Column C shows the results of the formula comparing the displayed value in each row with the displayed value in A2 of Table 2.
After setting up the tables, Select columns B and B of Table 1, then Hide those two columns, and click the checkbox to the right of "Filter" in the Inspector, and close the Inspector pane for this result:
To avoid 'bounce' when you switch images, remember to set all rows of Table 1 (except the header row) to the same height.
Regards,
Barry
I think I accidentally understood your example. And I have to say, this is the first time in years that I've come so close to a real answer. It is a great job that you have done. I believe I can now organize myself with this.
I am sending you a screenshot of two examples (out of 9) where I have placed images (logos) of 9 NHL teams and everything is working fine. I know I can put the name of the teams in place of the numbers.
There are some differences between our versions of Numbers. I have the latest version since this week.
Thank you very much, really.
Hello Barry
You have a good memory. The last time I asked for help with my hockey boards was 3 years ago. And you have helped me a lot.
I have not forgotten the Canadians (Cell #1). Given the time zones between us, I thought the Los Angeles Kings were a better fit for you. And I chose another team from the west (Vancouver) for the other example.
Now I can't wait to see how I can organize it all to do what I want. The fun is coming!
Thank you again for your help. I believe you will have some more of my questions to answer soon.
MA
And here is another success. We can change the data of 2 tables (and much more I guess) from a single cell.
I have a real pleasure to work with your discovery. I can't thank you enough for that!
Hope this can help others
Here 2 examples:
Hi Barry
The solution you offered me above a few days ago is probably the best ever for this problem. I realize that it is possible, from the same source, that we can change an image at will in several tables to have the same image everywhere (example 1) or, even, according to our choice, sometimes have 2 different images ( or more) (example 2).
I am not sure how this forum works. It would be very interesting, in my opinion, if you could come up with your solution so that as many people as possible could see it. It would be of service to a lot because during my research, for a long time, I noticed that several people were looking for a solution to the problem that I have submitted here.
For this purpose, I offer two examples which have exactly the same source.
Thank you again for your solution which makes my life easier !!!
MA
p.s. If my explanations are not clear, I can resume with several examples.
Hi Marc-Andr,
"text" in a cell is 'content'. "image" in a cell is "format"; specifically, "image fill".
Unless that has changed in the most recent version of Numbers, you cannot change the image fill of a cell using a formula referencing another cell.
You could place the images in a single column of a two column table, with a 'text key' or 'key number' in the second column, then Filter the table to show only rows containing the 'key' value placed in the control cell in the second table.
A quick glance at Filter rules shows they do not permit a direct reference to the value in another cell, so you may need to use a third column to convert the 'key' to a fixed value (such as "true" or "show" to fit the filter.
Regards,
Barry
Regards,
Barry
Hello Barry,
Ok. Now I think I was successful in setting up columns B and C of table 1 and A2 of table 2. But I don't understand how you get to the result of column A of table 1 which gives the picture we see on row A6.
And, would there be an error in the paragraph that starts with "After setting up ..." where you write "Select columns B and B of Table 1 ..."?
MA
"Thank you again for your help. I believe you will have some more of my questions to answer soon."
Looking forward to them!
Regards,
Barry
PS: I think my Hockey Hero was Goalie Glen Hall (before he was called up to the NHL).
B.
I don't think you are being serious here! Hall started in the NHL in 1952 (Wikipedia). So, having known him before, you are at least 75 years old! You are doing wonderfully well with Numbers for an old man of this age!
I was able to do it with a full row of information and 2 images. It promises to be interesting.
Thank you so much. However, I am not sure I fully understand your last 2 paragraphs. I'll check out what I can do and if I can't do it, let me come back to that for further help. Thanks again!
OMG, what an answer! I sincerely thank you. I will work on it in the next few days and come back to talk to you about it.
Looking good!
Happy to have helped.
But where are Les Canadiens? :-)
Regards,
Barry
Change the image of a cell from another cell