Inserting user first and last name into a cell in Calc

users
#1

I'm trying to find a way to insert a user's first and last name as defined
in the user date into a cell in a spreadsheet. Is there a function that
will let me do that?

Thanks.

#2

I'm actually referring to the first name and last name recorded in document
properties for LibreOffice. You can insert them in Writer by using the
appropriate fields. However, I can't find any sort of function that would
do the same thing for Calc.

#3

Did you try this:
https://ask.libreoffice.org/en/question/59798/macro-to-get-set-the-document-custom-properties/

#4

Hi John,

I'm trying to find a way to insert a user's first and last name as defined
in the user date into a cell in a spreadsheet. Is there a function that
will let me do that?

Probably with a macro that fetches that information :

https://forum.openoffice.org/en/forum/viewtopic.php?f=20&t=14750

which you would then have to insert into the cell in question via
another macro routine.

Alex