ReoGrid Forum

bka_812002

Member

Registered: 2015-08-24

Posts: 4

How to highlight the extra workshhet in Reo grid

Hi
As per my requirement, while comparing two excels having different number of worksheets, the extra\additional worksheets should be highlighted in the Reo grid.
Is it possible in Reo grid to highlight the additional worksheet with a different colour?[For ex, let's say excel1 contains sheets A,B and excel2 contains A,B and C, then sheet C should be coloured]

Thanks
Biraj

Jingwood

Moderator

From: jing at reogrid.net

Registered: 2014-06-03

Posts: 615

Re: How to highlight the extra workshhet in Reo grid

Sorry that background color for worksheet name only available in Pro-edition.
https://reogrid.net/v0-8-8/built-in-sheet-tab-control/

For free-edition of ReoGrid, below is one of workaround:

Step 1. Hide the default sheet tab control

Step 2. Make your own tab control and place it at bottom of ReoGrid control

Step 3. Determine and change the color for each tab that is associated to given worksheet

There are some events that could be used for interaction between your own sheet tab control and ReoGrid control:

• WorksheetInserted

• WorksheetRemoved

• WorksheetNameChanged

• CurrentWorksheetChanged

Regards, Jing