Hi,
I have some very strange issue.
I load and save workbook with:
(Workbook workbook = new Workbook();
if (File.Exists(fullPath))
{
myWorkbook.LoadFromFile(fullPath);
//... some calculations
myWorkbook.Save();
}
else
{
///...
}
The problem happens if workbook file exists in folder, but with different case. For example existing file name is "MyWorkBook.xlsx", but in variable fullPath it is myworkbook.xlsx. This happens on 2 of 5 client PCs, all tested PCs are with Win10 OS. When the bug happens, the result is totally unpredicted for me - in the folder there are both files MyWorkBook.xlsx and myworkbook.xlsx, but I cant open second one, it opens the first one It looks that this bug is combined with some windows bug As I know, NTFS file names are case sensitive by design, but some internal windows components prevent this and make it case insensitive. So my suggestion is that the spire xls makes something that don't pass the windows check.
Of course, the workaround that I created is very simple, just check the file properties before open and see its windows name.