it is little bit tricky....I am using a program which sends an Excel file as mail attachment. I have a field say TRIP No which is a character field. For some reason, I am hard coding inside my program the TRIP NO to be as " ="TRIP NO" ". Then I am calling a customised Z_CONVERT_ALV which converts lt_output to Excel file .
Inside this customised Z_CONVERT_ALV , they are using a condition like
IF ga_layout-displ_type EQ 'C' "Character
AND <f> CS c_quote_sap.
REPLACE ALL OCCURRENCES OF c_quote_sap
Hence my lt_ouput-TRIP NO contains c_quote_sap , hence satisfies this conditon, replaces all " with " (c_quote_pc), causing error in the Excel file
My question is : is there any way this IF condition can be made false and my ouput has ="TRIP NO" . even when I tried to change my TRIP NO to c_quote_pc and make this IF as false, but my output comes as "error in the Excel file".
Edited by: Rob Burbank on Mar 28, 2010 9:42 PM