It would be nice to have the ability to copy rows or columns with the same options available when using the paste command in Excel, i.e. data only, format only, data and format, formulas, etc. It could be done via an enum “CopyOptions” added to the parameter list of both methods.
Thanks for providing us details.
We will check the feasibility if we could support the feature “Add overloads to CopyRows and CopyColumns with Paste Special… options”. I have logged a ticket with an id “CELLSNET-43326” for your requested feature. We will look into it soon.
Once we have any update on it, we will let you know here.
This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-43326”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.