Images in Cells

[MarkBaker]

There is a common misconception that images can be placed in cells. This isn't the case; images (including charts) are in a layer that floats above the spreadsheet, like on a transparency, hiding the spreadsheet behind them, but not a part of the spreadsheet itself. Any positioning and sizing so that an image appears to be inside a cell has always been the responsibility of the developer, not of PhpSpreadsheet.

That is about to change, as Microsoft plan to implement a new Excel IMAGE() function, probably rolled out on release sometime in December. This doesn't allow images that are embedded in the file, but it is linked image urls.

I've just got access to this through the Beta channel; so I'll be experimenting with it over the next week or two, to see how it works internally, and to see if I can implement it.

It is likely to have some effect on existing functionality, such as autosizing columns. So it may take a bit longer to implement.