So there is an example of sorting in the PolyGrid documentation under the entry for the MESSAGE "headerClick" and under the entry to the PROPERTY "text" (and in 'the text of me')

The example code only sort the visible rows as "the text of widget X" returns the data of PolyGrid X as tab delimited, WITHOUT the column headers, but ONLY the visible rows.

So, what to use for sorting all the data in a PolyGrid by a particular column?

The tsvData of widget X (and csvData, and Text) doesn't seem to work. The all seems to only get the visible data (rows). Only the pgData of widget return the whole dataset of the PolyGrid. Is this the way these properties are supposed to work?

If that is how text, csvData, and tsvData are supposed to work (returning only the visible rows), then the sort example in the PolyGrid documentation require updating otherwise these properties require updating!



On 8/15/2022 2:29 PM, Paul Dupuis via use-livecode wrote:
So, I bought the Summer Bundle. Yes, it is a good deal.

In my case it was primarily for the Polygrid widget. Our application uses a Datagrid to display customer research data. The columns headers are text and the left most column ROWs are test and all other cells are numbers. Some customers can have quite large data sets and I have been running into the number of columns (ad a default width of 100px per column) exceeding a GROUPs 32,767px width maximum (about 327-328 columns). At this point the Datagrid just fails - no data is displayed.

I can now attest that a Polygrid (under LC 9.6.8) does not have this limit. I have a "test" stack (for Datagrid testing) I converted to the Polygrid and can easily generate 1000 columns x 1000 rows of data and it works.

So I guess the answer to bug https://quality.livecode.com/show_bug.cgi?id=23875 is "Use the PolyGrid"

On that note, the Datagrid has 2 features I use in this specific case, user column resizing (built into the Polygrid - Yea!) and column sorting (NOT built into the Polygrid - Boo!). So, does anyone have some column sort code for the Polygrid they have written that they might be willing to share?

Also, I have filled a Polygrid enhancement request to allow the left column (or the left N columns) to be locked/frozen, so they remain visible when the Polygrid is scrolled horizontally. See https://quality.livecode.com/show_bug.cgi?id=23880. If you might benefit from this enhancement, please follow the bug or add a comment to that effect.


_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Reply via email to