Sheets vs. Excel/Calc

Google Workspace

Chapter 5 · Sheets vs. Excel/Calc: Formulas That Mostly Transfer, Plus Live Collaboration on Data

The LibreOffice course's own Chapter 5 already covered formula syntax gotchas between Excel and Calc in real depth. This chapter won't repeat that ground — Sheets' formula syntax needs only a brief mention before pivoting to what's actually distinctive here: Chapters 2 through 4's collaboration concepts, now applied directly to spreadsheet data.

Formula Syntax: Comma-Separated, Just Like Excel

Sheets uses a comma as its function argument separator by default, matching Excel directly — unlike Calc, where the separator depends on locale settings (LibreOffice Chapter 5's own point). SUM, AVERAGE, IF, VLOOKUP, and XLOOKUP all exist under the same names, transferring with minimal friction. That's genuinely the extent of what's interesting on the syntax side — the real content of this chapter lies elsewhere.

The Real Point: Real-Time Collaboration on a Spreadsheet

Everything Chapter 2 described for Docs applies directly to Sheets: multiple people can edit different cells — or even the same cell — of the same spreadsheet simultaneously, each shown as a distinct, named, coloured cursor, live, exactly the same underlying mechanism as a shared Doc.

Cell-Level Attribution

A genuinely spreadsheet-specific detail: right-clicking or checking a specific cell's own edit history can show exactly who last changed that individual cell and when — a finer-grained version of Chapter 4's own whole-document version snapshots, now available at individual-cell resolution.

Simultaneous Formula Editing: What Happens to Dependent Cells

If one person changes a raw input value while another is actively viewing a formula elsewhere in the sheet that depends on it, that dependent formula recalculates live for both people at once — the same real-time merge behaviour Chapter 2 described for shared text, just applied here to a calculation dependency chain instead of a paragraph.

Comments and Suggesting Mode Apply Here Too

Chapter 3's Comments work identically in Sheets — attached to a specific cell rather than a text selection, but otherwise the same discussion-without-editing concept. Cell values themselves don't get quite the same underline/strikethrough "Suggesting" treatment Docs applies to flowing text, for a sensible structural reason: a cell holds one discrete value, not a sequence of characters that can be partially struck through and partially underlined the way a sentence can.

	Excel	Calc	Sheets
Argument separator	Comma	Comma or semicolon, by locale	Always comma
Live, simultaneous multi-person editing	Co-authoring exists, added later	Not a core design assumption	Built in from the start (Chapter 1's own architecture)
Cell-level "who edited this" attribution	Not a standard feature	Not a standard feature	Available per cell
Comments attached to a cell	Yes	Yes	Yes — same underlying concept

This chapter deliberately isn't a syntax tour

LibreOffice Chapter 5 already gave formula-syntax gotchas their proper depth. The genuine value of this chapter is confirming that Chapters 2 through 4's collaboration concepts — live cursors, comments, version history — hold up identically when applied to numeric, formula-driven data, not just flowing text.

Two people editing the exact same cell doesn't merge character-by-character the way shared text does

Chapter 2 described two people typing in the same paragraph merging both sets of keystrokes automatically. A single spreadsheet cell is a single atomic value, not a flowing sequence of characters — if two people genuinely edit the exact same cell at the exact same moment, Sheets resolves this by having one edit take effect (typically whichever registers last), rather than interleaving both people's input the way text in a Doc can be. This is a sensible consequence of what a cell actually is, not a bug — but it's worth knowing this differs from Chapter 2's own text-merging behaviour before assuming cell edits always combine the same way.

Hands-On Exercises

Exercise 1

Share a Sheet with a second account. Have one person edit a raw number in one cell while the other is actively viewing a formula elsewhere that depends on it. Describe exactly what the second person sees happen to the formula's displayed result.

📄 View solution

Exercise 2

Two people type genuinely different values into the exact same cell at the exact same moment. Explain what you'd expect to happen to that cell's final value, and why this differs from how two people typing in the same paragraph of a shared Doc would behave, per Chapter 2.

📄 View solution

Exercise 3

A colleague coming from LibreOffice Calc asks whether they need to worry about the argument-separator issue from LibreOffice Chapter 5 when writing formulas in Sheets. Explain why this concern doesn't apply here, and identify the one separator character Sheets always uses.

📄 View solution

Chapter 5 Quick Reference

Sheets' formulas use a comma separator always — no locale-dependent semicolon question, unlike Calc
Common function names (SUM, IF, VLOOKUP, XLOOKUP) transfer with minimal friction
Live, simultaneous multi-person editing (Chapter 2) applies directly — different cells, or even the same cell
Cell-level attribution shows who last edited a specific cell — finer-grained than Chapter 4's own version snapshots
A formula recalculates live for everyone the instant its own inputs change, anywhere in the sheet
Two people editing the exact same cell at once resolves to one winning edit — cells don't merge character-by-character the way shared text does