Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tamar Granor
  Where is Tamar Granor?
 Elkins Park
 Pennsylvania - United States
 Tamar Granor
 To: Paul Gibson
  Where is Paul Gibson?
 United Kingdom
 Paul Gibson
Subject: RE: XLS/XL5
Thread ID: 373817 Message ID: 373856 # Views: 51 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Microsoft Office Automation
Date: Wednesday, March 27, 2013 9:46:11 PM         

> I know the change to XL5 seems to handle dates slightly differently, for example:
ver	date		datetime
> v2	29-Feb-04	31-Dec-12 23:59:59
> v5	29/02/2004	31/12/2012 23:59:59

> Are there any gotchas or things I would need to know if I was switching between XLS and XL5 across the application?
> Thanks for your time.

In addition to the date issues (XL5 is much better on that front), XL5 allows more rows.

To the best of my knowledge, there is no downside in switching from XLS to XL5.



XLS/XL5 Posted by Paul Gibson @ 3/27/2013 11:50:59 AM
RE: XLS/XL5 Posted by Samir H. @ 3/27/2013 1:11:38 PM
RE: XLS/XL5 Posted by Paul Gibson @ 3/27/2013 1:35:38 PM
RE: XLS/XL5 Posted by Tamar Granor @ 3/27/2013 9:46:11 PM
RE: XLS/XL5 Posted by Anders Altberg @ 3/28/2013 12:29:33 AM
RE: XLS/XL5 Posted by Cetin Basoz @ 3/28/2013 1:38:14 AM