AW: Polygrid sorting (problems)

[Paul Dupuis]

Yes, Livecode enhancements bundle 1_0_21 (with PolyGrid 1.1.3)


On 8/18/2022 8:31 PM, Mike Kerner via use-livecode wrote:
> which version is that? 21?
>
> On Thu, Aug 18, 2022 at 7:21 PM Paul Dupuis via use-livecode <
> use-livecode at lists.runrev.com> wrote:
>
>> All,
>>
>> Bug 23886 has been fixed with the latest release of the Summer Bundle
>> widget sets. Download from the store.
>>
>> On 8/17/2022 3:51 PM, Paul Dupuis via use-livecode wrote:
>>> BTW the problem of:
>>> the text of widget X
>>> the csvData of widget X
>>> the tsvData of widget X
>>> AND (not in the Livecode 9.6.8 Dictionary for PolyGrid 1.1.1)
>>> the pgText of widget X
>>> ALL not returning the full data for a PolyGrid widget is a confirmed bug:
>>>
>>> See https://quality.livecode.com/show_bug.cgi?id=23886
>>>
>>>
>>>
>>> On 8/15/2022 3:34 PM, Paul Dupuis via use-livecode wrote:
>>>> 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 at 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 at 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 at 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 at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>