Prob_range Required. org Basic of the Developer's Guide. The INDIRECT function syntax has the following arguments: Ref_text Required. Fast: Gnumeric starts up quickly and handles large spreadsheets while remaining responsive. Data -> Consolidate provides a graphical interface for copying data from one range of cells to another, then running one of a dozen functions on the data. You can use it as a flowchart maker, network diagram software, to create UML online, as an ER diagram tool, to design database schema, to build BPMN online, as a circuit diagram maker, and more. A few basic functions are also represented by symbols. The video shows multiple ways of entering and working with functions. The data will be transmitted to third-party payment platform. Function Description. Macro: OpenOffice. This book starts by giving an overview of the language and its structure, before detailing the various commands and functions that are available in OpenOffice. Free office suite, open source, and compatible with. getByName("Module1") I can get the BASIC code that I'm interested in, and then I can search it with instr, but I was hoping for a way to have LO parse the BASIC and tell me if a given, named module exists. This function can be used to replace both characters and numbers (which are automatically converted to text). When I want to know about a specific issue, I usually search the Developers Guide, the tutorial, and then finally a google search. I have solved many problems using Base and I add them to this document as I solve them and as I have time to add them. From - Can I use an UDT as a parameter type into a basic sub or function? example:. " When I double click on the file I get a box pop up that informs me "There is no application installed for this file type". The PROB function syntax has the following arguments: X_range Required. IF you are in a OpenOffice program, click File > New > Spreadsheet. This will automatically add the code into the editor window. Download Openoffice from here. The Database functions are used to extract information from Calc data tables, where data is organised in rows. How to create a 3D Terrain with Google Maps and height maps in Photoshop - 3D Map Generator Terrain - Duration: 20:32. OpenOffice does provide basic bibliographic functions, these include; a simple bibliographic database, a process to insert in-text or endnote citations into a document and a bibliographic table generator to produce a reference table of citations formatted as specified by the user. The accountant would spread information like costs, payments, taxes,. Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and. See Section 11. Where VB functions are placed in OpenOffice Calc. To undo or redo an action, at the top, click Undo or Redo. Macros can be effective in saving time, increasing efficiency, and improving productivity in. To select a word, double-click it or use your cursor to select the text you want to change. I'm using OpenOffice Calc. org Basic programming language can be divided into four components: The language of OpenOffice. I need the right code to insert a checkbox in the sheet. org Basic の場合に限っていえば、UNO API に関してのみ大文字・小文字の区別が行われます。 次に、サブルーチンと関数の説明ですが、 OpenOffice. Any affiliate commissions that we earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel. MBASIC is a descendant of the original Altair BASIC interpreters that were among Microsoft's first products. An entry point of a Kotlin application is the main function. org Cursor". The AutoFill is used with filling the function throughout the worksheet. The official catalog of Apache OpenOffice templates. org, Spreadsheets, StarOffice | Permalink Comments I've found this useful and picked up a few other tips whilst I was here but I can't get the conditional formatting to work for text in cells. The term spreadsheet was derived from a large piece of paper that accountants used for business finances. Average, Sum and Charts. MICHEL THOMAS ITALIAN (BASIC) COURSE, 8 CDs. VBA : The method for passing parameters to procedures and functions in OpenOffice. lebenslauf vorlage openoffice kostenlos. org Basic, Python, Beanshell, and Javascript, this feature is more widely known as using Macros. You'll find templates ranging from letters and résumés to calendars and brochures. How to Create an OpenOffice Macro. SUMPRODUCT, FREQUENCY and TRANSPOSE are explored. Get FreeBASIC. org/download/index. If an item contains a date, the value must be expressed as a serial number or populated by using the DATE function so that the value will be retained if the worksheet is opened in a different locale. In September of 2010, some of the core developers of OpenOffice. Synonym's The Classroom covers more than just homework and study tips. For some reason I feel there should be some simple way to call a python script from basic macro. When applying for certain sorts of positions in america, and for many international educational and employment opportunities, you will require a curriculum vitae, commonly considered a CV. There are a few key items to create a Base document. This is useful for verifying that a specific macro continues to function in the current OOo version. If the SUM function were used on its own to total the data, it would be necessary to modify the range of cells used as the function's argument each time new data was added. When used in its "QB" language mode, FreeBASIC provides a high level of support for programs written for QuickBASIC. Generate barcodes in OpenOffice without installing additional fonts or other components. DEF FN—a pair of keywords introduced in the early 1960s to define functions. org (OOo), commonly known as OpenOffice, is a discontinued open-source office suite. This article is devoted to the types of data used in LibreOffice Basic, and to a greater extent, descriptions of variables and the rules for using them. You can apply user-defined functions in LibreOffice Calc in the following ways: You can define your own functions using the Basic-IDE. The Information Railroad: One of the major challenges facing universities in the next decade is to reinvent themselves as informa. LibreOffice was based on OpenOffice. org Cursor". IsDate(Value) checks whether a value is a date. http://www. The Professional version of Equation Editor- MathType is a powerful interactive tool for Windows and Macintosh that lets you create mathematical notation for word processing, web pages, desktop publishing, presentations, and for TeX, LaTeX, and MathML documents. In the Release Notes you can read about all new features, functions and languages. The Sum (AutoSum) is shown within this video tutorial. One powerful feature in Calc is the IF/ELSE statement. The accountant would spread information like costs, payments, taxes,. If you're interested in an Asus Eee PC, check out a model guide of basic specifications to pick the right model for you. 1 for Windows 10. I am writing the book using OOo. Lime Survey; Open Hardware. Creating a dropdown list in OpenOffice Calc that references a list of values (repost) I just started using feature this recently, for my LinuxWorld presentation. Just keep the basic purpose of each tool in mind, and you should have little trouble with Calc's function tools. A2 Which is fine, except. ODBC access from Apache OpenOffice, LibreOffice and OpenOffice. 12 KB 'Implying Range 1 > Range 2. Synonym's The Classroom covers more than just homework and study tips. The DD-WRT project; Other open source hardware projects. Newcomers find it intuitive and easy to learn, while professional data miners and number crunchers appreciate the comprehensive range of advanced functions. oxt) on my ubuntu 8. The PROB function syntax has the following arguments: X_range Required. Macros can be effective in saving time, increasing efficiency, and improving productivity in. Back to our example, let us assume, for example, that the matrices for the months of January, February, and March are To make sure that the reader knows what these numbers mean, you should be able to give the Health-expenses for family A and Food-expenses for family B during the month of February. 0 is a free, open source alternative to Microsoft's Office application suite. If the database is being distributed to multiple devices, the appropriate barcode font must also be installed on each device. The upper part is for adjusting the on screen size of the image. org Basic IDE. The following four Calc Toolbars appear at the top of all Calc screens. org Basic is virtually identical to that in VBA. Use the statements and functions described here to perform date and time calculations. org, Spreadsheets, StarOffice | Permalink Comments I've found this useful and picked up a few other tips whilst I was here but I can't get the conditional formatting to work for text in cells. 2)Set the data source URL to sdbc:embedded:hsqldb for an internal HSQL database. Welcome to FreeBASIC. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc. If an item contains a date, the value must be expressed as a serial number or populated by using the DATE function so that the value will be retained if the worksheet is opened in a different locale. Some of the functions are explained briefly in the following: Asc returns the Unicode value of the first character of its string parameter. Corporate finance spreadsheets: These spreadsheets are most useful if you are interested in conventional corporate financial analysis. org and LibreOffice What ip-calc can do: - increment an IP address - calculate a net mask - check if an address is in a subnet - calculate the difference between 2 IP addresses - calculate the size of a subnet - provide a set of helper functions for IP address parsing so you can easily write your own macro. Calc is the free spreadsheet program you've always needed. Math allows you to create basic charts and cell-dependent calculations just like Excel, and most useful features from Microsoft Word also. Free download the new WPS Office suite (Word, Spreadsheets, Presentation) for Windows, Linux, Android or iOS, with cloud connectivity and other top features. A square matrix of order n, is a (nxn) matrix. is defined? If I use ThisComponent. Free office suite, open source, and compatible with. Their idea was to fulfil the promise of independence written into the original charter. The PROB function syntax has the following arguments: X_range Required. It appears at the top of the OpenOffice. OpenOffice is an excellent alternative to the most popular office solutions. lebenslauf vorlage openoffice kostenlos. On Pardus Linux you have to install the openoffice-python package. Data -> Consolidate provides a graphical interface for copying data from one range of cells to another, then running one of a dozen functions on the data. Business mou template , Business Templates , Memorandum of understanding example , Memorandum of understanding form , MOU Sample , Non-profit mou template , Office Documents. org Basic supports several runtime functions for string manipulation. The most prominent way to do this, is to use a DataObject variable from the Forms library (language). Tool bar The tool bar is divided into two parts. The term spreadsheet was derived from a large piece of paper that accountants used for business finances. OpenOffice does provide basic bibliographic functions, these include; a simple bibliographic database, a process to insert in-text or endnote citations into a document and a bibliographic table generator to produce a reference table of citations formatted as specified by the user. These spreadsheet functions are used for inserting and editing dates and times. 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. Though I'm not completely into it, i extended the parser to match some more VB. Routine tasks can therefore be automated in OpenOffice. Any affiliate commissions that we earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel. org and found that it doesn’t support Visual Basic for Applications (VBA), the Microsoft Office macro language. The World Wide Web (abbreviated as WWW or W3, [3] commonly known as the web) is a system of interlinked hypertext documents accessed via the Internet. I did a function in LibreOffice calc. org Basic programming language can be divided into four components: The language of OpenOffice. Bob DuCharme. org Calc version 3. To subtract two or more numbers in a spreadsheet, Step 1: First click on the cell where you want the answer to be given. If you're interested in an Asus Eee PC, check out a model guide of basic specifications to pick the right model for you. After the difference is calculated, special functions are used to reconvert the values to the standard time or date formats. Download OpenOffice Draw FREE | OpenOffice is the leading open-source office software suite for word processing, spreadsheets, presentations, graphics, databases and more. Monthly & Annual Income & Expense Tracker. Updated regularly – download for free. It gives you the ability to create HTML files for tables and other tables. I am trying to save an excel file opened in openoffice as a dbf file. This will automatically add the code into the editor window. ==Function== The terms Internet and World Wide Web are often used in everyday speech without much distinction. Openoffice Writer is incompatible with MS Word, so why did they imitate it?. After the difference is calculated, special functions are used to reconvert the values to the standard time or date formats. A square matrix of order n, is a (nxn) matrix. None of them seems available. Download Openoffice from here. Formulas are expressions that take values from a range of cells or a single cell, and output a value. Built-in formulas, pivot tables and conditional formatting options save time and simplify common spreadsheet tasks. org or its siblings, you might find that use of "ByteString aBytePic" in the same fashion as "String aPic" was better than current code in the patch. Function bar The Function bar provides icons for basic functions like open file, save file, copy, and paste. However when I try to "saveas dbf" a text box opens that says "this document may contain formatting or content that cannot be saved in the dBASE file format". This book concentrates on one of those languages OpenOffice. Visual Basic 6 Module Example: Download the Visual Basic Barcode Font Module, which is free to use with the purchase of a Developer's License or above of any IDAutomation barcode font package and extract the IDAutomation. The first toolbar is the Main Menu toolbar that gives you access to many of the basic commands used in Calc. Start editing. Lime Survey; Open Hardware. Use the following steps to create a simple macro: 1) Create a new Calc document named CalcTestMacros. A few basic functions are also represented by symbols. This method requires an advanced knowledge of programming. Corporate finance spreadsheets: These spreadsheets are most useful if you are interested in conventional corporate financial analysis. org Calc version 3. JavaScript is required for this form. org and if you want to contribute to the new FAQ, there's always [email protected] Function Description. For a multiple-line comment, repeat the comment symbol ( ') on each line. Although OpenOffice 1. basic types. Normal precedence rules are used: Exponentiation, multiply and divide, add and subtract. Much documentation and books for Microsoft Access will apply similarly (but not necessarily identically) for OpenOffice. Passing Parameters. Under the hood Bluefish 2. For example, you can use dumpbin /exports user32. I'm using the VLOOKUP function to lookup values in a column based upon a search query. The prime function of a roster template is to alert others. Excel workbooks with Visual Basic for Applications (VBA) macros embedded do not function in Calc, even though VBA and StarBasic (SB) are syntactically the same. Routine tasks can therefore be automated in OpenOffice. Date & Time functions. 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. Here are four ways create a hyperlink -- click a link to go to those instructions, below: The text changes to a hyperlink, and you can click the link to go to the Contextures. Is there a manual for the basic use of Open Office 4. DEF FN—a pair of keywords introduced in the early 1960s to define functions. 2)Set the data source URL to sdbc:embedded:hsqldb for an internal HSQL database. 3, “Date and Time Types” , for a description of the range of values each date and time type has and the valid formats in which values may be specified. You can program functions as add-ins. MessageBoxA is the ANSI entry point for the MessageBox function; MessageBoxW is the Unicode version. Choose from thousands of free Microsoft Office templates for every event or occasion. org Basic • OO Basic uses structures inherited from BASIC (Beginners All-purpose Symbolic Instruction Code) via VBA, with many extensions • Program is usually stored with document, and can interact directly with document data or other apps • OOB and VBA allow for object-oriented programming (OOP) like C++, Java, etc. OxygenOffice Professional(OOOP, O2OP)is an enhanced version of free OpenOffice. org Base, is a relational database management system, a competitor to Microsoft Access and even suitable for beginners to databases. Free download OpenOffice 3. Use the statements and functions described here to perform date and time calculations. 1b A guide to complement the already existing documentation out there! DEPRECATED: Go to the FAQ at OOoAuthors. 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. Bluefish supports many programming and markup languages, but it focuses on editing dynamic and interactive websites. This software features several programs, including a word processor, a spreadsheet manager, a drawing tool, and a presentation creator, making both personal and professional use possible. However, there is a slight difference in the syntax used in Calc. 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. Routine tasks can therefore be automated in OpenOffice. lebenslauf vorlage openoffice kostenlos. To make it easier to accomplish this task, Calc includes a built-in formula called the SUM function. Calc is the free spreadsheet program you've always needed. Ninety-five percent of Microsoft Office users could switch to the free OpenOffice without tables and esoteric functions will need to verify OpenOffice can do the job for them. Example: when I type "=besselk(" it appaears a tip. Jump to: navigation, search. Basic IDE Tools is an extension for Apache OpenOffice and OpenOffice. dll to obtain function names. developerWorks blogs allow community members to share thoughts and expertise on topics that matter to them, and engage in conversations with each other. ) Voice over IP. Openoffice is available completely free of charge! It contains everything you need from an office suite: text editor, spreadsheets, presentation software, and much more. Xconvert : a module conversion functions for date, time and fractional complete the list of BASIC functions A demonstration program to serve as a model Demonstration The program can display two dialog boxes 1. Another project was formed, forking from the OpenOffice. Welcome to FreeBASIC. IP calculator for OpenOffice. There are no macros, formulas, or other complicated functions. Fast: Gnumeric starts up quickly and handles large spreadsheets while remaining responsive. I know this has nothing to do with your post, but I am at a loss as to how to perform a (seemingly) simple function in OpenOffice Calc. org Basic: Defines the elementary linguistic constructs, for example, The runtime library: Provides standard functions which have no direct reference to OpenOffice. This category contains the Mathematical. Although placing each statement on a separate line is the recommended method, Visual Basic also allows you to place multiple statements on the same line. MICHEL THOMAS ITALIAN (BASIC) COURSE, 8 CDs. The World Wide Web (abbreviated as WWW or W3, [3] commonly known as the web) is a system of interlinked hypertext documents accessed via the Internet. 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. Trim (MyString). I look at the features and functions. Step 2, Add A Label To the Columns. To subtract two or more numbers in a spreadsheet, Step 1: First click on the cell where you want the answer to be given. org and derivatives such as LibreOffice (where it is known as LibreOffice Basic). 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. Use the following steps to create a simple macro: 1) Create a new Calc document named CalcTestMacros. Excel workbooks with Visual Basic for Applications (VBA) macros embedded do not function in Calc, even though VBA and StarBasic (SB) are syntactically the same. For example, you can use dumpbin /exports user32. org Basic to open the OpenOffice. libreoffice. Tool bar The tool bar is divided into two parts. Moving to OpenOffice: Batch Converting Legacy Documents. Here are four ways create a hyperlink -- click a link to go to those instructions, below: The text changes to a hyperlink, and you can click the link to go to the Contextures. Apache OpenOffice (formerly OpenOffice. (Print this cover page separately. Welcome to FreeBASIC. 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. Java Download » What is Java? » Do I have Java? » Need Help? » Uninstall About Java. What I want to be able to do is pass a cell as the first argument for the formula, the second argument to be the value I want to set the formula to, and the third argument to. I'm trying to use Libre Office Basic to write user defined function for Libre Office Calc which runs Goal Seek as a function instead of me going to the menu and clicking. Using Procedures and Functions. Xconvert : a module conversion functions for date, time and fractional complete the list of BASIC functions A demonstration program to serve as a model Demonstration The program can display two dialog boxes 1. This site contains affiliate links. How to create a 3D Terrain with Google Maps and height maps in Photoshop - 3D Map Generator Terrain - Duration: 20:32. Bluefish supports many programming and markup languages, but it focuses on editing dynamic and interactive websites. JavaScript is required for this form. If you’re interested in an Asus Eee PC, check out a model guide of basic specifications to pick the right model for you. org Basic supports several runtime functions for string manipulation. Average, Sum and Charts. OpenOffice. They started the Document Foundation. Where VB functions are placed in OpenOffice Calc. Data -> Consolidate provides a graphical interface for copying data from one range of cells to another, then running one of a dozen functions on the data. When used in its "QB" language mode, FreeBASIC provides a high level of support for programs written for QuickBASIC. 2 encryption options and new spreadsheet functions. Basic Source for all 2D fonts will be provided within that particular package in the "Integration\OpenOffice VB" folder. org Basic: Defines the elementary linguistic constructs, for example, The runtime library: Provides standard functions which have no direct reference to OpenOffice. The Shield is an extremely thin and lightweight gun that is best suited for carry. In VBA, you can also use the keyword ByRef to force a parameter to be passed by reference. Check out the latest articles on It’s FOSS. org Basic offers complete access to all OpenOffice. The Professional version of Equation Editor- MathType is a powerful interactive tool for Windows and Macintosh that lets you create mathematical notation for word processing, web pages, desktop publishing, presentations, and for TeX, LaTeX, and MathML documents. The ZX80 4K BASIC had the exclusive function TL$(); it was equivalent to the string operator (2 TO ) in later versions. LibreOffice Basic Macro Tutorial Index This page contains index of all LibreOffice tutorials, including Calc Macros using basic that has been posted in www. (The cursor moves to C1. lebenslauf vorlage openoffice kostenlos. Alert Roster Template Alert roster templates are considered to be a useful tool to while conveying important information in times of need. org Basic of the Developer's Guide. In the early 1990s it was ported to Windows and Linux , and since 1999 it has been available as open source software with its runtime library under the LGPL license. Imitations are always inferior. When I want to know about a specific issue, I usually search the Developers Guide, the tutorial, and then finally a google search. Download OxygenOffice Professional - Office Suite for free. This method requires a basic knowledge of programming. All code donations from external organisations and existing external projects seeking to join the Apache community enter through the Incubator. It can be used legally without any fees at homes, businesses, offices and szkołach. EDIT: Regarding DATEDIFF: this is a function that's part of the Core SQL:1999 standard (see the overview of date/time sql functions in the SQL Wikibook), so you can use it with most SQL databases (OpenOffice Base, MySQL, PostgreSQL and so on). Openoffice is available completely free of charge! It contains everything you need from an office suite: text editor, spreadsheets, presentation software, and much more. 7 Date and Time Functions This section describes the functions that can be used to manipulate temporal values. Note: To edit a document on a touchscreen device, like a Pixel Book, double-tap the document to start typing. Apache OpenOffice Basic provides the following test functions for this purpose: IsNumeric(Value) checks whether a value is a number. Routine tasks can therefore be automated in OpenOffice. IF you are in a OpenOffice program, click File > New > Spreadsheet. OpenOffice. Back to our example, let us assume, for example, that the matrices for the months of January, February, and March are To make sure that the reader knows what these numbers mean, you should be able to give the Health-expenses for family A and Food-expenses for family B during the month of February. OxygenOffice Professional contains more extras like templates, cliparts, samples, fonts and VBA support. IF you are in a OpenOffice program, click File > New > Spreadsheet. Example: If you want to subtract. COUNTIF can be used to count cells with dates, numbers, and text that match specific criteria. In the LibreOffice Calc functions, parameters marked as "optional" can be left out only when no parameter follows. XBasic is a variant of the BASIC programming language that was developed in the late 1980s for the Motorola 88000 CPU and Unix by Max Reason. I have a column containing sequential dates through the year, and in the next column, in every seven cells, I would like to have a date range of the previous week listed. getByName("Standard"). Also, for power users, while MS Office uses Visual Basic for Applications (VBA) I think LibreOffice / OpenOffice both use Python (they have Java applets, but automation scripting via user is in Python). Breaking news from around the world Get the Bing + MSN extension. It contains various declarations for structures, constants, global variables, resources, functions and procedures that constitute the FutureBASIC language. LibreOffice Base Tutorial #1 - Basic Functionality. You can also safely rename this SUB. This category contains the mathematical finance functions of LibreOffice Calc. The official catalog of Apache OpenOffice templates. This default name has nothing to do with the order or the starting point of a LibreOffice Basic project. READ ALSO: WordPad in Windows 8, Windows 10 Becomes Cool With Spell Check Functions; OpenOffice works on Windows 10, Windows 8. I have long promised to write about the scripting language Basic and creating macros in LibreOffice. I wanted to show a 3 minute tutorial on Macros and Buttons. vsdx, Gliffy™ and Lucidchart™ files. bas file and then save this file and close the OpenOffice. org or its siblings, you might find that use of "ByteString aBytePic" in the same fashion as "String aPic" was better than current code in the patch. inverse mask). The accountant would spread information like costs, payments, taxes,. This category contains the Logical functions. org was once the open-source office suite of choice, but it fractured into two separate projects — Apache OpenOffice and LibreOffice. The system libc version is usually very outdated and is only meant to produce very limited results, but perhaps more dangerously such a random number generator is system dependent so moving your work from one system to another will. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc. The Cryptographic Hash Functions UNO Component for OpenOffice. org (aka StarOffice) 1. Install Install OpenOffice either by downloading a file or from a CD ; Writer This is the word processing feature in OpenOffice (similar to MS Word) Calc This is the spreadsheet feature in OpenOffice (similar to MS Excel) Impress This is the presentation feature in OpenOffice (similar to MS PowerPoint). FreeBASIC is a free/open source (GPL), BASIC compiler for Microsoft Windows, DOS and Linux. org suite of applications. This is an approximate transcript of the course, since Michel often changed his mind in the middle of a sentence to be t. Free office suite tools like OpenOffice and Libre Office have more advanced features than you might expect. @ qubit, thanks for your answer. Org Basic Screen. DEF FN—a pair of keywords introduced in the early 1960s to define functions. NET (C# and Visual Basic). We use cookies for various purposes including analytics. It will return the average value of a given series of numbers in Excel. An entry point of a Kotlin application is the main function. There are no macros, formulas, or other complicated functions. The term spreadsheet was derived from a large piece of paper that accountants used for business finances. The ZX80 4K BASIC also used these longer forms but differed by using the spelling RANDOMISE. Loan Calc; Loan Calc is an easy-to-use tool intended to calculate loans and mortgages repayments in a very simple way. BasicLibraries. If a built-in function is not available, you can write your own using procedural SQL or Java. org to open a document, export to PDF. Since April 2011 the function chk_spreadsheet_support() has been included in the io package.