Home

EtherCalc wiki

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.

Use Cases

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?
• ...

Syntax

As a spreadsheet, ethercalc accepts the following in a cell:

• mathematical formulae or other functions beginning with the equal sign =, e.g. =sqrt(3)/2, =if(1+1<0, 'surprise!', 'ok'), ...
• date of the form (by default) mm/dd/yyyy where yyyy>=1900, e.g. 12/25/2016
• texts beginning with the single quote character ', e.g. 'hello world

For text cells, ethercalc supports a rich set of formatting directives even in its default formatting option, including:

• bold: the point is *collaboration*
• italic: the point is _collaboration_
• strikethrough: can I -haz- cheezburger
• teletype: 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)
• hyperlink: Leonard Nimoy as "Spock"<https://en.wikipedia.org/wiki/Spock>

For more advanced editing, please see the parser, which is modeled after Socialtext Syntax.

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.

1. Go to cell B3 in sheet2
2. type this formula:="sheet1"!A1

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.

1. Go to cell B2
2. In the menu/format/format/text choose "HTML" and save for this cell
3. 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.

You can use any html formatting! See e.g.: http://www.w3schools.com/html/html_formatting.asp