How is your experience with the OutSystems Community?
14
Views
5
Comments
[AdvancedExcel] Cell_Freeze could be broken
Question
AdvancedExcel
Forge asset by Meivcore Industry Solutions

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.

 

2026-09-26 04-01-21
Huarlem Lima

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:

  • the version of AdvancedExcel (ODC) you're using
  • the parameters you pass to Cell_Freeze (row and column)
  • whether the error also happens when Cell_Freeze is the only action on a brand new file

Since this is the asset's support page, the owner should see your post here.

2020-04-08 11-40-04
Nuno Veiga

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

2024-05-13 14-48-32
João Pedro Oliveira

Hello Nuno, thank you for taking the time to look into this.

I have this server action. It gets an Excel binary and:

  • creates a table
  • can add number formatting to any column, depending on inputs
  • adjust column width
  • freeze panes on col 1 row 2.

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.

Format Excel Exports.oml
2020-04-08 11-40-04
Nuno Veiga

Hello João,

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

2024-05-13 14-48-32
João Pedro Oliveira

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!

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.