Skip to Content

size and position while exporting to excel

Oct 25, 2017 at 01:00 PM


avatar image


I created a page where the fields automatically change the size by the length of the field I got from the database. I'm using the function of the size and position.

like this: length(Totext (Maximum ({Items_Daily._Dtl_05}))) + 1 in size and position, you have to set a defualt value to the "width" column, to see the column in the design.

And when you go to preview the field take the length of the data and it works fine.

The Problem:

when I'm exporting to excel the column size go by the defualt value of the "Size and postiion" defualt width, and not by my changing width formula.
See attached image.

The Question:

How can I make the export to excel get the width size from my formula and not the defualt value?



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Ido Millet Oct 25, 2017 at 01:21 PM


If you need more control over the final output, see list of 3rd-party tools here.
At least one of these tools allows you to automate exporting to Excel and injecting the content into a highly formatted Excel template.
Here is a sample image from one of these tools.

10 |10000 characters needed characters left characters exceeded
Don Williams
Oct 25, 2017 at 01:12 PM

Hi Hezi,

You can't, the formatting engine needs to use some value so it can set the size for the data container before it starts exporting.

If you use Google search you should be able to fins a doc on how to optimize when exporting.

Search for this KBA:

1841430 - How to design a report that will export well to MS Excel from


10 |10000 characters needed characters left characters exceeded
Tina Li
Feb 05 at 08:35 AM

Hi Hezi,

We have tried some other ways to resolve this problem, hope it can help you:

  1. Setting this column on exported Excel as Wrap Text. (It can be displayed the whole text for this field and will not impact other fields’ display)
  2. Add formula of the field which you want toautomatically change the size. Also add formula of the next field on X (size and position).

More details information please check the screenshot in attachment. Please feel free to let us know if you have any concern.


Best regards,




10 |10000 characters needed characters left characters exceeded