On Tue, Oct 11, 2011 at 12:27 AM, Chris Muller <asqueaker at gmail.com> wrote:

> I am _really_ interested in a SpreadsheetMorph.  Just a grid of
> objects.  Drag and drop.  "Formulas" would just be Smalltalk
> expression strings sent to the SpreadsheetMorph itself, which can
> reference any of its cells, of course:
>
>    (self cellAt: 1 at 2) + (self cellAt: 1 at 3)
>
> would send the #+ message to whatever objects had been dragged into
> those referenced cells.
>

Skeleton is pretty much *exactly* what you're describing. If you haven't
already, please give it a look: http://languagegame.org:8080/ggame/11. The
SqueakMap package works in the latest Etoys image (I haven't tried a Squeak
image, though).

It supports formulas as smalltalk expressions just as you're describing
(except that it maps cell names as A1, B2, etc.).
The cells accept drag and drop of Etoys tiles, which is *extremely* cool,
because it lets you link the spreadsheet data with the morphic world.

Cheers,
Richo


>
> If I had that, I could finally finish and present a maui-based Office
> application for Squeak (word-proc, spreadsheet, presentation -- but
> integrated with standard domain objects as characters, cells,
> presentations-objects, respectively).  I would use Maui's rendering to
> allow each cell to assume any system or user-defined view.
>
> Unfortunately it's way down on my to-do list.  I hope someday I'll
> have time, I think it'd be fun to develop.
>
>  - Chris
>
>
> On Mon, Oct 10, 2011 at 9:59 PM, Ricardo Moran <richi.moran at gmail.com>
> wrote:
> >
> > On Mon, Oct 10, 2011 at 3:32 PM, Gary Dunn <garydunnhi at gmail.com> wrote:
> >>
> >> Nice looking work. Clearly your spreadsheet morph can display data in
> >> tabular format, and import/export to csv file. Can a cell be
> >> programmed with the common math expressions? C:1 = A:1 * B:1, B:3 =
> >> A:3 + 12.  Except the left side of the expression is assumed to be the
> >> current cell.
> >
> > No, that's not supported. It shouldn't be difficult to add, though. I
> always
> > liked that Skeleton allows you to write Smalltalk expressions inside cell
> > functions, that's pretty cool.
> >
> >>
> >> I tried working with it in Windows 7. Was able to load it and the
> >> utils package into Etoys 4.1.1 but how do I get it going? Can you
> >> suggest a simple 1-2-3 step process to get me to where I can poke
> >> around? (BTW, this is often a stopper for me, I sense it is effortless
> >> to experienced Squeakers.)
> >
> > You can start by looking at the Object Catalog, take out a "Spreadsheet"
> and
> > use the halo to open its viewer. You'll find two interesting categories:
> > "data i/o" to import/export from CSV files and "spreadsheet" to deal with
> > the cells/rows/columns stuff.
> > Or you can try evaluating the following snippet in a workspace:
> > -------------------
> > spreadsheet := ScrollableSpreadsheetMorph new openInHand.
> > spreadsheet numberOfRows: 20.
> > spreadsheet numberOfColumns: 10
> > -------------------
> > Look at the classes for more info. Basically, there are two morphs: a
> basic
> > spreadsheet and a scrollable spreadsheet that wraps it with a scroll bar.
> >
> >>
> >> I also tried loading it into a Squeak 4.2 image, but my feeble
> >> attempts to get it going were all met with MNUs. Have you tried on
> >> Squeak?
> >
> > I suggest you to use the version I'm attaching. I did a quick test and
> most
> > of it seems to be working in Squeak 4.2. This version doesn't need any of
> > the GSoC packages, but it needs CSV installed:
> > (Installer squeaksource project: 'CSV') install: 'CSV'.
> > Feel free to ask me if you have more questions.
> > Cheers,
> > Richo
> >
> >>
> >> On Fri, Oct 7, 2011 at 10:17 PM, Ricardo Moran <richi.moran at gmail.com>
> >> wrote:
> >> > Hi, I made a *very* simple spreadsheet morph for GSoC last year. It's
> >> > not
> >> > nearly as advanced as skeleton but if you're interested you can find
> it
> >> > here: http://www.squeaksource.com/GSoCSqueakland/
> >> >
> >> > Cheers,
> >> > Richo
> >> >
> >> > On Oct 7, 2011 8:12 PM, "Gary Dunn" <garydunnhi at gmail.com> wrote:
> >> >>
> >> >> Anybody have a spreadsheet morph? Not to compete with Excel, more
> like
> >> >> original Visicalc.
> >> >>
> >> >> Gary Dunn
> >> >> Open Slate Project
> >> >> http://openslate.org
> >> >>
> >> >>
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >>
> >> --
> >> Gary Dunn
> >> Honolulu
> >>
> >
> >
> >
> >
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeak-dev/attachments/20111011/6f4534cf/attachment.htm