You may want to start with something like this: http://www.activewidgets.com A lot of people in those forums have extended the functionality to be closer to a spreadsheet. -Jeff ----- Original Message ----- From: "Matthew Margolis" <mrmargolis-63mtpxcE9Cs@public.gmane.org> To: <rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org> Sent: Wednesday, July 13, 2005 3:52 PM Subject: [Rails] Spreadsheet on rails>I have a project that is focused around tabular data that needs to be >editable. The application will be replacing an excel spreadsheet and I am >hoping to emulate the format and functionality as much as is possible and >appropriate in a web application. > > The biggest issues I see with spreadsheet functionality are how the cells > are handled and how calculation takes place. > My client ideally would like to have a text cell that when clicked on > changes into a text field. I have no idea if the browsers will make this > easy but I was thinking of having a hidden div for each cell and on click > toggling between the visible text div and the hidden text field div. > Anyone know of any issues with this idea? Do you think it will break the > table? I only have to support firefox and IE6. > > For the calculation part I was thinking that ajax based field observers > would work great. Make a change in one of the observed fields and the > total or tax cell is updated automatically. The only problem I see here > is that I will be having several thousand cells on a page. Any ideas as > to what sort of stress a hundred observers will put on a browser? I am > not too worried about the server end as only two or three people will be > using the app at any one time. > > Has anyone already created a spreadsheet on rails? I would love to see > some examples if they are out there. > > > -Matthew Margolis > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails
On Jul 13, 2005, at 5:52 PM, Matthew Margolis wrote:> I have a project that is focused around tabular data that needs to be > editable. The application will be replacing an excel spreadsheet and > I am hoping to emulate the format and functionality as much as is > possible and appropriate in a web application. > > The biggest issues I see with spreadsheet functionality are how the > cells are handled and how calculation takes place. > My client ideally would like to have a text cell that when clicked on > changes into a text field. I have no idea if the browsers will make > this easy but I was thinking of having a hidden div for each cell and > on click toggling between the visible text div and the hidden text > field div. Anyone know of any issues with this idea? Do you think it > will break the table? I only have to support firefox and IE6. > > For the calculation part I was thinking that ajax based field > observers would work great. Make a change in one of the observed > fields and the total or tax cell is updated automatically. The only > problem I see here is that I will be having several thousand cells on > a page. Any ideas as to what sort of stress a hundred observers will > put on a browser? I am not too worried about the server end as only > two or three people will be using the app at any one time. > > Has anyone already created a spreadsheet on rails? I would love to > see some examples if they are out there. > > > -Matthew Margolis >Check out: http://numsum.com/ It''s pretty slick, and Rails. -Scott
TrimSpreadsheet is a nice, open-source JavaScript implementation, right down to the formulas: <http://trimpath.com/project/wiki/TrimSpreadsheet> It seems to come with more editable-ness built into it than ActiveWidget Grid does... but that might actually be a liability when it comes to integrating it with Rails. So, yay. On 7/13/05, Matthew Margolis <mrmargolis-63mtpxcE9Cs@public.gmane.org> wrote:> I have a project that is focused around tabular data that needs to be > editable. The application will be replacing an excel spreadsheet and I > am hoping to emulate the format and functionality as much as is possible > and appropriate in a web application. > > The biggest issues I see with spreadsheet functionality are how the > cells are handled and how calculation takes place. > > My client ideally would like to have a text cell that when clicked on > changes into a text field. I have no idea if the browsers will make > this easy but I was thinking of having a hidden div for each cell and on > click toggling between the visible text div and the hidden text field > div. Anyone know of any issues with this idea? Do you think it will > break the table? I only have to support firefox and IE6. > > For the calculation part I was thinking that ajax based field observers > would work great. Make a change in one of the observed fields and the > total or tax cell is updated automatically. The only problem I see here > is that I will be having several thousand cells on a page. Any ideas as > to what sort of stress a hundred observers will put on a browser? I am > not too worried about the server end as only two or three people will be > using the app at any one time. > > Has anyone already created a spreadsheet on rails? I would love to see > some examples if they are out there. > > > -Matthew Margolis > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-- ______________ Mike Sugarbaker Super Geiniuis
On Jul 13, 2005, at 11:00 PM, Scott Barron wrote:> Check out: http://numsum.com/ > > It''s pretty slick, and Rails.And be sure to visit http://tool-man.org/examples/edit-in-place.html for in-place editing. - Marten
I have a project that is focused around tabular data that needs to be editable. The application will be replacing an excel spreadsheet and I am hoping to emulate the format and functionality as much as is possible and appropriate in a web application. The biggest issues I see with spreadsheet functionality are how the cells are handled and how calculation takes place. My client ideally would like to have a text cell that when clicked on changes into a text field. I have no idea if the browsers will make this easy but I was thinking of having a hidden div for each cell and on click toggling between the visible text div and the hidden text field div. Anyone know of any issues with this idea? Do you think it will break the table? I only have to support firefox and IE6. For the calculation part I was thinking that ajax based field observers would work great. Make a change in one of the observed fields and the total or tax cell is updated automatically. The only problem I see here is that I will be having several thousand cells on a page. Any ideas as to what sort of stress a hundred observers will put on a browser? I am not too worried about the server end as only two or three people will be using the app at any one time. Has anyone already created a spreadsheet on rails? I would love to see some examples if they are out there. -Matthew Margolis
Marten Veldthuis wrote:> On Jul 13, 2005, at 11:00 PM, Scott Barron wrote: > >> Check out: http://numsum.com/ >> >> It''s pretty slick, and Rails. > > > And be sure to visit http://tool-man.org/examples/edit-in-place.html > for in-place editing. > > - Marten > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/railsSorry to dig this back up half a month later but I was wondering if anyone out there is using the in-place editing from the above link? My javascript isn''t the best in the world right now so I am having trouble getting this to work. If anyone has some examples of it beyond the ones at tool-man.org it would be really helpful to me to be able to see how you set things up. On the tool-man page there is so much going on that it is a tad hard to tell what actually has to do with the edit in-place and what is for dragging and what is just general layout CSS. Thank you, Matthew Margolis