[Sugar-devel] updates and testing SocialCalc on the Sugar Live CD
danb at bricklin.com
Sat Sep 5 21:39:15 EDT 2009
Thanks for doing the testing. Here are some answers to some of the
questions you asked or things you found undocumented.
The database functions, like all of the functions, are pretty much the
same as the functions by the same name in Excel and many other
spreadsheets (many going back to Lotus 1-2-3 and even sometimes
VisiCalc). They are defined in the Open Document Format specification.
The same is true of all of the financial functions. (There used to be an
Open Formula specification, which I think got moved into Open Document
Format. I coded the functions looking to the Open Formula
specification.) The built-in SocialCalc doc does not provide more than
the simple explanation for all functions to save space and since they
are well documented with other spreadsheets. Most of the SocialCalc
documentation is about what is special to SocialCalc. Also, the code
itself documents what it does, including, with the financial functions,
a reference to the Wikipedia entry that helped in their specification. I
assumed that others can read that to produce appropriate written
documentation. (I think there is a reported issue that SocialCalc's IF
function only takes the 3 argument form, not the 2 argument form. It
also evaluated all arguments unlike many other IF functions.)
The toolbar buttons, including the two types of move and swap colors, as
well as the sheet settings, names, and more are explained in a video I
created. The 54 minute Flash video, created with Camtasia, goes over
many of the features of the main SocialCalc engine that the Sugar
version of SocialCalc is built upon. (For example, that version does not
have the Sugar-specific graphing tab.) You can view the video at:
Note that the value format specification language, used to define
numeric formatting, is similar to that used in most spreadsheets,
including Excel. You can learn much of it by looking at the samples
already built into the product (set a format and the choose Custom to
see the definition). This can be used when customizing the product for
other locales to, for example, have different currency symbols and
placement. Custom formats are demonstrated in the video.
Thanks again for taking time to work with SocialCalc so we can help
provide this functionality around the world through this platform.
Edward Cherlin wrote:
> I ran through all of the basic functions of SocialCalc, including
> every icon on every tab. I have tested some but not all of the 109
> functions provided, with good results so far. Although there are
> functions I could wish for, the only real deficiency I have found is
> in the documentation.
> I have created a page for elements of Sugar that children are not
> likely to discover on their own,
> http://wiki.sugarlabs.org/go/The_undiscoverable. I recommend it to
> developers who want to think about whether more of Sugar can be made
> discoverable, or whether we need to write lesson plans for the
> features that cannot be made obvious to the novice. I will put in a
> section for SocialCalc. These are not bugs in the sense of incorrect
> behavior or missing explanations, so I omit them here.
> Here is a summary of the other issues I have encountered.
> o The database functions are severely underdocumented. What database?
> What are databaserange, fieldname, criteriarange?
> o Where does Paste Formats get its formats from?
> o What does Swap Colors do?
> o The financial and statistical function definitions in the Help might
> be clear to one who uses other spreadsheets a lot, but certainly are
> not to a beginner.
> o More explanation is needed on angles in degrees and radians.
> o I understand Move From and Move Paste, but not Move Insert.
> o I see how to set names, but not what to use them for or how.
> o I don't see the Sheet setting control on the Format tab that the
> Help refers to.
> o I found the OK and Sort... buttons on the Sort tab confusing. It has
> since become clear to me. Perhaps OK should be renamed Set Range.
> Not bad for a beta.
> On Thu, Sep 3, 2009 at 12:16 PM, Manusheel Gupta<manu at laptop.org> wrote:
>> Dear community members,
>> We are preparing for the next release of SocialCalc on Sugar. Localization
>> infrastructure, canonicalization of the save format and collaboration will
>> be the key features available in the next release. We are also looking
>> forward to develop interoperability between SocialCalc format and a number
>> of other spreadsheet formats like .wk3/.wk4/csv/excel/open office
>> spreadsheet. We have recently received a number of requests on developing
>> interoperability between SocialCalc and .wk3/.wk4 format, which has been a
>> challenging problem to work on. Hope to get this feature ready before the
>> next release.
>> Lately, I have been testing SocialCalc on the Sugar Live CD, and have run
>> into issues. I can't seem to get SocialCalc to start. I fired up the Sugar
>> LiveCD, and opened up the USB icon in my journal. I can see the file
>> SocialCalc.xo on my USB stick. When I click on it, I get a start button,
>> but then nothing happens. Below is a gears image, which starts something
>> that looks like a developer interface. Not sure, where I have been going
>> wrong. Any help on this issue is highly appreciated.
>> Please visit the SocialCalc on Sugar page at
>> http://seeta.in/j/products-and-services/socialcalc-on-sugar.html. The
>> activity is available for download both from the SEETA website
>> (http://seeta.in) and from activities.sugarlabs.org. If you have any
>> questions, or would like to add suggestions/comments/feature requests,
>> please do so here.
>> Thank you for your continued support.
>> Sugar-devel mailing list
>> Sugar-devel at lists.sugarlabs.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Devel