Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export Cursor data to Excel
Message
From
04/03/2004 14:23:01
 
 
To
04/03/2004 14:17:26
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00883201
Message ID:
00883203
Views:
10
>Hi,
>
>Yesterday I almost lost the remaining hairs in my almost bald head :(
>
>Below is a simple sequence that reproduces the behavior I was experimenting.
>
>My program generated a cursor (with many columns) and there was some columns with dates and other with numeric calculated values. After filling the cursor with many rows it was exported to Excel.
>
>Due to a logic error my program was generating numeric overflow when storing some numeric values into cursor numeric columns. Till this point it's all ok, BUT, when I looked at the resulting Excel spreadsheet the result was not only overflow in those numeric columns, but ALSO in some date columns. Want to check it? Just run the prg below.
>
>Create Cursor Test (Field1 D, Field2 N (1), Field3 D)
>
>dDate = Date ()
>
>For I = 1 To 20
>    Insert Into Test (Field1, Field2, Field3) ;
>              Values (dDate , I     , dDate )
>EndFor
>
>Select Test
>Browse
>Export To C:\Temp\Test.xls Type XL5
>
>Is that a bug in Excel, VFP or what? Note that in the browse window all dates are ok.
>
>Fernando

I think it's just a display issue in Excel. If you look the cells the dates are filled in and if you delete the "overflow" values in Excel and pagedown then up again, to refresh the screen, you will see the dates are display correctly.
Charles

"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform