Need repair after saving same file with SaveWorkbook function

[Abh7791]

Hi,
I am testing this with my code but Demo() also having same issue.
Kindly check attached photo.

From what I can gather problem come from SaveWorkbook function only .
Thanks

[ggreen86]

Hello— I just created the ExcelTest.xlsx file from the Demo() method (I am using Release 44) via excelxlsxtest.prg. I also successfully opened it in Excel 2016 with no errors. Please send me the ExcelTest.xlsx file that you created and send me the corrected file from Excel as ExcelTest_Fixed.xlsx so that I can see if I can find a problem. Greg From: Abh7791 ***@***.***> Sent: Wednesday, August 7, 2024 11:07 AM To: ggreen86/XLSX-Workbook-Class ***@***.***> Cc: Subscribed ***@***.***> Subject: [ggreen86/XLSX-Workbook-Class] Need repair after saving same file with SaveWorkbook function (Issue #120) Hi, I am testing this with my code but Demo() also having same issue. Kindly check attached photo. image.png (view on web)<https://github.com/user-attachments/assets/31aea569-7775-47d0-baf4-7b64643dd951> From what I can gather problem come from SaveWorkbook function only . Thanks — Reply to this email directly, view it on GitHub<#120>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AGWB33LUF3MTEA2VHGXL6G3ZQIZYTAVCNFSM6AAAAABMETXBJKVHI2DSMVQWIX3LMV43ASLTON2WKOZSGQ2TGNZSGUZDQMI>. You are receiving this because you are subscribed to this thread.Message ID: ***@***.******@***.***>>

[Abh7791]

Thanks for quick reply .
I have checked again with release 44 and using office 2019 professional plus.
I am attaching both excel files.
ExcelTest_originaal.xlsx
ExcelTest-Fixed.xlsx

[ggreen86]

In looking at your original file that was created, you are missing the Image Example sheet being written correctly. I suspect that you may be missing the file “vfpxbanner.gif” which should be in the same directory as the default directory. The program “excelxlsxtest.prg” if executed will set the current directory to its execution path; on my system this is: SET DEFAULT TO "e:\my work\foxpro\projects\workbookxlsx\program demos" DO excelxlsxtest.prg You might try the above in VFP by navigating to the directory containing the program “excelxlsxtest.prg” and then executing it. Greg From: Abh7791 ***@***.***> Sent: Sunday, August 11, 2024 1:01 AM To: ggreen86/XLSX-Workbook-Class ***@***.***> Cc: ggreen86 ***@***.***>; Comment ***@***.***> Subject: Re: [ggreen86/XLSX-Workbook-Class] Need repair after saving same file with SaveWorkbook function (Issue #120) Thanks for quick reply . I have checked again with release 44 and using office 2019 professional plus. I am attaching both excel files. ExcelTest_originaal.xlsx<https://github.com/user-attachments/files/16571625/ExcelTest_originaal.xlsx> ExcelTest-Fixed.xlsx<https://github.com/user-attachments/files/16571626/ExcelTest-Fixed.xlsx> — Reply to this email directly, view it on GitHub<#120 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AGWB33NMYAMQ3N3335S35N3ZQ3VZDAVCNFSM6AAAAABMETXBJKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBSGUZTGMRQG4>. You are receiving this because you commented.Message ID: ***@***.******@***.***>>

[Abh7791]

I just did another test.
I created simple xlsx file just one column .
and saved it again by function SaveWorkbook .
It giving me same error.

[Abh7791]

I just did another test.
I created simple xlsx file just one column .
and saved it again by function SaveWorkbook .
It giving me same error.

[ggreen86]

I would have to have your code in order to be able to understand what you did. The class does not have a method to create a column; it has a method to assign a value to a cell. The class does have a method to define a column width. Right now I am not able to reproduce any error that you are describing. I have attached the xlsx file that the demo method creates. Please try to open this file with your version of Excel and if it gives an error, please send me the corrected file that Excel produces. Thank you. Greg From: Abh7791 ***@***.***> Sent: Saturday, August 17, 2024 7:12 AM To: ggreen86/XLSX-Workbook-Class ***@***.***> Cc: ggreen86 ***@***.***>; Comment ***@***.***> Subject: Re: [ggreen86/XLSX-Workbook-Class] Need repair after saving same file with SaveWorkbook function (Issue #120) I just did another test. I created simple xlsx file just one column . and saved it again by function SaveWorkbook . It giving me same error. — Reply to this email directly, view it on GitHub<#120 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AGWB33LUFX4ARLLSMJVNDXTZR4VYVAVCNFSM6AAAAABMETXBJKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOJUHAZDSMBYGU>. You are receiving this because you commented.Message ID: ***@***.******@***.***>>