I have a large list (close to 4500 items) with many columns (about 100). My organization had SharePoint 2010 (on prem) until now and my client was happily using the datasheet view to display/bulk-edit rows in the list. Now, the organization is upgrading to SharePoint 2019 (on prem). I have tried using both the modern and classic modes, and the modern view seem to have problems with custom metadata fields for custom content types. Due to this, there is a good chance we would be asked to stick with the classic mode.
The view type in SP 2019 similar to Datasheet in SP 2010 is Quick Edit. In our Dev environment, I copied the large list and tried using the Quick Edit view but:
I find that the filtering options are much more limited in SP 2019 than they were in SP 2010. Is there a way to have the same custom filtering option in SP 2019 that is present out-of-box in SP 2010, especially for columns that have many different choices like "Project #"?
Is there a way to make SP 2019 show all rows of the list? So far, even in the Quick Edit view, SP 2019 displays only 30 rows at a time. This is a critical functionality for us and we do bulk-editing a lot of times.