Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Prevent editing in Web Browser
Message
De
22/12/2008 11:51:26
Mike Sue-Ping
Cambridge, Ontario, Canada
 
 
À
22/12/2008 11:39:28
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Contrôles ActiveX en VFP
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Divers
Thread ID:
01368880
Message ID:
01369195
Vues:
13
>>>>I've got a comma separated values file (csv) that opens in a webBrowser control hosted in a VFP9 form. It appears rendered as a spreadsheet (Excel) and is editable.
>>>>
>>>>How can I prevent the contents from being changed?
>>>>
>>>>I've tried to set the file as readonly, but, it does not help; the user can still edit the content.
>>>>
>>>>TIA
>>>>Mike
>>>
>>>
#define xlNoSelection                                     -4142
>>>
>>>oXLS = myWBControl.Object.Document
>>>oExcel = oXLS.Application
>>>oExcel.CommandBars("Standard").visible = .F.
>>>oExcel.CommandBars("Formatting").visible = .F.
>>>oExcel.ActiveWorkbook.ActiveSheet.EnableSelection = xlNoSelection
>>>oExcel.ActiveWorkbook.ActiveSheet.Protect(,,.T.,,.T.)
Cetin
>>
>>Hi Cetin,
>>
>>Thanks for the reply.
>>
>>After I've called the browser's navigate2("file://somepath/some_csv_file.csv") method I've added your code suggestion by modifying "myWBControl" to my object name, When I run the code I receive a Program Error - "OLE error code 0x80020006: Unknown name." when the line containing oXLS.Application tires to execute. From the VFP debugger, I can see that the object oXLS does not have this method. Did I not do this correctly?
>>
>>Mike
>
>If it doesn't then it is not opening with excel really. You may instead navigate to an xls file (an empty dummy one maybe) and then open the csv as a workbook.
>
>PS: Why don't you get that csv into a cursor and browse that one in a grid instead of a web browser control.
>Cetin

I'll give the "dummy file" a try.

I'm trying to add the ability to view "almost any type of document (within reason)" without having to shell execute and startup another application to do so. Do you know of another approach? Thus far, CHM files are the only ones the can't open directly in the browser.

Mike
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform