Page 1 of 2
How to use Stimulsoft Reports like EXCEL
Posted: Mon Mar 25, 2013 9:24 am
by shrek
Hi,
For Table/Cross table component, is it possible to assign the formula (likes excel cell) for the grid cells, e.g. B1=1.5*A1.
Any example codes will be appreciated.
Thanks
Re: How to use Stimulsoft Reports like EXCEL
Posted: Mon Mar 25, 2013 10:19 am
by Alex K.
Hello,
You can use the cells expression in necessary cell with your formula.
Thank you.
Re: How to use Stimulsoft Reports like EXCEL
Posted: Tue Mar 26, 2013 12:40 am
by shrek
How to get the value of the cells
Thanks
Re: How to use Stimulsoft Reports like EXCEL
Posted: Tue Mar 26, 2013 5:53 am
by Alex K.
Hello,
Please see the following topic in our knowledgebase:
http://stimulsoft.helpserve.com/index.p ... icleid=350
Thank you.
Re: How to use Stimulsoft Reports like EXCEL
Posted: Tue Mar 26, 2013 1:42 pm
by shrek
Hi,
Whether can use the formula in the Table,
After I used this formula({Cells[1,1]}) in the Table shows the result is '0'
Re: How to use Stimulsoft Reports like EXCEL
Posted: Wed Mar 27, 2013 5:44 am
by HighAley
Hello.
No, this expression works in the cross-tab only.
Thank you.
Re: How to use Stimulsoft Reports like EXCEL
Posted: Wed Mar 27, 2013 11:58 am
by shrek
Aleksey Andreyanov wrote:Hello.
No, this expression works in the cross-tab only.
Thank you.
Thank you,
How to get the value of the cells in Table
Re: How to use Stimulsoft Reports like EXCEL
Posted: Thu Mar 28, 2013 6:16 am
by HighAley
Hello.
You can get it to the Get Value event of the cell.
Thank you.
Re: How to use Stimulsoft Reports like EXCEL
Posted: Thu Mar 28, 2013 9:25 am
by shrek
Aleksey Andreyanov wrote:Hello.
You can get it to the Get Value event of the cell.
Thank you.
Sorry .
I think that you can give me an example of the expression.
Thanks.
Re: How to use Stimulsoft Reports like EXCEL
Posted: Thu Mar 28, 2013 10:05 am
by Alex K.
Hello,
shrek wrote:Hi,
Whether can use the formula in the Table,
After I used this formula({Cells[1,1]}) in the Table shows the result is '0'
You can use the expression from Cells[1,1] in your formula.
Thank you.