Openoffice Basic String Functions

Actually, the speed of comparison is never an issue unless you are designing a high performance system. The following describes the basic use of procedures and functions in LibreOffice Basic. Date and time: Returns the serial number of a particular time. Dichiara il nome, parametri e il codice che definiscono un Function procedure. More details: Be aware that although both LibreOffice (LO) and Apache OpenOffice (AOO) is capable of reading all MS formats, the exportation of native. Thus if you have created your own library say, Library1, you need to load the library explicitly inside basic to identify the user defined functions. If I read the question and posts correctly the data is not sorted. The same applies to the locale settings for date, time and currency formats. LibreOffice Basic Macro Tutorial Index This page contains index of all LibreOffice tutorials, including Calc Macros using basic that has been posted in www. Use the statements and functions described here to perform date and time calculations. Welcome to FreeBASIC. A function in the DLL is called; it returns a string, which we then display in a cell of the worksheet. org Calc add-in I wrote that provides a basic set of spreadsheet functions for manipulating scientific measurements, tracking units of measure and significant figures. When you assign the number format “Number†to a date or time value, it is displayed as a number. To make it easier to accomplish this task, Calc includes a built-in formula called the SUM function. The maximum length of prompt is approximately 1024 characters, depending on the width of the characters used. NET uses different names for some numerical functions. The NetSpell project is a spell checking engine written entirely in managed C#. Searching through strings in StarBasic/OpenOffice BASIC Hi, What I would like to do is write a bit of StarBasic which returns the number of spaces (that is a ' ') in a parameter which is passed to the function. Visual Basic/Procedures and Functions. You can also use the StrComp function to compare strings; it defaults to performing case-sensitive comparisons. If you intend to perform further calculations with a number which has been replaced by text, you will need to convert it back to a number using the VALUE function. By using the SUM and OFFSET functions together, however, the range that is totaled becomes dynamic. org string, formula. Converts a hexadecimal number to decimal. How to enter string or text in OpenOffice Spreadsheet? Explanation. When we declare a variable of type String we are declaring a member of a data type called BSTR which stands for Basic String. Question: In Microsoft Excel, I want to know if a string value contains alphanumeric characters only. This book will show you: How to create custom Calc applications Creating worksheet functions, automating repetitive tasks, creating new toolbars, menus, and dialog boxes A complete guide to the IDE, language, and object model Integrating Calc applications with other components of OpenOffice. OpenOffice is an open source package of office applications like Writer (equivalent to MS word), Calc (equivalent to MS excel), Impress (equivalent to MS power point), etc. Aim - Given a request of the form `/Images/`, for e. In the new version OOo 2. NET é a nova versão do Visual Basic, que é parte integrante da plataforma Microsoft. The Visual Basic (VB) 6. bas file and then save this file and close the OpenOffice. 8 (prerelease) on Ubuntu while doing C programming. This means that the strings "a" and "A" are not considered to be the same. This is an Excel solution but my understanding is that Calc supports most Excel functions. Using Names in Formulas a blog post by Solvieg Haugland. But this isn't the case. My company uses Sybase ASE, but I can't figure out how to connect to the database with Visual Studio 2015 (Visual Basic). Built-in wizards guide you through choosing and using a comprehensive range of advanced features. This feature enables the spreadsheet user to create conditional statements where the results of a cell will be dependent upon the answer to another cell. Bing helps you turn information into action, making it faster and easier to go from searching to doing. cgi?component=Spreadsheet&ctype=atom&product=LibreOffice&query_format=advanced&resolution=---&title=Bug%20List. You can pass this method a file path to an SVG or SVGZ document for conversion to PDF. Formulas are expressions that take values from a range of cells or a single cell, and output a value. One powerful feature in Calc is the IF/ELSE statement. To load any library, use the built-in properties BasicLibraries. The default language setting on your computer affects the return value in the following way:. This command can, in theory, be used whenever you need to set any equation variable. The look and function of OpenOffice is quite similar to Microsoft, although there are differences, for example in the way you go about formatting word processing documents. In Apache OpenOffice Basic, you can use the Exit Sub and Exit Function commands to terminate a procedure or function prematurely, for example, for error handling. Get FreeBASIC. The trim operation stops when the first non white-space character is encountered at the end of the string. If you intend to perform further calculations with a number which has been replaced by text, you will need to convert it back to a number using the VALUE function. Like many other popular programming languages, strings in Python are arrays of bytes representing unicode characters. Here is an example of how you can Count the number of cells with specific cell color by using. Use the TEXT function to combine and format strings. File I/O Functions. To go a few steps further, the -accept switch specifies a Universal Network Objects string that lets you communicate with the running OpenOffice process via an API from a program written in C++, OpenOffice Basic, Python, Java, or other languages and pass input documents to your OpenOffice process using API calls. I assume you mistook the resulting "1" as a "boolean" result, whereas a failed search would result "0". If you look through the VBA code and OOo Basic code we've seen so far, you'll see that there are a number of obvious differences: There appear to be more lines This website uses cookies to ensure you get the best experience on our website. To get the most out of this book, you should be familiar with other programming languages. You should write : "print", CallByName oDoc, "print", vbMethod, arg 'arg is an array of arguments (cf MakePropertyValue) OOo Basic functions OOo Basic has some (usefull) integrated functions or instructions, that Visual Basic doesn't have (and the opposite is true, of course ! see the VB 6 replace - also usefull - function !). In this example, variable A is a string, and variable B is an integer. HEX2DEC(number) The HEX2DEC function syntax has the following arguments: Number Required. 79 KB Function CONTARCOLOR ( CeldaColor As String , RangoSuma As String ) As Double 'Ej CONTARCOLOR("B5";"E2:F42") '' No olvidar las comillas , el primer parametro es la celda donde esta el color, la segunda es el rango donde procesamos y contamos sus coincidencias. Chapter 1: OpenOffice. createInstance( "com. getByName(sName)) Else 'Did not request a new page so return the found page and then get out of the function. [Solved] OpenOffice Basic - validating strings (View topic) • Apache OpenOffice Community Forum. Basic arithmetic and statistic functions article by Bruce Byfield. [Partially Solved] Using system function from a form (View topic) • Apache OpenOffice Community Forum. Question: In Microsoft Excel, I want to know if a string value contains alphanumeric characters only. A little snag I have is that I can't figure out how to convert a number ($125. The default is the space character. Since all other strings don't contain "NY", that's the correct result for those cells. It is described in the chapter OpenOffice. https://bugzilla. You can use the InputBox function in Excel VBA to prompt the user to enter a value. Text2: The string expression that you want to search for. Extensive examples are provided to help you quickly develop your own OpenOffice. LibreOffice Calc (and OpenOffice. Get FreeBASIC. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor. Kısa süre önce yayınlanan 3. In those cells, numbers appear normally, but are aligned to the left like character strings. 05 KB dim Sheet1 as String. Error-Handling Functions. A font is characterized by various characteristics such as a name, a style and a size. org Basic IDE. Adding up rows or columns of numbers is one of the most common operations carried out in spreadsheet programs like OpenOffice Calc. AutoSUM is a shortcut provided for using the SUM function. Provides six functions to insert date or time or timestamp, as text / string or field / value, in Writer / Calc, Pre-formatted to user needs ( ISO8601 format, adjustable) with German locale strings, English format notation in source: just un-comment. If you look through the VBA code and OOo Basic code we've seen so far, you'll see that there are a number of obvious differences: There appear to be more lines This website uses cookies to ensure you get the best experience on our website. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor. Number cannot contain more than 10 characters (40 bits). 00) into text (One Hundred Dollars and 00/100). This extension will install a Basic library/modules with the BASIC macros. If after requesting the extension download does not start automatically the extension manager, locate the installation file on your hard drive ( BasicIDETools. Note: There aren't any handy dropdown lists in Filter windows so that you can select "Contains" or "Starts with". The strtod function takes two arguments: the first is the input string, and the second a pointer to the character which ends the conversion process. org they require a serial number, although you can simply type in the dates in date format without quotes. This is an experimental implementation of OpenOffice. VB developers may add this module to their Visual Basic applications and access the functions directly. Expression: Numeric expression that defines the ASCII code for the character. It is described in the chapter OpenOffice. Often we look to certain symbols in Excel that are hard to locate on the keyboard. NET uses different names for some numerical functions. The result of the function is always displayed as text. A simple C++ program Let's use the code below to find what makes up a very simple C++ program - one that simply prints "Hello World!" and stops. How do I write an IF function that tests if VLOOKUP returns #N/A? I've read somewhere that #N/A is just a text string, so I've obviously tried:. The StrComp function returns -1, 0, or 1 if the first string argument is less than, equal to, or greater than the second string argument. Using Functions and Creating Formulas This PDF is designed to be read onscreen, two pages at a time. getCellByPosition(col -1, row-1). Ask Question 2. 2 OpenOffice Macros Explained Table 2. In Apache OpenOffice Basic, you can use the Exit Sub and Exit Function commands to terminate a procedure or function prematurely, for example, for error handling. The most popular built-in VBA functions are listed below. charAt() function returns the character located at the specified index. In such cases we must usually revert to using the CHAR Excel function or the CODE Excel function. When used in its "QB" language mode, FreeBASIC provides a high level of support for programs written for QuickBASIC. developerWorks blogs allow community members to share thoughts and expertise on topics that matter to them, and engage in conversations with each other. A reference to a cell that contains an A1-style reference, an R1C1-style reference, a name defined as a reference, or a reference to a cell as a text string. Lets define a function which can be used from any macro to open a file picker dialog. I am trying to develop a paycheck printing program in OpenOffice. I'm indebted to OpenOffice. But it's pretty straightforward and like any technology you're new to, it takes a little time to adapt to. [Solved] String Function in CALC - how to?. Or if you don't use the function ARRAY, you can use String() arrays: Function test1 ( ByVal changeFrom. getByName(sName)) Else 'Did not request a new page so return the found page and then get out of the function. Normal precedence rules are used: Exponentiation, multiply and divide, add and subtract. But since it's not a given that a value always exists for my search parameter, sometimes VLOOKUP returns #N/A. Suppose you have two spreadsheets and you want to append data from one sheet to another. In-line spell checking is enabled, which checks only the useful area's (strings and comments in C code). Net How to Connect Access Database to VB. LEN returns the number of characters in a text string. clearContents(36) getDataArray. The CSTR function is a built-in function in Excel that is categorized as a Data Type Conversion Function. I know how to produce these results in LibreOffice Basic using regular expressions or via iterating character-by-character through the original string, but I'm wondering if there are any existing functions or helper utilities I can use, so I don't have to "re-invent the wheel". Watch Queue Queue. To load any library, use the built-in properties BasicLibraries. es team, which adds a new toolbar to OpenOffice Basic editor (IDE). 1 (dBase, flat file, and spreadsheet) dosn't support any SQL functions. The default is the space character. Server returns "" as a String if not set, thus we skip Server. On Pardus Linux you have to install the openoffice-python package. Though I'm not completely into it, i extended the parser to match some more VB. org Basic and the pages on OpenOffice. org Basic supports several runtime functions for string manipulation. Use the TEXT function to combine and format strings. The document tries to compare the different BASIC dialects offered by various pocket computers made by Casio, Sharp, HP, TI and other vendors. You can use strings to edit text within LibreOffice Basic programs. To declare a global variable in vba you first create a module then you declare all your variables as public. File I/O Functions. Since all other strings don't contain "NY", that's the correct result for those cells. Basic IDE Tools is an extension for Apache OpenOffice and OpenOffice. The following command lines shows what they’ll return when executed; $ cat /proc/version = "It returns a full string of information". basic mode is the default for computers without Excel for Windows. The trim operation stops when the first non white-space character is encountered at the end of the string. VB6 and OpenOffice scalc Problem saving sheet I have one remaing problem I can Open, Close and Write but cannot Save Page 1 of 1. 29 April 2014: The Apache OpenOffice project announces the official release of version 4. To have Mid function in works, put some strings in a column in LibreOffice calc and run the Mid function. Often we look to certain symbols in Excel that are hard to locate on the keyboard. 'basic' — Flag to request reading in basic mode character vector | string Flag to request reading in basic mode, specified as the character vector or a string, 'basic'. The Array functions operate on and return entire tables of data. Bluefish 1. Or if you don't use the function ARRAY, you can use String() arrays: Function test1 ( ByVal changeFrom. For example, you might want to display only part of a serial number on a form. The TEXT function converts a numeric value to text and combines numbers with text or symbols. OpenOffice is an open source package of office applications like Writer (equivalent to MS word), Calc (equivalent to MS excel), Impress (equivalent to MS power point), etc. A font is characterized by various characteristics such as a name, a style and a size. To load any library, use the built-in properties BasicLibraries. The Apache OpenOffice User Forum is an user to user help and discussion forum for exchanging information and tips with other users of Apache OpenOffice, the open source office suite. And I am writing macro's in OpenOffice BASIC. org Basic offers complete access to all OpenOffice. An attempt to share the knowledge & experience with the community. Question: In Microsoft Excel, I want to know if a string value contains alphanumeric characters only. One common task is to convert MS/Word documents (. More details: Be aware that although both LibreOffice (LO) and Apache OpenOffice (AOO) is capable of reading all MS formats, the exportation of native. does not have data. org "Measurements" is an Openoffice. 79 KB Function CONTARCOLOR ( CeldaColor As String , RangoSuma As String ) As Double 'Ej CONTARCOLOR("B5";"E2:F42") '' No olvidar las comillas , el primer parametro es la celda donde esta el color, la segunda es el rango donde procesamos y contamos sus coincidencias. Using Apache OpenOffice 4. You can also perform vlookup in Open Office Calc which gives you the same result that you get in Excel. If you’ve spent years building hundreds of Excel macros, the fear of losing them all could keep you locked in to Office. Choose File - Save and File - Exit to exit the VB editor. In ogni Sub o Function può essere chiamata un'altra Sub o Function Quando una macro viene eseguita. org contains Python and PyUNO, the requierements of the Numbertext extension, but some Linux distributions remove them to separated packages. Basic constants True True (Boolean) Empty Var. Macros en Basic para enviar correos con o sin adjuntos desde Apache OpenOffice. How do I write an IF function that tests if VLOOKUP returns #N/A? I've read somewhere that #N/A is just a text string, so I've obviously tried:. Routine tasks can therefore be automated in OpenOffice. 2 and earlier allows attackers to cause a denial of service (crash) and possibly execute arbitrary code via a TIFF file with a DocumentName tag that contains UTF-8 characters, which triggers the overflow when a character is sign extended to an integer that produces more digits than expected in an sprintf call. Use the following statements and functions to define the way LibreOffice Basic reacts to run-time errors. org Calc Basic」は、書きかけです。加筆・訂正など、協力いただける皆様の編集を心からお待ちしております。また、ご意見などがありましたら、お気軽にノートへどうぞ。. Hello all, my gears are grinding for some weeks now. When OpenOffice/ LibreOffice is initiated, not all the basic libraries are loaded to save time. org Basic offers complete access to all OpenOffice. We will learn about each method with help of small code examples for better understanding. This extension implements a AOO/LibO Basic library for Base applications. The Basic is embeddable with an option to compile your applications to a small footprint executable. org Calc documentation on the SEARCH function). Note: The COUNTIF function will not count cells based on cell background or font color. The syntax for the Nz function in MS Access is: Nz ( variant, [ value_if_null ] ) Parameters or Arguments variant. OpenOffice Basic is a programming language for automating OpenOffice that has many similarities to Microsoft's Visual Basic for Applications, which is used to automate Microsoft Office. You can define a Function procedure only at module level. Lcase("Visual Basic") =visual basic. We will be using a simple programming language called Visual Basic for Applications (VBA) and will be going through the steps, one at a time to allow you to construct the model without prior knowledge of VBA. Declares the name, parameters, and code that define a Function procedure. The NetSpell project is a spell checking engine written entirely in managed C#. Arrays must be declared before they are used. One powerful feature in Calc is the IF/ELSE statement. This article describes the formula syntax and usage of the HEX2DEC function in Microsoft Excel. ) is always used as placeholder for the decimal separator defined in your locale and will be replaced by the corresponding character. Formulas are expressions that take values from a range of cells or a single cell, and output a value. org Basic Programmer's Guide. While the markup macro described in the previous post does the trick of formatting Writer documents, it has one tiny drawback: it doesn't save the formatted text in a separate file, which can come in handy in many situations. OpenOffice is an open source package of office applications like Writer (equivalent to MS word), Calc (equivalent to MS excel), Impress (equivalent to MS power point), etc. The hexadecimal number you want to convert. The Cryptographic Hash Functions UNO Component for OpenOffice. The TEXT function converts a numeric value to text and combines numbers with text or symbols. The INDIRECT function syntax has the following arguments: Ref_text Required. delimiter (optional): A string of one or more characters length that is used to delimit the Text. Before attempting to write macros you should read First Steps with OpenOffice. org Basic での呼び出し形式: Sub insertNewByName( name As String, index As Integer). navigate directly to the functions from this page, or select a function category, to find a one line description of each function and explanatory notes on the category, or see a list of functions in alphabetic order. Right (MyString, Length). String End Function. The Database functions are used to extract information from Calc data tables, where data is organised in rows. It can be used as a VBA function (VBA) in Excel. to Long instead of Integer, the function will work reliably when the length of the Temp variable is extremely large. TIMEVALUE function. A string is an array of characters that ends with a null character \0. It helps people either to migrate their Access applications to Base OR to write macros as if it was MSAccess/VBA OR to write their first macros. This BASIC can be the choice for developers, who seek a BASIC variant that runs on UNIX as well as under Windows and Mac OS X (Intel). I now have. It's easy to use Excel for many of your day-to-day number-crunching tasks, like determining your business's average sale, computing classroom grades, or forecasting college expenses. Or the opposite – we look to find the Excel character codes for certain characters. raw download clone embed report print Openoffice BASIC 0. 1, creating a program to look at a rich text format file, and wherever there is a more than three spaces in the document between the last letter or period (. Written with a tutorial style, Beginning OpenOffice Calc is ideal for self-study, and aids problem solving as well. Function Ipv6SetBlock(ByVal ip As String, blockNbr As Integer, ByVal valHex As String) As String ' make valHex exactly 4 characters long valHex = Right( "0000" & valHex, 4 ). org they require a serial number, although you can simply type in the dates in date format without quotes. So my spreadsheet will call a basic function which calls c++ to get and parse the string. org Basic supports several runtime functions for string manipulation. helpfile: Optional. For example, even "+" is an operator defined in Microsoft. Some of the functions are explained briefly in the following: Asc returns the Unicode value of the first character of its string parameter. UPPER(string), LOWER(string), INITCAP(string) Returns string in all upper case, all lower case, first letter of each word capitalized, respectively. The Array functions operate on and return entire tables of data. Welcome to FreeBASIC. Use this handy Cheat Sheet to discover great functions and tips to help you get the most out of Excel. Todo: A type of character encoding is automatically determined with the operating system's default encoding. Macros OpenOffice. News, tips, partners, and perspectives for the Oracle Solaris operating system. Visual Basic/Procedures and Functions. A function is a predefined calculation entered in a cell to help to analyze or manipulate data in a spreadsheet. This works fine for macros and other functionality that you can trigger from a menu item or a button. So my spreadsheet will call a basic function which calls c++ to get and parse the string. createInstance( "com. Basic arithmetic and statistic functions article by Bruce Byfield. Server returns "" as a String if not set, thus we skip Server. Providing the Standard I/O parameter with the proper values permits interaction with the child process through the StderrRead() , StdinWrite() and StdoutRead() functions. Quite honestly, the way that I begin such a search is go to Google and enter "open source XXXX" where "XXXX" is the function that I'm looking for. "basic" is a depreciated default view that come with older Webtop, it should be replaced by "Default" which always exist. Date & Time functions. Value End Function OpenOffice 側でのセル値取得メソッド 文字列版 † Function getString(sh As Object, row, col) As String getString = sh. Get FreeBASIC. to treat as text to be. es team, which adds a new toolbar to OpenOffice Basic editor (IDE). Choose File - Save and File - Exit to exit the VB editor. The following describes the basic use of procedures and functions in LibreOffice Basic. In ogni Sub o Function può essere chiamata un'altra Sub o Function Quando una macro viene eseguita. These functions simplify help to create the formulas needed to get the expected results. org Basic, links can be made to other programs — for example to a database server — and complex activities can be performed at the press of a button by using predefined scripts. Use the following statements and functions to define the way LibreOffice Basic reacts to run-time errors. Number cannot contain more than 10 characters (40 bits). Ta uproszczona wersja Visual Basica służy przede wszystkim do automatyzacji pracy z dokumentami, na przykład poprzez makropolecenia. org Internet-based collaborative applications How to. When you assign the number format “Number†to a date or time value, it is displayed as a number. This works fine for macros and other functionality that you can trigger from a menu item or a button. Text2: The string expression that you want to search for. LoadLibrary. But when I negate it with Not(IsNumeric(value)), it converts the return value to a long or an int. Calc is the free spreadsheet program you've always needed. Trim (MyString). getByName(sName)) Else 'Did not request a new page so return the found page and then get out of the function. oxt ) and double click itself, or from the context menu, select Open With. org and found that it doesn’t support Visual Basic for Applications (VBA), the Microsoft Office macro language. Select a function name to go to a full description of the function with examples of use. It can take either Unicode and byte strings, convert it, and return converted string. Date and time: Returns the serial number of a particular time. First, let's add a basic IF/ELSE function to a Calc spreadsheet. In addition, the slightly more recent version of BASIC that we are using includes the INPUT statement. The VBA Enum is a equally valuable construct – allowing you to clean up your mess by grouping a collection of constants into a single object you can easily. Actu-ally, OpenOffice isn't overly interested in names and starts parsing at the first function it finds in the macro module. I need the right code to insert a checkbox in the sheet. The function convertFromURL(. The purpose of this article is to describe how to create an Excel workbook using solely DocumentFormat. The most popular built-in VBA functions are listed below. LibreOffice Calc (and OpenOffice. When used in its "QB" language mode, FreeBASIC provides a high level of support for programs written for QuickBASIC. If I read the question and posts correctly the data is not sorted. Developers coding in another programming language can also use the source code as a guide. raw download clone embed report print Openoffice BASIC 0. 5 GHz Intel i5. org functions, 12 OpenOffice. A reference to a cell that contains an A1-style reference, an R1C1-style reference, a name defined as a reference, or a reference to a cell as a text string. Len (MyString). The default is the space character. opening an OpenOffice, LibreOffice workbook, importing a text/csv file etc. org/download/index. freedesktop. org can also export to PDF). OpenOffice or LibreOffice ? OpenOffice and LibreOffice are the main open-source office suites, the opensource equivalent to Microsoft Office, to create text document, spreadsheets, presentations and drawings. The vlookup or Vertical Look Up Function in Openoffice calc can be used to search a range of cells. org Basic uses all of the normal loops and control structures that you can find in any programming language, along with a number that come directly from Visual Basic. Calc Functions Listed by Category from the OpenOffice. Visual Basic automatically calls a property's Get procedure when an expression requests the property's value. @@ -17795,7 +17789,7 @@ Handle case when string representation of timestamp contains - trailing ‘. NET uses different names for some numerical functions. org Internet-based collaborative applications How to. Actu-ally, OpenOffice isn’t overly interested in names and starts parsing at the first function it finds in the macro module. org functions, supports all. The Sub keyword designates a function, which is called Main in this case. But it's pretty straightforward and like any technology you're new to, it takes a little time to adapt to. to treat as text to be. For the date separator (/), time separator (:), and the AM/PM indicators (t and tt), the actual formatted output displayed by your system depends on the locale settings the code is using. However if you have specific needs you can also import them using the OpenOffice. Calc is the free spreadsheet program you've always needed. Use this handy Cheat Sheet to discover great functions and tips to help you get the most out of Excel. 26 KB Function composeNewURL ' CurURL. doc ) into PDF. You can also perform vlookup in Open Office Calc which gives you the same result that you get in Excel. To load any library, use the built-in properties BasicLibraries. org/download/index. Visual Basic. How can I distinguish a cell that it is blank or not while inside a user-defined function in Calc Basic? From Andrew Pitonyak's OpenOffice. It was first released back in 2000 by the original developers, Sun Microsystems, under the name of OpenOffice. New Topic/Question. Extensive examples are provided to help you quickly develop your own OpenOffice. For instance, upper/lower case doesn't matter for variable names or keywords (if/IF, sub/Sub, function/Function are equivalents), function braces are optional like Ruby and type-conversion happens automatically. There are occasional glitches, which is true of any software. Before attempting to write macros you should read First Steps with OpenOffice. org Basic では、返り値を伴うものを関数、返り値を伴わないものをサブルーチンとしています。. How can I distinguish a cell that it is blank or not while inside a user-defined function in Calc Basic? From Andrew Pitonyak's OpenOffice. org "Measurements" is an Openoffice. Here is an example of how you can Count the number of cells with specific cell color by using. LibreOffice Basic Macro Tutorial Index This page contains index of all LibreOffice tutorials, including Calc Macros using basic that has been posted in www. org and was based on StarOffice, which the company had purchased the previous year. More Information Microsoft Excel does not have the built-in functionality to access the computer's current user name. This video is unavailable. [Solved] Format function and dates (View topic) • Apache OpenOffice Community Forum. zip or BasicIDETools. Function Ipv6SetBlock(ByVal ip As String, blockNbr As Integer, ByVal valHex As String) As String ' make valHex exactly 4 characters long valHex = Right( "0000" & valHex, 4 ).