ReoGrid Forum

sedighzade

Member

Registered: 2016-01-28

Posts: 6

Using Formula in multisheet scenario

Hi Mr. Jing,

In the editor provided, create 2 sheets. Fill the first column of the first sheet ( sheet1 ) with lets say 3 numeric values. Then in any cell of the second sheet enter the following formula:

=SUM(Sheet1!A1:Sheet1:A3)

Nothing happens!

Thanks for your help.
Sedighzade

asparatu

Member

Registered: 2014-08-20

Posts: 196

Re: Using Formula in multisheet scenario

Hello sedighzade and Jing,
   I have test it also it is not working. Also, sedighzade the syntax is wrong it should be =SUM(Sheet1!A1:Sheet1!A3) and you have =SUM(Sheet!A1:Sheet1:A3), but it still does not work. When you do =SUM(Sheet1!A1) it works.

Shane

Last edited by asparatu (2016-04-09 07:39:13)

sedighzade

Member

Registered: 2016-01-28

Posts: 6

Re: Using Formula in multisheet scenario

Sorry.

it was my fault.

asparatu

Member

Registered: 2014-08-20

Posts: 196

Re: Using Formula in multisheet scenario

Hello sedighzade,
  Its not a problem.. Even if you change the syntax it still does not work.. there is a bug in the function or control.
Shane

Jingwood

Moderator

From: jing at reogrid.net

Registered: 2014-06-03

Posts: 615

Re: Using Formula in multisheet scenario

Thanks Sedighzade and Shane, it is a problem and will be fixed from next release.