[squeak-dev] Spreadsheet morph
asqueaker at gmail.com
Tue Oct 11 03:27:08 UTC 2011
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.
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.
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
> 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.
>> On Fri, Oct 7, 2011 at 10:17 PM, Ricardo Moran <richi.moran at gmail.com>
>> > 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
More information about the Squeak-dev