TsWorksheetGrid AutoExpand [ANSWERED]
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
totya · 2016-09-27 19:40

Hi!

My I ask some information,

TsWorksheetGrid/AutoExpand aeData and aeNavigation

what are they doing exactly? I don't see much different...

Thanks, and Im 'sorry if this question already answered.

----------------------------------------------------------------------
wp · 2016-09-27 19:54

If AutoExpand is empty then the grid has a fixed size. In my demos it
is set up with 100 rows and 26 columns (one for each letter). You will
not be able to navigate outside this range, and you will not be able
to add any data by the grid methods outside as well. - This is the
standard StringGrid behavior. If you load a file with 200 rows and 5
columns then the pre-defined range will be adjusted accordingly.

If AutoExpand contains aeData the grid automatically exands if you add
some data or format outside the range. But you cannot navigate out of
the current range.

If AutoExpand contains aeNavigation the grid automatically expands if
you move the focused cell cursor out of the defined grid range.

In practice I think it is a good choice to have both options combined,
When I wrote this, however, I had the idea that there might be cases
to distinguish between aesData and aesNavigation.

I hope I remember correctly...

----------------------------------------------------------------------
totya · 2016-09-27 22:58

Hi!

Thanks for the answer!

I tried these in fpsgrid_no_install example.

If I load one file, the whole file is loaded and appear, this is
independent from data and navigation settings.

With the columns, these values isn't important too, because this is
almost always 255, this is more than enough, and this is known bug,
you said this. Se we talk about the rows... I  see the
fpsgrid_no_install example, and I think I understand now, see "Enter
value for cell [AB110]:" extend the range, if data is checked.

Thanks for this information!