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.