Issues with Copying Range From One Workbook to Another

Aspose.Cells Product Family
1

Hi,

We are using aspose cells and storing the excel workbooks as byte[] in our database.
But we are not actually saving the “Entire Workbook” what user selects, but creating a new Workbook and then copying only the “Certain ranges OR Charts” as specified by the end user.

We are doing this way because of size issues(as we have discussed this with aspose team here, Thus we are avoiding the size issues by following this approach.

Now, my question is i have read somewhere in your blog(old threads) that, when we are copying Range or Charts from one workbook to other, it may cause some issues and may not work properly.

So just wanted to confirm with you,whether these issues are resolved now or still we may expect any issues, if any , do you have any workarounds for the same?

Also, Will it be able to copy Ranges/Charts properly when external sheets/workbooks are referenced for any values/calculations/formulas etc.

Please let us know your thoughts and views on this as this is a serious concern for our clients.

Regards,
Prathap

2

@PrathapSV,

Thanks for providing us some details.

Well, apparently there should not be any significant issue when copying ranges or shapes b/w workbooks. Generally, Aspose.Cells works the same way as MS Excel does when copying range of cells. You should try using our latest version/fix: Aspose.Cells for .NET v19.4.x (which may include maximum enhancements).

There can be an issue when copying ranges where cells are referencing external sources (workbooks, sheets, etc.) especially when you are calculating/updating values based on external references. However, we can look into it. Please give it a try using latest version/fix and in case you find any issue, kindly do provide sample console application (runnable), template file(s) and output file with details to show the issue. Also give your expected file that you may manually create/update in Ms Excel.