Hello Team,
Error - crash with Exception “Instance is Read-only.”
-
When we open xls files (for example, the file sl_os375708.xls), if it contains a cell format “ММММ” (Cyrillic) (full name of a month), for example, “ДД ММММ ГГГГ ч:мм” the application is crushed
Code :
Excel.Workbook doc;
var lo = new LoadOptions ();
lo.Region = CountryCode.Russia;
doc = new Excel. Workbook (input, lo);
where input is the path to the file (sl_os375708.xls in archive) -
When we open xlsx files (for example, the ConverterExcelTest1.xlsx in archive), if it contains a cell format “МММ” (Cyrillic!) (abbreviated name of a month), for example “ДД МММ” the application is crushed
Code :
Excel.Workbook doc;
doc = new Excel.Workbook (input);
Here the situation is a bit more complicated.
- If we add LoadOptions and specify the region (lo.Region = CountryCode.Russia), then the constructor passes, but the export to pdf goes wrong (see the file ConverterExcelTest1.xlsx.pdf in archive). In the source xlsx file in the cell with the format it is displayed “29 май”, and in the result pdf file it is displayed as “29 мая”.
- On some files (example - book2.xlsx in archive) with this format, the error does not occur when the file is loaded, but it occurs when we try to save it to pdf. If you try to save such a file in xps, result builds without errors, but there are no pages with a problematic format in the resulting xps file
With best regards,
Oleg Istomin
Aspose.zip (52.4 KB)
Aspose2.zip (1.9 MB)