We have a .NET application that is hosted in IIS.
We are using Aspose.Cells 18.3.0 to load a new Workbook object in .NET.
We have two problematic spreadsheets.
Excel Sheet #1 contains custom formatting of g, gg, and ggg.
Excel Sheet #2 contains formatting to use [$-ja-JP]XXXX (Microsoft Excel 2016)
Excel Sheet #1 always exhibits the issue.
Excel Sheet #2 only exhibits the issue when a non-date value is in the cell.
For either sheet, the issue only occurs if the machine’s current region is set to Japan.
The issue we are seeing is that upon loading the Workbook object with the above mentioned Excel sheets, our software’s System.Globalization.CultureInfo.CurrentCulture’s Date patterns, and calendar are modified to the current Reiwa era of Japan, and a Japanese calendar.
The only way we can get our software to revert is to reset IIS to restart our application.
Is this something that was addressed in a later version of Aspose, or something that you are already aware of and actively addressing?
This is causing issues with customers using our software, so it is urgent.
I have attached the problematic Excel sheets.
Our code uses the Workbook constructor that takes in a stream containing the Excel file’s data. The issue occurs immediately after this constructor is invoked and a Workbook object is returned to us.
Aspose.zip (13.3 KB)