Thanks for the feedback and interest. It'll push me to keep exploring it further. A couple easy enhancements:
1. Add a formula bar (like Excel) and a toggle to turn the formula on/off for the cell. This will allow there to only be one grid. 2. Ability to paste in a text string and have it automatically create a grid. Basically this will let you copy/paste from emails or Excel 3. Make it easier to enter text columns. For example you can enter 'Price: in one of the columns (notice the single quote) otherwise it strips it out 4. Read/Write to a file Then I have the wishlist: 5. Plotting support 6. More intuitive cell references (to your point). For example A_ could refer to the first column, A1 the first cell. A1_A20 for a range... Need more thinking here I'd also like to create some example spreadsheets that show off some of the capabilities of J's formulas On Tue, Feb 25, 2014 at 4:23 PM, Brian Schott <[email protected]>wrote: > Yes, Joe and Raul, > > I am better understanding how to make the webspread work. I was exploring > ideas for writing formulae that did not require so much curtailing within > the summation, or in other "insert" style, formulae, for example. But I > don't suppose there is an easy solution. > > But, Joe, your spreadsheet demo is very informative regarding JHS > programming, and uncovers how difficult it would be to develop such a > spreadsheet in J that was easy to use. > > I got lost in the weeds trying to think about that and lost the beauty of > your concoction in being able to maintain the formula in a cell while show > the formula result in the output area. That is quite an accomplishment. > > > > On Tue, Feb 25, 2014 at 4:01 PM, Joe Bogner <[email protected]> wrote: > > > Hi Brian, I'm happy to see you playing around with webspread. > > > > I'm not sure I understand what you're looking for. > > > > Given: > > > > r_webspread_ > > ┌─┬──┬──┐ > > │1│13│14│ > > ├─┼──┼──┤ > > │2│2 │4 │ > > └─┴──┴──┘ > > > > I usually have column totals or row totals as the last row/column. So an > > easy trick is to just curtail the array: > > > > But you need to have a blank cell first to put the result in... > > > > r_webspread_ > > ┌─┬──┬──┬──┐ > > │1│13│14│28│ > > ├─┼──┼──┼──┤ > > │2│2 │4 │ │ > > └─┴──┴──┴──┘ > > > > > > This is what the spreadsheet text looks like: > > > > 1 13 14 +/ (> }: 0{::r) > > 2 2 4 > > > > Does that help address your question? > > > > > > > > -- > (B=) > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
