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

Free Support Forum - aspose.com

Horizontal support on dynamic formula

Hi.
I am trying to create a horizontal repeat (dynamic) formula. But, its’ not repeating and aspose syntax in file remains as it.
&=[DS].CloseDate(group:normal,noadd) &=[DS].Account(skip:2,noadd,numeric,horizontal) &=[DS].Amount(skip:2,horizontal,noadd) &=&={-1}{r}+1~(skip:2,horizontal)

If i use without horizontal keyword it works. but with this it don’t.
Aspose cells. 20.1.0 (no license so far)

@kuns200,
Thank you for your query.

Please share your runnable console application, the template file, program output and expected output file created by MS Excel for our reference. Please ensure that the application contains all the required data to run it standalone here. We will test the scenario and provide assistance accordingly.

@kuns200,

Well, grouping data horizontally may not be supported in Smart Markers, it might only works vertically. Anyways, as Ahsan Iqbal requested please share your console application, the template file, program output and expected output Excel file, we will evaluate it further.