Question about noncontiguous named ranges

Aspose.Cells Product Family
1

I would like some advice regarding the best way to do the following:
I need to create some named ranges that contain noncontiguous cells. For example:

=E7:E8,E11:E12,E15:E16

I am then going to refer to the named range in a sum, like "=Sum(test_range)".

My question is this: Can you add a range to an existing named range?
Something like this:

1) define named range as "E7:E8"

2) add "E11:E12" to get "E7:E8,E11:E12"

3) and add "E15:E16" to get "E7:E8,E11:E12,E15:E16"

I have attached a screenshot of a sample Excel file that shows what I am trying to do.

Thanks,
Mark

2

Hi,

Thanks for your question and consideration of Aspose.Cells.

We have logged this feature in our database.

We will provide you a sample code or implement this feature in coming releases if not available.

This issue has been logged as CELLSNET-40101.

3

Hi,


Please see the article for your complete reference:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/implementing-nonsequenced-ranges.html

Thank you.