You are not logged in.
This forum has been archived and no longer accepts new user registrations. Please report your questions, problems, and feedback to the issue page of ReoGrid on GitHub. Thank you for your cooperation.
Pages: 1
Topic closed
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
I will check this and reply you again. Thanks.
Offline
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
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
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
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
Hi! This problem has been fixed in 1.1 version and available for download at https://reogrid.net/download/, thanks for reporting.
Offline
Pages: 1
Topic closed