Re: Polygrid sorting

[Paul Dupuis via use-livecode]

Thank you Panos!

I must be going blind not to have seen the example when I clicked on the 
Dictionary entry for the message!


On 8/25/2023 5:16 AM, panagiotis m via use-livecode wrote:

Hello Paul,

See the example in the dictionary for the "headerClick" message:

local sDirection

on headerClick pColumnNumber
 local tText

 put the text of me into tText
 put not sDirection[pColumnNumber] into sDirection[pColumnNumber]

 set the itemDel to tab

 # Sort data by this column.
 if sDirection[pColumnNumber] then
 sort lines of tText ascending by item pColumnNumber of each
 else
 sort lines of tText descending by item pColumnNumber of each
 end if

 set the text of me to tText
end headerClick

Kind regards,
Panos

--

On Fri, 25 Aug 2023 at 02:57, Paul Dupuis via use-livecode <
use-livecode@lists.runrev.com> wrote:


The Polygrid, unlike the Datagrid, has no built in column sorting. You
have to roll your own.

Before I write my own, has anyone written a column sort (i.e click on a
column header to sort by it) for a Poly grid they'd care to share?




___
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



___
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

Re: Polygrid sorting

[panagiotis m via use-livecode]

Hello Paul,

See the example in the dictionary for the "headerClick" message:

local sDirection

on headerClick pColumnNumber
local tText

put the text of me into tText
put not sDirection[pColumnNumber] into sDirection[pColumnNumber]

set the itemDel to tab

# Sort data by this column.
if sDirection[pColumnNumber] then
sort lines of tText ascending by item pColumnNumber of each
else
sort lines of tText descending by item pColumnNumber of each
end if

set the text of me to tText
end headerClick

Kind regards,
Panos

--

On Fri, 25 Aug 2023 at 02:57, Paul Dupuis via use-livecode <
use-livecode@lists.runrev.com> wrote:

> The Polygrid, unlike the Datagrid, has no built in column sorting. You
> have to roll your own.
>
> Before I write my own, has anyone written a column sort (i.e click on a
> column header to sort by it) for a Poly grid they'd care to share?
>
>
>
>
> ___
> 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

Polygrid sorting

[Paul Dupuis via use-livecode]

The Polygrid, unlike the Datagrid, has no built in column sorting. You 
have to roll your own.


Before I write my own, has anyone written a column sort (i.e click on a 
column header to sort by it) for a Poly grid they'd care to share?





___
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

Re: Sorting [was: Polygrid sorting]

[Mike Kerner via use-livecode]

