Hi.
I'm manipulating an excel file by formatting some columns, creating a table, adjusting columns width and freezing panes. All works well, except freezing panes. Excel throws an error when opening the file:
We found a problem with some content in [file name] Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.
I have tried an action with just Cell_freeze and it breaks the file. All other actions perform as expected.
Hi João Pedro,
This could be an issue in the AdvancedExcel (ODC) component itself, since the file opens fine without the freeze action. I'm not 100% sure of the cause, though.
A few details would help the asset owner reproduce it:
Since this is the asset's support page, the owner should see your post here.
Hello João,
Sorry for the lateness in the reply.
I've done some tests and I couldn't reproduce your issue. Could you send me a sample OML so I can take a look on what's happening?
Thanks
Hello Nuno, thank you for taking the time to look into this.
I have this server action. It gets an Excel binary and:
It works ok with multiple files if I disable Cell_Freeze. When Cell_Freeze is enabled I get an error when opening the file.
If I accept to recover and open the file I get the data, but not table or any formating.
I managed to find the issue and fix it. I just submitted it to the Forge so it should be available anytime soon.
Please let me know if it works.
Best regards
Hello Nuno,
I have tested my app with the freeze panes functionality and this is working with no errors.
Thank you for fixing this.
Best Regards!