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.
Hello Jing,
Is it possible to use formulas in a sheet that refer to other sheet like in Excel?
e.g: (in VB.NET)
Dim sheet1, sheet2 As Worksheet
sheet1 = Me.ReoGrid1.Worksheets(0)
sheet2 = Me.ReoGrid1.Worksheets(1)
sheet1("A1") = 5
sheet2("B2") = "=Sheet1!A1"
I have tried to do it but the result in cell B2 of sheet2 is 0. However, if I export the workbook to Excel the result is ok.
A second question is about the format in a cell: Can I introduce a personal format like: "0.000 Meters" . By other hand, the format RedMinus should represent a negative number in red and keep the minus sign however only change the color and remove the minus.
The third and last question is about the colors in the cells. I have tried the following code but nothing happen:
Dim sheet As Worksheet
sheet = Me.ReoGrid1.CurrentWorksheet
'create a range position
Dim range As New ReoGridRange("A1:D4")
Dim Estilo As New ReoGridStyleObject
Estilo.BackColor = Color.Orange
sheet.SetRangeStyle(range, Estilo)
Could you tell me is something is wrong?
Thank you for your help.
Offline
Hi Navasender,
1) Current version does not support sheet reference, this feature is under development.
2) Yes from next version, the interface of custom data format will be introduced.
3) Please set the style flag like this:
Dim Estilo As New ReoGridStyleObject
Estilo.Flag = PlainStyleFlag.BackColor
Estilo.BackColor = Color.OrangeJing
Offline
Reference across worksheet now available from 0.9.0.0 version.
Offline