Pat,
I think you'll be pleased. But be forewarned - a collection based listbox
is not an extension or expansion of array based listboxes. It's a
completely new approach to listboxes. There has been a lot of discussion
about this on the list. I found this blog entry helpful:
https://blog.4d.com/display-a-collection-in-a-listbox/
Feel free to ping me if you have any questions.
On Mon, Feb 4, 2019 at 8:17 AM Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
wrote:
> Thanks Kirk.
> I haven't had time to properly look into using Collections but this will
> give me a good incentive to do so.
>
> Pat
>
> On Mon, 4 Feb 2019 at 15:35, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com
> >
> wrote:
>
> > Pat,
> > This would be a lot easier to do with collections instead of arrays.
> >
> > Each 'sheet' can be represented by a collection. The 'workbook' is itself
> > another collection with each 'sheet' pushed onto it. You will put some
> > graphic element on the form to manage choosing the sheet you want but
> then
> > it's simply a collection based listbox.
> >
> > Using arrays is the same idea but you get into pointers and multiple 2D
> > arrays. Complicated. Collections are easy.
> >
> > On Mon, Feb 4, 2019 at 7:22 AM Pat Bensky via 4D_Tech <
> > 4d_tech@lists.4d.com>
> > wrote:
> >
> > > Here's a nice little question to ponder for a Monday morning ...
> > >
> > > Let's say we have a 2-D array that represents the cells in a
> spreadsheet
> > -
> > > eg
> > > a2tCellContents{10}{10})
> > > 10 rows x 10 columns. Simples.
> > >
> > > Now, we want to add another layer to this. Maybe for the individual
> > sheets
> > > in a spreadsheet. So if there were 4 sheets with varying numbers of
> rows
> > > and columns in each sheet, we would have a structure something like
> this:
> > > a3tContents{1}{10}{10}
> > > a3tContents{2}{5}{20}
> > > a3tContents{3}{8}{6}
> > > a3tContents{4}{2}{50}
> > >
> > > How would you accomplish this?
> > > (Using v17)
> > >
> > > PB
> > >
> > > --
> > > *************************************************
> > > CatBase - Top Dog in Data Publishing
> > > tel: +44 (0) 207 118 7889
> > > w: http://www.catbase.com
> > > skype: pat.bensky
> > > *************************************************
> > > **********************************************************************
> > > 4D Internet Users Group (4D iNUG)
> > > Archive: http://lists.4d.com/archives.html
> > > Options: https://lists.4d.com/mailman/options/4d_tech
> > > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
> > > **********************************************************************
> >
> >
> >
> > --
> > Kirk Brooks
> > San Francisco, CA
> > =======================
> >
> > *We go vote - they go home*
> > **********************************************************************
> > 4D Internet Users Group (4D iNUG)
> > Archive: http://lists.4d.com/archives.html
> > Options: https://lists.4d.com/mailman/options/4d_tech
> > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
> > **********************************************************************
>
>
>
> --
> *************************************************
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *************************************************
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> Archive: http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
> **********************************************************************
--
Kirk Brooks
San Francisco, CA
=======================
*We go vote - they go home*
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************
