We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Question about noncontiguous named ranges

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:


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 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.


Please see the article for your complete reference:

Thank you.