search

ggreen86 / XLSX-Workbook-Class

VFP Class to Create an XLSX Workbook without Excel Automation or Installed
45 stars 16 forks source link

About hidden columns #32

Closed jhernancanom closed 3 years ago

jhernancanom commented 4 years ago

Hi, Greg and friends. I have found something, a possible bug, that I want to share.

There is an XLSX file that has several sheets, as a template; the first one is empty in the template, that must be filled with data. The rest of the sheets are different reports that take data from first one according to formulas.

I use VFPxWorkbookXLSX to open the template (OpenXlsxWorkbook), fill the first sheet and save the result file (SaveWorkbookAs). I confirm that I only touch the first sheet.

The problem is that the columns that are hidden --in the other sheets in the template-- appear visible in the resulting XLSX.

If someone could give me some workaround, I'll appreciate.

HERNAN CANO Systems Analyst

ggreen86 commented 4 years ago

Can you provide a sample workbook and how to reproduce what you are describing. I will look into it and let you know.

Greg

From: jhernancanom notifications@github.com Sent: Sunday, September 13, 2020 5:56 AM To: ggreen86/XLSX-Workbook-Class XLSX-Workbook-Class@noreply.github.com Cc: Subscribed subscribed@noreply.github.com Subject: [ggreen86/XLSX-Workbook-Class] About hidden columns (#32)

Hi, Greg and friends. I have found something, a possible bug, that I want to share.

There is an XLSX file that has several sheets, as a template; the first one is empty in the template, that must be filled with data. The rest of the sheets are different reports that take data from first one according to formulas.

I use VFPxWorkbookXLSX to open the template (OpenXlsxWorkbook), fill the first sheet and save the result file (SaveWorkbookAs). I confirm that I only touch the first sheet.

The problem is that the columns that are hidden --in the other sheets in the template-- appear visible in the resulting XLSX.

If someone could give me some workaround, I'll appreciate.

HERNAN CANO Systems Analyst

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/32, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33PA3EL36I5QZOL7V43SFSJMJANCNFSM4RKSCG7Q.

jhernancanom commented 4 years ago

Yes. CopyToHoja1.zip

ggreen86 commented 3 years ago

Release 31 and 32 Beta 12 does not support hidden columns. I have added this to the class which will be uploaded as Release 32 Beta 13.