Issues with Background Image and Performance in .sjs File

Posted by: bruno.bueno on 28 January 2025, 1:14 pm EST

  • Posted 28 January 2025, 1:14 pm EST - Updated 28 January 2025, 1:17 pm EST

    Hello,

    I’m working with a .sjs file in SpreadJS version 17.0.4, and I’m encountering an issue with one of the tabs. This tab has a background image applied, and it seems to have a style or property that’s significantly affecting performance.

    Specifically:

    The tab is extremely slow to interact with.

    It contains a very large number of rows, and I’m unable to delete them.

    When I open the same file in Google Sheets, the tab appears to have far fewer rows, which seems to resolve the performance issue.

    I suspect the issue might be related to how the background image or styles are applied, but I’m not sure how to address this within SpreadJS.

    Has anyone experienced something similar or knows how to fix this? Any tips or workarounds would be greatly appreciated!

    Thanks in advance!

    test.sjs.zip

  • Posted 30 January 2025, 1:20 am EST - Updated 30 January 2025, 1:25 am EST

    Hi,

    Apologies for the delayed response and thank you for sharing the file. I was able to replicate the performance issue when loading it.

    The primary reason for the slowdown is the large number of rows in the file, with the impact of background images being minimal.

    Upon reviewing the sample file, I noticed it contains around 16,000 columns and approximately 1,000 named styles, some of which are unused.

    To address this issue, we recommend opening the file in Incremental Loading mode (https://developer.mescius.com/spreadjs/docs/BestPractices/incremental-loading#site_main_content-doc-content_title) and calculating functions on demand (https://developer.mescius.com/spreadjs/docs/features/spreadjs-file-format#open-files)

    These settings should improve loading performance in SpreadJS, although editing the sheets may still pose challenges.

    Additionally, we observed similar performance issues when editing the XLSX version of the file in Google Sheets, indicating comparable behavior between Google Sheets and SpreadJS.

    We’ve escalated this matter to the development team under the internal tracking ID SJS-28144 and will share updates as soon as they become available.

    Please feel free to reach out if you need any further assistance.

    Best regards,

    Ankit

Need extra support?

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

Learn More

Forum Channels