Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

OK, this is a weird one. I take my blank Numbers sheet:

Blank sheet imported from blank CSV

...and export it to Excel:

enter image description here

Whoah, that seems a little large. Let's rename the Excel doc to .zip and have a look inside:

enter image description here

Digging a little deeper:

enter image description here

Well, we just found 99% of the file size. But what is it — some sort of embedded preview image? Let's open it:

enter image description here

Nope, just a 635x635 PNG of random noise. Anyone have any idea what's going on here?

share|improve this question
3  
At a guess, the PNG contains metadata that Numbers would like to roundtrip back into itself. PNGs can be used to store compressed data reasonably easily. This is used quite a lot in the demo scene where you have hard limits on how big your program can be. For more information see JsExe: pouet.net/prod.php?which=59298 . I don’t have a copy of Numbers to test unfortunately. –  Robin Aug 18 at 12:27
3  
I've tried deleting the image, and well, that doesn't affect the spreadsheet. And that's a little more odder... –  Nib Aug 18 at 12:41
    
It doesn't happen for me. I get a roughly 100 KiB file. Half of it are the preview images and a third is ThemeStylesheet.iwa. I'm using Numbers 3.2 (1861). –  Lukas Aug 18 at 12:44
3  
If you think that is weird, try exporting a file from Pages in Word 1997-2004 format. You'll get three of these PNGs. For a grand total of 1.5GB of useless. mcmillan.cx/blog/2014/05/31/bloated-exports-from-pages-5.2 –  Alistair McMillan Aug 18 at 13:16
4  
Oops. The comment should say 1.5 MB. –  Alistair McMillan Aug 19 at 12:19

3 Answers 3

up vote 39 down vote accepted

I'm not sure why it's included in the export, but this is one of the default "Image Fills": Image Fill

share|improve this answer

tl;dr: it's the default shape fill, strictly unnecessary if there are no shapes.

XLSX, DOCX and other formats use OPC (the open packaging conventions), which mandates the zip container and describes how files should be laid out. If there is a file that you do not recognize, look in the various relationship files (they end in .rels).

In this case, the relevant line can be found in the themes relationship file xl/theme/_rels/theme1.xml.rels:

  <Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/image" Target="../media/image1.png"/>

The file will be referenced in xl/theme/theme1.xml as rId1. Using ECMA-376 as a guide, you will find it referenced as the default shape fill:

<a:objectDefaults>                    <-- shape/line/text defaults
  <a:spDef>                           <-- shape defaults
    <a:spPr>                          <-- shape properties
      <a:blipFill rotWithShape="1">   <-- picture fill
        <a:blip r:embed="rId1"/>      <-- references the picture

The writer must not be omitting the image if there is no shape.

share|improve this answer

Keynote files exported to PowerPoint do things like this too. That PNG is a background fill from Keynote, and is made available to PowerPoint to be used as the default shape fill for shapes created in the exported document. Keynote not only exports your document, but also the template style elements it was created with - even if some of those style elements (i.e. the background image) haven't been used yet.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.