When exported to excel template, template layout changes?!

Tiwaz
Tiwaz Member Posts: 98
in NAV Tips & Tricks
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!! :D

Best Answer

Answers

  • Kishorm
    Kishorm Member Posts: 921
    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
    Tiwaz Member Posts: 98
    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?

Categories