ReoGrid Forum

drdbkarron

Member

Registered: 2015-05-06

Posts: 29

Need worksheet index number

I'm using ReoGrid workbook for entering, viewing and manipulating 3d data.
So the position of a sheet in a stack/collection of sheets is important.
A full cell specification should be sheet: row:col in some fashion.
In Excel, you can use the name of the sheet, even if it is another file, as a cell reference.

Is there any full string specification of a reogrid cell that includes the sheet?

How can I recover the position in the stack of sheets collection so I can give it a position in a 3d display?
Right now I am hacking it by counting the sheets and using my count as the position enumerator.
You should put a field in the sheet to expose this without having to count sheets each time.

What do you think? Bug or future feature?

Is there a field in the worksheet to the parent workbook?

Jingwood

Moderator

From: jing at reogrid.net

Registered: 2014-06-03

Posts: 615

Re: Need worksheet index number

Is there any full string specification of a reogrid cell that includes the sheet?

Same as Excel. e.g. Sheet1!B3

How can I recover the position in the stack of sheets collection so I can give it a position in a 3d display?

You want to get index position of a sheet? try reoGridControl.GetWorksheetIndex("sheet2") method
https://reogrid.net/document/workbook/

Is there a field in the worksheet to the parent workbook?

You can use the Workbook property of worksheet.
https://reogrid.net/document/workbook/