Hi and happy new year,

We use dw2xls (Desta) for exporting dws to Excel. There's a specific dw that failed to generate an xlsx that could be opened by Excel. (Ironically, LibreOffice has no problems with it).

So after spending quite some time, I fixed the problem by making a specific field invisible before the export. This field had the "Password" attribute checked. So before the export, I set the field to invisile and after, I set it to visible again. However, that last Modify() doesn't seem to work. The execution of the Modify() returns no error, but the column does no show.

Now I know that grid datawindows are a bit special, but has anyone found the same problem and maybe have a solution?

For now, I've solved the problem by doing a GetFullState before setting the field invisible and a SetFullState after the export to excel.

regards,

MiguelL