[xwiki-devs] Prototype SocialCalc integration
I've done a nice experiment with SocialCalc and I'm pretty happy of the results: It allows to edit a spreadsheet stored in a Wiki Page. It lacks a server-side transformation of the spreadsheet to a Wiki table for rendering, printing and pdfs, but it's already interesting. http://incubator.myxwiki.org/xwiki/bin/view/Test/Calc Ludovic -- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost
Hi Ludovic, On Thu, Oct 22, 2009 at 3:48 AM, Ludovic Dubost <[email protected]> wrote:
I've done a nice experiment with SocialCalc and I'm pretty happy of the results:
It allows to edit a spreadsheet stored in a Wiki Page. It lacks a server-side transformation of the spreadsheet to a Wiki table for rendering, printing and pdfs, but it's already interesting.
Looks cool :) Is there a way we can use social-calc / gdocs (or both) to allow users to edit / save attached excel documents? . Didn't do any research myself, just asking in case you have already done that part ;) Thanks. - Asiri
Ludovic
-- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost
_______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
I don't know socialcalc model but it would be simple to integrate GoogleSpreadsheet even if it would be done with something such an iframe for the editor. One limitation: the doc will be stored in google not in xwiki. I have been studying google api with groovy also and this works, you can even create a spreadsheet from your script... Pascal ---------- Forwarded message ---------- From: Asiri Rathnayake <[email protected]> Date: Thu, Oct 22, 2009 at 5:35 AM Subject: Re: [xwiki-devs] Prototype SocialCalc integration To: XWiki Developers <[email protected]> Hi Ludovic, On Thu, Oct 22, 2009 at 3:48 AM, Ludovic Dubost <[email protected]> wrote:
I've done a nice experiment with SocialCalc and I'm pretty happy of the results:
It allows to edit a spreadsheet stored in a Wiki Page. It lacks a server-side transformation of the spreadsheet to a Wiki table for
rendering,
printing and pdfs, but it's already interesting.
Looks cool :) Is there a way we can use social-calc / gdocs (or both) to allow users to edit / save attached excel documents? . Didn't do any research myself, just asking in case you have already done that part ;) Thanks. - Asiri
Ludovic
-- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost
_______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
_______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
Hi, On Thu, Oct 22, 2009 at 5:35 AM, Asiri Rathnayake < [email protected]> wrote:
Hi Ludovic,
On Thu, Oct 22, 2009 at 3:48 AM, Ludovic Dubost <[email protected]> wrote:
I've done a nice experiment with SocialCalc and I'm pretty happy of the results:
It allows to edit a spreadsheet stored in a Wiki Page. It lacks a server-side transformation of the spreadsheet to a Wiki table for
rendering,
printing and pdfs, but it's already interesting.
Very very nice, seems like you made interesting progress since yersterday :-) Can the macro already be published on code.xwiki.org as is? Does it require more than the macro page to work? If not I can publish http://www.myxwiki.org/xwiki/bin/view/XWiki/SocialCalcMacro on code.xwiki.org right away - although I'm not sure where the underlying JS code is located right now.
Looks cool :)
Is there a way we can use social-calc / gdocs (or both) to allow users to edit / save attached excel documents? . Didn't do any research myself, just asking in case you have already done that part ;)
From http://www.socialtext.net/m/page/exchange/socialcalc_faq :
Not yet. I guess we'd need to write some kind of transformation thing on the backend to allow editing an attached Excel spreadsheet right from the wiki page but that would be pretty cool :-) * * *Can I import an Excel spreadsheet into SocialCalc?** **Right now you can import data from Excel by selecting a range in Excel, copying it to the clipboard, and then doing a "Ctrl-V" paste in SocialCalc. The values are pasted - no formats and no formulas. In the future we plan to have more extensive Excel import, so that you can upload an Excel file and turn it into a SocialCalc page, preserving some of the formatting and (hopefully) formulas (where there is functional overlap). Macros will not be imported. CSV file format import is also planned at some point.** **Can I export from SocialCalc to Excel?** **You can copy a range of data in SocialCalc (e.g., Ctrl-C) and then paste it into Excel. CSV export will be available by July 17. Excel export is on roadmap * So it looks like there's still some work to do for this to work. * * Anyway, that's a good start! Guillaume * *
Thanks.
- Asiri
Ludovic
-- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost
_______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
_______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- Guillaume Lerouge Product Manager - XWiki SAS Skype: wikibc Twitter: glerouge http://guillaumelerouge.com/
Guillaume Lerouge a écrit :
Hi,
On Thu, Oct 22, 2009 at 5:35 AM, Asiri Rathnayake < [email protected]> wrote:
Hi Ludovic,
On Thu, Oct 22, 2009 at 3:48 AM, Ludovic Dubost <[email protected]> wrote:
I've done a nice experiment with SocialCalc and I'm pretty happy of the results:
It allows to edit a spreadsheet stored in a Wiki Page. It lacks a server-side transformation of the spreadsheet to a Wiki table for
rendering,
printing and pdfs, but it's already interesting.
Very very nice, seems like you made interesting progress since yersterday :-)
Can the macro already be published on code.xwiki.org as is? Does it require more than the macro page to work? If not I can publish http://www.myxwiki.org/xwiki/bin/view/XWiki/SocialCalcMacro on code.xwiki.org right away - although I'm not sure where the underlying JS code is located right now.
Right now the JS and Images are in xwiki/js/resources/socialcalc We could turn all this into JSExtensions but I'm not sure it is a good idea. It would make us fork the socialcalc codebase. At this point I've been able to only add some JS and add some CSS and it could even be in separate files. I was thinking I could have made a zip of that directory and have it as an attachment, but I don't think I can use the JSExtensions system with zips attached in the Wiki Ludovic -- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost
On 10/22/2009 10:29 AM, Ludovic Dubost wrote:
Guillaume Lerouge a écrit :
Hi,
On Thu, Oct 22, 2009 at 5:35 AM, Asiri Rathnayake< [email protected]> wrote:
Hi Ludovic,
On Thu, Oct 22, 2009 at 3:48 AM, Ludovic Dubost<[email protected]> wrote:
I've done a nice experiment with SocialCalc and I'm pretty happy of the results:
It allows to edit a spreadsheet stored in a Wiki Page. It lacks a server-side transformation of the spreadsheet to a Wiki table for
rendering,
printing and pdfs, but it's already interesting.
Very very nice, seems like you made interesting progress since yersterday :-)
Can the macro already be published on code.xwiki.org as is? Does it require more than the macro page to work? If not I can publish http://www.myxwiki.org/xwiki/bin/view/XWiki/SocialCalcMacro on code.xwiki.org right away - although I'm not sure where the underlying JS code is located right now.
Right now the JS and Images are in
xwiki/js/resources/socialcalc
We could turn all this into JSExtensions but I'm not sure it is a good idea. It would make us fork the socialcalc codebase. At this point I've been able to only add some JS and add some CSS and it could even be in separate files.
I was thinking I could have made a zip of that directory and have it as an attachment, but I don't think I can use the JSExtensions system with zips attached in the Wiki
But this could be a new feature. -- Sergiu Dumitriu http://purl.org/net/sergiu/
On 10/22/09 10:29 AM, Ludovic Dubost wrote:
Guillaume Lerouge a écrit :
Hi,
On Thu, Oct 22, 2009 at 5:35 AM, Asiri Rathnayake< [email protected]> wrote:
Hi Ludovic,
On Thu, Oct 22, 2009 at 3:48 AM, Ludovic Dubost<[email protected]> wrote:
I've done a nice experiment with SocialCalc and I'm pretty happy of the results:
It allows to edit a spreadsheet stored in a Wiki Page. It lacks a server-side transformation of the spreadsheet to a Wiki table for
rendering,
printing and pdfs, but it's already interesting.
Very very nice, seems like you made interesting progress since yersterday :-)
Can the macro already be published on code.xwiki.org as is? Does it require more than the macro page to work? If not I can publish http://www.myxwiki.org/xwiki/bin/view/XWiki/SocialCalcMacro on code.xwiki.org right away - although I'm not sure where the underlying JS code is located right now.
Right now the JS and Images are in
xwiki/js/resources/socialcalc
We could turn all this into JSExtensions but I'm not sure it is a good idea. It would make us fork the socialcalc codebase. At this point I've been able to only add some JS and add some CSS and it could even be in separate files.
I was thinking I could have made a zip of that directory and have it as an attachment, but I don't think I can use the JSExtensions system with zips attached in the Wiki
There are ways to achieve this (this is what I did for the bespin editor for example). I used a hack writing the <script> dependency to dojo (which is in the zip) in javascript using document.write(). Jerome.
Ludovic
SocialCalc uses it's own format to declare the spreadsheet. I'm not sure what is available to make a conversion from XLS to that format. We could use our Excel plugin to do that if there is nothing in SocialCalc For Google Docs, it's a very different Integration and we already did it (it would need to be polished) http://code.xwiki.org/xwiki/bin/view/Plugins/GoogleDocsPlugin It sends an XWiki table to Google Docs for editing and has a method to retrieve it. Now Google Docs is the best editor (more powerfull than SocialCalc) but it's not an option if you want to 100% keep your data inside. SocialCalc is one of the best solutions for internal usage for simple spreadsheet. Ludovic Asiri Rathnayake a écrit :
Hi Ludovic,
On Thu, Oct 22, 2009 at 3:48 AM, Ludovic Dubost <[email protected]> wrote:
I've done a nice experiment with SocialCalc and I'm pretty happy of the results:
It allows to edit a spreadsheet stored in a Wiki Page. It lacks a server-side transformation of the spreadsheet to a Wiki table for rendering, printing and pdfs, but it's already interesting.
Looks cool :)
Is there a way we can use social-calc / gdocs (or both) to allow users to edit / save attached excel documents? . Didn't do any research myself, just asking in case you have already done that part ;)
Thanks.
- Asiri
Ludovic
-- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost
_______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
_______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost
participants (7)
-
Asiri Rathnayake -
Guillaume Lerouge -
Jerome Velociter -
Ludovic Dubost -
Ludovic Dubost -
Pascal Voitot -
Sergiu Dumitriu