![]() The new project was known as, and the code was released as open source on 13 October 2000. On 19 July 2000 at OSCON, Sun Microsystems announced it would make the source code of StarOffice available for download with the intention of building an open-source development community around the software and of providing a free and open alternative to Microsoft Office. In August 1999, Star Division was acquired by Sun Microsystems for US$59.5 million, as it was supposedly cheaper than licensing Microsoft Office for 42,000 staff. originated as StarOffice, a proprietary office suite developed by German company Star Division from 1985 on. Apache renamed the software Apache OpenOffice. In 2011, Oracle Corporation, the then-owner of Sun, announced that it would no longer offer a commercial version of the suite and donated the project to the Apache Foundation. It was distributed under the GNU Lesser General Public License version 3 (LGPL) early versions were also available under the Sun Industry Standards Source License (SISSL). was primarily developed for Linux, Microsoft Windows and Solaris, and later for OS X, with ports to other operating systems. It could also read a wide variety of other file formats, with particular attention to those from Microsoft Office. Its default file format was the OpenDocument Format (ODF), an ISO/ IEC standard, which originated with. 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). Sun open-sourced the OpenOffice suite in July 2000 as a competitor to Microsoft Office, releasing version 1.0 on. OpenOffice was an open-sourced version of the earlier StarOffice, which Sun Microsystems acquired in 1999 for internal use. Active successor projects include LibreOffice (the most actively developed ), Apache OpenOffice, Collabora Online and NeoOffice (commercial, and available only for macOS). ( OOo), commonly known as OpenOffice, is a discontinued open-source office suite. exe without JRE) ĭual-licensed under the SISSL and GNU LGPL ( 2 Beta 2 and earlier) If I had that I think I could figure out the weekly and monthly stuff on my own, though if someone could quickly make a template for me to follow that would be great too.Linux, OS X, Microsoft Windows, Solaris ġ43.4 MB (3.3.0 en-US Windows. I'm working with Apache OpenOffice Calc, I'd be very thankful if someone could help me out in any way, just posting some type of formula for the time calculation and maybe a guide for how to format my cells to get everything into workable formats would be great. ![]() Ideally I guess I want to convert it to a decimal format as in one and a half hours is 1.5 hours, I guess that's easier to work with? Additionally once I get past that I'll have to find a way to separate it into weeks (monday to sunday) to calculate the weekly overtime (hours worked - 40 - daily overtime) and then also separate it per month (first to last day of the month) so I can compare it to my paychecks. This is where I'm stuck, I just can't figure out how to get things into good formats etc. I have filled in the total time manually but I would like to set up a formula to calculate it from the start and end times. Daily overtime doesn't count towards weekly overtime, I have 30 minutes break every day I work more than 5 hours. This is what I have right now and shows the format I'm working with.įrom left to right it shows Weekday, Date, Work time, Work start, Work end, total time, overtime for the day and overtime for the week. So I need to calculate it but I'm struggling to set up an excel sheet. ![]() In Norway working more than 40 hours in a week entitles you to overtime pay, but my employer has conveniently "forgotten" to pay me for it. Hi, I'm trying to create a spreadsheet into which I can enter my work times for the past year to find weeks where I worked more than 40 hours. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |