How to reduce image file size in spreadsheet

Maybe because of this?

Maybe you have some saved as a 'Single File' some as a 'Package'?

SG

When you insert a picture in a cell, it's used as a background.

To do that, the app keep it in a size allowing it to accomodate the larger cell size permitted.

If you want to get small images matching the cell size which you use, you must reduce the picture by yourself before inserting it. For instance, cells are often 72 * 16 pixels ones so you may reduce your pictures so that thir width become 72 pixels.

Of course, if the user enlarge the cell, the picture will become highly pixelated.

Look at this example.

In B4 is the original : 202 x 177 pixels

In C3 is the reduced one : 72 x 63

in B2 is the reduced one in a 202 x 177 pixels cell. It's awfully pixelized

We must arbitrate between size and quality.

Yvan KOENIG (VALLAURIS, France) samedi 10 septembre 2011 16:50:24

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

My iDisk is : <http://public.me.com/koenigyvan>

Please : Search for questions similar to your own before submitting them to the community

Hello

In Pages and in Numbers, the objects are :

main text layer (only in Pages WP documents)

charts

images

lines

shapes

tables

text boxes

I didn't made tests but I guess that only "images" are treated by the "Reduce Image File Size" feature.

Pictures inserted in tables aren't.

Yvan KOENIG (VALLAURIS, France) lundi 12 septembre 2011 10:30:53

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

My iDisk is : <http://public.me.com/koenigyvan>

Please : Search for questions similar to your own before submitting them to the community

I found an easier way to reduce the file size. this came after spending a couple of months building a spreadsheet full of pictures. I was not ready to go back and reduce the size of every single picture individually and then put them back in.

The solution provided in the earlier posts is not a fix. More like a bad process to what should be a built in process with in the app.

the problem lies with now numbers uses the pictures. the pictures are not just saved into the spreadsheet, The pictures are literally attached so the spreadsheet. So if you put in a 10 Mb pic, your file size increases by the same amount no matter the size.

So how do you fix it?

disclaimer: My files are all iCloud.

1. In Finder go to the file you need to reduce the size on.

2. Secondary click (right click) the file you want to reduce and select "Show Package Contents"

3. In the package contents, Select the Data Folder. The data folder contains all the attachments to the numbers file including all the pictures.

4. Select all the pictures you want to reduce the size on and secondary click (right click) Preview

5. In preview, select all the files using Command A

6. Select the Tools Menu then Adjust Size

7. Now you can select your picture size or set a custom size for all the pictures. At the bottom you will see the reduced size of all the files that in turn will reduce the size of your numbers file.

Hope this helps others. I think that numbers has some really great features missing from Windows excel and this file size restriction almost made me switch back. I'm glad I stuck it out and kept looking for another option.

M2140 you are my hero. thank you so so much for this!!! woohoo!!!

Actually, something strange is that on some of my numbers files, it doesn't say "show package contents". On others it does. Can't figure out why.