Formatting is lost after download.

[abhishek9884]

Issue Description:

We've developed a program using ABAP2XLSX to download Adobe forms into Excel. While it works well in our sandbox system, we face problems in our development system:

Problem in Development System:

File downloads successfully but prompts a message when opened in Excel: 'We found a problem with some content in test.xlsx. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.'
After clicking "Yes," the data is correct but formatting (font, bold, font size, alignment) is lost.

We urgently need help to identify and understand the root cause of this issue.
Thank you in advance for your assistance

[sandraros]

Hello. This is a very generic corruption message which alone can't help in identifying the error. We can't help if we can't reproduce ourselves this problem, I hope you understand. Please attach a minimal reproducible example. If you can't create a minimal program, at least please post one corrupted Excel file (make sure there's no private information, because here is a public place). Thank you.

[abhishek9884]

Hello,

Thanks for reply.
I have attached two files which was generated using program 'ZDEMO_EXCEL31' in sandbox and development system.
Sandbox file doesn't have error whereas development file has it.
Appreciate your help. Thanks
ZDEMO_EXCEL31_Sandbox.xlsx
ZDEMO_EXCEL31_Devlopment.xlsx

[sandraros]

Thank you.
As you say that it's the same program, which is the official ZDEMO_EXCEL31 demo program, as far as I can see it's based on nothing else than just abap2xlsx code (i.e. not depending on some S/4HANA code), it will always generate the same XLSX on any ABAP system, so the issue you have can be explained only by having different versions of abap2xlsx on the two systems. You should install the same (latest) version of abap2xlsx on all systems.
I don't see another possible reason.