Join GitHub today
GitHub is home to over 28 million developers working together to host and review code, manage projects, and build software together.Sign up
EtherCalc is the spreadsheet equivalent of a wiki document, without logins and without editing locks. People can collaborate on a spreadsheet-like page simultaneously. It's somewhat a google sheet alternative, open source style.
Read french version here.
When or why would you use EtherCalc? Here are a few scenarios.
- Scheduling a meeting without asking via e-mails nor filling one-time forms: Every participant can see the most up-to-date availability of other members. One can update his/her schedule any number of times. The number of available participants in each time slot can be easily seen.
- Car pooling arrangement: Who will ride in whose car? How many seats are still available in each car?
- Students mutual-grading: What does each student think of each other's exercises or projects?
- A good communication tool between the Direction of Programs and the Studio in a radio station : the director writes the roadmap in a calc sheet and the technician at the studio can easily follow along and receive the latest modifications without any interaction needed (no required clicks, no required refresh).
As a spreadsheet, ethercalc accepts the following in a cell:
- mathematical formulae or other functions beginning with the equal sign
- date of the form (by default)
mm/dd/yyyywhere yyyy>=1900, e.g.
- texts beginning with the single quote character
For text cells, ethercalc supports the following formatting directives in its "default" formatting option:
the point is *collaboration*
the point is _collaboration_
can I -haz- cheezburger
it reads ``SOS``(backquote character)
- horizontal line:
--(two or more dashes at the very beginning of the cell's text)
- header text of various levels:
^^Section 4(one or more caret characters at the very beginning of the cell's text)
Leonard Nimoy as "Spock"<https://en.wikipedia.org/wiki/Spock>
For even richer formatting options such as color text/background, you can select a range of cells, switch to the format tab, and change format:text from "default" to "html". Then you can type html syntax such as
<span style="color:red; background:yellow">hello</span> in your cells. See e.g.: http://www.w3schools.com/html/html_formatting.asp
Tips and tricks
Use a cell value from another sheet.
Example, I have two sheets named sheet1 and sheet2 and I want to display cell A1's value from sheet1 in the sheet2's cell B3.
- Go to cell B3 in sheet2
- type this formula:
Color a cell depending of its value (aka Conditional Formating) .
Example, I want a cell B2 to turn green if its value is foo; or else to be red.
- Go to cell B2
- In the menu/format/format/text choose "HTML" and save for this cell
- Then type this formula:
=if(A1="foo","<span style=""background-color:rgb(81,184,72);color:rgb(81,184,72)"">_______</span>","<span style=""background-color:rgb(226,86,43);color:rgb(226,86,43)"">_______</span>")
So how does it work? Your IF function checks A1's value and gives you two possible output each of them being a simple text string made of underscores. The only subtility here is that we specify both pen color and background color to be the same (either green or red) so as it looks like the cell is filled either in red or in green. This is a workaround since there is no current straitforward function to set an empty cell's background color.
Create a form
Say you have a calc named
foo, which URL is https://calc.example.org/foo.
You can create a form by adding
/appeditor to your URL (which become https://calc.example.org/foo/appeditor).
You can add '/form' to show the form - e.g. https://calc.example.org/foo/form
You screen will be split in three parts. To the left, the form as it will be rendered, to the right, your calc, which will be used to create the form, and at the bottom, the results from the form.
To create an input field, go in a cell and write
=TEXTBOX("some text"). Note that you can't use
=TEXTBOX(""), you have to put the quotes, but the content can be blank.
Have a look at the other form possibilities by clicking on the "Fx" button on the spreadsheet, and selecting "Button & Input" section.
To create a submit button, go in a cell and write
=submit("send") (you can put any text you want).
To get the form link to share, click on the "Form" tab of your calc, then on the "Live form" button. It will redirect you to your form: you only have to share that page's URL.
To get the results of your form, add
_formdata/view at the end of your calc's URL (which become https://calc.example.org/foo_formdata/view).
Warning! It's easy to get the results page's URL or the original calc's URL from the form URL. Don't use it to get private datas!
Warning! (part 2) There's currently an issue with forms on Ethercalc: the input fields lose focus after each keystroke.
- Master Template https://calc.example.org/foo
- Form: https://calc.example.org/foo/form
- submitted data: https://calc.example.org/foo_formdata
- Master form view: https://calc.example.org/foo/app
You can export your calc in CSV or XLSX format by appending
.xlsx at the end of your calc's URL (https://calc.example.org/foo.csv).
Links to More Tips
Please also see the ethercalc Q&A for Stack Exchange Web Applications