Chapter 21 · 21.9
Notes and comments from Excel: what happens to them in Euro-Office
For a few years now, Excel has had two kinds of notes on a cell: notes (the old yellow sticky note) and comments (a conversation with replies). Euro-Office only has comments. If you work with colleagues or clients who use Excel, it helps to know what happens to their notes.
Example: the stock list of Bakkerij De Korenaar. In Excel, Lisa added a note to the flour stock ("new delivery ordered on 10 January") and Tom added one to the seeds ("order organic only").
What you see when you open the file
Open the spreadsheet in your WebOké Nextcloud. Cells with a note have a small orange triangle in the top right corner. Click the speech bubble in the left sidebar (1): the notes appear in the Comments panel, along with the cell (B3, A5) and the text. So Euro-Office shows a note from Excel as a comment. You can reply to it, edit it or resolve it, just like any other comment (see Commenting and mentioning someone).

What happens when you save
As soon as you change something in the file, Euro-Office saves it (see Saving: how automatic saving works). When it does, the notes are stored in the file as comments. We checked this in a saved file: the text of the notes is kept, but in the file they have become comments. What this means for your Excel colleagues:
- In a recent version of Excel, they see a comment (a conversation with replies) on those cells instead of the yellow sticky note.
- If they open the file in an older version of Excel, a line Author: or a name may appear above the text.
- The text itself is not lost.
Creating a note yourself?
You can't: Euro-Office only has comments. To add a new explanation to a cell, add a comment: right-click the cell and choose Add Comment. Want a fixed explanation that always appears when someone selects the cell, without a conversation around it? Then use an input message in Data Validation (see Data validation and drop-down lists), or add an extra column called Explanation.
Working with colleagues in Excel
- Agree that everyone uses comments and not notes. That way everyone sees the same thing, in Excel and in Euro-Office.
- Finished with the comments? Resolve or delete them before the file goes to a client (see Removing comments and changes before sending a document).
Pitfalls
- Author "Author": if a file comes from a program that doesn't add a name to the note, Euro-Office shows Author as the name above the comment. This isn't a colleague, just a default name.
