Skip to Content
avatar image
Former Member

size and position while exporting to excel

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 25, 2017 at 01:21 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • 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

    Don

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    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.

    Thanks

    Best regards,

    Tina

    datestheziadd-formular-of-x.png

    datestheziformular-of-width.png
    Add comment
    10|10000 characters needed characters exceeded