Openoffice Calc Functions

A concatenate function on steroids for OpenOffice calc On February 16, 2011 February 16, 2011 By pvanb In Data handling , LibreOffice / OpenOffice In OpenOffice / LibreOffice Calc, you would normally use CONCATENATE to combine strings from different cells, like in the example below:. vlookup() searches for values in one column and given values in another column in true. I am using LibreOffice 3. org in 2010, LibreOffice Calc underwent a massive re-work of external reference handling to fix many defects in formula calculations involving external references, and to boost data caching performance, especially when referencing large data ranges. Converting Microsoft Office Documents. These spreadsheet functions are used for inserting and editing dates and times. 1 FURIGANA: This function translates Japanese Kana-Kanji mixed text into Katakana. Resolution: When reading Excel 2k3/2k7 doc, if meet comma in the end of a formula, add a number '0' (this solution only apply on those function that default value is 0 when meet miss argument, and which can't be skipped. The Sum (AutoSum) is shown within this video tutorial. You could put both values into R1 (separated by a space) and parse the text out to be used by INDIRECT to generate4 cell/range addresses. DATEDIF(Start date; End date; Interval) Start date is the date from when the calculation is carried out. On Monday 24 July 2006 15:44, Antonio Pintus wrote: > Hi, > I am a TortoiseSVN user and I have some problem with changes in Open > Document (. To make it easier to accomplish this task, Calc includes a built-in formula called the SUM function. This version of OpenOffice features improved ODF support, including new ODF 1. 'Calc' is the common name of the spreadsheet component of LibreOfice and of Apache OpenOffice as well. Open Office is the leading open source office software suite for word processing, spreadsheets, databases, graphics, presentations and more. Information. • Database functions, to arrange, store, and filter data. It is acquired mostly during image acquisition and transmission. List of Calc Text functions. Note: OpenOffice. Functions comparison of LibreOffice Calc and Excel. There are almost 100 different functions available that are grouped into more than 10 categories. C H A P T E R 3 Functions You might have heard that functions and formulas are difficult to master. the second row, first column), then chose Data/dataform. 00 (that I will want to change to other values) in cells E10:E850 and I have a number, that I want to be able to change so that the number of £0. Find out why Close. 0 or higher required. org Guidebook and owner of GetOpenOffice. Calc includes over half a dozen tools to help you manipulate functions and formulas, ranging from features for copying and reusing data to creating subtotals automatically to ones. Enter text, numbers, or functions. Heck, even the Calculator applet that comes with Windows returns 48. However, when you realize that the number can be not only a number or a single cell, but also an array or range of cells that contain several or even hundreds of cells, then the apparent limitation vanishes. In both cases you also have options to protect cells. One powerful feature in Calc is the IF/ELSE statement. OOo version 2. Days … - Selection from Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting [Book]. message }}. OOo version 2. The Calc Toolbars. Open A Spreadsheet. To display formulas by other means, choose Tools > Options > OpenOffice. Use these functions for inserting, editing and manipulating dates and times. org handles and computes a date/time value as a number. It is produced by Intelore. For the command to work correctly when sorting dates, the cells containing the dates must be formatted as dates. Instead of Powerpoint, there’s Impress, instead of Excel, there’s Calc. LibreOffice Calc (and OpenOffice. Paste Special, using the Operations section. Spreadsheet Formulas for Microsoft Excel, OpenOffice Calc and Google Sheets are widely available and can be used to quickly create spreadsheets with numerical functions. IF you are in a OpenOffice program, click File > New > Spreadsheet. 8 /usr/lib/perl5 /usr/share/perl5 /usr/lib. Vertex42 lists over a dozen free budget spreadsheets that work with Microsoft Excel, as well as some that are compatible with Apache OpenOffice Calc and Google Sheets. So let us check two simple ways to accomplish this task. Instead of Powerpoint, there’s Impress, instead of Excel, there’s Calc. Novell Linux Desktop 9 for x86,Novell Linux Desktop 9 for x86_64,SUSE Linux Enterprise Desktop 10 SP3 for AMD64 and Intel EM64T,SUSE Linux Enterprise Desktop 10 SP3 for x86,SUSE Linux Enterprise Desktop 11 GA,SUSE Linux Enterprise SDK 10 SP2,SUSE Linux Enterprise SDK 10 SP3,SUSE Linux Enterprise SDK 11 GA,openSUSE 11. Employ the function wizard. Component also refers to an Office Application (Writer, Calc and so on). The OpenOffice. El programa no está disponible como una descarga, depende del hardware. However, you can display all the formulas in the spreadsheet instead of their values. Press the Inverse FFT button (note that no window function is used for the inverse FFT). org Calc Functions and Formulas Tips. You can use single or double lines, bold lines, slashes or X's as the strikethrough character. Calc includes over half a dozen tools to help you manipulate functions and formulas, ranging from features for copying and reusing data to creating subtotals automatically to ones. I'm using Excel 2010, but I think this works in previous versions too: simply add the two columns with a plus sign. 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. Count Cells with Strings, Numbers Using COUNTIF Function – Calc Published on : June 20, 2018 by arindam This tutorial would explain various ways of COUNTIF function in LibreOffice Calc which can be used to count strings, numbers from a cell, range, rows, columns etc. I can't find an OR function in OpenOffice Calc, although I CAN find an AND function, in the help. 0 offers a solution to users who want to search for text in one or more OpenOffice Calc files. org is not able to open and run these macros on the Excel spreadsheets. Is there an easy way to convert the macros, or do I have to learn how to write macros in Open Office and redo them all? Is there a better alternative than Open Office or StarOffice,(which seem to be the same to an end-user like me)? I use two main. 0 123PDF Converter is an easy-to-use conversion tool that gives you powerful conversion options. Root Cause: When reading Excel 2k3/2k7 doc, comma will be ignored if it is in the end of a formula. If you want to print a copy, your PDF viewer should have an option for printing two pages on one sheet of paper, but you may need to start with page 2 to get it to print facing pages correctly. - sort and summarize subnets or routes. 0 offers a solution to users who want to search for text in one or more OpenOffice Calc files. This version of OpenOffice features improved ODF support, including new ODF 1. Calc includes over half a dozen tools to help you manipulate functions and formulas, ranging from features for copying and reusing data to creating subtotals automatically to ones. (Print this cover page. OpenOffice included a word processor (Writer), a spreadsheet (Calc), a presentation application (Impress), a drawing application (Draw), a formula editor (Math), and a database management application (Base). IP calculator for OpenOffice. Select only Formulas and click OK. The application shares some of the same features and functions as Microsoft Excel. [Solved] Nested IF or AND function (View topic) • Apache OpenOffice Community Forum. Date and time functions. With Safari, you learn the way you learn best. Calc is similar to Microsoft Excel, with a roughly equivalent range of features. Two engineers created NeoOffice in 2003 when they made OpenOffice run natively on OS X for the first time. Calc includes over half a dozen tools to help you manipulate functions and formulas, ranging from features for copying and reusing data to creating subtotals automatically to ones. 48 Reading material: Spreadsheet Software A spreadsheet is an interactive electronic computer application to performing mathematical calculations. It is time to fill in our function. PDF Combiner v. All you have to do is add the arguments, and the calculation is automatically made for you. File is the complete file name, including path. I have a feeling it is easy, but I am a basic user and it is proving frustrating to me. These functions simplify help to create the formulas needed to get the expected results. El programa no está disponible como una descarga, depende del hardware. OpenOffice Calc function return #VALUE. Setting up a spreadsheet If you are setting up more than a simple one-worksheet system in Calc, it is worth planning ahead a little. 'Default' cell format has set the 'Cell Protection' to 'Protect' checked, 'Hide formula' not checked. On Windows, instead of spending money on Microsoft Office, download and use Openoffice. It contains various components, has its own file formats and is able to read and save other file formats, including those associated with several Microsoft Office applications. In concrete, XOfficeXls is the app OpenOffice Calc that is run remotely in our servers. Created by Amortization Schedule website. It can be used in Calc as Basic macro custom function. Let us learn here how to calculate mean in OpenOffice Calc explained neatly with sample pictures. DATEDIF(Start date; End date; Interval) Start date is the date from when the calculation is carried out. VBA : The method for passing parameters to procedures and functions in OpenOffice. However, you can display all the formulas in the spreadsheet instead of their values. 3’s and MS Office 2007’s word processors and slide show programs. Competition and retraining. Bah, fuck this shit. It also features enhanced graphics, including shear transformations, line caps, and native support for Scalable Vector Graphics (SVG). Newcomers quickly learn that functions are a main feature of spreadsheets, but there are almost four hundred, and many require input that assume specialized knowledge. function SaveResults_14_02(FileToSave, Param, expPathname, TotalDuration, dt, fs,tot_samples,RealDateStart,RealTimeStart, Threshold,TimePause,ChannelInfo, ActDur, MVC. การใช้งานฟังก์ชั่นSUM การคำนวณทั่วไป ในExcelควรรู้ - Duration: 5:35. Can't locate File/Spec/Functions. "Full-fledged" means that. An improvement on OpenOffice 3. Many organizations currently prefer to use free OpenOffice. One powerful feature in Calc is the IF/ELSE statement. This is just to the right of the Left Align, Center, Right Align, and Justify buttons. Free demo download. On Monday 24 July 2006 15:44, Antonio Pintus wrote: > Hi, > I am a TortoiseSVN user and I have some problem with changes in Open > Document (. This calculator allows to create payroll for your employees and users percentage method as described in IRS Publication 15. This tutorial explain how to use the Look-Up functions in Calc. "Full-fledged" means that. Open Office Calc Учебник СРЕДНЯЯ функция Математически существует ряд способов измерения основная тенденция или, как его обычно называют, среднее значение для набора значений. [Solved] Format function and dates (View topic) • Apache OpenOffice Community Forum. After forking from OpenOffice. Nevertheless, it is hard to guess the parameters for a given problem. Print Multiple HTML Files has 3 main functions: 1) Print from a. The time or frequency domain graphs can now be viewed by clicking the Time Domain Graph or Power Spectrum buttons. 8 /usr/local/share/perl/5. Introduction. It is also used to store, organize, analyze and graphically represent numeric data. Functions This version adds only the SQLREQUEST function to Calc. A more reliable method is to use the Function List. Bah, fuck this shit. These enhancements cover all the issues (shortcomings) listed by the CorePolyGUI extension, and a few others as well. Most other functions in the spreadsheet can be performed through the menus, toolbars, as well as the right-click menu. 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. Select only Formulas and click OK. see a list of functions in alphabetic order. If you want to print a copy, your PDF viewer should. Any value which is a non-zero number or text is considered to be TRUE. Use the logical functions to test values and produce results based on the result of the test. Set the cursor in another cell and enter the. REQUEST function provided with old MS-Excel. OpenOffice Calc 4 Spreadsheet Tutorials OpenOffice Calc is a spreadsheet tutorial similar to Microsoft Excel. And you want to apply this function to large number of column cells. Hi experts, I need to find a way to obtain the cell color code from, something like =CellColorCode(A1) I'm using OpenOffice/LibreOffice thanks in advance Mariano OpenOffice/LibreOffice (CALC) cell color function. Click Tools and Options to open the OpenOffice options window. VBA : The method for passing parameters to procedures and functions in Apache OpenOffice Basic is virtually identical to that in VBA. 3 > OpenOffice. Best Answer: As the other person mentioned, you should use commas; also, rather than giving both a true and a false response for the first if, simply nest the second if as the. Hi everyone, i would like to implement something like the rubber/pencil function known from excel. NG-Review Chanel 126,399 views. I am having difficulty getting the day name from OpenOffice Calc. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone. Xlwt is a fork of the unmaintained pyExcelerator module with several bugfixes and enhancements. Being an array function, SQLREQUEST, results in an array containing the data returned by the data source. =TEXT(A2,"0000") TEXT Function in openoffice calc Welcome to the most active Linux Forum on the web. This extension adds the SQLREQUEST function to Calc. Calc spreadsheets: similar to Excel or Lotus 1-2-3, it offers the inherent functions to this kind of program, as well as others not offered by Microsoft's tool, such as certain functions carried out with charts. COM AT (619) 354-4636 Hugo Sanchez Realtor THE NEW SAMSUNG G4 WAS UNVEILED TODAY!!! This is the next best thing after Toasted Bread! many new f. Open here for more details on Intelore. However, some layout features and formatting attributes may not work in the same way. Don't miss to download the new release and find out yourself. Find out why Close. Functions in OpenOffice Calc. org Calc spreadsheet. Howto: Fit sigmoid functions in OpenOffice Calc and Excel SVEN KOCHMANN. To solve this problem Calc needs to know the monthly interest Rate (. 1) Using the Functions Icon 2) Using the Function Wizard Tab Method 1: Using the Function Icon This is the simplest method to calculate the arithmetic mean of a set of numbers. org Basic Macros dialog (see Figure 7). OpenOffice gave me the possibility to mostly do what I wanted to (with writer, base, calc, impress and draw - in that historic order) in an efficient way, and the only thing I don't like is, that it always tends towards following MS Office although it already was better in many ways. So let us check two simple ways to accomplish this task. org was once the open-source office suite of choice, but it fractured into two separate projects — Apache OpenOffice and LibreOffice. replace function Software - Free Download replace function - Top 4 Download - Top4Download. org Calc is the spreadsheet component of the OpenOffice. I tried to find such functions and could not find it. Support a variety of built-in character extraction and processing functions, and also supports the. Main Menu Toolbar. org Calc can be programmed using the built-in language OOoBasic. Apache OpenOffice Calc Free Download. A concatenate function on steroids for OpenOffice calc On February 16, 2011 February 16, 2011 By pvanb In Data handling , LibreOffice / OpenOffice In OpenOffice / LibreOffice Calc, you would normally use CONCATENATE to combine strings from different cells, like in the example below:. Filter reviews by the users' company size, role or industry to find out how LibreOffice Calc works for a business like yours. Logical functions. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone. How to Learn Spreadsheet Basics with OpenOffice. When the help browser is already open F1 jumps to the main help page. A friend of mine is familiar with working in Lotus 1-2-3 and has asked me for some assistance in converting to Excel or OpenOffice Calc. org handles and computes a date/time value as a number. Set the cursor in another cell and enter the. You can also perform vlookup in Open Office Calc which gives you the same result that you get in Excel. The default file format for OpenOffice Calc version 2. I have a column which contains: € 53,28 € 1. i use spreadsheets a lot for my work. 0 - see Issue 91020. Passing Parameters. End_date Required. Introduction. To make the numbers match, change the decimals to 7 and use Open Office. An improvement on OpenOffice 3. dllの存在するフォルダを指定した後、以下を実行すると Declare. I would like to highlight all cells with a specific day and transfer those rows to another spread sheet. Ask Question 3. The time or frequency domain graphs can now be viewed by clicking the Time Domain Graph or Power Spectrum buttons. To make it easier to accomplish this task, Calc includes a built-in formula called the SUM function. The default file format for OpenOffice Calc version 2. Optional parameters in formulas Some formulas have more than one optional parameter at the end of the parameter list. I downloaded this just now, and installed it in Open Office 3. Why reinvent the wheel, after all. The link is to the index on his old site. 3's and MS Office 2007's word processors and slide show programs. Scenario Feature in Open Office Calc. Apache OpenOffice - Official Site - The Free and Open Productivity Suite. For pH take the corresponding cell of the first column. Ur input method was wrong ! The search function syntax like that, SEARCH(“FindText”; “Text”; Position), where FindText is the text to be searched for, Text is the text where the search will take place and Position is the position in the text where the search is to start (hopefully it is optional). QuantLibXL is the implementation of QuantLibAddin for Microsoft Excel. The solution to storing all your numbers and lists! Calc is the spreadsheet application you've always wanted. 0075), number of payments to be made NPER ), and the loan amount ( PV , i. In this video tutorial I will show you how to use basic formulas in Open Office Calc. OpenOffice Calc offers pretty much most of the functionalities that are in Microsoft Excel. I am trying to add 2 sets of times in columns C and D respectively with the results in column E. The first toolbar is the. The type parameter is implemented from OOo3. Calc is similar to Microsoft Excel, with a roughly equivalent range of features. Competition and retraining. Don't know anything for Linux :(. So long that Microsoft's SmartScreen. Let's suppose you have a spreadsheet table listing packages and their contents. Press simultaneously the Ctrl + Shift + Y Keys. Recently I attempted to add the pricing in a column when I discovered OpenOffice sum function not working- it is a bug in OpenOffice Calc. The QuantLib group. Java Project Tutorial - Make Login and Register Form Step by Step Using NetBeans And MySQL Database - Duration: 3:43:32. org version 2. That may not sound like much at first. The link is to the index on his old site. A more reliable method is to use the Function List. Newcomers find it intuitive and easy to learn; professional data miners and number crunchers will appreciate the comprehensive range of advanced functions. Mail about any other subject will be silently ignored. All you have to do is add the arguments, and the calculation is automatically made for you. LibreOffice Calc is the spreadsheet component of the LibreOffice software package. One powerful feature in Calc is the IF/ELSE statement. LibreOffice, the best free and open source office suite. Do-it-yourself recovery of ODS files. From The Document Foundation Wiki. Hier j'étais en train de mettre à jour un fichier OpenOffice Calc (tableur) quand Windows 10 a "détecté un problème" et a redémarré, sans me demander mon avis. Paste Special, using the Operations section. Necessary Criteria Of Mastering Excel. 04 by following steps download Apache_OpenOffice_incubating_3. One powerful feature in Calc is the IF/ELSE statement. In case of problems with the functioning of Apache OpenOffice (AOO) Bugzilla, please contact [email protected] OpenOffice Calc is a great free tool, but it comes with it’s share of glitches. [Solved] Format function and dates (View topic) • Apache OpenOffice Community Forum. Open Office Functions I will be going through all of the functions in Open Office Calc and posting a real life or mathematical example of every function. What did infinitesimal calculus do? What are the function of open office calc?. Adds the statistical functions ANOVA (OneWayANOVA-Stacked, OneWayANOVA-Unstacked, TwoWayANOVA)and Multiple Linear Regression ( output with Coefficients and further forecasting based on the Multiple Linear Regression model)into the Statistics Category of the function list of prevailing OpenOffice? Calc application, which aids comprehensive data. A concatenate function on steroids for OpenOffice calc On February 16, 2011 February 16, 2011 By pvanb In Data handling , LibreOffice / OpenOffice In OpenOffice / LibreOffice Calc, you would normally use CONCATENATE to combine strings from different cells, like in the example below:. Se qualcuno può aiutarmi, gli sarei molto grato. OpenOffice. org provides the following 4 Calc functions to manipulate Japanese text. • Dynamic charts; a wide range of 2D and 3D charts. This version is limited to 5 employees only, otherwise it is fully functional. By default, the parameters are passed by reference. Nevertheless, it is hard to guess the parameters for a given problem. IF on the desktop, click > All Programs > OpenOffice. NeoOffice is an office suite for Mac that is based on OpenOffice and LibreOffice. org Calc and Gnumeric. Se qualcuno può aiutarmi, gli sarei molto grato. How to Convert OpenOffice to Excel. The AFP2PDF conversion viewer must be installed before you can use it to view documents. see a list of functions in alphabetic order. It contains the Name Box drop down menu (which contains the address of the cell that is currently selected or the range of cells, e. org Basic is virtually identical to that in VBA. The SUM function in Excel adds the arguments you enter in a formula. pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5. What is the maximum number of documents that you can have open at once?. Microsoft company Stand out, the particular spreadsheet computer software developed as well as commercialized through Microsof company, is a component with the Workplace Package and it's also obtainable both with regard to Macs techniques and also Windows. Calc also supports a wide range of other file formats, for both opening and saving files. It's also a powerful function in OpenOffice. I am trying to add 2 sets of times in columns C and D respectively with the results in column E. Most other functions in the spreadsheet can be performed through the menus, toolbars, as well as the right-click menu. 'Default' cell format has set the 'Cell Protection' to 'Protect' checked, 'Hide formula' not checked. 1, on openSUSE 11. org in 2010, LibreOffice Calc underwent a massive re-work of external reference handling to fix many defects in formula calculations involving external references, and to boost data caching performance, especially when referencing large data ranges. Is there any other way to use these Reg replacements. Named cells/ranges are recognised in Calc from OOo2. Martin Baker Has written a tutorial about building a relational database with Base. That's a plug-in which adds a new NUMBERTEXT function to Calc spreadsheets. org Calc, and click on View to open the window in the shot below. But dragging is some times a very boring or tedious job. Applying a User-defined Function in LibreOffice Calc. 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". OpenOffice Calc functions: SUMIF The SUMIFS and DSUM Functions use Multiple Criteria in. Rubber/Pencil function for Calc. 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. To sort a column alphabetically in OpenOffice Calc, highlight the column and use the sort function. With this efficient and user-friendly piece of software, you can easily extract cell text from one or more OpenOffice Calc ODS files. OpenOffice. In version 2. OpenOffice Calc To PDF Converter Software v. The next step is to click “Export as Image” from the context menu. Use these functions for inserting, editing and manipulating dates and times. Returns the number of days between two dates. I have a feeling it is easy, but I am a basic user and it is proving frustrating to me. Beginners might be content to use Calc for lists, but, for advanced users, functions are the. To get the most out of the site and to ensure guides display correctly, we suggest upgrading your browser now. It was forked in 2010 from OpenOffice. Office: GAB, Room 418-D. Charts in OpenOffice Calc. Unlike many others, this book is short, concise, and filled with practical tips on OpenOffice. Create spreadsheets with raw data and use DataPilot technology to cross-tabulate, summarize and convert into meaningful information. FORECAST() Adding Just Odd Rows or Just Even Rows. Templates offer attractive layouts, project-specific functions and just generally save a lot of time. The following directions apply to OpenOffice. Need help? Post your question and get tips & solutions from a community of 430,411 IT Pros & Developers. Newcomers find it intuitive and easy to learn; professional data miners and number crunchers will appreciate the comprehensive range of advanced functions. Once you are comfortable with inputting functions and formulas, the next step is to learn how to automate the processes. 0 or higher required. So long that Microsoft's SmartScreen. Nor are the often circular definitions of. This category contains the Logical functions. Functions help you create the formulas needed to get the results that you are looking for. By default, the parameters are passed by reference. That used to be the case a long time … - Selection from Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting [Book]. 0 This software offers a solution to users who want to convert multiple OpenOffice Calc documents into PDF files. replace function Software - Free Download replace function - Top 4 Download - Top4Download. 00 (that I will want to change to other values) in cells E10:E850 and I have a number, that I want to be able to change so that the number of £0. I find the Open Office. Open a Calc document and enter numbers for the function parameters a, b, and c in cells A1, B1, and C1. org > Paths > Add-ins dialog, these libraries are recognized and can be utilized by Calc. This version is limited to 5 employees only, otherwise it is fully functional. Create spreadsheets with raw data and use DataPilot technology to cross-tabulate, summarize and convert into meaningful information. For information about the DAY function, see DAY function. on April 16, 2007. There are several standard functions available in calc that you can just insert it to a cell and use it. The Macro from box lists available macro library. The OpenOffice Calc Guide. org's documents, should they be texts (from Writer), spreadsheets (from Calc), presentations (from Impress), drawings (from Draw), support the com. It was forked in 2010 from OpenOffice. How to Create a Check Register with OpenOffice. Hi experts, I need to find a way to obtain the cell color code from, something like =CellColorCode(A1) I'm using OpenOffice/LibreOffice thanks in advance Mariano OpenOffice/LibreOffice (CALC) cell color function. Open Office is the leading open source office software suite for word processing, spreadsheets, databases, graphics, presentations and more. They could thus also be described as 'Lookup' functions. One powerful feature in Calc is the IF/ELSE statement. org Calc-a premier desktop spreadsheet software that can be used as a free replacement for Microsoft Excel. Unlike many others, this book is short, concise, and filled with practical tips on OpenOffice. Andrew Pitonyak Better known in the Open Office community for his macro programming skills, offers a Base tutorial, along with some intersting examples. Extracting Weekdays from a Date (WEEKDAY) Syntax: WEEKDAY(t; Day) The WEEKDAY function is used to convert a date given in any recognizable format into a day of the week. SQLREQUEST allows you to query a database using a JDBC driver or an SDBC driver. Windows PC. This merges the three cells. After forking from OpenOffice. org Calc can be programmed using the built-in language OOoBasic. org documents. HiPER Calc 2.