Javascript Spreadsheet Needed

Is there one available to work in PHP/MySQL?

[PaulPA]

I'd like to add a feature that would allow users to create and store a spreadsheet within a PHP/MySQL setup. I assume javascript would be the best option. Unfortunately, I can't seem to find anything, open source or commercial, that seems to work. Anyone have an idea on where to locate?

Not looking for an Excel converter, unless that is my only real option.

[DrDoc]

So, when you say "spreadsheet" -- what exactly do you mean?

[PaulPA]

Calculating rows and columns (i.e., Excel) with ability to allow for creation of charts/graphs from the data.

[DrDoc]

That would be a beast to get working in JavaScript.
How are you planning on generating the graphs?

[PaulPA]

Actually there are a few spreadsheet scripts available but I was hoping someone may offer suggestions on products I was not familar with. Maybe its just not available, though I wonder whether some scripts aimed at the Math area may generate graphs/charts.

[moltar]

Have a look at ActiveWidgets. It's not free, but it's really good.

[DrDoc]

Spreadsheet, yes ... but graphics and stuff?

[PaulPA]

moltar - Thanks but unfortunately, as they say in a response to a question on their website: "The grid is a data grid, not a spreadsheet. Any calculations that need to be done have to be programmed by you."

Really looking for a spreadsheet app. with graphing/charting capability. Looks like I may have to abandon this idea for now.

[DrDoc]

What kind of advanced calculations might you need?
And, how big of a spreadsheet do you need?

[PaulPA]

DrDoc - I appreciate your interest in this.

This is part of a bigger business planning tool so probably a max of 10 columns (screen size issue more than anything) and 25 rows. Calculations would be basic stuff (+,-,/,*) though my wish list would allow some level of formatting (bold, underline, decimal, currency).

My BIGGER WISH LIST would allow for some linking between multiple sheets so that a value changed in one sheet would change something in another.

And the BIGGER, BIGGER WISH LIST has the graphing/charting capability.

I realize it is probably a shot in the dark to find an existing product that is open source/free script. But can't even find a useful commercial product.

[RonPK]

Keep in mind that JavaScript does not let users save their sheet on their PC. Entered data and calculations are lost when the browser is closed. So you might want to have an option to store entered data on the server?

Why not use ordinary office software?

[bcolflesh]

The VisiCalc mastermind is working on this:

[softwaregarden.com...]

[Bernard Marx]

It is actually possible to save entered data, in IE at least, and without ActiveX involvement. I did something myself a few years back...can't remember now. It involves document designMode. If you switch to that then the document can simply be saved as normal.

[PaulPA]

I'm looking for users to create everything online rather than locally. In which case they would have a unique id in order to save the information they create. Certainly I would like for users to be able to save locally once created but this could be done with a download maybe as a cvs.

Looked at Bricklin's work and it looks promising. But I'm not sure I want to work with PERL since this would be part of a bigger application that is PHP. Also, currently no graph/chart option with Bricklin's work but that may be coming down the road.

[gsanroman]

Sounds like iRows.

[irows.com...]

[PaulPA]

While this look excellent it does appear to be a webhosted solution and not something I can stick on my site. I'll send them an email and see whether a stand alone version is forthcoming.

[PaulPA]

A rep from iRows says they are working on a stand-alone version that could be available soon. The current web-hosted product looks very nice and if they can deliver this as a stand-alone that would solve my needs. For anyone who has not seen this product I'd recommend taking a look.

gsanroman - thanks for the info on this product

[Rambo Tribble]

What about the PEAR::Spreadsheet_Excel_Writer described in this article, [sitepoint.com ]?

[PaulPA]

Is there a working demo on this?