Feng Forum

Other Topics => Development => Applications => : conrado May 29, 2007, 01:43:49 PM

: Open Source on-line spreadsheet
: conrado May 29, 2007, 01:43:49 PM
This are the open source on-line spreadsheets I found:


Have you found any other?

Which one's the best?
: Re: Open Source on-line spreadsheet
: conrado June 01, 2007, 01:18:54 AM
After watching this terrific demo (http://www.peapodcast.com/sgi/wikicalc97demo/) I have already made up my mind for the preferred Open Source Spreadsheet.

It is wikicalc (http://www.softwaregarden.com/products/wikicalc/index.html). Check it out.
: Re: Open Source on-line spreadsheet
: yed June 06, 2007, 10:39:48 AM
Did anyone try the Zimbra spreadsheet?
Zimbra has a open source version of their product and they do seem to have web based documents and spreadsheets. I think we can take a look at their source it just might help us out.
Zimbra Collaboration Suite 4.5: http://www.zimbra.com/products/ (http://www.zimbra.com/products/)
Screen Shot: http://www.zimbra.com/products/ss_document_spreadsheet.html (http://www.zimbra.com/products/ss_document_spreadsheet.html)
(http://www.zimbra.com/_media/ss_document_spreadsheet.gif)
: Re: Open Source on-line spreadsheet
: conrado June 06, 2007, 02:45:28 PM
Wow, I forgot. Good thing you mentioned it.

I think Marcos and Ignacio did try it. It would be good to learn their opinions.

Zimbra is definitely a sister project we should be following, and maybe trying to work together.
: Re: Open Source on-line spreadsheet
: yed June 07, 2007, 11:28:42 AM
This is what I believe in a very abstract way what the spread sheet should simulate.

The online spread sheet is  broken down to cells
Each cell is like a wiki page with its own history
Each cell like a wiki page can have their own attributes
Operations on cells and combination of cells will be based on the attributes of the cell

Many wikis already have a spreadsheet plugin. A few examples below
http://doc.tikiwiki.org/tiki-index.php?page=Spreadsheet
http://twiki.org/cgi-bin/view/TWiki/SpreadSheetPlugin

But they are not exactly as feature rich as the other (namely editgrid or google spreadsheets) May be because we dont have a FCKspreadsheet  ;)

: Re: Open Source on-line spreadsheet
: conrado June 07, 2007, 05:15:21 PM
This is what I believe in a very abstract way what the spread sheet should simulate.

The online spread sheet is  broken down to cells
Each cell is like a wiki page with its own history
Each cell like a wiki page can have their own attributes
Operations on cells and combination of cells will be based on the attributes of the cell

Many wikis already have a spreadsheet plugin. A few examples below
http://doc.tikiwiki.org/tiki-index.php?page=Spreadsheet
http://twiki.org/cgi-bin/view/TWiki/SpreadSheetPlugin

But they are not exactly as feature rich as the other (namely editgrid or google spreadsheets) May be because we dont have a FCKspreadsheet  ;)



Ok. Agreed on that definition.

The spreadsheet is a very tough one. Having done a simple "bird-eye view" of the lot (Zimbra still a miss) I am still going with wikicalc. Of course, a formal evaluation would be the way to decide this. That is no small task though  :-\
: Re: Open Source on-line spreadsheet
: yed June 11, 2007, 02:40:23 PM
Could you have brief look at Zimbra and provide us a overview of how Zimbra has gone about it?
I cant because I right now dont have that infrastructure to setup Zimbra.
Thanks in advance
: Re: Open Source on-line spreadsheet
: admin June 11, 2007, 02:44:48 PM
Will try it ASAP.  :)
: Re: Open Source on-line spreadsheet
: yed June 15, 2007, 05:20:49 PM
I just tried Zoho spreadsheet and this is what I will have to say about a hypothetical web spreadsheet (a slight modification of the one I stated few post earlier)
------------------------
This is what I believe in a very abstract way what the spread sheet should simulate.

The online spread sheet is  a table of cells
Each save of the document creates a state or version of the spread sheet.
Each cell can have their own attributes (like color/type of data etc..)
Operations on cells and combination of cells will be based on the attributes of the cell - eg. mathematical functions - which actually make a table into a spread sheet.
----------------------

Any comments?
: Re: Open Source on-line spreadsheet
: conrado June 20, 2007, 03:29:40 PM
This is what I believe in a very abstract way what the spread sheet should simulate.

The online spread sheet is  a table of cells
Each save of the document creates a state or version of the spread sheet.
Each cell can have their own attributes (like color/type of data etc..)
Operations on cells and combination of cells will be based on the attributes of the cell - eg. mathematical functions - which actually make a table into a spread sheet.

Agreed.

