2 Replies Latest reply: Jun 8, 2017 1:03 AM by Ronald Wang RSS

    Nprinting export to excel by column locating column position

    Ronald Wang

      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

        • Re: Nprinting export to excel by column locating column position
          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.