News for hackers. Stuff that matters.
Re:Why does Numbers hide a huge PNG file in exported Excel s... by lukashed on Monday August 18, 2014 @08:30AM (#8192336)
I'm not sure why it's including this in the export, but this is one of the default "Image Fills".

http://f.cl.ly/items/1X0M2o0V0f3A463c0a2H/Untitled_numbers.p...

Re:Why does Numbers hide a huge PNG file in exported Excel s... by donatj on Monday August 18, 2014 @09:52AM (#8192593)
If you ever dissect an uncompressed pages file there's a lot of junk in there you really don't need. My guess would be that this is a case of that, Apple including the default fill pattern when it need not be included.

Uncompressed, an empty pages file includes about a megabyte of XML for a 3x3 sheet with tons of absolutely unnecessary default metadata about the sheet as well as each individual cell. Pages really isn't very good at knowing what it actually needs to include.

I spent a few days dissecting the format a few years back at a previous job for a data processing tool. We decided it wasn't worth our time.

As for the size, some things simply don't compress well in PNG.

Re:Why does Numbers hide a huge PNG file in exported Excel s... by gchokov on Monday August 18, 2014 @09:02AM (#8192423)
I guess the other color image fills are just variation of the original blue image.
Re:Why does Numbers hide a huge PNG file in exported Excel s... by alistair75 on Monday August 18, 2014 @09:21AM (#8192477)
Pages does it too. Export a document in DOCX format and you get the same PNG file. Export a document in Word 97-2003 format and you get three of these PNG files!

http://mcmillan.cx/blog/2014/05/31/bloated-exports-from-page...

Re:Why does Numbers hide a huge PNG file in exported Excel s... by brad0 on Monday August 18, 2014 @11:51AM (#8193159)
From the looks of the OOXML format, the image there is just used as a resource. http://web.mit.edu/~stevenj/www/ECMA-376-new-merged.pdf xl/theme/_rels/theme1.xml.rels refers to image1.png. I'd say it's a default background of some description. Still, it would be cool if there was something in there. Maybe taking a look at the frequency of the bytes would help?
Re:Why does Numbers hide a huge PNG file in exported Excel s... by jackgavigan on Monday August 18, 2014 @09:04AM (#8192428)
Someone should run that image through a steganalysis tool.
Re:Why does Numbers hide a huge PNG file in exported Excel s... by UnoriginalGuy on Monday August 18, 2014 @09:39AM (#8192535)
Or more simply, just MD5 them from two machines and see if the hashes (and sizes) match. It is actually quite hard to find hidden text in "random" images. Quite easy to tell if they're identical always however...
Re:Why does Numbers hide a huge PNG file in exported Excel s... by DanBC on Monday August 18, 2014 @10:03AM (#8192629)
Most steganography is trivially easy to detect. Good steganography needs a lot of cover data and better systems than manipulating the LSB.
Re:Why does Numbers hide a huge PNG file in exported Excel s... by nitrogen on Monday August 18, 2014 @10:17AM (#8192690)
If the distribution of bits in an encrypted stream is indistinguishable from normal image dithering, wouldn't encrypted steganography be hard to detect?

It wouldn't survive any lossy image transformations, though.

Re:Why does Numbers hide a huge PNG file in exported Excel s... by MichaelGG on Monday August 18, 2014 @10:22AM (#8192713)
Steganography on normal pictures. If the picture is just random pixels then it would not be detectable.
Re:Why does Numbers hide a huge PNG file in exported Excel s... by DanBC on Tuesday August 19, 2014 @01:46PM (#8198717)
Randomness is something that cryptographers have spent a lot of time studying.

Introducing non-random data into a random data stream is easy to find unless you're very careful about the amounts of data-to-be-hidden and cover-data.

Re:Why does Numbers hide a huge PNG file in exported Excel s... by MichaelGG on Tuesday August 19, 2014 @06:07PM (#8200084)
If you encrypt the data first, then you're inserting "random" data as far as analysis goes.
Re:Why does Numbers hide a huge PNG file in exported Excel s... by hamed_benz on Wednesday August 20, 2014 @03:58AM (#8201453)
salam
Re:Why does Numbers hide a huge PNG file in exported Excel s... by valevk on Monday August 18, 2014 @08:52AM (#8192394)
It doesn't seem to be explicitly associated with Numbers, but with Excel: http://www.it-volpers.net/2011/03/21/disassemble-xlsx/
Re:Why does Numbers hide a huge PNG file in exported Excel s... by kyberias on Monday August 18, 2014 @10:17AM (#8192691)
The file in the OP's article was generated by Numbers, not Excel. The png file in your link is there for a reason, since an image (a logo) was added in an Excel spreadsheet.

So you are mistaken.

Re:Why does Numbers hide a huge PNG file in exported Excel s... by UnoriginalGuy on Monday August 18, 2014 @09:41AM (#8192544)
That article doesn't support your conclusion. Did you draw that conclusion because the file is named "image1" in both the OP's article and that one?
Re:Why does Numbers hide a huge PNG file in exported Excel s... by louhike on Monday August 18, 2014 @10:22AM (#8192712)
According to one of the answer, it is an image to fill used by Excel. So its goal is the same, even if the picture is different.
Re:Why does Numbers hide a huge PNG file in exported Excel s... by wlesieutre on Monday August 18, 2014 @11:04AM (#8192927)
The image1.png file included by Excel is definitely an image that the author used in the spreadsheet, not a piece of cruft. Since he provides a copy of the xslx file, it's trivial to check:

http://i.imgur.com/j1A5vvC.png

Re:Why does Numbers hide a huge PNG file in exported Excel s... by eXpl0it3r on Monday August 18, 2014 @08:46AM (#8192383)
It doesn't happen to me. No strange image gets included when saving the spreadsheet.
Re:Why does Numbers hide a huge PNG file in exported Excel s... by lallysingh on Monday August 18, 2014 @08:52AM (#8192392)
Maybe it's a default that the user's set (say as part of a user style)?
Re:Why does Numbers hide a huge PNG file in exported Excel s... by brad0 on Monday August 18, 2014 @11:20AM (#8193012)
Here's something interesting. The image only has 47 unique RGB values in it. 47 is such an arbitrary amount though. It doesn't go into power of two cleanly.
Re:Why does Numbers hide a huge PNG file in exported Excel s... by brad0 on Monday August 18, 2014 @11:22AM (#8193022)
The colours go from 16708e and increase all RGB values by one. So the next ones are 17718f, 187290, 197391 etc.
Re:Why does Numbers hide a huge PNG file in exported Excel s... by gchokov on Monday August 18, 2014 @08:58AM (#8192414)
Can't be just a placeholder. If it was, it would be a single color for a better compression. Hence the whitenoise - it helps to maintain compression ratio low.
Re:Why does Numbers hide a huge PNG file in exported Excel s... by th3iedkid on Monday August 18, 2014 @08:29AM (#8192329)
What is that image?Any answers from anyone in HN?
Re:Why does Numbers hide a huge PNG file in exported Excel s... by jbrooksuk on Monday August 18, 2014 @08:36AM (#8192352)
The first comment on the question itself makes the most sense to me.

Edit: Sure, downvote me ;)