In basic, Date is a datatype used to store date and time values. You can use the calculated values of the path and name of file only by calling such a function inside your code.In this tutorial I will show how to do basic date processing in basic via LibreOffice CALC cells. Of course, calling such a function from a table cell will not bring much benefit - you just get True if the current document is saved or False otherwise. IsFileNameGood = (sFileName 'file name undefined') Function isFileNameGood(Optional ByRef sFileName As String, Optional ByRef sFilePath As String) As Boolean In this case the function (usually, but not necessarily!) returns a boolean value - whether the execution was successful. There is another way to return multiple values from a single function - you need to list all returned values as parameters by reference. You can write each of these functions in a formula in a cell and get the desired result. ' Returns file path excluding trailing separatorįilePath = aTemp(0) ' First element of arrayįileName = aTemp(1) ' Second element of array For example, Function FilePath() As String You can use this function in your other functions and procedures. You can enter in cell as an array formula and get in two adjacent cells two values returned by the function. SFilePath = Left( sTemp, Len( sTemp ) - Len( sFileName ) - 1 ) ' rest of URL-string is pathįilePathAndName = Array( sFilePath, sFileName ) ' pack both value to array and return it as function name SFileName = aTemp( Ubound(aTemp) ) ' last element of array is a part of string after last PathSeparator If sTemp = '' Then ' if document is new (not saved) then URL is empty stringĪTemp = Split( sTemp, GetPathSeparator() ) STemp = ConvertFromURL( ThisComponent.getUrl() ) ' get URL of current document ' The result is an array of two elements.ĭim sTemp As String ' temporary string variable - the URL of the current documentĭim aTemp As Variant ' temporary variable of the variant - later it will be an arrayĭim sFileName As String, sFilePath As String ' the purpose of these variables is clear from their names ' Returns file path excluding trailing separator and file name

Let’s look at a function that returns two values. This is just a different syntax, the meaning of the last line in the function is the same. In fact, the operator “return value” does the same thing - it assigns a “value” to the “function name”.

Libreoffice basic date functions