Hello,
I have a Calc spreadsheet where I need to use the document title (the one set via the File->Properties dialog) in several places. I was wandering if there is any way to do that (similar to Writer’s Insert Field (title) option). I searched on the web for a suitable method but couldn’t find any.
In this way I can, for example, use the same text in multiple cells, as well as for headers/footers.
Thanks in advance.
While editing a cell right mouse click in the cell (! not in the input line) and from the context menu choose Insert Fields… Title.
Thanks for the tip.
Thanks for your answer, it worked perfectly.
I tried this with LibreOffice 5.3 and there was no Insert Fields entry in the context menu nor did Insert… lead anywhere useful. Is this changed or gone?
Works for me
Version: 5.3.3.2 (x64)
Build ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448
CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Layout Engine: new;
Locale: es-ES (es_ES); Calc: group
@jgossage You probably tried in the input line, not in the cell, or on the cell without being in edit mode. Use the context menu in the cell while editing it.