PureBasic Forums - English

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: That's why I supported this topic in the wishlist: http://www.purebasic.fr/english/viewtop ... 50#p468950

Very nice, EXCEL class
Thanks for your great job and mainly for sharing

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

Thank you VERY much for your work !

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

writes undefined

Constant has been changed...

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

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

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?

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

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

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

@said,
A very good update. Impressive!

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

Very good, thank you very much!

Waooouhhh !!!
The insert image, the adjust width and height column at double clic
A real jewel, thanks a lot for this precious sharing