The function SNAKECASE() is designed to combine words using underscores, so it returns a single word, for example "snake_case_function".
Snake Case splits a string of words separated by spaces, hyphens, underscores, or case changes, then converts those words to lowercase and concatenates them with an underscore separator ("_").
The SNAKECASE() function can be useful in programming to convert variable names according to accepted code writing conventions
Here is the macro code to create a custom function that can convert text into individual words separated by underscores (Snake Case) in LibreOffice Calc.
Open the menu Tools - Macros - Edit Macros..., select Module1 and copy the following text into the module:
Function SnakeCase(ByVal str As String) As String Dim words As Variant Dim FCalc As Object FCalc = CreateUnoService("com.sun.star.sheet.FunctionAccess") str = Replace(str,"-"," ") str = Replace(str,"_"," ") str = FCalc.callFunction("TRIM", Array(str)) str = FCalc.callFunction("REGEX", Array(str,"([:lower:])([:upper:])","$1 $2","g")) str = LCase(str) words = Split(str, " ") SnakeCase = Join(words,"_") End Function
Then close Macro Editor, return to LibreOffice Calc and use our new function in any cell.
You can also use the SNAKECASE() function by setting the extension " YouLibreCalc.oxt ". After that, this function will be available in all files that will be opened in LibreOffice Calc.