wrong cell width with autosize in cell containing text

Topics: Developer Forum, User Forum
Oct 6, 2014 at 9:52 AM

I have made a sheet using office 365, but when showed online the cell width is often too narrow and text is wrapped. I have tried with different fonts an browsers, but to no avail. if I insert varying no. of spaces (after text length) I can force it to work, but that not a good solution.
Please help.

Regards Bo
Oct 8, 2014 at 1:54 PM
How are you using PHPExcel with this Office365 worksheet?
Oct 9, 2014 at 12:22 PM
I have made a sheet in office365 and uploaded it, and it's when i'm displaying it online with PHPExcel, the width is too narrow

Sorry, I should have been more clear, but - you know - it was obvious to me :-)
Oct 9, 2014 at 12:35 PM
Edited Oct 9, 2014 at 12:36 PM
How are you displaying it online with PHPExcel? What does your code look like? How are you setting the cell widths in Office365?
Oct 9, 2014 at 1:05 PM
My code is not much:

error_reporting(E_ALL ^ E_NOTICE);
require_once './Classes/PHPExcel/IOFactory.php';
$objPHPExcel = PHPExcel_IOFactory::load("Mappe1.xls");
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'HTML');

The sheet is made with auto width

You can see it at http://tulstrup.net/rul/rul1.php - I'v put ekstra spaces in, to make it look nice, except in cell D:10 - 4. okt third "navn" containing " Helene til 13/Lisa fra 13" and this is therefor wrapped to two lines.