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.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers - Have a cel equal to whatever you’re actively selecting?

I have a line item database; each row is one item in the database.

I use a cel in the row whose fill color is an image of the item whose entry it is to serve as a thumbnail.


Due to the size of the cel the thumbnail is very small.


As I’m browsing each entry on my tablet by selecting the thumbnail cel, I’d like a second, separate, much larger cel in a 1x1 table to display the fill of the selected cel to serve as a magnifier of the thumbnail.


Doable? How?

iPad Pro, iPadOS 16

Posted on Aug 19, 2024 3:50 AM

Reply
Question marked as Top-ranking reply

Posted on Aug 19, 2024 12:35 PM

That's pretty good. It made me think of the idea below where the images don't have to be in two places.



Formula in all data cells of column B (with the images) is =IF(A,REPT(CHAR(8232),15),"")

This creates a string of 15 line separator characters when the checkbox is checked. If the row heights are the default "automatic fit", the row height will expand. Use something larger than 15 to get a larger image. The width of column B will limit its size. Wider column = ability to show a larger image.


If the database is already populated with images you won't be able to drag-fill the formula to get the formula in all the rows. It will drag-fill the image along with it. You will have to copy/paste.

  1. Copy the formula from here, including the equals sign
  2. Select all the data cells in column B,
  3. Paste


If you want to edit them later (such as to change the 15 to something else),

  1. Edit one of them,
  2. Copy that cell,
  3. Paste & Match Style to the rest of the column. Do not use the normal Paste.


To "scroll" through the images/rows you can do this

  1. Select one of the checkbox cells
  2. Space bar to check it
  3. Space bar to uncheck it
  4. Arrow key to move to the next row
  5. Repeat at 2


3 replies
Question marked as Top-ranking reply

Aug 19, 2024 12:35 PM in response to Yellowbox

That's pretty good. It made me think of the idea below where the images don't have to be in two places.



Formula in all data cells of column B (with the images) is =IF(A,REPT(CHAR(8232),15),"")

This creates a string of 15 line separator characters when the checkbox is checked. If the row heights are the default "automatic fit", the row height will expand. Use something larger than 15 to get a larger image. The width of column B will limit its size. Wider column = ability to show a larger image.


If the database is already populated with images you won't be able to drag-fill the formula to get the formula in all the rows. It will drag-fill the image along with it. You will have to copy/paste.

  1. Copy the formula from here, including the equals sign
  2. Select all the data cells in column B,
  3. Paste


If you want to edit them later (such as to change the 15 to something else),

  1. Edit one of them,
  2. Copy that cell,
  3. Paste & Match Style to the rest of the column. Do not use the normal Paste.


To "scroll" through the images/rows you can do this

  1. Select one of the checkbox cells
  2. Space bar to check it
  3. Space bar to uncheck it
  4. Arrow key to move to the next row
  5. Repeat at 2


Numbers - Have a cel equal to whatever you’re actively selecting?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.