Free Support Forum - aspose.com

SumProduct calculations result in #VALUE but can be calculated inside Excel

Aspose.Cells Product Family
#1

Hi,

I have the following calculation:

=SUMPRODUCT((AM6:AM108=1)*(K6:K108)*(I6:I108))/SUMIF(AM6:AM108,1,I6:I108)

It results in #VALUE when I generate the file, but upon opening it in Excel and F2 then enter on the cell, it has the correct values.

I am setting the above formula to the "cell.Formula" property of the cell, and I am explicitly calling Workbook.CalculateFormula() at the end.

Now I'm pretty much stuck, with my deadline ticking closer! Please can you help as soon as possible (perhaps with an alternative methodology for calculating the conditional sum product?)

Kind Regards,

Vic

#2

Hi,

Thanks for considering Aspose.

Yes, we found the problem, we will fix this issue soon.

Thank you.

#3

Please try this attached fix.

#4

Many thanks Laurence - that is fantastic - the new dll does seem to work fine.

However, just one thing; as we are a corporate, it would be better if it was an official release? Can you tell me whether this modified dll is based only on the last official release, or if it contains all cumulative changes implemented thus far? Will this dll you posted now be widely available as the official "patch" release?

Finally, when do you anticipate your next "official" release?

Many thanks,

Vic

#5

Yes, this fix contains all changes. We will publicly release a new version in 1-2 weeks.

#6

Ok - thanks again for your prompt responses.

Regards

Vic