Excel table with slicer performance problem

Posted by: yyoshimura on 26 May 2021, 8:37 pm EST

  • Posted 26 May 2021, 8:37 pm EST

    We have a book with table and slicer. We notice that the performance of reference cell degrades drastically when table has lots of rows and slicers are defined. We are using the latest version V4.1.1.

    Please reference attachment for reproduction.
    Target workbook: slicer.xlsx

    Sheet0:
    Table has 100, 000 rows and no slicer is defined. It's very fast to access cells in this sheet.

    Sheet1:
    Table has 1000 rows and slicers are defined. It's running a litter slower but still acceptable.

    Sheet2:
    Table as 10, 000 rows and slicers are defined. Every access to cell costs 6 seconds or so at our end.

    Sheet3:
    Table has 100, 000 rows and slicers are defined. Almost unusable with this setup. Every cell operation costs infinite time and almost not responding.

    Please help to investigate this issue. Thank you.

    Regards

    slicer_performance.zip
  • Replied 27 May 2021, 7:21 pm EST

    Hello,

    We too can observe the issue at our end and escalated this to the development team for investigation.
    [Internal Tracking ID: DOCXLS-4187]

    Regards,
    Prabhat Sharma.
  • Marked as Answer

    Replied 17 June 2021, 3:38 am EST

    Hello,

    This issue has been fixed in the latest version of the GcExcel API version 4.1.2. Please update your project with the latest builds to avoid this issue:
    https://www.nuget.org/packages/GrapeCity.Documents.Excel/
    Regards,
    Prabhat Sharma.
  • Replied 22 June 2021, 4:40 pm EST

    We confirmed that the issue has been fixed in the latest build V4.1.2. Thank you for your support.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels