Hi all, I was developing a small report on our CRM with SAP_BASIS 750 0026 and SAP_ABA 750 0026. During development we switched to SAP GUI 8 patch 8 from SAP GUI 7, and the behaviour of the “view in Excel” button switched to in place instead of opening an Excel application window outside SAP GUI. No SAP update on the server was done at this time.
I am using this code:
cl_salv_table=>factory(
importing
r_salv_table = lr_alv
changing
t_table = lt_display_data ).
* enable toolbar for e.g. Excel button
lr_functions = lr_alv->get_functions( ).
lr_functions->set_all( abap_true ).
catch cx_salv_msg into lx_salv_msg.
message ‘error’ type ‘E’.
endtry.
With the old SAP GUI version the Excel button opened a new Excel window. After the update I now get Excel in place, which is worse for our use case,especially as we cannot save (it saves a temporary file that cannot be overriden, and “save as” is not available in this mode, it seems).
I have tried to figure out how to force opening in an Excel app window, but so far have not had luck.