News for hackers. Stuff that matters.
Re:Ethersheet – An open-source collaborative spreadsheet by binarymax on Monday October 13, 2014 @04:48PM (#8450579)
Looks like a great start! First thing that comes to mind - let arrow keys move the focus to the adjacent cells. Without this it is a huge usability loss.
Re:Ethersheet – An open-source collaborative spreadsheet by based2 on Monday October 13, 2014 @03:57PM (#8450271)
Re:Ethersheet – An open-source collaborative spreadsheet by cooperq on Monday October 13, 2014 @03:59PM (#8450279)
Interesting, it looks like it's based of ethercalc which is also a great project. We were trying to go in a different direction though and be a little bit more user friendly and also work on mobile.
Re:Ethersheet – An open-source collaborative spreadsheet by newscracker on Monday October 13, 2014 @11:52PM (#8451903)
I gave it a quick spin and it seems like it needs more work to behave like a spreadsheet.

Even simple circular references are not detected right now. For example, I put some numbers from A1 through A5 and then put a SUM(A1:A6) into A6. It added everything up (including the sum itself) and keeps updating A6 with the sum of A1:A5 every time I move from one cell to another using Enter or Tab. You can see this at https://ethersheet.org/s/IsThisAwesomeNow

And also, as @binarymax stated, arrow keys to navigate (along with F2 to edit a cell instead of the default of putting a cell in edit mode), usage of arrow keys within formulas to get cell references (instead of typing the cell reference), easy ways to format cells, easy way to extend the width or height of columns/rows...I presume there's a large backlog of features to implement. :)

Right now, this is far behind EtherCalc in terms of features and usability.

Re:Ethersheet – An open-source collaborative spreadsheet by fiatjaf on Monday October 13, 2014 @07:47PM (#8451252)
I was looking for a spreadsheet which I could use to implement custom formulas that would interact with a client-side app, and embed the sheets in the app also, so I started building this: https://github.com/fiatjaf/react-microspreadsheet

Here's a hosted version for test: http://sheets.alhur.es/test

It has a lot of features (try the edge cases if you feel like and report your experience to me, please), but it also has some bugs with, for example, the click-at-a-cell-to-add-it-as-input-to-the-currently-being-edited-cell. I'm seeking to make this work.

There are some bugs with the formula parsing too, but they are easy to solve, I'm just being lazy. I was using a very nasty raw regex parsing, but I switched to a Jison implementation that is more reliable, I guess. I've never done this before, though.

Re:Ethersheet – An open-source collaborative spreadsheet by eddyparkinson on Tuesday October 14, 2014 @07:26PM (#8456403)
I wish I had your design skills.

My spreadsheet sideproject: www.cellmaster.com.au

Small business wants to automate. At the moment they use spreadsheets, email and web forms to interact with customers, but want these to work together. I have seen 20 requests a week, on a single forum, for small bits of code. Code to do very simple automation tasks. I am making it so they can automate with only basic spreadsheet skills.

Happy to chat with you eddyparkinson after the at add gmail dot com

Re:Ethersheet – An open-source collaborative spreadsheet by dryman on Monday October 13, 2014 @05:58PM (#8450911)
Looks pretty similar to ethercalc... https://ethercalc.org
Re:Ethersheet – An open-source collaborative spreadsheet by spoomor on Tuesday October 14, 2014 @03:29AM (#8452319)
Like ethercalc, you can use any URL, even non-secret ones like: https://ethersheet.org/s/1
Re:Ethersheet – An open-source collaborative spreadsheet by u124556 on Monday October 13, 2014 @05:52PM (#8450882)
I love that it's anonymous. It would be cool if it had a read only version (using a random url) to share. Like piratepad (etherpad) has.
Re:Ethersheet – An open-source collaborative spreadsheet by tedsuo on Monday October 13, 2014 @05:27PM (#8450775)
It doesn't currently mention this on the site, but one use case for Ethersheet is to embed it as a component in a larger application.
Re:Ethersheet – An open-source collaborative spreadsheet by sequoia on Monday October 13, 2014 @03:59PM (#8450280)
How do you get a sum of a range of cells?
Re:Ethersheet – An open-source collaborative spreadsheet by cooperq on Monday October 13, 2014 @04:01PM (#8450302)
The same way as you would in excel `=SUM(A1:A11)`
Re:Ethersheet – An open-source collaborative spreadsheet by ilaksh on Monday October 13, 2014 @05:42PM (#8450838)
How is this better than ethercalc?
Re:Ethersheet – An open-source collaborative spreadsheet by beefman on Monday October 13, 2014 @06:14PM (#8450967)
It sure seems lighter/faster. Other differences:

* It doesn't support drag to enter ranges in formulas

* Arrow keys don't move the selection

* It doesn't have nifty pie menus for dragging a selection

* It doesn't support ctrl+z undo

Does EtherCalc have multiple worksheets? Ethersheet does.

EtherCalc's tabs-and-forms UI is clunky.

Re:Ethersheet – An open-source collaborative spreadsheet by cooperq on Monday October 13, 2014 @07:08PM (#8451157)
The undo functionality is actually almost there, I think we just don't have an interface for it. The arrow keys thing should be easy to implement. I will add it to github, and of course accept a pull request! We definitely need to accept ranges for formulas or some up with some easy way to do that.

The project as a whole is definitely unfinished but we have been working on it for so long and lost some motivation. I wanted to just get it out there to at least re-motivate myself to work on it.

Re:Ethersheet – An open-source collaborative spreadsheet by beefman on Tuesday October 14, 2014 @12:44AM (#8452006)
Please note, I don't think all the features I listed are desirable. (Pie menus for dragging gestures? Pretty hokey.)

Ethersheet allows typing ranges in formulas and that is possibly enough. Dragging to choose a range can be nice but it has to be implemented carefully. When to stop acquiring cells for the range and return focus to the formula editor? Some versions of Excel do this badly. For example, after dragging to enter a range you use arrow keys to balance parens. Excel thinks you are still selecting cells and inserts multiple ranges into your formula.

Re:Ethersheet – An open-source collaborative spreadsheet by audreyt on Tuesday October 14, 2014 @03:13AM (#8452288)
EtherSheet's UI for worksheets and column/row label context menus are both nice ideas — I'll work on integrating them into EtherCalc. :-)
Re:Ethersheet – An open-source collaborative spreadsheet by antman on Tuesday October 14, 2014 @03:24AM (#8452309)
Dragging the selected region works only for the last selected cell, not for all your selection. If you put 1 2 3 , select them all together and drag it becomes 1 1 1 1 1 not 1 2 3 4 5
Re:Ethersheet – An open-source collaborative spreadsheet by genericacct on Monday October 13, 2014 @07:11PM (#8451160)
With 143 forks you can be sure at least some of them support multiple sheets :)
Re:Ethersheet – An open-source collaborative spreadsheet by greggawatt on Monday October 13, 2014 @05:14PM (#8450718)
EtherSheet Got Me Laid!
Re:Ethersheet – An open-source collaborative spreadsheet by sitkack on Monday October 13, 2014 @06:14PM (#8450968)
EtherSheet Got Me Paid!
Re:Ethersheet – An open-source collaborative spreadsheet by tesladethray on Monday October 13, 2014 @04:01PM (#8450305)
I love spreadsheets. So much so that I even mentioned Excel in dating profiles. But Excel is expensive, OpenOffice slow and buggy, and Google is... well, Google. Ethersheet is a fast, effective, and reliable alternative to get your spreadsheeting done. I love spreadsheets and so I love Ethersheet. If you're like me, you will, too.
Re:Ethersheet – An open-source collaborative spreadsheet by monstermonster on Monday October 13, 2014 @06:16PM (#8450981)
This post reminds me of http://www.zombo.com/

FYI you can rent Excel, Outlook, Word, Powerpoint, OneNote, Access and publisher for three beers a month at London prices. That's pretty cheap and it works online and offline.

Agree with OpenOffice though.

Re:Ethersheet – An open-source collaborative spreadsheet by cooperq on Monday October 13, 2014 @04:04PM (#8450319)
I swear this person was not coached in any way ... :)