@wknauf
We can reproduce such issues.
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSNET-58027
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.
We are pleased to inform you that your issue (Ticket ID: “CELLSNET-58027”) has been resolved. The fix will be included in our upcoming release (Aspose.Cells.GridDesktop v25.4) that we plan to release in the first half of April 2025. You will be notified when the next version is released.
The issues you have found earlier (filed as CELLSNET-58027) have been fixed in this update. This message was posted using Bugs notification tool by leoluo
Problem 1:
Filter col B and uncheck “107518”.
Now you can select cells in row 12, but not in row 14. not_selectable_row.png (35.7 KB)
Problem 2:
Filter col B and uncheck “107518”. Select cell B12, then click cell B14 (which is not selectable, see before).
Then open filter for col B again and click “clear filter”.
Then open the filter again and uncheck “107518” again. Click OK => row 13 is still visible, though it does not match the filter.
Problem 3:
I still can reproduce the exception of issue 2 from my initial bug report.
Filter col B and uncheck “107518”.
Click cells B11, B12 and then try to click cell B14. It is only reproduceable if you perform exactly those steps, with other selections it works!
Now try to open the filter dropdown in col B => crash.
HResult=0x80131600
Message=Cell has been removed: B17
Source=Aspose.Cells.GridDesktop
StackTrace:
at .()
at .e()
at Aspose.Cells.GridDesktop.RowFilterSettings.(e , Int32 , Int32 )
at Aspose.Cells.GridDesktop.RowFilterSettings.(Int32 )
at Aspose.Cells.GridDesktop.Worksheet.(Int32 , Int32 )
at Aspose.Cells.GridDesktop.GridDesktop.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(HWND hWnd, MessageId msg, WPARAM wparam, LPARAM lparam)
at Windows.Win32.PInvoke.DispatchMessage(MSG* lpMsg)
at System.Windows.Forms.Application.ComponentManager.Microsoft.Office.IMsoComponentManager.FPushMessageLoop(UIntPtr dwComponentID, msoloop uReason, Void* pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(msoloop reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(msoloop reason, ApplicationContext context)
at GridDesktopTest.Program.Main() in E:\Projekte\Temp\GridDesktopTest\Program.cs:line 14
After initial testing, I am able to reproduce/confirm all three problems you mentioned (by following your steps/sequence) using your original template Excel file with Aspose.Cells.GridDesktop v25.4. I noticed the issues regarding AutoFilters with read-only mode in Aspose.Cells.GridDesktop.
We require thorough evaluation of the problems you shared. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSNET-58205
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.
We will make an effort to thoroughly investigate and figure out the issue regarding auto-filtering precisely. However, it would be greatly appreciated if you could kindly share the steps or process involved in replicating it on our end. Additionally, if possible, please provide a screenshot once you encounter this issue. Thank you for your cooperation.
I tested and after following your mentioned steps I found this problem (“wrong entries appear in filter popup”). I have logged it with your existing ticket “CELLSNET-58205” into our database. We will look into it as well.
Whow, that was fast! I can confirm that the new issues 1-4 are all fixed.
But I found a new one:
In the filter of col B, uncheck “Blanks” => two blank rows are still visible. And the grid selection is confused, as the blank rows are not selectable and selecting rows below them has an offset.
I tested your scenario using Aspose.Cells.GridDesktop v25.4.1 and confirmed the issue you mentioned regarding blanks handling during data filtering. We will work on the fix and appreciate your ongoing efforts with auto-filtering checking and testing. We apologize for any inconvenience this may have caused.
Moreover, regarding issue when handling blanks and hidden rows in data filters, We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Support Policies
Issue ID(s): CELLSNET-58052
Once we resolve the issue or we have some other updates on it, we will let you know here.
This is to inform you that your issue (Ticket ID: “CELLSNET-58052”) has been resolved. The fix/enhancement will be included in an upcoming release (Aspose.Cells.GridDesktop v25.5) that we plan to release in the first half of May 2025. You will be notified when the next version is released.
We’re glad to hear that Aspose.Cells.GridDesktop 25.4.2 (fix) has resolved your issue. If you have any more questions or comments, please don’t hesitate to reach out to us.
The issues you have found earlier (filed as CELLSNET-58052) have been fixed in this update. This message was posted using Bugs notification tool by leoluo
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.