Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export Cursor data to Excel
Message
 
To
04/03/2004 14:17:26
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00883201
Message ID:
00883213
Views:
8
Does "copy to TYPE xls" overflow also?

>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
Imagination is more important than knowledge
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform