Problem handling SUM with non-contiguous cells


#1

Hi,

currently I am generating SUM formulae over non-contiguous cells, namely constructs of the sort:

=SUM(A1;B2;D4;C3;O8)

and such. However the string being generated is just fine and I assign it to the Formula property. When I open the resulting Excel file, I get a formula of the kind

=SUM(‘A1;B2;D4;C3;O8’())

Note the quote and function brackets that get introduced. Maybe there’s a different way in achieving what I want, but I feel this is a bug in the formula handling or non-contiguous cell handling.

Any help would be appreciated

Regards

Kai Iske


#2

Please set the formula as

=SUM(A1,B2,D4,C3,O8)

The dilimeter in formula can only be ‘,’.


#3

Laurence,

thanks for the information. However Excel does support ‘;’ as a delimiter.
Anyway, maybe you should add this information to the Formula property’s help page so that people now. It only shows a sample using the range delimiter ‘:’

Regards

Kai


#4

Yes. I will add it to our API reference. Thank you.