Smart markers - Insert only cells

Aspose.Cells Product Family
1

I am using smart markers to fill in a sheet. I have name ranges defined in the first row for the first 8 columns in the sheet. When data is loaded onto the sheet how do the name ranges get extended automatically?.

Also a name range should extend only upto the no of the data rows that are filled in that column.

The current behavior is that all name ranges defined in that sheet will extend up to the maximum row which has data in any of the corresponding columns.

2

Hi,

Thanks for considering Aspose.

Could you give us more detail what are you requiring for? If possible, kindly create a sample project with a template file that will show what is lacking in and your proposed demand of the scenario. After we evaluate and consider the feasiblity, we 'll get back to you soon.

Thank you.

3

Hi,

The scenario is;

In Sheet 1 - I defined a Name Range 'Range1' to include cells A1:A2 and 'Range2' to include cells B1:B2. and have put smart markers in A1 and B1 as &=SUPP.name and &=PROD.name respectively. Now when data is loaded and the column A is filled with 10 Suppliers and column B is filled with 5 Products I would like to have the corresponding name ranges to extend (Range1 should include A1:A10 and Range2 should include from B1:B5 only and NOT till B10 ). If some 8 data rows are loaded into column C which has another name range 'Range3' defined then it should extend to as C1:C8

What currently happens is like all the name ranges Range1, Range2 and Range 3 extend to as A1:A10, B1:B10 and C1:C10 (i.e upto the max number of data rows loaded in any column).

Note: I initially defined Range1 and Range2 to include 2 cells because a new row is inserted below the current row to populate multiple data rows and as a result the name range would extend automatically. It would be wonderful if this is also not necessary which would avoid the extra blank cell that gets included in each of the name range.

Appreciate your response.

Thanks

4

Hi,

Thanks for the scenario and detail.

Well, by default the named range will go and further extend in accordance with the max data value (bottom most cell value) of a column. We will check the feasiblity and effecitiveness against your demand and get back to you soon.

Thank you.

5

Hi,

Can you please give me an update on this. I am waiting on it to respond to my client to complete the evaluation process.

Thanks in advance,

Satish.

6

Hi Satish,

Thanks for evaluating our product.

We will enahnce Smart Markers to add your required feature soon.

Thank you.

7

Hi Satish,

In these few days I am investigating this feature. However, I have to say that we cannot make a simple solution for it because:

Now when populating data, we insert blank rows first. That make the named ranges extending same rows in different columns. To make named ranges extending different rows in different columns is very complex and will degrade the performance. And more is that it would zigzag data below smart markers.

A workaround is that you can create named ranges at run time with Aspose.Cells. Then you can define them according to your need.