After some further investigation (still shallow; I have to admit) and with the activeCollab approach in mind, I now think that TrimSpreadsheet (http://code.google.com/p/trimpath/wiki/TrimSpreadsheet) would be the best candidate. It is simple, so that means easy to build upon.
: Re: Open Source on-line spreadsheet
: yed June 28, 2007, 12:00:44 AM
Did you check the latest features added to pbwiki?
They have added spreadsheets to pbwiki using numsum.
Might give us some pointers.
: Re: Open Source on-line spreadsheet
: conrado June 29, 2007, 12:02:57 PM
No, I haven't. Thanks for the tip. I will try that too.

How do they do it? The sheets are hosted an NumSum's servers right? NumSum is not OpenSource right?

I did try Zimbra's demo, but didn't like the approach; you can only embed a spreadsheet in a word document. I downloaded the code, but I am still experimenting with TrimSpreadsheets, so didn't have time to take a look at it.
: Re: Open Source on-line spreadsheet
: lusmo December 19, 2007, 09:38:46 AM
And some other links:
http://tikiwiki.org/tiki-directory_browse.php?parent=70
: Re: Open Source on-line spreadsheet
: editfish September 11, 2008, 10:40:19 PM
Any updates as to the pending or future integration of spreadsheet capabilities into OpenGoo?

thanks!
: Re: Open Source on-line spreadsheet
: cabeza September 12, 2008, 11:36:53 AM
We had a meeting about the topic on Tuesday ... the project is in progress and we expect results, soon ... I'll tell the component developers to post about this.
Marcos

: Re: Open Source on-line spreadsheet
: FernandoR September 12, 2008, 12:25:26 PM
Hi all:

we had two or three main topics on Tuesday:

We are performing a redesign of the spreadsheet server architecture. No big deal, but is a must in order  to maintain certain aspects of the code and the posibility to extend it, etc.

There are several changes on the client side too, with the same purposes .
in addition to this, the browser compatibillity issue is top priority and let me tell you is a headache (among other pains).

Before moving on, we have the need to consolidate and ensure what we've got so far (and test it, of course)

news coming up in a couple of weeks
keep posting!!

Fernando
: Re: Open Source on-line spreadsheet
: justforkicks September 16, 2008, 10:28:06 AM
Using this really cool scripting language called Rebol (http://www.rebol.com), you can create small applications that are surprisingly powerful. For example, check out RebCalc (a 2 KB spreadsheet) at http://www.rebol.org/view-script.r?script=rebocalc.r

Rebol code works in over 43 platforms unchanged and the interpreter is rather tiny. There is also a RebWiki that works like a Word processor. And finally Rebol supports dialects or so-called Domain specific languages, so you can create a dialect that is specific to solving a particular problem. For example, one can create a Visual Basic for Applications (VBA) dialect so that Excel macros work inside OpenGoo.
: Re: Open Source on-line spreadsheet
: FernandoR September 16, 2008, 04:30:01 PM
Thanks for the information, we will take a look at it ASAP.

by the way, if you think theres something you've found and seems useful in some way, just post it

bye


: Open Source Presentations
: justforkicks September 17, 2008, 02:11:33 AM
Also check out the MagicPoint Presentation tool. MagicPoint takes a very different approach to the problem of editing presentations. This tool is based on plain text files and a custom markup language. Editing of slides is done with an ordinary text editor; the resulting file must be fed to the utility to see the final result.

Check it out: http://member.wide.ad.jp/wg/mgp/

Magicpoint has a few other neat features as well.

1.) Scribbling on slides during presentation with the mouse (two colors)
2.) One pixel time thermometer, visible to speaker, generally not on overhead projector: green for lots of time, yellow for wrap-up, red for time's up
3.) "swallow" features allows one to run an external program (X11) within a slide!
4.) %filter allows one to filter text in a slide through a rendering engine (such as latex2eps) to generate images which can then be displayed within slides.
5.) A variety of pauses, "cut-ins" (text sliding in from one side or another), fades (slide transitions) are supported. There aren't many of them, and they should be used sparingly, but they're simple and functional.
: Re: Open Source on-line spreadsheet
: justforkicks November 03, 2008, 09:19:59 AM
Folks,

I know this might disappoint a lot of people but I seriously feel that we need to have a spreadsheet component before OpenGoo 1.0 release. Even if it means that we will probably have something like TrimSpreadsheet or OpenRecord we should still include that for the sake of completeness. For a lot of people, Spreadsheets are the very reason they use an Office productivity suite and not having that in the first release might reduce the impression of OpenGoo.

---
JFK
: Re: Open Source on-line spreadsheet
: FernandoR November 07, 2008, 03:06:58 PM
@justforkicks:

Hi:

The alpha version of the spreadsheet is almost complete. It was implemented as a stand alone module and we are integrating it with opengoo.

There are minor issues that we are taking care of before release.

bye!





: Re: Open Source on-line spreadsheet
: justforkicks November 26, 2008, 08:23:51 AM
Check out this amazing AJAX Spreadsheet (Open Source) at http://www.zkoss.org/product/zkspreadsheet.dsp

This is part of the ZKOss Javascript library...
: Re: Open Source on-line spreadsheet
: ignacio November 26, 2008, 11:14:16 AM
Looks really nice, but it's developed in Java, so it wouldn't be too practical to integrate with OpenGoo as it would add the requirement for Java on the server.
: Re: Open Source on-line spreadsheet
: Mark February 11, 2009, 10:51:33 PM
@justforkicks:

Hi:

The alpha version of the spreadsheet is almost complete. It was implemented as a stand alone module and we are integrating it with opengoo.

There are minor issues that we are taking care of before release.

bye!

It seems your project to build an stable spreadsheet module did never finish??
An live spreadsheet editor in OpenGoo would give an huge boost!
: Re: Open Source on-line spreadsheet
: ignacio February 15, 2009, 03:58:02 PM
The spreadsheets module hasn't been finished yet, and although you shouldn't take this as a promise, expect it to be finished in the next couple of versions.
: Re: Open Source on-line spreadsheet
: r2gnl March 07, 2009, 09:00:10 AM
Can you give me an inside on what the spreadsheet module is based on, reading trough these postings I'm not surre.

Remco
: Re: Open Source on-line spreadsheet
: Mage March 24, 2012, 09:10:10 PM
Does anyone have any updates to this?

I am having trouble finding one that is super clean.