Automatically calculate columns width / rows height

[adrilo]

Instead of using the default width/height, Spout could calculate the optimal width/height for each cell, based on its content.

This involves using a graphics library, render the text content with the chosen font and get the width/height of the rendered text.

This calculation may be slow so it should be optional. It can also be used when using "wrap text" as wrapping does not work well without a custom row height in LibreOffice.

Spout should expose an option to automatically set the optimal width/height but should also allow developers to specify a max width / height. When the max width is reached, the content will automatically wrap and the cell height will increase. It will increase until it reaches the max height.

[zendre4]

+1

[linaspasv]

+1

[ttkulm]

+1 Would be a really good feature!

[arisdario]

+10

[jordanade]

I don't need auto-fit, just a way to set widths for each column! Any way to workaround/hack this for now?

[jordanade]

Oh, figured it out--just added this line to Worksheet.php, startSheet(), between the header and the data:
fwrite($this->sheetFilePointer, '<cols><col min="1" max="1" width="100" customWidth="1"/><col min="2" max="6" width="30" customWidth="1"/></cols>');

[adrilo]

@jordanade You can also look at #225 if you need to hack something that works.
I'm not a big fan of this as it creates an API that is specific to XLSX. Also, if Spout could automatically calculate the width of each column, it would solve 95% of the problems. So I'd rather have this transparent solution in place, instead of having to manually specify the width of each column.

[jordanade]

Surely there is room for APIs that may not work for all possible file outputs? Best effort, etc...

[adrilo]

I'm actually trying to avoid this as much as possible. Although I'll definitely reconsider after implementing the automated method.