Filtered XLS Causes Exception

[wraydc]

Hi, I'm experiencing an exception (System.InvalidCastException: Unable to cast object of type 'Spire.Xls.Core.Spreadsheet.AutoFilter.FilterColumn' to type 'Spire.Xls.Core.Spreadsheet.XlsAutoFilter'.) when working with an auto filtered XLS. Note the same issue does not occur with an XLSX version of the same spreadsheet. The issue also doesn't occur if the autofilter is removed.

The code to recreate this issue is below:

Code: Select all

        public void XLSAutoFiltered()
        {
            try
            {
                string strFileName = @".\Vehicle Filter.xls";
                string strTargetFileName = @".\Vehicle Filter.xls";
                Spire.Xls.Workbook workBook = new Workbook();

                workBook.LoadFromFile(strFileName);

                workBook.SaveToFile(strTargetFileName);

                workBook.Dispose();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
        }

[wraydc]

XLS attachment for the source code.

[rachel.lei]

Hello,

Thanks for your post.
I have reproduced your issue and logged it in our bug tracking system with the ticket SPIREXLS-2507. Our Dev team will further investigate and fix it. If it is resolved, we will let you know immediately.
Sorry for the inconvenience caused.

Sincerely,
Rachel
E-iceblue support team

[wraydc]

Just a quick check-in on this one - Any progress or ETA that I can work to?

Many thanks in advance,

Darren

[rachel.lei]

Hi Darren,

Thanks for your following up.
I got news from our Dev team that this issue has been resolved and now it is in the testing phase. If it passes the test, we will compile a hotfix you. Thanks for your patience.

Sincerely,
Rachel
E-iceblue support team

[wraydc]

A quick check on this one - Is this also fixed in temporary hotfix 5.7.5?

Thanks in advance,

Darren

[rachel.lei]

Hi Darren,

Thanks for your post.
Unfortunately this issue has not been fixed in Spire.Office v5.7.5. Our Test team is testing the cases of Spire.XLS. The fix for your issue will be included in the next version.
Once the new version is available, we will inform you ASAP.

Sincerely,
Rachel
E-iceblue support team

[wraydc]

OK, thanks for the update.

[wraydc]

Any further update on this ticket? I was hoping to have a solution before we all head out for the weekend.

Thanks in advance,

Darren

[rachel.lei]

Hi Darren,

Thanks for your following up.
I just got news from our Test team that they found some issues when testing the hotfix. Our Dev team are working on these issues now, sorry we are unable to provide you with a new version at this moment.
Once the new version is ready, we will notify you immediately. Thanks for your understanding.

Sincerely,
Rachel
E-iceblue support team

[wraydc]

Rachel,

Thanks for the update, I'll follow-up with you next week. Have a good weekend

Darren

[rachel.lei]

Hello,

Ok, once the remaining issues are resolved, we will compile a hotfix for you. Thanks for your patient waiting.

Sincerely,
Rachel
E-iceblue support team

[wraydc]

Just a quick check-in - Any update on this item?

Thanks in advance, Darren

[rachel.lei]

Hi Darren,

Sorry that the new version is not available now. Our Dev team is still fixing the remaining issues. I have urged them. Sorry for the delay and inconvenience caused.

Sincerely,
Rachel
E-iceblue support team

[wraydc]

A quick check-in before the weekend. Any news on this one?

Darren

Hi Darren,

Sorry that the new version is not available now. Our Dev team is still fixing the remaining issues. I have urged them. Sorry for the delay and inconvenience caused.

Sincerely,
Rachel
E-iceblue support team