Nprinting export to excel by column locating column position

[ronaldwang]

When exporting to excel by column, if tick expand range, do we have option whether to expand up-down and left-right. say for example I only want to expand up-down, how can I achieve that? thanks

[Lech_Miszkiewicz]

Hi,

there is no such option, and to be honest expansion right-left will not apply when exporting to excel by column as you are already predefining number of columns. and they can only expand down.

The expansion realy works for:

• down direction with:
  • straight tables &
  • columns
• down  and right direction with
  • pivot tables

You can only expand or not expand.

The other property you may be interested in is width of columns which can be controlled on Excel side when switching off "Keep source formats" and setting a width of column of your choice in Excel.

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

[ronaldwang]

thanks Lech