We have an issue with one of our excell report . it has 2 tables in excel template.
above table has static Aspose tags and below table has dynamic tags which insert columns horizontally.
Ex: we are using columns A to F
Table 1(Above table in Excel) has static tags in A to F.
Table2(Below Table in Excel) has dynanic horizontal tag in colum A like "&=[Table2].Year(horizontal)"
suppose we have 10 years of data when we run the report second table tags insert 10 dynamic columns due to this the above static colums (From B) move towards right 10 columns imean its showing after the end of second table(dynamic columns)
Is there any way to protect the above table as it is even when second table insert columns?