ReoGrid Forum

Fast and powerful .NET Spreadsheet Component

You are not logged in.

Announcement

This forum no longer accepts new user registrations, please report your question, problem and feedback to the issue page of ReoGrid on Github. Thanks for your cooperation.

https://github.com/unvell/ReoGrid/issues

#1 2016-02-13 19:55:03

sedighzade
Member
Registered: 2016-01-28
Posts: 6

Cell referencing bug for cloumns in the referencing sheet

Hi,

1- Create 2 sheets named S & Q
2- Type what ever data you like in any cells of S.
3- Reference those cells above in what ever cell of the Q. Cell data will be set to nothing.
    e.g. set Q.A[1-n].Data = 'S'!B2. This results to nothing except empty cell for Q.A[1-n].
4- At certain times, magically the cell referencing starts to work properly. the reason? unknown to me!

the cell formula is shown in the formula bar correctly, but the text displayed is an empty string.

Last edited by sedighzade (2016-02-13 19:56:41)

Offline

#2 2016-02-14 10:32:08

Jing
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: Cell referencing bug for cloumns in the referencing sheet

I will check this and reply you again. Thanks.

Offline

#3 2016-02-14 15:43:21

Jing
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: Cell referencing bug for cloumns in the referencing sheet

You can't use Data property to set formula, did you tried use Formula property instead?

Q.Cells["XX"].Formula = "S!B2"

I've checked about this but haven't found problems.

Offline

#4 2016-02-14 16:44:44

sedighzade
Member
Registered: 2016-01-28
Posts: 6

Re: Cell referencing bug for cloumns in the referencing sheet

hi,

I did it in the GUI you have provided,not by coding!
I also have my own project based on the component, both have the same problem.
Run Editor2013 project, set cell values for A1 & A2 in sheet1. Now insert another sheet ( Sheet2 ). In cell A1 of Sheet2 type (=Sheet1!A1 or even ='Sheet1'!A1)
Nothing happens.
Now in cell B1 of Sheet2 type =Sheet1!A1. It works.

Offline

#5 2016-02-15 05:39:04

Jing
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: Cell referencing bug for cloumns in the referencing sheet

OK I found the problem, if cell positions from two worksheet are same, e.g. Sheet3.A1 = Sheet1.A1 the problem will happen. Sheet3.A2 = Sheet1.A1 it will work. Thanks for reporting. It will be fixed and released in next version soon.

Offline

#6 2016-02-15 06:39:56

sedighzade
Member
Registered: 2016-01-28
Posts: 6

Re: Cell referencing bug for cloumns in the referencing sheet

Hi Mr. Jing,

Thank you very much for your reply.

Please be advised that Excel compatible functions do not work in multi-sheet scenario. If you set cells A1 to A5 of sheet1, then in sheet2.B4 =SUM(sheet1!A1:sheet1:A5) won't work, though I have only checked SUM & AVERAGE functions.

BTW, thanks for your great job.

Offline

#7 2016-02-17 07:05:24

Jing
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: Cell referencing bug for cloumns in the referencing sheet

Hi! This problem has been fixed in 1.1 version and available for download at https://reogrid.net/download/, thanks for reporting.

Offline

Board footer

Powered by FluxBB