When exported to excel template, template layout changes?!

Tiwaz

Hi guys.
I created processing only report that exports my document to excel template (attachment "1.xls"). But when it exporst, it completely changes my template (atachment "2.xls").
Not only does it spread this excel file to 2 pages in excel, but it also removes borders and field coulouring. Latter 2 i do not mind so much, but I would like it to stop spreading my template to 2 pages.
Does anyone know what can cause this?
THANKS!!

Kishorm

Difficult to say without seeing any of your code or knowing what version of Excel Buffer you are using.

Search for XlWrkShtWriter in Table 370, if you have this then you can use the XlWrkShtWriter.SetColumnWidth method to resize the 1st column.

Kishorm

It looks like it's caused by the descriptions in the first column. In your original file the descriptions "overflow" across several columns whereas in the second file the first column is expanded to allow the full description to fill it.

You could try merging the columns in the original file where you have long descriptions, this will probably stop the column being expanded.

Tiwaz

Hm, yeah, you are right. I have merged all of those cells but it still did not help. Is there a way to create a function, or alter my function EnterCell() in a way not to allow any formating or moving of columns?

Kishorm

Difficult to say without seeing any of your code or knowing what version of Excel Buffer you are using.

Search for XlWrkShtWriter in Table 370, if you have this then you can use the XlWrkShtWriter.SetColumnWidth method to resize the 1st column.