size and position while exporting to excel

[Former Member]

Description:

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?

thanks,

Hezi

[Former Member]

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.

Thanks

Best regards,

Tina

datestheziadd-formular-of-x.png

datestheziformular-of-width.png

[ido_millet]

See: http://kenhamady.com/cru/archives/231

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.

[former_member11696]

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

Don