Range.copyValue(Range) between workbooks

Aspose.Cells Product Family
1

Range.copyValue(Range) between workbooks does not copy anything.

I managed to transfer my data by iterating on origin range and copying values cell by cell to the destination cells.

2

Hi,


Thanks for providing us some details.

Could you try to call Workbook.calculateFormula() method before creating and copying ranges if it works fine.

If you still find the issue, kindly create a sample JAVA program (runnable) to reproduce the issue on our end, we will check it soon. Also provide your template file(s) (if you have any).

Also, see the document for your reference on copying data b/w ranges using Range.copyData() method instead:

Thank you.

3

I’m confused, I have used copyValue method the wrong way, calling it from source range !

Sorry for the useless post and your wasted time.

4

Hi,

Thanks for your posting and using Aspose.Cells.

We are good to know that your issue is resolved. Please feel free to ask any question you like, we are pleased to help you. Have a nice day.