Potential User Questions

I am trying the datagrid in ActiveWidgets and up to now, I am impressed, but I have a few questions as there does not seem to be a central point of documentation.

Can cells be multi-line ?

Can you sort on more than one column ?

Can you move columns, ie rearrange the order displayed ?

Can you edit all cells in a row or just one at a time ?

How do you write the edited cell/s to the CSV file ?

Can cells contain HREF Links which can be clicked and activated ?

Can data be sourced from external sights such as Google Spreadsheets or Amazon S3 ?

Is it possible to filter csv records so only matching records are displayed ?

Is paging of records possible ?

Will ActiveWidgets work with Windows Mobile Phone Browsers ?

Sorry for all the questions, but I need to get all the above working if we are to use ActiveWidgets.

Thanks

Richard

>> Can cells be multi-line ?

Yes, but all rows should have the same height.

>> Can you sort on more than one column ?

The sort algorithm is 'stable' so you can just click on several headers one after another (like in windows explorer). Or you can do whatever you want in javascript.

>> Can you move columns, ie rearrange the order displayed ?

In script - yes. Via drag-n-drop - no.

>> Can you edit all cells in a row or just one at a time ?

Sorry, I don't understand this. You edit cursor can only be at one point, not at several places simultaneously?

>> How do you write the edited cell/s to the CSV file ?

You need to send the modified data back to the server. Server then saves the data (on the server).

>> Can cells contain HREF Links which can be clicked and activated ?

Yes. Actually the cells can contain any html, not just links.

>> Can data be sourced from external sights such as Google Spreadsheets or Amazon S3 ?

Depends on the format. Javascript files can be downloaded directly from the third-party domain. All other files require a proxy on your own server (cross-domain security restrictions).

>> Is it possible to filter csv records so only matching records are displayed ?

There is no built-in filter function, so you have to do it in script.

>> Is paging of records possible ?

There is no built-in paging support. The grid works in 'virtual scrolling' mode, see -

http://www.activewidgets.com/general.demos/virtual-mode.html

>> Will ActiveWidgets work with Windows Mobile Phone Browsers ?

Mobile browsers are not supported. Last time I've checked this - the code required minor adjustments to work on Windows Mobile, but the performance was quite bad, so I would not recommend it.

Thank you for those encouraging replies.

How would you make all rows the same size, when you have no idea which is the largest of the multiline cells or do you have to pre-process the file and try and work it out ?

As someone who has a smattering of javascript skills, where can I find all these scripts that answer my questions ?

Thanks again

Richard