Add bill photo to a cell in a shared document


This is a shared file where two people work on this file at different system at different location.what i want is,in the last column Bill, the photo of bill is added by one person so that other person can view this bill from another system.is it possible to accomplish this ? Can shared album be used for this purpose?

Posted on Aug 13, 2021 6:35 AM

Reply
Question marked as Top-ranking reply

Posted on Aug 13, 2021 1:32 PM

I don't use the collaboration features but you should be able to use a photo of a bill as a background image in a cell and everyone should see the same background image. The real problem is in viewing that photo. You cannot click or right click on the cell to have the photo enlarge. The photo will never be bigger than the cell it is in and it is not convenient to resize the column and row to see it, then put it all back like it was. There is a way to view a background image in full resolution but it isn't all that convenient or easy either. If you have the Preview app in your dock, you can drag the image from the cell inspector and drop it on the Preview icon on the dock and it will open the full size image in Preview.





An alternative is to host your photos online and put hyperlinks to them in your spreadsheet. A click would take you to the online photo. That may be what you were alluding to by asking about a "shared album". If each photo has its own URL, I see no reason why a "shared album" wouldn't work.


7 replies
Question marked as Top-ranking reply

Aug 13, 2021 1:32 PM in response to NALK

I don't use the collaboration features but you should be able to use a photo of a bill as a background image in a cell and everyone should see the same background image. The real problem is in viewing that photo. You cannot click or right click on the cell to have the photo enlarge. The photo will never be bigger than the cell it is in and it is not convenient to resize the column and row to see it, then put it all back like it was. There is a way to view a background image in full resolution but it isn't all that convenient or easy either. If you have the Preview app in your dock, you can drag the image from the cell inspector and drop it on the Preview icon on the dock and it will open the full size image in Preview.





An alternative is to host your photos online and put hyperlinks to them in your spreadsheet. A click would take you to the online photo. That may be what you were alluding to by asking about a "shared album". If each photo has its own URL, I see no reason why a "shared album" wouldn't work.


Aug 13, 2021 4:41 PM in response to NALK

Correct. If your accountant uses Dropbox, for instance, each file has its own URL. He/you would paste the URL into a cell in the Numbers document. Clicking on the link would take you to Safari and to that image. I assume the same would be true for a shared album in iCloud. You will probably want your images hosted on an account that you "own", whether it is a Dropbox account or iCloud or another service.

Aug 16, 2021 2:28 PM in response to NALK

Another way of enclosing the images as image fil in a cell, then displaying those images at or closer to full scale is to place a second table, consisting of one cell (or more) of the size you want the image to be for viewing purposes.


Expanding the image then becomes a Copy and Paste process:





The main table is the one on the left, containing the 'bill image' as background fill in cell E2. The (larger) single cell table on the right is the 'Viewing table,' wher the image will be placed for viewing.


Select Cell E2 with a single clock, then press option-command-C to copy the cell's format settings, including Image Fill, and the image used in that fill.


The select cell A1 of the single cell table (single click), and press option-command-V to paste the copied format into that cell. For the image above, the result is shown below:



To remove the image from the 'Viewing Table,' Select and copy the format settings of any cell that has been set to No Fill, then Paste that format into the Viewing Table cell. using the same option-commnd-C and option-command-V keystroke combinations as above..


Regards,

Barry


PS: consider adding a second cell to the viewing table, set to have No Fill, to provide a convenient fixed location from which to copy this setting to be pasted into A1 to clear it.


B.



Aug 14, 2021 3:24 PM in response to Badunit

Hey badunit.Thank you very much again for giving me the idea of dropbox.actually i am not familiar with dropbox so i gonna learn about dropbox and use your idea of pasting the url into the cell for bill.For the shared album in icloud, i dont think i will get an url that is to be pasted in the cell

Aug 13, 2021 4:17 PM in response to Badunit

Thank you very much badunit for your reply.In your reply,you have given two solutions 1) To use photo of bill as a background image in a cell and this was explained well 2) To host photo of bill online and put hyperlinks to the cell under bill

i am interested in solution 2.and my idea is my accountant create a shared album with me and he add all the bill to it and then he add hyperlinks under column for bill correspond to each expense.For example if i click on hyperlink correspond to newapaper i should get the photo of newspaper bill which is stored in shared album

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Add bill photo to a cell in a shared document

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