Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
AutoFitWidth in ExcelML
Message
De
18/03/2013 17:04:17
 
 
À
18/03/2013 16:31:00
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Versions des environnements
Microsoft Office:
Office 2010
Divers
Thread ID:
01568605
Message ID:
01568747
Vues:
17
>It work for me for all type of columns (string, date, numeric, etc.) But I use this from VFP.

Ok, but this is because you are using an OLE approach. Thus, you are building the sheet as if you would be sitting in Excel. Thus, Excel knows the width and can adjust it. For example, if you save as XML, you will see it has hardcoded the width value for every cell. But, when you generate the XML, you cannot benefit from that approach. Only when the document is opened, and I go set the width to be autofit, after another save, there I can have the auto width to be ok, but this is because it has calculated the width value when I was adjusting its layout when I was in Excel.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform