I like to inform you that issue mentioned by you is not related to Aspose.Slides. I am moving this query to Aspose.Cells forum and our colleagues from Aspose.Cells will contact you soon.
Could you re-attach your template XLSX again here as I cannot download your attachment. Also paste your complete sample JAVA program (runnable) here to evaluate your issue properly on our end, we will check it soon.
Could you separate the issue and create a simple console program with a few lines of code that should load your template Excel file (you may attach it here) and specify/set the formula on the cells to reproduce the issue on our end, we will check it soon. This way will save our time and we might log a ticket for it to consequently figure it out soon.
We’re experiencing this particular issue on column R of Global tab in “Range_Plan_Report_1473847566484.xls” file. Code in file truRangePlanReport.jsp at line 2742 is producing this issue. As requested, I couldn’t replicate this issue in sample java file and would need your help to understand the reason why it’s showing up in attached truRangePlanReport.jsp file at line 2742?
Well, it is really hard to trace the issue using your big .jsp file, we might not execute it properly due to different custom objects used in your code. We again request a simple JAVA console program(runnable) to reproduce the issue on our end. Also, if you cannot find the issue in a separate program, then the issue might be with your own code, so you should debug it and figure out the issue by yourself.
As requested, I’ve created one sample program to explain this issue (PFA java program. Rename file to .java). I’ve used below formula in A1 column of USA tab,
We have evaluated the scenario on our side, and we believe the presented behaviour is correct. Please note, you are inserting a formula which references a worksheet that does not exist at that time, therefore the API considers it as an external source. Please try the same scenario in Excel application. As soon as you insert the same formula in the formula bar, the Excel application will pop-up a dialog to select the external spreadsheet in order to resolve the reference for Global.
If you wish to handle this situation in code, please insert the worksheet Global before referencing it in any formula. Please check the following piece of code as well as its resultant spreadsheet as attached.