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.
  • Posted 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

  • Posted 29 May 2022, 5:29 am EST

    It doesn’t seem to be working.

    Is it supported in 12.2.5?

  • Posted 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

  • Posted 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

  • Posted 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

  • Posted 20 June 2022, 5:30 am EST

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



    Thanks,

    Mitra

  • Posted 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

  • Posted 20 June 2022, 5:26 pm EST

    Thank you. How can I get the license key for this?

  • Posted 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

  • Posted 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?

  • Posted 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

  • Posted 21 July 2022, 7:49 pm EST

    We want to upgrade to 14.2.5 and the hostname is Planful Inc. I have created a new case as per your instruction.

    Thanks,

    Mitra

  • Posted 24 July 2022, 5:03 pm EST

    Hi,

    We have responded to the portal case. Please refer to that case.

    regards,

    Avinash

  • Posted 21 August 2022, 5:10 pm EST - Updated 3 October 2022, 12:03 am EST

    Hi,

    After upgrading to V 14.2.5 , I am seeing an issue with filter popup UI. The content inside the filter popup is not taking full width. Please see the attached screenshot.

    Surprisingly, with window resize, it sets properly.

  • Posted 22 August 2022, 9:37 pm EST

    Hi,

    From the image, it seems like the App CSS is conflicting with SJS CSS. Please share a working sample that replicates the issue so that we could investigate it further help you accoridngly.

    Regards,

    Avinash

  • Posted 5 September 2022, 1:14 am EST

    Is there a stackblitz or any other platform where I can create the sample?

  • Posted 5 September 2022, 5:45 pm EST

    Hi,

    You may edit the following sample and share it back with us.

    sample: https://codesandbox.io/s/suspicious-driscoll-gimom8?file=/src/index.js

    Regards,

    Avinash

Need extra support?

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

Learn More

Forum Channels