Copy/Paste is not working correctly after filtering rows

Posted by: msharma on 26 May 2022, 4:10 pm EST

  • Posted 26 May 2022, 4:10 pm EST

    I am facing an issue with copy-paste of multiple cell values after the filter is applied.
    Please do the following steps on this demo https://www.grapecity.com/spreadjs/demos/features/filters/custom-filter/purejs

    1. Select column B and apply 2 cellvaluecondition filters. EqualsTo 1 OR EqualsTo 3 and click on Set Filters
    2. Now copy the cell values, D3 and D5 (Abby & Alisa) together.
    3. Paste them in a different column say G. Only one of them (D3 value) is pasted.
  • Replied 26 May 2022, 10:19 pm EST

    Hi,

    For this, you may need to set the pasteSkipInvisibleRange to true. Please refer to the following code snippet and let me know if you face any issues.

       spread.options.pasteSkipInvisibleRange = true;



    API References:

    pasteSkipInvisibleRange:
    https://www.grapecity.com/spreadjs/docs/latest/online/paste-skip-data-invisible-range.html?highlight=pasteskipinvisiblerange%2C

    Regards,
    Avinash
  • Replied 29 May 2022, 5:29 am EST

    It doesn't seem to be working.
    Is it supported in 12.2.5?
  • Replied 29 May 2022, 3:48 pm EST

    Hi,

    We are sorry but this feature is available from v14.1.0. You may update this build for getting desired behavior however the late version of spreadS is v15.1.0 and it is recommended, always update to the latest version since it has more features and bug fixes.

    Regards,
    Avinash
  • Replied 29 May 2022, 10:15 pm EST

    Thanks for your quick response. Upgrading to V14 or V15 is very difficult for us as of now. We may do it in the future.

    Can you please give a fix for V12 as this issue is critical for us?

    Regards,
    Mitra
  • Replied 30 May 2022, 7:44 pm EST

    Hi,

    We are sorry this is not a simple fix it is a completely new feature that is added in v14.1.0 and we do not have any simple fix for this issue. You may need to update on the latest version. we are sorry for the inconvenience.


    Regards,
    Avinash
  • Replied 20 June 2022, 5:30 am EST

    We want to upgrade to V14.2.5. Can you please share the download link?

    --
    Thanks,
    Mitra
  • Replied 20 June 2022, 3:10 pm EST

    Hi Mitra,

    You can download the SpreadJS V14.2.5 from the following link: http://cdn.grapecity.com/spreadjs/14.2.5/Files/SpreadJS.Release.14.2.5.zip

    Regards
    Ankit
  • Replied 20 June 2022, 5:26 pm EST

    Thank you. How can I get the license key for this?
  • Replied 20 June 2022, 5:51 pm EST

    Hi Mitra,

    If you are running the application on localhost, you won't be required a license. For deployment, you need to purchase the SpreadJS License. It is recommended to always update to the latest version since it has more features and bug fixes.

    You can contact the sales team for purchase: us.sales@grapecity.com

    Regards

    Ankit
  • Replied 20 June 2022, 6:36 pm EST

    We already have purchased the license. When I upgrade to the newer version, I get this error

    Invalid license key. Email us.sales@grapecity.com if you need help.

    I wanted to check if you will provide a new license key for the newer version or the same old one should work?
  • Replied 21 June 2022, 7:44 pm EST

    Hi Mitra,

    You will be required a new license key for the newer version. The old license key won't work with newer version. Could you please confirm which version you have upgraded to ?

    Please share the hostname for which you want the license key on our private portal by creating a new case on: https://www.grapecity.com/my-account/my-support

    Regards

    Ankit
Need extra support?

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

Learn More

Forum Channels