Super User
Super User

Questions tagged [openoffice]

Open source application suite that includes Writer, Calc, Impress, Base, Draw and Math

OpenOffice is an open source office application suite. It consists of the following programs:

  • Writer - Word processor similar to WordPerfect and Microsoft Word
  • Calc - Allows users to create and edit spreadsheets
  • Impress - Presentation program along the likes of PowerPoint and Keynote
  • Base - Database management system
  • Draw - Vector graphics editor akin to Visio and CorelDRAW
  • Math - Program to create and edit mathematical formulae similar to Microsoft's Equation Editor

History

OpenOffice.org, which has been discontinued, was an open-source version of the earlier StarOffice, which Sun Microsystems acquired for internal use. After acquiring Sun, Oracle Corporation continued developing OpenOffice.org, but on a much reduced scale. The majority of outside OpenOffice.org developers left the project to form The Document Foundation. TDF released the fork LibreOffice, which most Linux distributions soon moved to. Oracle donated the project to the Apache Foundation, which still develops the project under the name Apache OpenOffice.

588 questions
90
votes
5 answers

OpenOffice: get distinct values from column

How do I get a list of all distinct values from a column of values? Basically, this question: How do I get the distinct/unique values in a column in Excel? but I need the answer for Open Office Calc instead of MS Excel. I'm using Open Office 3.2
David Oneill
  • 2,678
46
votes
5 answers

How to open Mac Keynote presentations on Ubuntu?

How to open Mac Keynote presentations on Ubuntu? Can it be imported to Impress?
takeshin
  • 2,243
42
votes
1 answer

How NOT to print sheet name and page number in OpenOffice.org Calc?

When I print a spreadsheet in OpenOffice.org Calc (latest version), it keeps adding the name of my current sheet to the top, and a page number to the bottom of my print out. How do I turn this off? P.S. I am running it on Mac OS X 10.6.4 Snow…
hpy
  • 6,261
27
votes
3 answers

Copying just text, not formulas, in OpenOffice Calc

How do I copy and paste the text (not the formulas) from one Calc sheet to another in OpenOffice?
kelly
27
votes
1 answer

Preventing LibreOffice from using smart quotes (“ ”) instead of (dumb) straight quotes?

I use LibreOffice Calc to make lists of programs with different parameters to run on an hpc cluster. For each batch of commands I must do a find and replace on the smart quotes, as they cause errors in command line arguments. It would be nice to cut…
tweirick
  • 443
27
votes
4 answers

OpenOffice: Delete rows based on cell value

I've got a rather large spreadsheet that I need to filter some rows out of. In the spreadsheet, all rows whose M-Column doesn't equal "on" must be removed. I applied a filter, and re-saved the document, but that kept the unwanted rows - how can I…
Sampson
  • 7,378
24
votes
3 answers

How to merge 2 columns into one in LibreOffice or OpenOffice?

In my CSV, I have two columns which are really just one column, so I want to concatenate the content of these two columns - for each row - into the first one(after this I want to remove the extra column)? I use Mac, so I use LibreOffice and…
Vladimir Despotovic
  • 366
22
votes
6 answers

OpenOffice vs LibreOffice - what's the difference?

I'm considering switching from Microsoft Office (too expensive) to an open-source option. What's the difference between OpenOffice and LibreOffice?
Kyle L
  • 2,379
12
votes
2 answers

Move rows with the keyboard in Calc

How might one move a row to a different location with the keyboard? I have found this guide for the mouse but due to disability I have trouble using the mouse for this. Note that I am not looking to 'sort manually' and using an extra 'sort ordinal'…
dotancohen
  • 11,720
12
votes
1 answer

How do I copy the results of a calculation without copying the formula behind it? Open Office Calc

How do I copy and paste only the results of a calculation without copying the formula behind it? I'm learning to use Open Office Calc. I remember other spreadsheets that had a values function, or simply a menu choice to paste values instead of the…
toolman
  • 121
12
votes
3 answers

Open Office makes my words bumpy

I'm using OpenOffice 3.4.1 on Windows 7, the Writer keeps giving me these weird bumps in my words. Sometimes, randomly, the words I type have little hills and/or valleys of about one pixel. I took a screenshot and blew it up so you can see what I…
Lincoln Bergeson
  • 1,004
12
votes
1 answer

Open Office Calc: Convert a date to timestamp

I have a column with dates in M/D/Y like this: 8/8/2007 8/9/2007 8/10/2007 8/13/2007 8/14/2007 8/15/2007 8/16/2007 I would like to convert them to a unix timestamp (in a new column). Would anyone know how I can do that ? Thank you
Andrei
  • 493
12
votes
2 answers

auto-replacing my dash makes me sad

I am working in Open Office Writer 3.3.0 and I have come across something a bit odd. When I write a semi-mathematical formula my "-" gets replaced by a "–", a slightly longer dash, and I cannot seem to turn it off in the autocorrect. I am not sure…
Sier Bahnn
  • 131
12
votes
5 answers

How do I stop Open Office from automatically changing the date format?

I am trying to enter a date in a document with the following format: 1 September 2010 However, OpenOffice insists on changing it to: 01/09/10 I've looked in the AutoCorrect options and elsewhere and have been unable to find a way to disable this…
Dan Dyer
  • 324
12
votes
1 answer

Looking for a very fast to load lightweight csv viewer

Possible Duplicate: light text editor for csv file? (on windows) I frequently need to open csv files just to have a look at what is inside and what its structure is. I also may need to find a text string and possibly edit a typographical error. I…
IThink
  • 467
1
2 3
…
39 40