topic Re: write statement giving diffrent ouput when downloaded to spreadsheet in Application Development and Automation Discussions

write statement giving diffrent ouput when downloaded to spreadsheet

Former Member — Tue, 03 Mar 2009 11:38:50 GMT

Hi.

i am doing the same write statement for both the dates like march 3rd 09 and january 01 2008,but while downloading the file in spreasheet,the style is getting changed.i have tried using left-jiustified and condense keywords still the problem remains same.in the execution of report,both are coming in same style but here you can see that the sttyle is getting chnges.

please suggest what to do in such case.

thanks!

(All ship-tos)Report

3-Mar-09

06:28:42AM

January 01, 2008 to December 31, 2008

Re: write statement giving diffrent ouput when downloaded to spreadsheet

former_member242255 — Tue, 03 Mar 2009 11:48:12 GMT

it may be some problem with the format of the cell at whcih it is getting filled..

please check the properties of the cell..

Re: write statement giving diffrent ouput when downloaded to spreadsheet

Former Member — Tue, 03 Mar 2009 12:00:20 GMT

Hi, Format the cells in Excel sheet.

The problem may not be in WRITE Statement

Re: write statement giving diffrent ouput when downloaded to spreadsheet

Former Member — Tue, 03 Mar 2009 12:03:31 GMT

thanks.

my problem got solved as there was nothing in the write statement.

the format of date was getting changed because in excel,it was purely a date so i made the dot concatenated with it to make it as string.

thnaks!