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 2015-06-12 10:49:32

Navasender
Member
Registered: 2015-06-09
Posts: 10

References to others sheets and other questions

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

#2 2015-06-14 14:19:19

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

Re: References to others sheets and other questions

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.Orange

Jing

Offline

#3 2015-09-10 14:54:50

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

Re: References to others sheets and other questions

Reference across worksheet now available from 0.9.0.0 version.

Offline

Board footer

Powered by FluxBB