Ask Your Question

How to insert the document title in a cell in a Calc Spreadsheet?

asked 2015-01-23 20:37:35 +0100

Pablo gravatar image


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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-01-23 22:01:30 +0100

erAck gravatar image

While editing a cell right mouse click in the cell (! not in the input line) and from the context menu choose Insert Fields... Title.

edit flag offensive delete link more


Thanks for the tip.

m.a.riosv gravatar imagem.a.riosv ( 2015-01-23 23:04:52 +0100 )edit

Thanks for your answer, it worked perfectly.

Pablo gravatar imagePablo ( 2015-01-25 19:32:10 +0100 )edit

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?

caolin gravatar imagecaolin ( 2017-05-11 20:42:52 +0100 )edit

Works for me Version: (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

m.a.riosv gravatar imagem.a.riosv ( 2017-05-11 23:55:28 +0100 )edit

@caolin 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.

erAck gravatar imageerAck ( 2017-05-13 15:49:59 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-01-23 20:37:35 +0100

Seen: 1,409 times

Last updated: Jan 23 '15