Writing XLSX format and column/alignment problem about spout HOT 4 CLOSED

Hey @finalwebsites,

There seems to be something wrong with the "wrap text" feature when reading an XLSX file in Open Office. Although if you unset and re-set "wrap text" on the column, it fixes the weird display.
Have you tried exporting an ODS file instead to see if that works better?

In Excel, it works as expected (although the default width for some columns is way too small... I need to fix that!).

from spout.

Hi @adrilo,
Thanks for the tips.
You're right a re-set on the wrapping option is good workarround and the files are okay in MS Excel and Google Spreadsheets. No I never tried the .ods file.

from spout.

I'd like to keep this open, as this is an actual issue.

from spout.

I investigated deeper and the only way to have this properly working is by setting the exact height of the row. Which requires intensive calculations: for each cell, based on the chosen font and the width of the column, we need to send the text content to a graphic library to get what the final height of the row needs to be to have the whole text fit.

To keep good performance, I'd like to avoid doing this if possible. Anyway, I created a new issue to track this enhancement, if I (or someone else) ever wants to tackle it: #129

from spout.