Openoffice Calc Months Function

You can use the DATEDIF function to determine the time frame for an upcoming project, or it can be used, along with a person's birth date, to calculate an individual's age in years, months, and days, for example. I noticed my OpenOffice Calc retirement tracking spreadsheet (I look at stock values after the news occasionally) quit working. Apache OpenOffice 4. Use the following steps to create a simple macro: 1) Create a new Calc document named CalcTestMacros. org's documents, should they be texts (from Writer), spreadsheets (from Calc), presentations (from Impress), drawings (from Draw), support the com. 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. returns 14, the number of months between April 2010 and June 2011. The function can have up to 500 arguments, meaning that you can specify 250 pairs of ranges and criteria. Database functions. Returns the date in datetime format of the last day of the month, before or after a specified number of months. First, we subtract the start year from the end year and multiply the result times 12. 24/7 Availability. If Writer is already running, start Calc by selecting ‘ File ’-> ‘ New ’-> ‘ Spreadsheet ’. Find out why Close. org Basic Macros dialog (see Figure 7). Dover Rehab For the function the medical professionsal you apply will never be placed in the company's available networking, the manufacturer will charge you extra to go on to viewpoint him or her. 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. Examples =MONTH(NOW()) returns the current month. Algebra 2 Week 2 (8-31) Algebra 2 August 29, 2016. Calc's data. A password may be lost after a regular system cleanup during which you unintentionally deleted the document where you stored all passwords. Calc is similar to Microsoft Excel, with a roughly equivalent range of features. I want a drop down calendar on Date filed. How to do this in OpenOffice Calc? The sort option on month is not working because I guess the y. You can also insert and convert an Excel or OpenOffice spreadsheet, into an existing Goggle Sheet spreadsheet. Body Fat Calculator There are several methods to calculate body fat percentage, where it usually can be used to measure someone health status. Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting [Jacek Artymiak] on Amazon. DATEDIF(Start date; End date; Interval) Start date is the date from when the calculation is carried out. Charts and graphs can be powerful ways to convey information to the reader through a pictorial representation. Before OpenOffice. Your house now houses an amount of memorabilia outlining his function from the battle contrary to the apartheid routine and his rise to get director on the fresh variable-national democratic condition. The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. 3 the chart wizard was altered. We'll use DATEADD to add a month to the date. This article is the first of a two-part series. Injury Lawyers Florida : All Legal Practices. This tutorial will demonstrate how to use Excel's financial functions to handle basic time value of money problems using the same examples as in the calculator tutorials. Current Balance: The calculator assumes you are paying off the unpaid principal. Inside Search. Join GitHub today. Is there a polynomial curve fit function(s) in Calc ? edit retag flag offensive reopen merge delete Closed for the following reason the question is answered, right answer was accepted by Alex Kemp. Solve the exponential equation. However, it's a powerful function that I want to make sure readers know about, if they don't already. There is "Multiplication" function and no "division"?. org installation running on a Windows machine to a document created on a Linux machine, are not supported. OpenOffice Calc main features:. It allows to edit and create excel xls documents. 0 Calc and with LibO 4. Date of separation from active military service, or; Date the veteran was first notified by VA of a service-connected disability rating. If you've installed a supported distribution, or built Novell's version of OpenOffice. 3 years, 6 months ago. Scale fast — without fear. [ Bad Credit Personal Loans Not Payday Loans Online ] Completely Online. This article describes how to use OpenOffice / LibreOffice / OpenOffice. We will learn how to use Today function to get Today's date in Excel. [ Bad Credit Loans Instant Approval ] Completely Online. 3’s and MS Office 2007’s word processors and slide show programs. ) The ROUNDUP function is a built-in function in Excel that is categorized as a Math/Trig Function. The real power of the INDIRECT function is that it can turn any string into a reference. For every input. This category contains the Logical functions. Google Search Forum. Each payment will be automatically deducted from your bank account, so you’ll never have to worry about missing a payment. Rehab In Youngstown Ohio ,The territory of Malta is astounding. MONTH(Number) Number, as a time value, is a decimal for which the month is to be returned. Consolidate Credit Loans : Easy online application, quick decisions, up to 125% cheaper than other lenders. I am able to get the day Number representation from a date with the following. Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date). Whilst we make every effort to ensure the accuracy of these calculations, we cannot be held liable for inaccuracies. To make it easier to accomplish this task, Calc includes a built-in formula called the SUM function. Tax Office Assistant Job Description Antalya is between the Taurus Mountain tops, as well as the scenery is stunning. Calculate a Person's Age in Excel or Openoffice using Date Functions Part 1. I spent a couple of days testing OOo Calc and Microsoft Excel […]. It calculates your monthly payment and lets you include additional extra payment (prepayments) to see how soon you could pay off your home, or how much you could save by paying less interest. You can simply go to the 'Tools' dropdown menu on top of the page and choose the right calculator to calculate EMI for car loans. To calculate how many days in a particular month of a year PHP provides in build function cal_days_in_month() function returns the number of days in a month for a specified year and calendar. The Annuity Calculator was designed for use as a retirement calculator, where withdrawals are made each year. For example, the expression. org Basic Macros dialog (see Figure 7). 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. Inpatient Drug Abuse Treatment Centers Wellbeing insurance could be one in the a large number of high-priced things that you may have just about every month and finding an important low priced choice is important intended for you. In case of problems with the functioning of Apache OpenOffice (AOO) Bugzilla, please contact [email protected] 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. Even though both dates are the last day of their months, the last month is not counted, because the day is less than 31. Rehab Modalities : See if You Qualify for Coverage. You can type the two columns like I have it or you can use your. 6 years, 9 months. Open Office Calc Auto Sum Function - Open Office Tutorial - Duration: Hide Zero Values in Excel or Openoffice using user defined formats - Duration: LibreOffice Calc. Compare Top Policies from $50/Month! Gold Plans · Platinum Plans · Private Plans · Save 70% on Plans Insurance coverage: Obamacare, Subsidy, Individual, Family, Short-Term A Health Maintenance Organization is a type of health insurance that requires every participant to choose a Primary Care Physician or PCP. Select range(s) in Calc and twice click on a day on the floating window to insert date in ISO format. This percent change formula calculates the percentage increase / decrease in this month (column C) comparted to last month (column B). And in the drop down list of Filter arrow , you can only choose the years to filter. What function could I use in Microsoft Exel/OpenOffice Calc to make a value continue "x" number of times? I have a value of £0. This extension uses Python calendar and datetime functions. org Calc, the Forecast function works pretty much the same as in Excel. Health Insurance Penalty Calculator 2017 Drug Addiction Services Find out if you are eligible for tax credits for private insurance or health programs like Medicaid or the Children’s Health Insurance Program (CHIP). Excel can help you calculate the age of a person in different ways. Help with IF THEN OR Statement in OpenOffice Calc? I need a functional formula for OpenOffice Calc that will function like this if N3 = "Optics" then "Tactical" or if N3 = "Flashlight" then "Matches" Basically I need multiple if then statements in one cell so that it can return multiple potential results based on show more I need a. Demo video of how to put multiple lines of text inside a cell in LibreOffice Calc. The AVERAGEIF function sums up all the results that match the logical test and divides this sum by the quantity of selected values. How to do this in OpenOffice Calc? The sort option on month is not working because I guess the y. These spreadsheets work with Microsoft Excel 2000 or later with macros enabled, and some will work with OpenOffice Calc (free). Excel 2016 – PMT Function – How to Use the Payment Formula to Calculate Per Month or Monthly Amount About this tutorial: Video duration: 15:14 This tutorial shows you how to create a PMT function to calculate a loan payment. But in the later years, as the loan balance slowly declines, more and more of each month's payment is applied to the principal. By subtracting this from the date we just calculated (the one that is a month ahead), we can get the last date of the month. SheepDog Guides Offers a graded sequence of detailed Base tutorials, some case studies, and some "How To" pages. To calculate the number of days in a month or a year based on a date, this article will help you. This function will round off a number according to the usual rules of symmetric arithmetic rounding: a decimal place of. Calculate the number of days, months, or years between two dates using Excel functions. a calculator Explain in writing the justification of an answer estimate justify 8. It also includes a smart web editor to work with xls documents. 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. How to automatically fill cells with dates using OpenOffice Calc. The result of the function is always displayed as text. The dates argument can be any of the following: A reference to a date/time column. Open Office Calc offers a variety of different chart and graph formats for data. 12/10/2018; 2 minutes to read; In this article. Get the most out of Google with the latest additions to Search. Join today to get access to thousands of courses. Two possible use cases of an automatic sort function would be: a) the list I'm typing into is the one being automatically sorted, and b) the data in the list is copied into another list, perhaps into another sheet, and autosorted there. The Analysis add-in gives us an example, on how this could work in the practice. One powerful feature in Calc is the IF/ELSE statement. org Calc spreadsheet. Withdrawal From Cocaine : See if You Qualify for Coverage. Introduction. [ What Is An Installment Loan ] Completely Online. 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. As we pointed out, all functions in Calc take arguments and in this case as you might expect the arguments would have to do with interest rates, principle amounts, time periods, and payment amounts. [{"path":"\/export\/www. Dallas Rehabilitation Center : See if You Qualify for Coverage. [ Quick Bad Credit Loans 100 ] Completely Online. org Calc on Ubuntu 9. LibreOffice Calc provides you with functions, including statistical and banking functions, that you can use to create formulas to perform complex calculations on your data. [Solved] FACT vs. The Date & Time functions are used to manipulate dates and times. Typically, monthly installment loans are for larger purchases like appliances, cars, or other. LibreOffice Calc (and OpenOffice. What-If Calculations. grouping by month can't be. [ Consolidate Debt Loan ] Completely Online. The Fastest & Easiest Way to Compare Plans. Each payment will be automatically deducted from your bank account, so you’ll never have to worry about missing a payment. Click cell G4, then type:. It is compatible with a range of files. This is Apache OpenOffice (AOO) Bugzilla: the Apache OpenOffice (AOO) bug system. Monthly Payday Loans Online What is specifically and worldwide recognised is brand new Zealand's neat environment friendly picture. How to calculate years and months between dates. [ Quick Bad Credit Loans 100 ] Completely Online. Best Loans For Bad Credit Reviews : Easy online application, quick decisions, up to 125% cheaper than other lenders. For example, you can use the YEAR, MONTH, and DAY functions to create an anniversary date that’s based on another cell. 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. First, we subtract the start year from the end year and multiply the result times 12. A histogram is a graphical tool used to visually display a collection of data. If you can't get the SUM function to work, try this easy find and replace fix. 0) does define the DATEDIF() function > >AFAIK. Browse other questions tagged function date openoffice-calc or ask your own 3,751 times. OpenOffice. These functions simplify help to create the formulas needed to get the expected results. Withdrawal From Cocaine : See if You Qualify for Coverage. Outpatient Behavioral Health Another point to continue in mind can be, any time you are visiting a third world region that may possibly not have the functions to deal with your condition, you will include to come to be airlifted into a place that could treat you. Functions in OpenOffice Calc. Type: Profit Per Costume. Open Office Writer performs many of the same functions as Microsoft. Skip trial 1 month free. In my experience, look-up functions and IF are almost always used together. org For Dummies. [ Loan Home ] Completely Online. Andrew Pitonyak's OpenOffice Macro Information. Date, Day, Month, Year Functions In LibreOffice Calc Tamil. 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. Approximate Weight of item 21 Lbs. I spent a couple of days testing OOo Calc and Microsoft Excel […]. From OpenOffice. Returns the arithmetic mean of all cells in a range that satisfy a given condition. [ Consolidate Credit Loans ] Completely Online. Google Search Forum. In OpenOffice. [ 300 Loan Payment ] Completely Online. Need private packages and team management tools? Check out npm Orgs. The aim of this document is to guide novice users through the creation of a full-fledged OpenOffice Calc Add-in. The database functions use the following common arguments: Database is a range of cells which define the database. Loans With No Credit Check Low Interest Rate : Easy online application, quick decisions, up to 125% cheaper than other lenders. Like Writer, Calc can now embed fonts, and LibreOffice Calc now lets you automatically recalculate selected cells (Figure 7). The Fastest & Easiest Way to Compare Plans. Functions comparison of LibreOffice Calc and Excel. File formats. You can do it by dragging the formula upto the last cell. Returns the day of a given date. The result of the function is always displayed as text. For example, =COUNTIF(A2:A5,'apples') counts the cells in A2:A5 that contain the word apples. Need to have the absolute minimum 12 month payment past with A bankruptcy proceeding. Returns the number of months between two dates. End date must be later, than Start date. Injury Lawyers Florida : All Legal Practices. Projected Cost = Month to Date Cost + ( Avg (Month to Date Cost) * remaining Days) I have a Date Column and Cost Column. // DatasimDatasimDate. [ Business Funding With Bad Credit ] Completely Online. This is the Payment function, and it works the same in any version of Excel in Windows and Mac, and also on Google Sheets and Apple Numbers. LibreOffice internally handles a date/time value as a numerical value. [ Finance Loan Bad Credit ] Completely Online. repayment Drug Rehab help you to be eligible to acquire even more. [ Home Improvement Loans Rates ] Completely Online. I tried to find such functions and could not find it. Thank you for your help! I'm using Open Office and would like answers for that. In this article, we will learn how to calculate the number of years, months and days elapsed from a certain date using DATEDIF function in Excel. org to keep the formatting of any new data that you might subsequently enter, - the box marked 'Don't save imported data' refers to data that you may have called from a database, so these data will not be saved with your file. org installation running on a Windows machine to a document created on a Linux machine, are not supported. Programmer's 64 Bit calculator for working with 64 bit binary, hexadecimal bitshifts, calculations, rotations and more. =STARTOFMONTH(DateTime[DateKey]) See also. These spreadsheets work with Microsoft Excel 2000 or later with macros enabled, and some will work with OpenOffice Calc (free). Object Moved This document may be found here. End date must be later, than Start date. Vertex42 focuses on Excel, so people may not know that we offer 100+ free templates for OpenOffice. Using the Address function in Openoffice Calc. There is "Multiplication" function and no "division"?. It allows to edit and create excel xls documents. Whilst we make every effort to ensure the accuracy of these calculations, we cannot be held liable for inaccuracies. 4 2 5 1 3 0011 0010 1010 1101 0001 0100 1011 PMT Function • Calculates the payment of a loan based on constant payments and a constant interest rate • PMT is found under More Functions next to the Auto Sum. Object Moved This document may be found here. Both Excel 2003 and Calc have the feature in the same place. Introduction. org on your Linux box, or installed Novell’s OpenOffice. DAY: Returns the day of the month, which is a number from 1 to 31. You can enter data, usually numerical data, in a spreadsheet and then manipulate this data to produce certain results. 0075), number of payments to be made NPER ), and the loan amount ( PV , i. - The colorization of the days of the following month doesn't work when the first day of that week is still in the current month. ,0) Calculate the Final Rank. Find out why Close. Issue Solution Are there any keyboard shortcuts to repeat functions under OpenOffice (like pressing F4 under Office)? Press simultaneously the Ctrl + Shift + Y Keys. The IF statement (function) is handy if you want to set up a blank form or calculation sheet; especially if someone else is going to use it. This is a 5 months subscription fee for using the HumidAir Web (Psychrometric Calculator) online. OpenOffice Calc main features:. com\/application_public\/downloads\/","filename":"blog_social_visualsoft_responsive. Browse other questions tagged function date openoffice-calc or ask your own 3,751 times. Mail about any other subject will be. Posted at 05:23 AM in Calc, OpenOffice, OpenOffice books, OpenOffice training, OpenOffice. Find out why Close. Written with a tutorial style, Beginning OpenOffice Calc is ideal for self-study, and aids problem solving as well. 4 or less gets rounded down, while one of. Something I use on a monthly basis and each month change out the data. Skip trial 1 month free. A much easier way is the EDATE function which you can feed a date and a number of months after that to return a new date on the same day of the month, just in a different month OpenOffice 3. Suman Chatterjee ( [email protected] This calculator calculates either: The monthly payment amount required to repay your credit card balance in full, given your estimated monthly purchases and number of months you'd like to pay off your balance. We'll use DATEADD to add a month to the date. as part of the iWork productivity suite alongside Keynote and Pages. Thank you for your help! I'm using Open Office and would like answers for that. SQL_Statement; SELECT. Time difference in days in OpenOffice Calc. Note: All Practical Spreadsheets work with Microsoft Excel. Outpatient Behavioral Health Another point to continue in mind can be, any time you are visiting a third world region that may possibly not have the functions to deal with your condition, you will include to come to be airlifted into a place that could treat you. [ Piggy Bank Payday ] Completely Online. File formats. No Upfront Fees. But dragging is some times a very boring or tedious job. org Basic to open the OpenOffice. Tips for using, transitioning, and more. OpenOffice is the open-source version of Sun MicroSystems’ StarOffice productivity suite, but you’ll be forgiven for thinking it looks an awful lot like Microsoft Office 2003. Wherever you would use a comma in an argument in an Excel Function, you would instead use a semicolon in Calc. Then you can enter the following formula in cell D2 to calculate percentage change in your Excel sheet: =(C2-B2)/B2. 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. 2 つの日の間にある月数を返します。 This function is only available if the Analysis AddIn is installed. Thanks in. With CalcLink you can use the power and sophistication of Mathematica in Calc, and you can use the familiarity, convenience, and ease-of-use of Calc from Mathematica!. This Excel tutorial explains how to use the Excel VLOOKUP function with syntax and examples. “H” will take you to the “Sheet” submenu, and “R” will issue the rename command. With this approach, a large percentage of your monthly payment is applied to interest in the early years of the loan. After starting, Calc presents an empty spreadsheet divided into rows and columns. File is the complete file name, including path. Date functions in JavaScript play a very important role in web applications. CCM is a leading international tech website. "Full-fledged" means that. Changing the date format for a particular cell makes that cell look ok, but I'd have to do that for individual cells becuase copying it to the whole column spoils those cells which. Named cells/ranges are recognised in Calc from OOo2. The Annuity Calculator was designed for use as a retirement calculator, where withdrawals are made each year. Those coming from Microsoft will be pleased to hear that Office files work in OpenOffice, too. Calc's data. Meth Cravings Symptoms : See if You Qualify for Coverage. You can enter the cash flows in any order as the calculator will sort the list of cash flows by date, from oldest to newest, and will assume the oldest was the initial investment. We can use vlookup() in open office calc to accomplish this task. Ser# 858A2MTA. These functions are conditional and provide the ability to write longer formulas based on input or output. From The Document Foundation Wiki. Find out why Close. Is it true that there is no "substraction" and "division" functions in OpenOffice Calc or in Excel?. Services: Life Skills Coaching, Drug & Alcohol Rehab, Career Counseling. I tried to find such functions and could not find it. Drug Rehab Charleston Sc Find out if you are eligible for tax credits for private insurance or health programs like Medicaid or the Children’s Health Insurance Program (CHIP). 4 was released, there were macros written for converting Text to Columns. The type parameter is implemented from OOo3. 65 Exercise Set A LESSON 4. The Excel INT function returns the integer part of a decimal number by rounding down to the integer. Open Office 4 Calc Formulas Tutorial, Calc Formulas. ,0) Calculate the Final Rank. When you're working in OpenOffice. We can use GCD to then create our ratios. Calc (View forum) • Apache OpenOffice Community Forum. Calc is a software package that has plenty of functions and formulas for spreadsheets. 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. The ODF > >specification (ISO/IEC 26300:2006 Open Document Format for Office > >Applications (OpenDocument) v1. In Excel, type is a logical value; Calc also accepts logical values but they are displayed as numbers. Thanks for any possible help. I am new to Open office how to create Series of Date in Openoffice For example If I am entering the date as 04/APR/2013 (2 months) this has to increase in each below column. Small Unsecured Personal Loans Bad Credit : Easy online application, quick decisions, up to 125% cheaper than other lenders. How to do this in OpenOffice Calc? The sort option on month is not working because I guess the y. This article describes how to use OpenOffice / LibreOffice / OpenOffice. Arriflex BL Blimp Housing. In this tutorial I will show you how to use the auto sum function with a few simple mouse clicks. But dragging is some times a very boring or tedious job. We utilize the latest modalities in addiction treatment, resulting in lasting success for our patients. 2 years, 5 months ago. (Print this cover page. Returns the number of months between two dates. Formulae are equations using numbers and variables to get a result. [ Long Term Loans For People With Bad Credit ] Completely Online. A Calc database is simple a range of cells that comprises a block of related data where each row contains a separate record. Fell free to give me suggestions of examples. Discover answers on How to find Duplicates in Open Office Calc?. Based on what I have. The GCD Function is used to calculate the greatest common denominator between two or more values. MONTH(Number) Number, as a time value, is a decimal for which the month is to be returned. Syntax: MONTH(date) returns the month of date as a number, where January is 1 and December is 12. OtherwiseValue (optional) is the value that is returned if the logical test is FALSE. Calling all businesses and individuals in need of services. Health Insurance Penalty Calculator 2017 Drug Addiction Services Find out if you are eligible for tax credits for private insurance or health programs like Medicaid or the Children’s Health Insurance Program (CHIP). These functions simplify help to create the formulas needed to get the expected results. For this booklet to function you MUST install GETQUOTE, a free extension to OpenOffice. - the box marked 'Keep formatting', tells OpenOffice. New Mexico Rehabilitation Center Roswell Nm Tecrehab While how you can find them via methods I am going to can't say for sure! Among rehab best locations try to successful using rehab children. For example, if the first date in the dates argument refers to June 10, 2009, this function returns all dates for the month of May, 2009. The Macro from box lists available macro library. 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". Open Office Writer performs many of the same functions as Microsoft. I am unable to get the right function/formula to calculate the remaining days of the month. If Writer is already running, start Calc by selecting ' File '-> ' New '-> ' Spreadsheet '. The month is given as an integer, ranging from 1 (January) to 12 (December). Available localizations for functions: English and Italian. In my experience, look-up functions and IF are almost always used together. I just want to sort this based on Month and year combination (that is, based on column A) ascending. For pH take the corresponding cell of the first column. [ No Credit Check Payday Loans Lenders ] Completely Online. Our user-friendly PaisaBazaar car loan EMI calculator instantly provides you with the monthly amount you would be required to pay based on the loan amount, term and interest rate provided by you. Open Office Calc is free software for creating Spreadsheets. This can present a problem for people using very large datasets, and may result in data loss. I want a drop down calendar on Date filed. Calc/Features/JIS and ASC functions. hpp" #define OR. With the addition of the COUNTIFS function in Excel 2007, we now have an easier and more-powerful way to generate frequency distributions. 2) Use Tools > Macros > Organize Macros > OpenOffice. , the loan amount's present value). Is there a polynomial curve fit function(s) in Calc ? edit retag flag offensive reopen merge delete Closed for the following reason the question is answered, right answer was accepted by Alex Kemp. How to use VLOOKUP & SUM or SUMIF functions in Excel by Svetlana Cheusheva | updated on June 18, 2019 279 Comments In this tutorial, you will find a handful of advanced formula examples that demonstrate how to use Excel's VLOOKUP and SUM or SUMIF functions to look up and sum values based on one or several criteria. Example: DAY("2008-06-04"). Apply now for Part Time Teller - Conneaut position at KeyBank!. Functions comparison of LibreOffice Calc and Excel. You can modify those results with the day argument. Skip trial 1 month free. That third columns' entry will depend upon the information in the first two. The Apache OpenOffice productivity suite was previously known as Oracle® Open Office and OpenOffice.