<br><div class="gmail_quote">On Tue, Oct 11, 2011 at 12:27 AM, Chris Muller <span dir="ltr"><<a href="mailto:asqueaker@gmail.com">asqueaker@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
I am _really_ interested in a SpreadsheetMorph. Just a grid of<br>
objects. Drag and drop. "Formulas" would just be Smalltalk<br>
expression strings sent to the SpreadsheetMorph itself, which can<br>
reference any of its cells, of course:<br>
<br>
(self cellAt: 1@2) + (self cellAt: 1@3)<br>
<br>
would send the #+ message to whatever objects had been dragged into<br>
those referenced cells.<br></blockquote><div><br></div><div>Skeleton is pretty much *exactly* what you're describing. If you haven't already, please give it a look: <a href="http://languagegame.org:8080/ggame/11">http://languagegame.org:8080/ggame/11</a>. The SqueakMap package works in the latest Etoys image (I haven't tried a Squeak image, though).</div>
<div><br></div><div>It supports formulas as smalltalk expressions just as you're describing (except that it maps cell names as A1, B2, etc.).</div><div>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.</div>
<div><br></div><div>Cheers,</div><div>Richo</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br>
If I had that, I could finally finish and present a maui-based Office<br>
application for Squeak (word-proc, spreadsheet, presentation -- but<br>
integrated with standard domain objects as characters, cells,<br>
presentations-objects, respectively). I would use Maui's rendering to<br>
allow each cell to assume any system or user-defined view.<br>
<br>
Unfortunately it's way down on my to-do list. I hope someday I'll<br>
have time, I think it'd be fun to develop.<br>
<font color="#888888"><br>
- Chris<br>
</font><div><div></div><div class="h5"><br>
<br>
On Mon, Oct 10, 2011 at 9:59 PM, Ricardo Moran <<a href="mailto:richi.moran@gmail.com">richi.moran@gmail.com</a>> wrote:<br>
><br>
> On Mon, Oct 10, 2011 at 3:32 PM, Gary Dunn <<a href="mailto:garydunnhi@gmail.com">garydunnhi@gmail.com</a>> wrote:<br>
>><br>
>> Nice looking work. Clearly your spreadsheet morph can display data in<br>
>> tabular format, and import/export to csv file. Can a cell be<br>
>> programmed with the common math expressions? C:1 = A:1 * B:1, B:3 =<br>
>> A:3 + 12. Except the left side of the expression is assumed to be the<br>
>> current cell.<br>
><br>
> No, that's not supported. It shouldn't be difficult to add, though. I always<br>
> liked that Skeleton allows you to write Smalltalk expressions inside cell<br>
> functions, that's pretty cool.<br>
><br>
>><br>
>> I tried working with it in Windows 7. Was able to load it and the<br>
>> utils package into Etoys 4.1.1 but how do I get it going? Can you<br>
>> suggest a simple 1-2-3 step process to get me to where I can poke<br>
>> around? (BTW, this is often a stopper for me, I sense it is effortless<br>
>> to experienced Squeakers.)<br>
><br>
> You can start by looking at the Object Catalog, take out a "Spreadsheet" and<br>
> use the halo to open its viewer. You'll find two interesting categories:<br>
> "data i/o" to import/export from CSV files and "spreadsheet" to deal with<br>
> the cells/rows/columns stuff.<br>
> Or you can try evaluating the following snippet in a workspace:<br>
> -------------------<br>
> spreadsheet := ScrollableSpreadsheetMorph new openInHand.<br>
> spreadsheet numberOfRows: 20.<br>
> spreadsheet numberOfColumns: 10<br>
> -------------------<br>
> Look at the classes for more info. Basically, there are two morphs: a basic<br>
> spreadsheet and a scrollable spreadsheet that wraps it with a scroll bar.<br>
><br>
>><br>
>> I also tried loading it into a Squeak 4.2 image, but my feeble<br>
>> attempts to get it going were all met with MNUs. Have you tried on<br>
>> Squeak?<br>
><br>
> I suggest you to use the version I'm attaching. I did a quick test and most<br>
> of it seems to be working in Squeak 4.2. This version doesn't need any of<br>
> the GSoC packages, but it needs CSV installed:<br>
> (Installer squeaksource project: 'CSV') install: 'CSV'.<br>
> Feel free to ask me if you have more questions.<br>
> Cheers,<br>
> Richo<br>
><br>
>><br>
>> On Fri, Oct 7, 2011 at 10:17 PM, Ricardo Moran <<a href="mailto:richi.moran@gmail.com">richi.moran@gmail.com</a>><br>
>> wrote:<br>
>> > Hi, I made a *very* simple spreadsheet morph for GSoC last year. It's<br>
>> > not<br>
>> > nearly as advanced as skeleton but if you're interested you can find it<br>
>> > here: <a href="http://www.squeaksource.com/GSoCSqueakland/" target="_blank">http://www.squeaksource.com/GSoCSqueakland/</a><br>
>> ><br>
>> > Cheers,<br>
>> > Richo<br>
>> ><br>
>> > On Oct 7, 2011 8:12 PM, "Gary Dunn" <<a href="mailto:garydunnhi@gmail.com">garydunnhi@gmail.com</a>> wrote:<br>
>> >><br>
>> >> Anybody have a spreadsheet morph? Not to compete with Excel, more like<br>
>> >> original Visicalc.<br>
>> >><br>
>> >> Gary Dunn<br>
>> >> Open Slate Project<br>
>> >> <a href="http://openslate.org" target="_blank">http://openslate.org</a><br>
>> >><br>
>> >><br>
>> ><br>
>> ><br>
>> ><br>
>> ><br>
>><br>
>><br>
>><br>
>> --<br>
>> Gary Dunn<br>
>> Honolulu<br>
>><br>
><br>
><br>
><br>
><br>
><br>
<br>
</div></div></blockquote></div><br>