Issue 110130

Calc does not show the title of the document in the page header/footer although
it is selected.

Try this:

(01) New spreadsheet document
(02) Select File | Properties... | Description
(03) Set Title to: I like OOo
(04) OK.  Save document as: MySheet.ods

(05) Select Format | Page... | Header | Edit...
(06) Click into left area
(07) Hold down the mouse over the title icon until the pull-down menu appears.
(see screenshot)
(08) From the pull-down menu choose: Title

(09) Click into center area
(10) Hold down the mouse over the title icon until the pull-down menu appears.
(11) From the pull-down menu choose: File name

(12) Click into right area
(13) Hold down the mouse over the title icon until the pull-down menu appears.
(14) From the pull-down menu choose: Path/File name

Result:
Left area shows: MySheet
Center area shows: MySheet.ods
Right area shows: file:///home/user/documents/MySheet.ods

Defect:
Left area should show: I like OOo


Notes:
AFAIR, in former versions of OOo the document title was shown in the title bar
of the document window, which is not the case any more. In younger versions of
OOo the title bar of the document window shows the filename instead. Don´t know,
if this has any relation to the issue.

Possibly related issue: #95320
Also possibly related:
http://api.openoffice.org/servlets/BrowseList?list=dev&by=thread&from=1893657
(complete new title API, that came with OOo 3.0)