GetSex feature

GETSEX() Description

The GETSEX() function returns the gender attribute (male/female/undefined) by parsing first name, last name, and patronymic.

Names can be written in Ukrainian, English and Russian.

Main Features Functions GETSEX

Syntax:

=GETSEX(Name)

Parameters:

• Name: A cell with a person's name.

Example Usage

The GETSEX() function is easy to use. You just need to specify a cell with a person's name and LibreOffice Calc will automatically determine their gender:

=GETSEX(Name)

We will have the following result:

This example uses the following values:

• Name: A3 - A cell containing a person's name ("John Brown") .

Download the extension

You can use the GETSEX() function by installing the extension YLC_Utilities.oxt .

After that, this function will be available in all files that will be opened in LibreOffice Calc.