Dear Carlos Freitas and everyone on the OutSystems Forum,
I am experiencing an issue after upgrading the OutSystems Platform that appears to be related to the Advanced Excel Forge component. I would greatly appreciate your advice on the possible root cause of this issue.
The steps are as follows:
1,Upgrade the OutSystems Platform.
2,Republish all applications.
3,Open and use the application, which was developed using Traditional Web.
The Import functionality does not work correctly. After investigation, I found that the Worksheet_Select function does not return the expected result. I have provided more details below.
4,Republish the affected module once again, meaning the module is published twice in total.
5,Open and use the application again, and it works normally.
In 2025:
We upgraded the Platform from 11.18.1 to 11.31.0.
We performed the standard republishing process as part of the Platform upgrade.
However, we had to republish the affected module a second time before the application worked normally.
In 2026:
We upgraded the Platform from 11.31.0 to 11.41.0.
We again performed the standard republishing process as part of the Platform upgrade.
The same issue occurred, and we had to republish the affected module a second time before the application worked normally.
Below is some demo code that I created to reproduce logic similar to that used in the actual application. I apologize that I cannot share screenshots of the actual application code here.
The expected value of WorksheetIndex should be 1.
However, during debugging, WorksheetIndex always returns 2.
Even if I replace:
GetEntity1(Entities.Entity1.SheetIndex).Entity1.IntValue
with a hard-coded value of 1, Worksheet_Select still selects the wrong worksheet.
Because the correct worksheet cannot be selected, the Import functionality does not work as expected.
However, what is particularly difficult for me to understand is that simply republishing the affected module one more time resolves the issue, and the application then works normally without any other changes.
This behavior has occurred after Platform upgrades on two separate occasions, from 11.18.1 to 11.31.0 in 2025 and again from 11.31.0 to 11.41.0 in 2026.
I would really like to understand the root cause of this behavior.
Could this be related to how the Advanced Excel component or its dependencies are compiled or republished during a Platform upgrade? Why would the first republish not resolve the issue, while republishing the same module a second time makes Worksheet_Select work correctly?
The version of Advanced Excel I am using: Version 2.2.2
I would greatly appreciate any insights, explanations, or suggestions from Carlos and the OutSystems community regarding this issue.
Thank you very much for your help.
Just following up on this. Does anyone have any thoughts or suggestions regarding this issue?
Hi @Duc Anh Nguyen,
Worksheet_Select hasn't changed since 2.2.2. With an index above 0, it returns Worksheets[index] from the bundled EPPlus library, so the action itself can't turn a 1 into a 2. EPPlus can, though, if it starts counting sheets from 0. That happens in two cases:
Recommendation: update to the latest Advanced Excel on the Forge, because 2.2.2 is from 2021 and many fixes have shipped since. Then refresh dependencies and republish the modules that use it. Where you can, select sheets by WorksheetName rather than by index. If it still happens, please send the EPPlus.dll version in your module's bin folder and the list of extensions your module depends on.
@Duc Anh Nguyen, one more thing: Advanced Excel isn't a supported Forge component, but you can still open a case with OutSystems Support and ask them to help with the analysis. They can see things in your environment that we can't from here, such as which EPPlus.dll gets deployed to your module's bin folder on each publish, and what changed with the platform upgrade. Please post what they find here, so we can fix it in the extension if it turns out to be ours.