Integration with charts?

Charts is definitely something that Sheetnode should offer or at least integrate with. I'll add it to the roadmap. For now, you can export to XLS and do graphing in Excel/OpenOffice. And please send feedback when you do try the module!

It would be great if this module integrated with http://drupal.org/project/chart

I'm working on a distribution that will leverage Sheetnode for data visualizations. Therefore, I need to find some kind of way to make Sheetnode work with some kind of charting library. Assigning to myself to motivate me to work on this over the next week or so.

Anyone have any idea how I should design this? Should I add new content types that reference sheetnodes? Or should this be done as some kind of field formatter — i.e., instead of displaying the Socialcalc interface and the data, display a chart instead? Also, should I try to use something like Visualization API (Instead of, say, Chart)?

I would have liked to see a charting feature that's embedded within the spreadsheet, like Excel / OpenOffice.

But I guess it depends on your use case. What are you trying to achieve?

Hi!
My distribution (Website / Project page) is essentially designed to be a platform for uploading data and creating sharable visualizations from that data. If you're familiar with IBM's ManyEyes platform, what I'm trying to accomplish is pretty close to that (Except in Drupal, and with all the visualizations via d3.js).

re: Integrated charts -- have you seen NDoiron's attempt at it? A demo is here. I'd think that's probably as close as one'd get to having charts directly within Sheetnode itself (That said, even that doesn't work super well -- it's kind of surprising there isn't any native graphing functionality in Socialcalc yet).

Your project looks great! Hope I can help in any capacity.

So what's your current plan of action for SocialCalc graphing? At the moment, I don't have much time to code but I can definitely spend some time orienting you or helping out with the architecture. Feel free to contact me privately.

Thanks!

Socialcalc doesn't appear to do images very well at all -- try pasting an image into a cell, for example. For this reason, I don't really see it being used as a layout engine in the same way that some old-school Excel people built forms. With that in mind, it might make as much sense to use Socialcalc as the data storage and manipulation faculty, with visualizations being handled through something separate -- though how to do that, I'm not sure.

Will drop you an email once I've mulled it over a little bit.

To whom it may concern: I'm a new maintainer, of both chart (mentioned in #2) and charts (often recommended as the successor of the chart module). Refer to my Comparison of charting modules for various charting modules available today ... And to #2368793: Chart 2.0 to get an idea of what I'm working on these days as it related to charting in Drupal.

Whatever direction this module ever takes regarding charting: try to NOT reinvent the wheel when it comes to charting in Drupal.

Thanks for commenting Pierre. I may look at this again in a few months. I would probably think that running it through Views would be good, but not 100% sure at the moment.