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.
]]>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.
Q.Cells["XX"].Formula = "S!B2"
I've checked about this but haven't found problems.
]]> 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.
]]>