Skip to Content
author's profile photo
Former Member

How to change default selected format for spreadsheet export.

Hello Experts ,

While downloading one report in excel (spreadsheet export ) , I selected one format & also I selected the option " Always use selected format "

Now I want to change that format , but it doesnot take me to the change format screen since I selected the option of always use this format .

How to deactivate this ? I want to select another format .

Thanks in advance.

Abhishek.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

7 Answers

  • Best Answer
    author's profile photo
    Former Member
    Aug 30, 2014 at 02:39 AM

    As mentioned by Mike Kostek, it is working!

    1) simply just execute any report,

    2) Right click anywhere in the report.

    3) Select the "Spreadsheet" from the pop up box.

    4) Now you are able to export to Excel with your chosen option

    5) Once above action done, the " Always use selected format " shall be turn unchecked!


    Capture01.JPG (27.1 kB)
    Capture02.JPG (26.0 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 25, 2009 at 12:48 PM

    Try following...

    Execute report

    Right click anywhere in the report output and select u201CSpreadsheetu201D

    A pop up box will appear, select which export option you would like to use and click green check

    Exit report and then re-execute report

    Choose u201CList -> Export -> Spreadsheetu201D from menu options

    Select preferred export option and check u201CAlways use selected formatu201D checkbox and then green check

    You should now be able to export to Excel with your chosen option

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Aug 11, 2009 at 08:02 AM

    When you are in the line item overview.

    Go in the menu to Settings / Switch list

    Click with the right mouse button on the context menu (left site top from the list)

    2 Select Spreadsheet

    Now you get the old menu back that you can select

    see SAP note's:

    1080608 - Defining ABAP ALV export format for spreadsheet

    1065001ALV export XML: Customizing of export options

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Aug 11, 2009 at 07:54 AM

    Hi!

    You need to run program SALV_BS_ADMIN_MAINTAIN (might need to ask someone to do it unless you have authorizations to run programs).

    Instructions can be found in this thread in the second last post:

    [always-use-selected-format-check-box-in-line-items;

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Aug 11, 2009 at 07:54 AM

    Hi

    Use transaction SALV_BS_ADMIN_MAINTAIN

    Hope this helps.

    Rene

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 23, 2015 at 06:52 PM

    Hi,

    I believe the following SAP note is what you are looking for too:

    https://support.wdf.sap.corp/sap/support/notes/1678355

    Hope this was helpful for you.

    Regards,

    Cristiano

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    May 08, 2015 at 09:17 AM

    Hi Abhishek..

    I am facing 1 issue which exporting my report output to Excel..

    There are some values which are coming as # .I have to replce it with some String..

    The frontend tool which I am using is WAD .There I was able to manage with some JAVAScript but the Excel generated after Exporting it to Excel there it is not reflecting ..

    Please let me know if you have any idea about this ..

    Any help will be greatly appreciated!!!

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Mahip/Chan

      Thanks but my issue is somewhat different .I have a report in which I am getting values as # so I have written some JAVAScript there at browser level to replce it with No Applicable Data now when I export it to Excel this JavaScript is not reflecting in my downloaded Excel file and I am getting the # value which should be No Applicable Data .I hope you are clear on the issue...

      Please let me know if you have any solution for this..

      Regards,

      Suraj Grewal