Openoffice Basic String Functions

Openoffice Basic String Functions

Openoffice Basic String Functions

Sub DoFactorial Print " = " & RecursiveFactorial(4) Print " = " & IterativeFactorial(4) End Sub Function IterativeFactorial(ByVal n As Long) As Long Dim answer As Long answer = 1 Do While n > 1 answer = answer * n n = n - 1 Loop IterativeFactorial = answer End Function ' 1. The nested function acts as one of the main function's arguments. Syntax examples for COUNTIF(), counting cells that meet the specified criteria in the range B2:B35. 0 from Download Center. Some of these commands are based on the BASIC programming language. org Basic sin embargo el comodn "*" puede ser el ltimo carcter de un nombre de archivo o de una extensin, lo cual no es vlido en VBA. bas file and then save this file and close the OpenOffice. When using the COM DLL as a font encoder, the FontEncode function is used to convert the data to encode into a string, that when combined with the Data Matrix font, will create a correct barcode. delimiter As. This works fine for macros and other functionality that you can trigger from a menu item or a button. Author: Dmitri Popov Just because OpenOffice. Java+You, Download Today!. 0 these drivers will support the following functions. > We should complete helpfile with this information. To have Mid function in works, put some strings in a column in LibreOffice calc and run the Mid function. Character: Any single character used to build the return string, or any string of which only the first character will be. In Basic erhalte ich immer nur 40x die Null. So for keywords like "bold line" or "section" or "outline" a large line should be used. Search for jobs related to Openoffice programming basic or hire on the world's largest freelancing marketplace with 15m+ jobs. place – number of decimal places displayed. org Calc Basic」は、書きかけです。加筆・訂正など、協力いただける皆様の編集を心からお待ちしております。また、ご意見などがありましたら、お気軽にノートへどうぞ。. Breaking news from around the world Get the Bing + MSN extension. Note Functions whose names end with _ADD are provided for compatibility with Microsoft Excel functions. Java software for your computer, or the Java Runtime Environment, is also referred to as the Java Runtime, Runtime Environment, Runtime, JRE, Java Virtual Machine, Virtual Machine, Java VM, JVM, VM, Java plug-in, Java plugin, Java add-on or Java download. Now in the Calc program you can type the below function for converting Numbers to Words. raw download clone embed report print Openoffice BASIC 1. [Solved] Format function and dates (View topic) • Apache OpenOffice Community Forum. Visual Basic/VB6 Command Reference. Working with LibreOffice Basic. So for keywords like "bold line" or "section" or "outline" a large line should be used. If helpfile is provided, context must also be provided. Functions that return position values, such as STRPOS, encode those positions as INT64. Learn how to extend and customize Calc, the OpenOffice. Sorting the characters in a utf-16 string in java Difference between decryption and deciphering? How to break 信じようとしていただけかも知れない into separate parts?. 2) Use Tools > Macros > Organize Macros > OpenOffice. LENB returns the number of bytes used to represent the characters in a text string. Any affiliate commissions that we earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel. Character: Any single character used to build the return string, or any string of which only the first character will be. 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). 8, and (4) Netscape 7. 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:. When you create a new module, LibreOffice Basic automatically inserts a SUB called "Main". OpenOffice Basic is a Visual Basic compatible interpreter that originated in StarOffice office suite. OpenOffice. You can also perform vlookup in Open Office Calc which gives you the same result that you get in Excel. Public Function FindSeries(TRange As Range, MatchWith As String) dim i as long i= 1 Excel VBA conversion OpenOffice Basic. Last modified: Saturday, 31st December, 2016 @ 02:22pm. The Check Digit Calculator & Font Encoder with Visual Basic source code works with IDAutomation's barcode fonts to create a text string that will display an accurate barcode when combined with IDAutomation's fonts. Ho cercato di installare "numbertext" un'estensione di openoffice calc ma appena immetto come formula "numbertext" attraverso "funzioni" in calc e faccio riferimento come valore ad una cella che contiene un numero come risultato mi da "#valore". The following functions and statements validate and return strings. If you have national language support enabled, the arguments strings or returned strings can be strings or ustrings. In particular, this column should. You don't need to be a developer to create useful and powerful routines and applications. (Print this cover page separately. Character: Any single character used to build the return string, or any string of which only the first character will be. You can use any kind of files supported by OpenOffice as input, and can define the parameter -convert-to to any format supported by Open Office. org Basic to open the OpenOffice. createInstance( "com. context: Optional. STRING values must be well-formed UTF-8. Subtract Numbers in Spreadsheet. ScriptBasic has an open interface for module developers. Analysis ToolPak functions The function EFFECT provided by the Analysis ToolPak for Excel is converted to. The Basic is embeddable with an option to compile your applications to a small footprint executable. The following tables list Calc’s functions organized into eleven categories. LibreOffice Calc (and OpenOffice. Each function link provides a full description of the function, with examples of use and common errors. The following functions and statements validate and return strings. The first is a string containing the name of the worksheet [sheet] function to invoke. 80022846907377E-02 for example. I'm reading through the documentation on OpenOffice regarding arrays and it seems like Calc is capable of array functions just like Excel. Apache OpenOffice Basic recognizes but ignores this keyword, because this is already the default procedure in Apache OpenOffice Basic. SAS for the statistical functions. 1BestCsharp blog 7,424,935 views. Concatenation can be used to join strings from different sources including column values, literal strings, output from user defined functions or scalar sub queries etc. These functions also work in Google Sheets, LibreOffice Calc, which is the spreadsheet component of the LibreOffice software package, and Apache OpenOffice. c) in D-Bus (aka DBus) before 1. Here are some of the most common string methods. The concatenate function combines multiple cells, ranges or strings of data into one cell. How to create Spreadsheet file in OpenOffice? Explanation. place – number of decimal places displayed. 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. C++, Java, Python, CLI, OpenOffice Basic, JavaScript, OLE). To find the position of a substring in a string, use the FIND function. 1 fest OPTION EXPLICIT Legt fest, dass jede Variable explizit. org BASIC Programming Guide This guide provides an introduction to programming with OpenOffice. File I/O Functions. Array elements can also be homogeneous: Other arrays, objects, structures, strings, or any other data type can be used in LibreOffice Basic. CryptographicService") computes hashes (message digests) of text and files using following hashing algorithms: MD2, MD5, SHA-1, SHA-256, SHA-384 and SHA-512. It allows to use OpenOffice as service provider in other applications, extend it with new functionality or simply customize and. 0"; DestPath = "/afs/net. Description. org spreadsheet, using OOoBasic, OOo's built-in programming language. org Basic では、返り値を伴うものを関数、返り値を伴わないものをサブルーチンとしています。. Syntax: REPLACE(old_text, start_num, num_chars, new_text). このページ「OpenOffice. They return the. I would like to write a Basic function for Calc that return #VALUE! testable with ISERR(). This help section explains the most common runtime functions of LibreOffice Basic. Easily share your publications and get them in front of Issuu’s. org Basic offers complete access to all OpenOffice. Array elements can also be homogeneous, other arrays, objects, structures, strings, or any other data type used in the LibreOffice Basic. org Calc) is no exception. explain what a variable is, what "string" stands for or how to pass parameters to a function. , "-10+8i") are treated as strings, so the function needs to parse the arguments into real and imaginary parts, convert these parts to numbers, do the math, and then re-create the string (answer) to be returned. In many cases, using the ampersand operator is quicker and simpler than using CONCATENATE to create strings. FBeginner is a concise, hands-on beginner's guide to FreeBasic and is aimed at the novice programmer. Number cannot contain more than 10 characters (40 bits). The function is used to join or concatenate the two Java strings. El OpenOffice. How to subtract numbers in OpenOffice Spreadsheet? Explanation. NET programming tutorial, I'll be teaching you the basics of Strings, how to change string case, how to use Find and Replace, and how to create and split delimited. Pour ceux qui sont intéressés par plus de détails reportez- vous au chapitre " Passage de chaînes à une procédure DLL" de l'aide MSDN. 14159265358979 (Double) Nothing (objects) delete previous assignment. 0 introduces text to columns for Calc. org and other word processors. This introductory notice is intended to allow the user to understand the general principles and to learn some basic features of the OODoc module without browsing the whole reference manual. org has improved file locking support and has the ability to render graphics using anti-aliasing. Unlike standard macros which are installed in standard modules, Workbook Events are installed in ThisWorkBook in the following manner: Alt+F11 (Visual Basic Editor), Get into your project library (name of your workbook) with Ctrl+R (View, Project Explorer), under the name of your workbook you see Microsoft Excel Objects, then before Modules you see ThisWorkBook, doubleclick and paste the code. But when I negate it with Not(IsNumeric(value)), it converts the return value to a long or an int. However, if you are going to use them for extracting text from a string they can make things complicated. There are some situations when programming StarOffice is advantageous: You want to customize its behavior. As an Excel user, you may have looked at OpenOffice. Ask Question a direct function to extract the Open/Libre Office Basic from the sheet. lower() runs the lower() method on that string object and returns the result (this idea of a method running on an object is one of the basic ideas that make up Object Oriented Programming, OOP). 2 sürümüyle birlikte kullanım oranı iyice artan OpenOffice. OpenOffice is a free, open source office suite that is currently developed by The Apache Software Foundation. NET compiles and runs using the. The result of the function is always displayed as text. 21 KB ' the first function in a module regardless of its name, so Main feels like a ' good starting point. The first is a string containing the name of the worksheet [sheet] function to invoke. The result #VALUE! is the default result if the search failes (see the OpenOffice. 1 web browsers do not properly prevent a frame in one domain from injecting content into a frame that belongs to another domain, which facilitates web site spoofing and other attacks, aka the frame injection vulnerability. Macro Objective We are going to create a macro which would put the string 'Hello World' in the first cell of LibreOffice calc i. 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. Blog Meet the Public Q&A team. This help section explains the most common runtime functions of LibreOffice Basic. If helpfile is provided, context must also be provided. A method is like a function, but it runs "on" an object. Create Spreadsheet File in OpenOffice. Normal precedence rules are used: Exponentiation, multiply and divide, add and subtract. The most common way to store data in rows and columns is through "Spreadsheet". Make sure that any array variables are dimensioned before you access them. This default name has nothing to do with the order or the starting point of a LibreOffice Basic project. Issuu is a digital publishing platform that makes it simple to publish magazines, catalogs, newspapers, books, and more online. This introductory notice is intended to allow the user to understand the general principles and to learn some basic features of the OODoc module without browsing the whole reference manual. Note that some of the Excel text functions listed below are new to Excel 2013 or Excel 2016, so are not available in earlier versions of Excel. bas using the notepad's Save As function. raw download clone embed report print Openoffice BASIC 7. 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 !). I now have. String concatenation means to append one string to the end of another string. org Training, Tips, and Ideas Blogging by Solveig Haugland, author of the OpenOffice. Java+You, Download Today!. These functions also work in Google Sheets, LibreOffice Calc, which is the spreadsheet component of the LibreOffice software package, and Apache OpenOffice. [RESOLVED] Write to OpenOffice Calc Sheet I have been tring to get this to write to a template. org Calc) is no exception. org Basic supports several runtime functions for string manipulation. So, where is the table of unique strings located? It is in an "\xl\sharedStrings. 0"; DestPath = "/afs/net. Kemeny and Thomas E. Description. The following 3 are commonly used: The Format VBA function. Apache OpenOffice Base. then Open the Calc application then go to Tools > Macros > Organise Macros > OpenOffice. Step 3: Press the Enter key on. Functions ☞ General function syntax: Result = FunctionName(arguments)' String functions (Type String) Asc() Return the ASCII value (of 1st character) of. GLBasic is a commercial BASIC programming language that can compile to various platforms including Windows, Linux, Mac OS X, as well as some handheld devices. Chr returns a string containing the character that is specified by the ASCII or Unicode value passed to the function. Since all other strings don't contain "NY", that's the correct result for those cells. Expression: Numeric expression that defines the ASCII code for the character. SAS for the statistical functions. Spreadsheets - Sorting Strings and Numbers Openoffice is a free spreadsheet package. 0"; DefaultDestPath = "staroffice6. Sorting the characters in a utf-16 string in java Difference between decryption and deciphering? How to break 信じようとしていただけかも知れない into separate parts?. How to concatenate string in hyperlink function. The goal of the book is to create a solid foundation in the basics of programming in FreeBasic that the programmer can build and expand upon. I now have. This example shows various uses of the Format function to format values using both String formats and user-defined formats. Similar to the Array-problem above, boolean values are converted when they are returned to a cell formula. Instance Variables −. Sign up to view the full version. The topics in this section contain tables of the Visual Basic run-time member functions. org Basic Macros dialog (see Figure 7). If your number always appears at the beginning of a text string and is followed by at least one space, then: =VALUE(LEFT(A1,SEARCH(" ",A1)-1)) will extract the value from such a string in cell A1. Besides the four standard arithmetic operations, BASIC includes raising-to-the-power, the symbol of which is “^”. A function is a predefined calculation entered in a cell to help to analyze or manipulate data in a spreadsheet. In this example, variable A is a string, and variable B is an integer. Basic Source for all 2D fonts will be provided within that particular package in the "Integration\OpenOffice VB" folder. Functions ☞ General function syntax: Result = FunctionName(arguments)' String functions (Type String) Asc() Return the ASCII value (of 1st character) of. The most common way to store data in rows and columns is through "Spreadsheet". Visual Basic/VB6 Command Reference. Sorting the characters in a utf-16 string in java Difference between decryption and deciphering? How to break 信じようとしていただけかも知れない into separate parts?. 1 OpenOffice. Issuu is a digital publishing platform that makes it simple to publish magazines, catalogs, newspapers, books, and more online. org Basic is designed to automate mundane tasks doesn't mean that you must use it only for serious work. Use these functions for inserting, editing and manipulating dates and times. To replace all occurrences of a specified value, use the global (g. Any affiliate commissions that we earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel. org functions, 12 OpenOffice. Before it was possible to import delimited text (typically comma or tab delimited) into the spreadsheet through a file or a clipboard. dialogs and SimpleFileAccess service of module com. Apache OpenOffice Basic can be used by any Apache OpenOffice user without any additional programs or aids. : 2) String durchsuchen, bis zum ersten mal der gesuchte Wert auftritt. If I have > selected a single cell I can get to the formula via > ThisComponent. The custom function must include this interface both as an input and output argument. org openoffice-calc openoffice-basic or ask your own question. I'm sure I'm missing some basic documentation somewhere but I can't find it for the life of. I would like to add a column in my OpenOffice Calc spreadsheet. Using Functions and Creating Formulas This PDF is designed to be read onscreen, two pages at a time. The BasicIDETools extension allows with selected BASIC code (a word, a function, a module): · Format the code (keywords, function names, variables ) · Indent, de-indent, or re-indent everything automatically · Comment, uncomment or toggle comments · Convert to upper or lower case · Search forward or backward - NEW ASCII codes table. This means that the strings "a" and "A" are not considered to be the same. Macros: argument is not optional. In Excel some of the financial functions accept string parameters for dates; in OpenOffice. org Guidebook and owner of GetOpenOffice. I have looked for ways to use REGEX in queries in Base (internal database) and in Basic macros to do string replacements. Analysis ToolPak functions The function EFFECT provided by the Analysis ToolPak for Excel is converted to. org Basic program can contain dozens, hundreds, or even thousands of markers, which are names for variables, constants, functions, and so on. Visual Basic/VB6 Command Reference. Formulas are expressions that take values from a range of cells or a single cell, and output a value. It allows users to create spreadsheet files and formulas to perform calculations. Right (MyString, Length). raw download clone embed report print Openoffice BASIC 0. Error-Handling Functions. 0 from Download Center. Hi all, Trying to write these Basic macros is extremely frustrating. This works fine for macros and other functionality that you can trigger from a menu item or a button. 1BestCsharp blog 7,424,935 views. This extension uses the text from the clipboard of the operating system to read the selected text, and after processing, replace the selected text with the text processing. Open Office Calc BasicGuide_OOo3. The purpose of using OpenOffice. raw download clone embed report print Openoffice BASIC 1. Here is an example of how you can Count the number of cells with specific cell color by using. The inverse. explain what a variable is, what "string" stands for or how to pass parameters to a function. org Basic, OOo Basic. Private Type SHFILEOPSTRUCT hwnd As Long wFunc As Long pFrom As String pTo As String fFlags As Long fAnyOperationsAborted As Long hNameMappings As Long lpszProgressTitle As String End Type Private Const FO_DELETE As Long = &H3 Private Const FOF_ALLOWUNDO As Long = &H40 Private Declare Function SHFileOperation Lib "Shell32. File I/O Functions. Ask Question 3. As an Excel user, you may have looked at OpenOffice. OpenOffice Calc function return #VALUE. Public Function FindSeries(TRange As Range, MatchWith As String) dim i as long i= 1 Excel VBA conversion OpenOffice Basic. Function CELL_LINE (vSheet,lRowIndex&,iColIndex%,optional n) 'calls: getSheetCell REM Split by line breaks, missing or zero line number returns whole string. 45 KB 'Get HorizontalAlignment of SheetCell in open office basic Private Function GetHorizontalAlignment ( sheetCell As SheetCell ) As String. The arguments of this function is Mid(string, start position, length of the sub-string). To load any library, use the built-in properties BasicLibraries. The Basic format code will be interpreted and displayed according to your locale setting. How do I convert from a string to an integer? Here's what I tried: Price = CInt(Int(txtPrice. with no numbers following it. This example shows various uses of the Format function to format values using both String formats and user-defined formats. [Solved] Removing Characters using functions (View topic) • Apache OpenOffice Community Forum. 2) Constructs the string with count copies of character ch. raw download clone embed report print Openoffice BASIC 0. El OpenOffice. When you create a new module, LibreOffice Basic automatically inserts a SUB called "Main". To get detailed information about a function, click its name in the first column. Learn how to extend and customize Calc, the OpenOffice. Public Function FindSeries(TRange As Range, MatchWith As String) dim i as long i= 1 Excel VBA conversion OpenOffice Basic. Sorting the characters in a utf-16 string in java Difference between decryption and deciphering? How to break 信じようとしていただけかも知れない into separate parts?. raw download clone embed report print Openoffice BASIC 7. dll (namespace is DocumentFormat. 14 uses incorrect logic to validate a basic type, which allows remote attackers to spoof a signature via a crafted key. 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. 7, (3) Firefox 0. SuperBASIC is an advanced variant of the BASIC programming language with many structured programming additions. The IF Function. The following tables list Calc’s functions organized into eleven categories. SQL+Basic: problem with date (View topic) • Apache OpenOffice Community Forum. Visual Basic/VB6 Command Reference. Ask Question a direct function to extract the Open/Libre Office Basic from the sheet. 1 BASIC Guide · April 2009. For instance, doReplace uses the ubound function, which returns the highest index number for a array. Now in the Calc program you can type the below function for converting Numbers to Words. The AND, OR, and IF functions are some of Excel's better known logical functions that are commonly used together. Connection strings for Excel. org Basic provides the InStr function for searching for a partial string within another string: ResultString = InStr (MyString, SearchString) The SearchString parameter specifies the string to be searched for within MyString. Basic can send any kind of information to java (log, or result of method testing), and this will call the appropriate methods of the Runner. org, LibreOffice. First, let's add a basic IF/ELSE function to a Calc spreadsheet. OpenOfficeTips. Basic constants True True (Boolean) Empty Var. get char from. I'm reading through the documentation on OpenOffice regarding arrays and it seems like Calc is capable of array functions just like Excel. The Sub keyword designates a function, which is called Main in this case. I would like to add a column in my OpenOffice Calc spreadsheet. 109 Long time intervals and special dates 111 Conclusion 112 ix Chapter 6: String Routines 113 ASCII and Unicode values 114 Standard string functions 117 Substrings 119 Aligning strings with LSet and RSet 121 Fancy formatting with Format 122 Converting data to a string 125 Conclusion 126 Chapter 7: File Routines 127 Using URL notation to. es team, which adds a new toolbar to OpenOffice Basic editor (IDE). ) It is common to assign a macro to a keystroke or toolbar icon so that it can be quickly started. These commands stop the procedure or function and return the program to the point at which the procedure or function was called up. Parameters: n: Numeric expression that indicates the number of characters to return in the string. HOW TO USE THE DOCUMENTATION. If you want to avoid writing ESQL for this then you can ask XMLNSC to do it automatically. Syntax: REPLACE(old_text, start_num, num_chars, new_text). ) is always used as placeholder for the decimal separator defined in your locale and will be replaced by the corresponding character. The most common way to store data in rows and columns is through "Spreadsheet". When you assign the number format “Number†to a date or time value, it is displayed as a number. Output is a string that includes a con-stant part, "It is ", and the output of the Time() function, which gives us the time of day. C++, Java, Python, CLI, OpenOffice Basic, JavaScript, OLE). Right (MyString, Length). LEN returns the number of characters in a text string. In particular, this column should. OOo BASIC VB VB. 14159265358979 (Double) Nothing (objects) delete previous assignment. AND(), OR(), NOT()). Check Digit Calculator and Font Encoder. Some of these commands are based on the BASIC programming language. The Basic format code will be interpreted and displayed according to your locale setting. Function DocumentoAbiertoLocal( rutaynombredocumento As String ) ' Devuelve True si el documento está abierto por algún usuario local con OpenOffice ' Devuelve False si no lo está Dim oDesk As Object, oDocs As Object, oDoc As Object rutaynombredocumento = ConvertToURL(rutaynombredocumento) Set oDesk = CreateUNOService("com. spreadsheets have their own functions and a whole different approach to dynamic content anyway. es team, which adds a new toolbar to OpenOffice Basic editor (IDE). One powerful feature in Calc is the IF/ELSE statement. Choose File - Save and File - Exit to exit the VB editor. In Excel some of the financial functions accept string parameters for dates; in OpenOffice. I'm sure I'm missing some basic documentation somewhere but I can't find it for the life of. As it's very name suggests, Basic is a lenient programming language actually designed with ease of use in mind. NetSpell's suggestions for a misspelled word are generated using phonetic (sounds like) matching and ranked by a typographical (looks like) score. I need the right code to insert a checkbox in the sheet. Formula but I haven't been able to > find a way to evaluate that formula. org Basic の場合に限っていえば、UNO API に関してのみ大文字・小文字の区別が行われます。 次に、サブルーチンと関数の説明ですが、 OpenOffice. On a multi-core architecture control panel (with GUI updates) and logging do not affect the performance since they run in their own thread. 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. 7, (3) Firefox 0. Syntax: LEFT(text, [num_chars]). 21 KB ' the first function in a module regardless of its name, so Main feels like a ' good starting point. , object instantiation (obMake), method invocation (obCall), or result conversion (obGet)) in 4 seconds on a 2. The occurrence argument is used to specify which substring ought to be replaced. Working with LibreOffice Basic. For more in-depth information please refer to the OpenOffice. The default is the space character. To enter a string in the spreadsheet, first click on the cell where you want the string to be entered. Code: Public Sub ExportToOpenOffice() ConnectOpenOffice() Dim myDoc As Object, firstSheet As Object Dim fields As Object,. These functions also work in Google Sheets, LibreOffice Calc, which is the spreadsheet component of the LibreOffice software package, and Apache OpenOffice. 1 OpenOffice. Annoyance in readme "HERE is Edward Bear, coming downstairs now, bump, bump, bump, on the back of his head, behind Christopher Robin. 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. Besides the four standard arithmetic operations, BASIC includes raising-to-the-power, the symbol of which is “^”. Len (MyString). Introduction. Tips for using, transitioning, and more. , "-10+8i") are treated as strings, so the function needs to parse the arguments into real and imaginary parts, convert these parts to numbers, do the math, and then re-create the string (answer) to be returned. 1BestCsharp blog 7,424,935 views. However, if you are going to use them for extracting text from a string they can make things complicated. Strings are not objects so they do not have methods but there is a number of functions that manipulate strings. Lets define a function which can be used from any macro to open a file picker dialog. vlookup() searches for values in one column and given values in another column in true. This function is used fairly rarely, and basically returns -1, 0, or 1 based on the sort order comparison of two string values. org and was based on StarOffice, which the company had purchased the previous year. Basic Source for all 2D fonts will be provided within that particular package in the "Integration\OpenOffice VB" folder.