Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Office 2007 compatibility issues
Message
From
15/02/2007 07:14:42
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
General information
Forum:
Visual FoxPro
Category:
Third party products
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01191826
Message ID:
01195949
Views:
24
>>>Aleksey,
>>>
>>>As I now understand, Visual FoxPro doesn't support versions of Excel beyond XL8. like in the new Office 2007.
>>>
>>>Since both Excel and Visual FoxPro are MS products, can we expect a solution in a service pack?! As of this moment I have not a single client who uses Office 2007, but that will most likely change in the course of this year.
>>>
>>>See also: Re: Import from Excel in Office 2007 Thread #1191678 Message #1191724
>>
>>Hi Peter,
>>
>>To the best of my knowledge, there are no plans to enhance IMPORT command to support new file formats. IMHO it was a mistake to add support for importing Excel documents the way it was done in VFP. The import isn't performed using any standard API, instead the knowledge about certain file formats is hard coded into VFP's code. A file is read as a byte stream and is interpreted by VFP itself. You can imagine that as a result, the cost of adding and testing support for new file formats or rewriting the code to use a standard API is very very high. It doesn't fit into an SP. There is a number of standard APIs that can be used to read Excel documents: ODBC, OLEDB, Automation of Excel.
>
>Aleksey,
>
>Thanks for the answer. So, there may well be a compatibility issue soon (or already). If it is true that the regular Save feature of the new Excel produces an incompatible file format, and if an existing vfp-application uses IMPORT to import such an xls-sheet, then that existing app will gonna crash, right? Are you saying here that the developer has no other choice than, either to change the code in the app, or to instruct the suppliers of the xls-sheets to deliver an older Excel file format?

As per the CC:
"and if an existing Visual FoxPro-application uses IMPORT". Luckily I have never used IMPORT in my applications:)
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform