<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: formatting when using gui_download in Application Development and Automation Discussions</title>
    <link>https://community.sap.com/t5/application-development-and-automation-discussions/formatting-when-using-gui-download/m-p/3185028#M758374</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;You may try passing REFERENCE TABLE &amp;amp; REFERNCE FIELD in the FIELDCATALOG of ALV, if its an ALV output.&lt;/P&gt;&lt;P&gt;Export to LOCAL file of ALV will then provide an excel file with proper alignment.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Best regards,&lt;/P&gt;&lt;P&gt;Prashant&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 20 Dec 2007 04:14:46 GMT</pubDate>
    <dc:creator>Former Member</dc:creator>
    <dc:date>2007-12-20T04:14:46Z</dc:date>
    <item>
      <title>formatting when using gui_download</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/formatting-when-using-gui-download/m-p/3185027#M758373</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi All,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I am using method gui_download to download data containing korean characters to .txt file. If i dont mentioned codepage in gui_download, korean characters appears as # but formatting is ok. When i mentioned codepages korean characters appear fine but some extra spaces get added and that is why column looks zigzag. Is there any other way to mention codepage. how to get proper formatting of the column.&lt;/P&gt;&lt;P&gt;My code is as foolowing:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;CALL METHOD CL_GUI_FRONTEND_SERVICES=&amp;gt;GUI_DOWNLOAD&lt;/P&gt;&lt;P&gt;  EXPORTING&lt;/P&gt;&lt;UL&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;   BIN_FILESIZE              =&lt;/P&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;    FILENAME                  = Zfilename&lt;/P&gt;&lt;P&gt;    FILETYPE                  = 'ASC'&lt;/P&gt;&lt;UL&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;   APPEND                    = SPACE&lt;/P&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;    WRITE_FIELD_SEPARATOR     = 'X'&lt;/P&gt;&lt;UL&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;   HEADER                    = '00'&lt;/P&gt;&lt;/LI&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;   TRUNC_TRAILING_BLANKS     = SPACE&lt;/P&gt;&lt;/LI&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;   WRITE_LF                  = 'X'&lt;/P&gt;&lt;/LI&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;   COL_SELECT                = SPACE&lt;/P&gt;&lt;/LI&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;   COL_SELECT_MASK           = SPACE&lt;/P&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;    DAT_MODE                  = 'X'&lt;/P&gt;&lt;UL&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;   CONFIRM_OVERWRITE         = SPACE&lt;/P&gt;&lt;/LI&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;   NO_AUTH_CHECK             = SPACE&lt;/P&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;    CODEPAGE                  =  '8500'&lt;/P&gt;&lt;UL&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;   IGNORE_CERR               = ABAP_TRUE&lt;/P&gt;&lt;/LI&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;   REPLACEMENT               = '#'&lt;/P&gt;&lt;/LI&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;   WRITE_BOM                 = SPACE&lt;/P&gt;&lt;/LI&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;   TRUNC_TRAILING_BLANKS_EOL = 'X'&lt;/P&gt;&lt;/LI&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;   WK1_N_FORMAT              = SPACE&lt;/P&gt;&lt;/LI&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;   WK1_N_SIZE                = SPACE&lt;/P&gt;&lt;/LI&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;   WK1_T_FORMAT              = SPACE&lt;/P&gt;&lt;/LI&gt;&lt;LI level="1" type="ul"&gt;&lt;P&gt;   WK1_T_SIZE                = SPACE&lt;/P&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;  IMPORTING&lt;/P&gt;&lt;P&gt;    FILELENGTH                = LEN&lt;/P&gt;&lt;P&gt;  CHANGING&lt;/P&gt;&lt;P&gt;    DATA_TAB                  = downtab[]&lt;/P&gt;&lt;P&gt;  EXCEPTIONS&lt;/P&gt;&lt;P&gt;    FILE_WRITE_ERROR          = 1&lt;/P&gt;&lt;P&gt;    NO_BATCH                  = 2&lt;/P&gt;&lt;P&gt;    GUI_REFUSE_FILETRANSFER   = 3&lt;/P&gt;&lt;P&gt;    INVALID_TYPE              = 4&lt;/P&gt;&lt;P&gt;    NO_AUTHORITY              = 5&lt;/P&gt;&lt;P&gt;    UNKNOWN_ERROR             = 6&lt;/P&gt;&lt;P&gt;    HEADER_NOT_ALLOWED        = 7&lt;/P&gt;&lt;P&gt;    SEPARATOR_NOT_ALLOWED     = 8&lt;/P&gt;&lt;P&gt;    FILESIZE_NOT_ALLOWED      = 9&lt;/P&gt;&lt;P&gt;    HEADER_TOO_LONG           = 10&lt;/P&gt;&lt;P&gt;    DP_ERROR_CREATE           = 11&lt;/P&gt;&lt;P&gt;    DP_ERROR_SEND             = 12&lt;/P&gt;&lt;P&gt;    DP_ERROR_WRITE            = 13&lt;/P&gt;&lt;P&gt;    UNKNOWN_DP_ERROR          = 14&lt;/P&gt;&lt;P&gt;    ACCESS_DENIED             = 15&lt;/P&gt;&lt;P&gt;    DP_OUT_OF_MEMORY          = 16&lt;/P&gt;&lt;P&gt;    DISK_FULL                 = 17&lt;/P&gt;&lt;P&gt;    DP_TIMEOUT                = 18&lt;/P&gt;&lt;P&gt;    FILE_NOT_FOUND            = 19&lt;/P&gt;&lt;P&gt;    DATAPROVIDER_EXCEPTION    = 20&lt;/P&gt;&lt;P&gt;    CONTROL_FLUSH_ERROR       = 21&lt;/P&gt;&lt;P&gt;    NOT_SUPPORTED_BY_GUI      = 22&lt;/P&gt;&lt;P&gt;    ERROR_NO_GUI              = 23&lt;/P&gt;&lt;P&gt;    others                    = 24 .&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Please reply.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 18 Dec 2007 09:29:58 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/formatting-when-using-gui-download/m-p/3185027#M758373</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2007-12-18T09:29:58Z</dc:date>
    </item>
    <item>
      <title>Re: formatting when using gui_download</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/formatting-when-using-gui-download/m-p/3185028#M758374</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;You may try passing REFERENCE TABLE &amp;amp; REFERNCE FIELD in the FIELDCATALOG of ALV, if its an ALV output.&lt;/P&gt;&lt;P&gt;Export to LOCAL file of ALV will then provide an excel file with proper alignment.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Best regards,&lt;/P&gt;&lt;P&gt;Prashant&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 20 Dec 2007 04:14:46 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/formatting-when-using-gui-download/m-p/3185028#M758374</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2007-12-20T04:14:46Z</dc:date>
    </item>
  </channel>
</rss>

