Canvas based Grid gadget

Andre · **Posted:** Fri Aug 14, 2015 9:35 pm

Thanks a lot, said!

Works very well on MacOS too, as I just tested with your newest .pbi

I only had to add the following code to have the missing color constant on MacOS:

Code:

CompilerIf Not Defined(White, #PB_Constant)
  #White = $EEEEEE
CompilerEndIf

That's why I supported this topic in the wishlist: viewtopic.php?f=3&t=26568&p=468950#p468950 :twisted:

Kwai chang caine · **Posted:** Sat Aug 15, 2015 5:42 pm

Very nice, EXCEL class :shock:

Thanks for your great job and mainly for sharing

said · **Joined:** Thu Apr 14, 2011 6:07 pm **Posts:** 342

Kiffi, ozzie, LuckyLuke, Fred, Andre and Kwai chang caine (that's quite a looong nickname) ... Thank you all for the nice words

You are welcome

This grid gadget as is now is good .... but in reality we are using in our applications a newer and better version ... Since there is so much interest in that grid, give me some time so i pack the new version (along with some help) and upload it, i hope you will like it

In case the PB team finds that my grid deserves be part of PB ... this will be my honor

Said

Niffo · **Posted:** Fri Nov 20, 2015 5:11 pm

Thank you VERY much for your work !

Would love to see the last non public version you are talking about.

mestnyi · **Joined:** Mon Nov 25, 2013 6:41 am **Posts:** 830

Code:

#PB_Shortcut_Prior
#PB_Shortcut_Next

writes undefined

mk-soft · **Posted:** Wed Feb 08, 2017 1:17 am

Constant has been changed...

Code:

#PB_Shortcut_PageUp
#PB_Shortcut_PageDown

Andrew Lindsay · **Joined:** Mon May 30, 2011 12:17 pm **Posts:** 18

Said, or anyone else that may be able to help...

Is there any way to override the default behaviour of printing the row and column headers, or to change them to something else?

I would like to be able to use the grid as a data input form for multiple columns of input, perhaps even having the column labels based on entries in a list in another grid.

Any assistance would be appreciated.

Best regards

Andrew

said · **Joined:** Thu Apr 14, 2011 6:07 pm **Posts:** 342

Andrew Lindsay wrote:

Said, or anyone else that may be able to help...

Is there any way to override the default behaviour of printing the row and column headers, or to change them to something else?

I would like to be able to use the grid as a data input form for multiple columns of input, perhaps even having the column labels based on entries in a list in another grid.

Any assistance would be appreciated.

Best regards

Andrew

Sure you can change the default headers!
Have you tried MyGrid_SetText() ?!
Row or Col Headers are Col = 0 and Row = 0

Said

Andrew Lindsay · **Joined:** Mon May 30, 2011 12:17 pm **Posts:** 18

Yes, I tried that and nothing changed. I was wondering if there was something I was going wrong.

When I get home I will send through my example.

Also, is there a way to limit the number of columns and rows, say 3 columns and 10 rows?

Andrew Lindsay · **Joined:** Mon May 30, 2011 12:17 pm **Posts:** 18

OK, yes that worked, not sure why it did not work, previously, perhaps I hit run instead of compile when I tried it.

Are you able to assist in how to limit the size of the grid (number of rows x number of columns)?

Best regards

said · **Joined:** Thu Apr 14, 2011 6:07 pm **Posts:** 342

Andrew Lindsay wrote:

OK, yes that worked, not sure why it did not work, previously, perhaps I hit run instead of compile when I tried it.

Are you able to assist in how to limit the size of the grid (number of rows x number of columns)?

Best regards

Good it worked

as for the number of rows, columns

1. In case you know prior to creating the grid the required number of rows, cols then you can define them in MyGrid_New() while creating the grid
2. otherwise, you need to re-dimension the grid after creating it then you can use:
2.1 MyGrid_ReDefine() ... this will clear any previous content, you can re-define nbr of rows/cols
2.2 MyGrid_ReDefineRows() ... this can be used to adjust the number of rows but keeping the same number of columns, it will preserve the contents (if you are shrinking or keep whatever is there if you are enlarging)

After creating the grid you cannot change the number of columns without clearing all contents!

Said

said · **Joined:** Thu Apr 14, 2011 6:07 pm **Posts:** 342

Hi All,

After a long time, here is a new update of this grid, many new improvements, for more details see first post

The nest update will be in 2019 :mrgreen:

davido · **Posted:** Sat Nov 11, 2017 8:08 am

@said,
A very good update. Impressive!

Thank you for sharing, all the hard work you have put in to developing it.

Andre · **Posted:** Sat Nov 11, 2017 9:18 pm

Very good, thank you very much!

Kwai chang caine · **Posted:** Sun Nov 12, 2017 9:20 pm

Waooouhhh !!!
The insert image, the adjust width and height column at double clic :shock:

A real jewel, thanks a lot for this precious sharing

PureBasic Forum

Canvas based Grid gadget

Who is online