oh, i love this topic. this onion is so, so thick.
since you are throwing in the curveball of on-demand column sorting, i have
several suggestions (and these are just my suggestions):
the obvious one is to use one of the bajillion ways that LC can sort,
right? grab the data (if you don't already have the data in a container
that you're using to populate the widget), sort it, put it back
the less obvious is to do what i end up doing in many of my apps (because
everything i write, now, is mobile), and that is have a local sqlite or
mysql db. keep all the data that you retrieve from the server in there, and
use the local copy as the data source. i do that because i can't guarantee
network connectivity, but i want my apps to run, anyway. in that case, my
sorting is still done in my db - my local cache. plus, if my app exits,
crashes, loses the focus, device reboots, etc., i want it to come back in
exactly the state it was in when it left, which is something that's easy to
do with a local db.
then there's using the local command line, because every OS has a sort
routine you can call.
___
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

Re: Sorting [was: Polygrid sorting]

[Paul Dupuis via use-livecode]

So what if you use the column headers on a PolyGrid (or whatever) to 
give the user a UI for sorting by column (adding, or not, sort arrows to 
the header labels).


Is it still more efficient to re-query the database with the new, user 
chosen, sort order and repopulate the PolyGrid?


Or more efficient to just resort the data already populated into the 
grid in the desired order the user has chosen? I suspect this later is 
the more efficient case unless you are sure you have a fast network and 
server with low latency and no competition for bandwidth.


As always, people's use-cases for these widgets vary widely. That is why 
the more versatile a widget is the often (but not always) the better it is.



On 8/25/2022 11:17 AM, Bob Sneidar via use-livecode wrote:

Not sure how that happened. If the source is a DATABASE...

On Aug 25, 2022, at 08:02 , Bob Sneidar via use-livecode 
mailto:use-livecode@lists.runrev.com>> wrote:

+1 if the source is a dabs, sort during query.

Bob S

___
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

Re: Sorting [was: Polygrid sorting]

[Bob Sneidar via use-livecode]

Not sure how that happened. If the source is a DATABASE...

On Aug 25, 2022, at 08:02 , Bob Sneidar via use-livecode 
mailto:use-livecode@lists.runrev.com>> wrote:

+1 if the source is a dabs, sort during query.

Bob S

___
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

Re: Sorting [was: Polygrid sorting]

[Bob Sneidar via use-livecode]

+1 if the source is a dabs, sort during query.

Bob S


On Aug 25, 2022, at 07:21 , Mike Kerner via use-livecode 
mailto:use-livecode@lists.runrev.com>> wrote:

it will probably be faster and more flexible to have your database do your
soriting for you, though.

On Mon, Aug 15, 2022 at 7:47 PM Paul Dupuis via use-livecode <
use-livecode@lists.runrev.com> wrote:

Perhaps some expansion of the column "pgContentTypeofColumn" property?
The current possible values are:
text|svg-lcname|imagedata|imagefile|color|boolean|autoincrement
Allowing the addition of 'numeric' and 'datetime' would at least allow a
mapping to sorts although sort support 'international' (perhaps should
be the default for a polygrid column of type "text" and "binary". I am
also not sure how svg-iconname, imagedata, imagefile, and color should
sort. Perhaps svg-iconname should sort as "text". Bolean can sort as
"text" since ascending puts "false" first and descending puts "true" first.

___
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

Re: Sorting [was: Polygrid sorting]

[Mike Kerner via use-livecode]

it will probably be faster and more flexible to have your database do your
soriting for you, though.

On Mon, Aug 15, 2022 at 7:47 PM Paul Dupuis via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Perhaps some expansion of the column "pgContentTypeofColumn" property?
> The current possible values are:
> text|svg-lcname|imagedata|imagefile|color|boolean|autoincrement
> Allowing the addition of 'numeric' and 'datetime' would at least allow a
> mapping to sorts although sort support 'international' (perhaps should
> be the default for a polygrid column of type "text" and "binary". I am
> also not sure how svg-iconname, imagedata, imagefile, and color should
> sort. Perhaps svg-iconname should sort as "text". Bolean can sort as
> "text" since ascending puts "false" first and descending puts "true" first.
>
>
> On 8/15/2022 7:25 PM, Alex Tweedly via use-livecode wrote:
> > So it occurred to me, while playing with sorting by columns, that it
> > might be nice to have an additional "sortType" available.
> >
> > I'd like to be able to say
> >
> >  - if all the 'things' being sorted on are numbers, then sort numeric,
> > otherwise sort alphabetical.
> >
> > Would that be a reasonable enhancement request ?
> >
> > Would "natural" be a reasonable suggested name ?
> >
> > Alex.
> >
> >
> > ___
> > 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
>


-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
___
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

Re: AW: Polygrid sorting (problems)

[Paul Dupuis via use-livecode]

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@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@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


___
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






___
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

Re: AW: Polygrid sorting (problems)

[Mike Kerner via use-livecode]

which version is that? 21?

On Thu, Aug 18, 2022 at 7:21 PM Paul Dupuis via use-livecode <
use-livecode@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@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
> >
> >
> > ___
> > 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
>


-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe a

Re: AW: Polygrid sorting (problems)

[Paul Dupuis via use-livecode]

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@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



___
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

AW: Polygrid sorting (problems)

[Paul Dupuis via use-livecode]

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@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



___
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

Re: Polygrid sorting

[Mark Smith via use-livecode]

I downloaded and installed the widget, it works (very well) now :) 

> On 15 Aug 2022, at 9:10 pm, Paul Dupuis via use-livecode 
>  wrote:
> 
> Okay, I built the stack and tested it under Windows 10. The 3 beeps are 
> intentional. It is to let me know when it is done as some test with 500+ 
> columns/rows takes a while. It does display under LC9.6.8 (64 bit) on Windows 
> 10.
> 
> Now I have to go try it on macOS?
> 
> 
> 
> On 8/15/2022 4:01 PM, Mark Smith via use-livecode wrote:
>> Hi Paul,
>> 
>> I downloaded your sample stack, put 100 into the Columns field, heard 3 
>> audible beeps but no data (or PolyGrid) appeared. There is data in the 
>> pgcolumnnames and pgdata custom properties (so those values were defined). 
>> It’s just the grid that did not appear. Thinking it might be my laptop 
>> (apple silicon M1) I tried it on an Intel MacBook Pro and got the same 
>> result.
>> 
>> I am a big fan of being able to lock top and left-most column/rows of any 
>> grid and would happily endorse your request.
>> 
>> Cheers,
>> Mark
>> 
>>> On 15 Aug 2022, at 7: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
> 
> 
> ___
> 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

Re: Polygrid sorting

[Mark Smith via use-livecode]

Hi Paul,

My bad. I don’t have the polygrid widget installed. I bought the summer bundle 
but haven’t had time to install or play with it. I will try this afternoon and 
send feedback later. 

Mark


> On 15 Aug 2022, at 9:49 pm, Paul Dupuis via use-livecode 
>  wrote:
> 
> FYI,
> 
> I also just tested on a MacBook Air, M1, running Monterey with LC9.6.8 and 
> the version 1.0.0 of the Summer Bundle widget packs and the PolyGrid and my 
> sample stack displayed for me at 10, 100, and 500 columns and rows.
> 
> 
> On 8/15/2022 4:01 PM, Mark Smith via use-livecode wrote:
>> Hi Paul,
>> 
>> I downloaded your sample stack, put 100 into the Columns field, heard 3 
>> audible beeps but no data (or PolyGrid) appeared. There is data in the 
>> pgcolumnnames and pgdata custom properties (so those values were defined). 
>> It’s just the grid that did not appear. Thinking it might be my laptop 
>> (apple silicon M1) I tried it on an Intel MacBook Pro and got the same 
>> result.
>> 
>> I am a big fan of being able to lock top and left-most column/rows of any 
>> grid and would happily endorse your request.
>> 
>> Cheers,
>> Mark
>> 
> 
> 
> ___
> 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

Re: Polygrid sorting (problems)

[Mark Wieder via use-livecode]

On 8/15/22 16:43, Mark Wieder via use-livecode wrote:

On 8/15/22 16:22, Alex Tweedly via use-livecode wrote:

I haven't tried csvdata or tsvdata (they're not listed in the 
dictionary, so I'd tend to avoid them if possible.


I do see tsvData in the dictionary, but I'm getting weird errors thrown 
from the widget when I try to use it. May still be experimental. There 
aren't any examples and the source isn't available.


Correcting myself, I do see examples in the enhancements folder, they 
just aren't installed. There's also a Plugins/Templates/Default folder 
for various things, but I'm not sure what I'm supposed to do with those, 
if anything. If I use just the examples in the folder then the I can 
manipulate the tsvData and it works. But if I try to generate my own I 
end up throwing weird errors.


--
 Mark Wieder
 ahsoftw...@gmail.com

___
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

Re: Polygrid sorting (problems)

[Paul Dupuis via use-livecode]

On 8/15/2022 7:51 PM, Paul Dupuis via use-livecode wrote:

On 8/15/2022 7:22 PM, Alex Tweedly via use-livecode wrote:


On 15/08/2022 20:34, 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.


I'm using (I think) the latest version 
(com.livecode.widget.polygrid.1.1.1) and I don't see that problem at 
all.




Okay, a widget ignorant question: How do you tell what version of a 
widget you have installed? (i.e where/how do you see 
com.livecode.widget.polygrid.1.1.1)


Never mind. It is in the file name, com.livecode.widget.polygrid.1.1.1.lce

Also, FYI, regarding you note that:

Both "the text and "the pgtext" return the entire grid (without headers).

I haven't tried csvdata or tsvdata (they're not listed in the 
dictionary, so I'd tend to avoid them if possible.


Under the dictionary entry for "polygrid", I see the csvData and tsvData 
properties listed. The "text" property and the pgData property, but NO 
entry for pgText. It would appear, if the .lce file name is correct, 
that I am at the same version, 1.1.1. I am on Windows 10, under LC 9.6.8


___
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

Re: Polygrid sorting (problems)

[Paul Dupuis via use-livecode]

On 8/15/2022 7:22 PM, Alex Tweedly via use-livecode wrote:


On 15/08/2022 20:34, 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.


I'm using (I think) the latest version 
(com.livecode.widget.polygrid.1.1.1) and I don't see that problem at all.




Okay, a widget ignorant question: How do you tell what version of a 
widget you have installed? (i.e where/how do you see 
com.livecode.widget.polygrid.1.1.1)


___
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

Re: Sorting [was: Polygrid sorting]

[Paul Dupuis via use-livecode]

Perhaps some expansion of the column "pgContentTypeofColumn" property? 
The current possible values are: 
text|svg-lcname|imagedata|imagefile|color|boolean|autoincrement
Allowing the addition of 'numeric' and 'datetime' would at least allow a 
mapping to sorts although sort support 'international' (perhaps should 
be the default for a polygrid column of type "text" and "binary". I am 
also not sure how svg-iconname, imagedata, imagefile, and color should 
sort. Perhaps svg-iconname should sort as "text". Bolean can sort as 
"text" since ascending puts "false" first and descending puts "true" first.



On 8/15/2022 7:25 PM, Alex Tweedly via use-livecode wrote:
So it occurred to me, while playing with sorting by columns, that it 
might be nice to have an additional "sortType" available.


I'd like to be able to say

 - if all the 'things' being sorted on are numbers, then sort numeric, 
otherwise sort alphabetical.


Would that be a reasonable enhancement request ?

Would "natural" be a reasonable suggested name ?

Alex.


___
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

Re: Polygrid sorting (problems)

[Mark Wieder via use-livecode]

On 8/15/22 16:22, Alex Tweedly via use-livecode wrote:

I haven't tried csvdata or tsvdata (they're not listed in the 
dictionary, so I'd tend to avoid them if possible.


I do see tsvData in the dictionary, but I'm getting weird errors thrown 
from the widget when I try to use it. May still be experimental. There 
aren't any examples and the source isn't available.


--
 Mark Wieder
 ahsoftw...@gmail.com

___
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

Re: Sorting [was: Polygrid sorting]

[Bob Sneidar via use-livecode]

Datagrids have this feature, so yes, I would expect there to be some way to 
specify what kind of sort you want to do. But it would have to be on a per 
column basis. 

But if you are sorting the text yourself, you can use the syntax: sort lines of 
tText by item n of each.

I don't think any assumptions should be made by the engine as to what kind of 
data each column contains. I worked with an accounting system many years ago 
which had numeric invoice numbers, or so it seemed. Once you created a credit 
memo, it prepended R to the invoice number. 

Bob S


> On Aug 15, 2022, at 16:25 , Alex Tweedly via use-livecode 
>  wrote:
> 
> So it occurred to me, while playing with sorting by columns, that it might be 
> nice to have an additional "sortType" available.
> 
> I'd like to be able to say
> 
>  - if all the 'things' being sorted on are numbers, then sort numeric, 
> otherwise sort alphabetical.
> 
> Would that be a reasonable enhancement request ?
> 
> Would "natural" be a reasonable suggested name ?
> 
> Alex.
> 
> 
> ___
> 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

Re: Polygrid sorting (problems)

[Bob Sneidar via use-livecode]

I think they are trying to be consistent with datagrid terminology, perhaps 
thinking that a tabular data object has become a new class of objects. 

Bob S


> On Aug 15, 2022, at 16:22 , Alex Tweedly via use-livecode 
>  wrote:
> 
> 
> On 15/08/2022 20:34, 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.
>> 
> I'm using (I think) the latest version (com.livecode.widget.polygrid.1.1.1) 
> and I don't see that problem at all.
> 
> Both "the text and "the pgtext" return the entire grid (without headers).
> 
> I haven't tried csvdata or tsvdata (they're not listed in the dictionary, so 
> I'd tend to avoid them if possible.
> 
> And come to think of it - why did they need to invent a new property name 
> "pgText" ?  It seems to be a synonym for "the text", so would it not have 
> been better to just use that ?  Full consistency with many other controls, no 
> added "mental clutter", and "the text" colours nicely in the script editor, 
> so more obvious if you mistype it.
> 
> Alex.
> 
> 
> 
> ___
> 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

Sorting [was: Polygrid sorting]

[Alex Tweedly via use-livecode]

So it occurred to me, while playing with sorting by columns, that it 
might be nice to have an additional "sortType" available.


I'd like to be able to say

 - if all the 'things' being sorted on are numbers, then sort numeric, 
otherwise sort alphabetical.


Would that be a reasonable enhancement request ?

Would "natural" be a reasonable suggested name ?

Alex.


___
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

Re: Polygrid sorting (problems)

[Alex Tweedly via use-livecode]

On 15/08/2022 20:34, 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.


I'm using (I think) the latest version 
(com.livecode.widget.polygrid.1.1.1) and I don't see that problem at all.


Both "the text and "the pgtext" return the entire grid (without headers).

I haven't tried csvdata or tsvdata (they're not listed in the 
dictionary, so I'd tend to avoid them if possible.


And come to think of it - why did they need to invent a new property 
name "pgText" ?  It seems to be a synonym for "the text", so would it 
not have been better to just use that ?  Full consistency with many 
other controls, no added "mental clutter", and "the text" colours nicely 
in the script editor, so more obvious if you mistype it.


Alex.



___
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

Re: Polygrid sorting

[Paul Dupuis via use-livecode]

On 8/15/2022 4:55 PM, Mark Wieder via use-livecode wrote:

On 8/15/22 13:12, Paul Dupuis via use-livecode wrote:
So I see that the Summer Bundle of widgets in the store has a note 
that says "Latest update 1.0.19: 11 August 2022"


However, the Download button says "Version 1.0.0". Does anyone know 
how to update the widget set to 1.0.19 or how to update a single widget?


Yeah. The versioning is wonky and annoying. Apparently the 1.0.0 
version is always the most recent.


From a July 27 comment from Steven Crighton on 
https://livecode.com/polylist-widget-in-the-spotlight/#comment-129572


For the moment you have to update the new widgets manually. To do 
this, first log in to your LiveCode account. In the left hand 
navigation make your way to Products > thirdparty. Scroll down this 
list to find LiveCode Enhancements and download that bundle. Inside 
the bundle folder there is a widgetpackinstaller.livecode file – If 
you want to update everything in your bundle in one go I recommend 
using that. Simply open that stack and click the install button. Note 
– DataView will now be PolyList after you have updated.


I updated once and looks like I'll have to again.



Thank you Mark! (and Steven)

___
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

Re: Polygrid sorting

[Mark Wieder via use-livecode]

On 8/15/22 13:12, Paul Dupuis via use-livecode wrote:
So I see that the Summer Bundle of widgets in the store has a note that 
says "Latest update 1.0.19: 11 August 2022"


However, the Download button says "Version 1.0.0". Does anyone know how 
to update the widget set to 1.0.19 or how to update a single widget?


Yeah. The versioning is wonky and annoying. Apparently the 1.0.0 version 
is always the most recent.


From a July 27 comment from Steven Crighton on 
https://livecode.com/polylist-widget-in-the-spotlight/#comment-129572


For the moment you have to update the new widgets manually. To do this, 
first log in to your LiveCode account. In the left hand navigation make 
your way to Products > thirdparty. Scroll down this list to find 
LiveCode Enhancements and download that bundle. Inside the bundle folder 
there is a widgetpackinstaller.livecode file – If you want to update 
everything in your bundle in one go I recommend using that. Simply open 
that stack and click the install button. Note – DataView will now be 
PolyList after you have updated.


I updated once and looks like I'll have to again.

--
--
 Mark Wieder
 ahsoftw...@gmail.com

___
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

Re: Polygrid sorting

[Paul Dupuis via use-livecode]

FYI,

I also just tested on a MacBook Air, M1, running Monterey with LC9.6.8 
and the version 1.0.0 of the Summer Bundle widget packs and the PolyGrid 
and my sample stack displayed for me at 10, 100, and 500 columns and rows.



On 8/15/2022 4:01 PM, Mark Smith via use-livecode wrote:

Hi Paul,

I downloaded your sample stack, put 100 into the Columns field, heard 3 audible 
beeps but no data (or PolyGrid) appeared. There is data in the pgcolumnnames 
and pgdata custom properties (so those values were defined). It’s just the grid 
that did not appear. Thinking it might be my laptop (apple silicon M1) I tried 
it on an Intel MacBook Pro and got the same result.

I am a big fan of being able to lock top and left-most column/rows of any grid 
and would happily endorse your request.

Cheers,
Mark




___
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

Re: Polygrid sorting

[Paul Dupuis via use-livecode]

I just tested on macOS Mojave (10.14) on an Intel MacBook Pro and the 
PolyGrid and my sample stack work as expected. Tried 10, 100, and 500 
columns/rows.


Now I have to find the MacBook Air with Monterey and see...


8/15/2022 4:01 PM, Mark Smith via use-livecode wrote:

Hi Paul,

I downloaded your sample stack, put 100 into the Columns field, heard 3 audible 
beeps but no data (or PolyGrid) appeared. There is data in the pgcolumnnames 
and pgdata custom properties (so those values were defined). It’s just the grid 
that did not appear. Thinking it might be my laptop (apple silicon M1) I tried 
it on an Intel MacBook Pro and got the same result.

I am a big fan of being able to lock top and left-most column/rows of any grid 
and would happily endorse your request.

Cheers,
Mark




___
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

Re: Polygrid sorting

[Paul Dupuis via use-livecode]

So I see that the Summer Bundle of widgets in the store has a note that 
says "Latest update 1.0.19: 11 August 2022"


However, the Download button says "Version 1.0.0". Does anyone know how 
to update the widget set to 1.0.19 or how to update a single widget?




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

Re: Polygrid sorting

[Paul Dupuis via use-livecode]

Okay, I built the stack and tested it under Windows 10. The 3 beeps are 
intentional. It is to let me know when it is done as some test with 500+ 
columns/rows takes a while. It does display under LC9.6.8 (64 bit) on 
Windows 10.


Now I have to go try it on macOS?



On 8/15/2022 4:01 PM, Mark Smith via use-livecode wrote:

Hi Paul,

I downloaded your sample stack, put 100 into the Columns field, heard 3 audible 
beeps but no data (or PolyGrid) appeared. There is data in the pgcolumnnames 
and pgdata custom properties (so those values were defined). It’s just the grid 
that did not appear. Thinking it might be my laptop (apple silicon M1) I tried 
it on an Intel MacBook Pro and got the same result.

I am a big fan of being able to lock top and left-most column/rows of any grid 
and would happily endorse your request.

Cheers,
Mark


On 15 Aug 2022, at 7: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



___
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

Re: Polygrid sorting

[Mark Smith via use-livecode]

Hi Paul,

I downloaded your sample stack, put 100 into the Columns field, heard 3 audible 
beeps but no data (or PolyGrid) appeared. There is data in the pgcolumnnames 
and pgdata custom properties (so those values were defined). It’s just the grid 
that did not appear. Thinking it might be my laptop (apple silicon M1) I tried 
it on an Intel MacBook Pro and got the same result. 

I am a big fan of being able to lock top and left-most column/rows of any grid 
and would happily endorse your request.

Cheers,
Mark

> On 15 Aug 2022, at 7: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

Re: Polygrid sorting (problems)

[Paul Dupuis via use-livecode]

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

Polygrid sorting

[Paul Dupuis via use-livecode]

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