ZCL_EXCEL_Converter

[ivanfemia]

The converter I provided to help for the OLE solution has still sevral bugs with sorting and layout processing in the background.
I have over the last weeks corrected and improved the converter.
Bugs found:

1. Sort grid will not convert correctly in background
2. Layout definitons will not be taken into account in background
3. Columnoptimization does not work in forground if not based on layout load.
   Enhancements:
4. Colored fields will be convertered
5. Subtotals will be created
   Let me know what you think.
   Rene

[ivanfemia]

I have resolved several issue I found using the converter.
I will create now a new demo file if your agree with all the possibilities.

[ivanfemia]

Thank you Rene a demo report would be great, maybe an enhancement to the existing one we are using.

I'm going to include it in my version :)

[ivanfemia]

Hi Rene,

I had a problem on line 20 of method ZIF_EXCEL_CONVERTER~CREATE_FIELDCATALOG of class ZCL_EXCEL_CONVERTER_EX_RESULT.

You're using get_ref_to_table this method is not available on 7.02, I made this change could you please check in your release;

old

lo_data = lo_bs_data->if_salv_bs_data_source~get_ref_to_table( ) .

new

lo_data = lo_bs_data->if_salv_bs_data_source~get_table_ref( ) .

[ivanfemia]

Rene,

do you have also a demo in WDA?

Thanks
Ivan

[ivanfemia]

Hi Ivan

I will fix the issue with the lo_bs_data object problem.
if_salv_bs_data_source does not exist in 7.00. I will do a check and use the interface if it exists, otherwise the old logic will be used. No idea if this will work in 6.40 or 6.20

I am still working on the WD interface. There is issues with getting all the formating correctly. Until now I have only figured out the data table. As soon as it fully works I will let you know and than clearly I can provide an example.
Rene

[ivanfemia]

Move to new in order to trace WDA Converter

[ivanfemia]

Code will be included in the next daily build.

Thanks