CellRange.Copy vulues not formulas

[thecobe4]

Hi
i'm using CellRange.Copy method with these parameters:
reportRange.Copy(masterRange, true, false);

The problem is that it's copying formulas not values
I would like to copy only values

I can't use reportBook.CalculateAllValue() because file has 15 sheets and a lot of formulas. it takes too many time
consider i have to copy 46 sheet from different files into one

it should be like computedFormulaValue parameter for ExportDataTable method

thanks bye

[Betsy.jiang]

Hi,

Thanks for your inquiry.
I have posted your requirement of only copying values to our Dev team. We will let you know once there is any update.

Sincerely,
Betsy
E-iceblue support team

[Betsy.jiang]

Hi,

Glad to inform you that the new feature has been done. Please download Spire.XLS Pack(Hotfix) Version:10.1.1.
Our website link: https://www.e-iceblue.com/Download/down ... t-now.html
NuGet link: https://www.nuget.org/packages/Spire.XLS/

Sample code for your reference:

Code: Select all

CopyRangeOptions copyOptions = CopyRangeOptions.OnlyCopyFormulaValue;
sourceRange.Copy(destRange, copyOptions);

Sincerely,
Betsy
E-iceblue support team

[Betsy.jiang]

Hi,

Greetings from E-iceblue.
Do you use the hotfix and the new feature? Has your issue been resolved?

Sincerely,
Betsy
E-iceblue support team