copyTo and hidden rows bug

copyTo and hidden rows bug

Posted by: brian.ploe on 28 June 2021, 1:04 pm EST

• 

  brian.ploe

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 June 2021, 1:04 pm EST

  Hello,
  
  Is there a flag or something that will cause the copyTo command to behave correctly when used on a range that includes hidden rows?

  It corrupts the layout of the sheet unless I unhide the rows before I copyTo the range.

• 

  brian.ploe

  • Post Options:
  • Link
    Copy

  Posted 28 June 2021, 5:37 pm EST

  This is not a bug. I’m just dumb. I found a spot in one of my javascript files setting spread.options.pasteSkipInvisibleRange = true;

  Please disregard. If there was a way to delete my post to save myself the embarrassment i would.

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 29 June 2021, 3:26 am EST

  Hi Brian,

  That’s ok no worries. This is how we learn. I will keep this post here so that anybody who faces a similar issue can find this post helpful.

  Regards
  
  Avinash