How to use Stimulsoft Reports like EXCEL

Stimulsoft Reports.NET discussion
shrek
Posts: 14
Joined: Sun Mar 24, 2013 5:39 am

How to use Stimulsoft Reports like EXCEL

Post 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
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: How to use Stimulsoft Reports like EXCEL

Post by Alex K. »

Hello,

You can use the cells expression in necessary cell with your formula.

Thank you.
shrek
Posts: 14
Joined: Sun Mar 24, 2013 5:39 am

Re: How to use Stimulsoft Reports like EXCEL

Post by shrek »

How to get the value of the cells


Thanks
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: How to use Stimulsoft Reports like EXCEL

Post by Alex K. »

Hello,

Please see the following topic in our knowledgebase:
http://stimulsoft.helpserve.com/index.p ... icleid=350

Thank you.
shrek
Posts: 14
Joined: Sun Mar 24, 2013 5:39 am

Re: How to use Stimulsoft Reports like EXCEL

Post 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'
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: How to use Stimulsoft Reports like EXCEL

Post by HighAley »

Hello.

No, this expression works in the cross-tab only.

Thank you.
shrek
Posts: 14
Joined: Sun Mar 24, 2013 5:39 am

Re: How to use Stimulsoft Reports like EXCEL

Post 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
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: How to use Stimulsoft Reports like EXCEL

Post by HighAley »

Hello.

You can get it to the Get Value event of the cell.

Thank you.
shrek
Posts: 14
Joined: Sun Mar 24, 2013 5:39 am

Re: How to use Stimulsoft Reports like EXCEL

Post 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.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: How to use Stimulsoft Reports like EXCEL

Post 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.
Post Reply