Hi,

I think your users are asking for excel and not the VFP grid control. Did you try inserting a spreadsheet into a form and get the data into it. I think it would be much easier for them.

Good Luck,
Kamal

>Since most of my users are current Excel very much, they also request
>some commands to do which is internal built in Excel...
>They tract the grid as if a normal work sheet of Excel..
>
>>_<' It make many problem here.
>
>1) Choose number of column and row freezed in run-time.
>After try to freeze one column, they complain the screen frash too much and make their eye no compatible!
>
>2) Ask for sort order as they which... Nearly I need to set all field to be indexed... #__#'
>
>3) Ask to display a Calculated Value, Some maybe like Vlookup... but when force the grid cell, show the actually formula and calculated value at same screen. Of cos, different position...
>
>4) Run-Time select area in grid to set Print Area and print them... Crazy! but surely easy done in Excel.
>
>5) Want True Delete, not mark Delete.
>
>6) The most crazy one is:
>Ask to add Field/Modify Field long if needed in run-time!!
>
>But the application is using in muli-user.... @__@'
>Impossible!!
>

---

>I don't know how to reply them, they only shout what they wants...