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.
Over the years I've created sheets which contain some kind of catalog of my creations.
1. cell: name
2. cell: thumbnail image
3. cell: creation date, ...
Before I switched to Mac I've used MS Office to create these sheets and could sort elements consistently.
Now with Numbers everything sorts, except the images.
What do I have to do, to let images sort with the row they belong to?
MacBook Pro, macOS Sierra (10.12.3)
Images pasted into Numbers cells become Image Fill, a format setting of the cell.
Images below are png files inserted in the cells of column B.
This image shows the table sorted descending on column A
The one below shows the same table sorted ascending on column A:
Note that the order of rows has reversed, and the images have been carried along with the sort.
The table cannot be sorted on the contents of bolumn B because the cells in column B contain no data on which to base the sort.
Regards,
Barry
Images pasted into Numbers cells become Image Fill, a format setting of the cell.
Images below are png files inserted in the cells of column B.
This image shows the table sorted descending on column A
The one below shows the same table sorted ascending on column A:
Note that the order of rows has reversed, and the images have been carried along with the sort.
The table cannot be sorted on the contents of bolumn B because the cells in column B contain no data on which to base the sort.
Regards,
Barry
The trick is to ensure that your images are pasted into table cells rather than just onto the sheet that contains the table.
Note that Numbers is pretty good at storing and displaying a relatively small number of images, but if you have a good number of images your Numbers document will become bloated in size and it will stay bloated even if you think you have "deleted" images from cells.
SG
"Numbers is pretty good at storing and displaying a relatively small number of images, but if you have a good number of images your Numbers document will become bloated in size…"
Especially true if you do not reduce the size (a copy of) of the image file before pasting it in!
Barry
Hi hv,
From your description, Excel cells can be 'containers' for images.
Numbers cells cannot, so the images are pushed out of the cells as part of the translation of Excel files to Numbers documents. Images displayed in Numbers cells are part of the cell's format, not part of its contents.
Regards,
Barry
Barry wrote:
Hi hv,
From your description, Excel cells can be 'containers' for images.
Not really. But properties of images in Excel can be set to 'Move and size with cells' or 'Move but don't size with cells' or 'Don't move or size with cells.' Note the plural, not a single cell.
An image in Numbers, if pasted into the background of a cell rather than left on the canvas of the sheet, can be thought of as "belonging" to that particular cell as its 'Image Fill.' It will move with the cell. Once a background fill has been added, it never really "goes away." The image can be hidden by formatting the cell as 'No Fill'. But it's still there, in the bowels of the .numbers package, and reappears as soon as fill is set back to 'Image Fill' or 'Advanced Image Fill'.
If a document becomes bloated, there are ways in Finder to delve into the guts of the .numbers package to excise unused images, but that's not for the faint of heart.
SG
Right! While migrating from Excel, the images were imported not in their cells, but absolutely positioned.
You "only" need to cut the image, click the cell and insert it again. ...can take some time!
Sorting of rows including images
