AVERAGE calculation error

[Jon]

When you use the AVERAGE formula in Excel and the range of cells includes empty cells, it will calculate the average based upon only those cells with a value (see image).



However if I call Workbook.CalculateAllValue() on a workbook with this included it throws an error.

Code: Select all

Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:\temp\Book1.xlsx", ExcelVersion.Version2010);
workbook.CalculateAllValue();

As I do not know the range of cells at designtime, how can I get this work?

[Gary.zhang]

Hello,

Thanks for your inquiry. After an initial test with Spire.XLS Pack Hotfix Version:7.6.1, I am afraid, I could not see any issue with your input documents, could you please clarify what the issue is?
Thanks,
Gary
E-iceblue support team

[Jon]

I am using version 7.6.1.
Here is a screenshot of the error in Visual Studio:

[Gary.zhang]

Hello,

Thanks for your quick reply. What's your develop environment?

Thanks,
Gary
E-iceblue support team

[Jon]

My Dev Environment:

Windows 8.1 Pro
Visual Studio 2013 Pro update 4

I enclose a copy of the test project.

[Gary.zhang]

Hello,

Sorry for late reply as weekend.
Thanks for the information. Here is a newest hotfix you could try.
http://www.e-iceblue.com/downloads/hot_ ... 7.6.18.zip
Thanks,
Gary
E-iceblue support team

[Jon]

Hi,
Hotfix 7.6.18 appears to have solved that issue.

Thank you.

[Gary.zhang]

Hello,

Glad to hear that. Feel free to contact us if you have any questions or needs.

Sincerely,
Gary
E-iceblue support team