Protected View in Excel with GX 9

Question

Protected View in Excel with GX 9

Navigation

#1 by (0 votes)

1

I am generating Excel files from GX9 - java. The Excel version is 2013, Win 8. If they are generated on my pc, all Excel files open with "Vista Protegida" red level. In the same application there are other procedures that generate Excel spreadsheets and do not have this drawback. The coding process is the same in all:

&ExcelDoc.UseAutomation = 0
&ExcelDoc.Open(&Path)

Do 'CheckStatus'
&ExcelDoc.Clear()
&ExcelDoc.AutoFit = 1

... listing code

&ExcelDoc.Cells(&Fila, &Columna).Color = 55
&ExcelDoc.Cells(&Fila, &Columna).Bold = 1
&ExcelDoc.Cells(&Fila, &Columna).Size = 14

...

&ExcelDoc.Save()
Do 'CheckStatus'
&ExcelDoc.Close()

I already tried the topic of the "Configuration of the trust center" of Excel, but nothing. Does anyone have any idea what can be? Or has something similar happened to them? Thank you very much.

excel genexus

asked by María José 12.10.2017 в 15:50

source

1 answer

In ASP, C #, IIS, LDAP capture the user of a domain in another intranet web server Wait for answers to continue Selenium Python

score 0 · Answer 1

I have had similar problems. Using Genexus X too. It gives the same error if instead of "opening" the file from the browser, first "download" it to the hard disk and then open it from the folder DOWNLOAD? To me with that change of procedure I was solved many problems that happened to me with different versions of Office. The other test for me is to see what happened when using LibreOffice or other software to open the file, and the same ALWAYS opened without problems. Only to rule out that the problem is "THE GENERATED FILE" or "MS OFFICE".