Hi
Virtualization on the SfPivotView control is inoperable on large volumes of data.
First, the horizontal scrollbar is no longer displayed when virtualization is active. However, it is when virtualization is inactive. The final user is therefore unable to view the data which is not displayed in the case where the virtualization is active. Not really acceptable by the end customer.
With virtualization active :
With virtualization inactive :
Second, data navigation is often unacceptable. Sometimes data does not display after a scroll. Above all, the are untimely reloads which sometimes bring us back to the data previously displayed when we have just scrolled. Totals do not always display. Not to mention the jerky scroll with incessant jumps that make you want to vomit. This even when trying to scroll slowly. It's very simple, there is data that I can't display. I can't find a precise line as the control jumps in one direction or the other. Impossible to put such a control in an application for an end customer.
Pagination would have minimized the effects and made the control usable. But there is no such option in your control.
All this is very unfortunate because your control is really great (apart from virtualization) and that's one of the reasons that made us choose your controls over the competition.
Hi Frederic,
We can be able to reproduce the problem and we are validating it at our end. We will update the further details within two business days (April 8, 2022).
Regards,
Angelin Faith Sheeba.
Hi Frederic,
We have considered this as a bug “Horizontal scroll bar not appeared when virtualization enabled in pivot table.”. And the fix will be available in our 2022, Volume 1 SP release which is estimated to be rolled out at the mid of May 2022. You can keep track of the bug from the below feedback link.
Feedback Link : https://www.syncfusion.com/feedback/34080/horizontal-scroll-bar-not-appeared-when-virtualization-enabled-in-pivot-table
Regards,
Angelin Faith Sheeba.
Hi Frederic,
Sorry for the inconvenience.
Due to its complexity, the fix for the issue " Horizontal scroll bar not appeared when virtualization enabled in pivot table" could not be included in 2022 Vol1 SP release as promised. However, it will be included in our upcoming patch release, which is estimated to be rolled out at May 25, 2022.
We appreciate your patience until then.
Regards,
Angelin Faith Sheeba.
Hi Frederic,
We are glad to announce that our Essential Studio weekly release V20.1.56 is rolled out and fix for the issue “Horizontal scroll bar not appeared when virtualization enabled in pivot table” has been included in this release. Please refer to the following sample.
Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/PivotTable-2094121414
We thank you for your support and appreciate your patience in waiting for this release. Please contact us if you require any further assistance.
Regards,
Angelin Faith Sheeba