Search code examples
stringvbalibreoffice-calclibreoffice-basic

Testing if first character of a string is non-numeric in LibreOffice Basic

I have column of strings mostly composed of numbers. Most of these strings are indeed 10 digit numbers formatted as string like :1234567890 except a few of them. Those exceptions start with a literal character with a letter to be specific like :A1234567890. What I want to do is while looping over that column I want to check on first characters and if it is a literal I want to branch my code. I'm not familiar with LibreOffice Basic yet VBA so any help is appreciated.

Solution

  • Listing 6.14. Display all data in a column in Andrew Pitonyak's Macro Document shows how to loop through all cells in a column.

    To find out if the cell's string is numeric, use the IsNumeric function:

    If IsNumeric(aCell.String) Then