search

ggreen86 / XLSX-Workbook-Class

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

InsertRow method not saving the footer rows correctly. #108

Closed rawilliamsjr closed 6 months ago

rawilliamsjr commented 7 months ago

Availability_Template.xlsx

Using the attached Excel file and issuing this command the last footer row values are missing and the rows merged cells have been unmerged.

goExcel.InsertRow(lnWb, 1, 20, INSERT_BEFORE)

ggreen86 commented 7 months ago

I will look into the problem. Thank you for submitting the spreadsheet for testing.

rawilliamsjr commented 7 months ago

Do you have an ETA for this correction? We are in the middle of a large project and this issue is holding us up from completing the project.

ggreen86 commented 6 months ago

Hello--

I have corrected the issue of not retaining the footer and header. This was actually not caused by the InsertRow method; but rather, I was not saving the these definitions when reading an existing workbook. I have added the retaining of the header/footer definitions when the open method is used. This will be in Release 41.