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

learn more… | top users | synonyms (1)

46
votes
3answers
46k views

OpenOffice: get distinct values from column

How do I get a list of all distinct values from a column of values? Basically, this question: Excel: Get distinct values in column but I need the answer for Open Office Calc instead of MS Excel. ...
22
votes
3answers
18k views

How to open Mac Keynote presentations on Ubuntu?

How to open Mac Keynote presentations on Ubuntu? Can it be imported to Impress?
20
votes
5answers
6k views

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?
16
votes
1answer
24k views

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? ...
12
votes
3answers
16k views

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 ...
12
votes
3answers
402 views

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 ...
11
votes
5answers
28k views

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 ...
10
votes
3answers
2k views

Turn off tooltip in openoffice while scrolling?

When I scroll through an Openoffice.org Writer document I have a constant tooltip with page number and (when applicable) the bullet I might be hovering over. It frequently obstructs the text and is ...
10
votes
1answer
12k views

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?
10
votes
1answer
8k views

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

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 ...
10
votes
1answer
5k views

Looking for a very fast to load lightweight csv viewer [duplicate]

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 ...
9
votes
1answer
9k views

How can I do two columns in OpenOffice.org Writer?

I would like to structure my document with two columns in the middle of the page, and one column in the top and in the bottom. Like my example below. How can I do two columns like this in ...
9
votes
1answer
12k views

Copying partial cell to another cell in OpenOffice Calc

Cell A1 says 0001 John Smith Cell A2 says 0002 Bill Snyder I want to basically split this, so one column just shows the numbers (0001, 0002, etc.) and then another column just shows the name. The ...
9
votes
4answers
5k views

Is there a way for elegant source code listings in OpenOffice.org Writer?

I have tried to insert source code as listings in OpenOffice.org Writer, but it just doesn't work in an acceptable way. If space is not enough for an line, it breaks that line automatically into the ...
8
votes
3answers
9k views

Use OpenOffice from command line to convert HTML to RTF

I'm trying to build a bash script in Cygwin that will convert HTML files to RTF. In OS X this is trivial with textutils, but that doesn't exist for regular Linux or Cygwin. Instead I'm trying to use ...
8
votes
2answers
10k views

Converting Open Office (odt) files to Latex

How do you convert Open Office (ODT) documents to tex files? I have made a report using libre office. Now I wish to continue editing the document using lyx (latex front end). So the ODT file needs to ...
8
votes
4answers
76k views

How to open ods files in Excel?

What is the best way to open ods files in Excel 2003? Is there some plug-in available? Should I use some convertor to xls? Or would it be best if I just used LibreOffice (or OpenOffice)? The file I ...
7
votes
7answers
5k views

Alternative to Abiword, LibreOffice or Open Office under Linux

Actually I'm looking for a word processor with the folllowing features : Base Formatting Lightweight Stable & bugfree It should work for common office work on quite old machines. EDIT : It's ...
7
votes
6answers
9k views

LaTeX Equations in MS Word/OpenOffice?

How can I turn something like: \[ H = \sum_{x \in X} p_x \log p_x \] into an image file that can be used to place into a MS Word or OpenOffice Document?
7
votes
4answers
1k views

Math equation formats

I need to store equations in a text file, in a source format that can be converted to something that can be rendered (e.g. mathML). I like the format used in OpenOffice. I don't want to use TeX, or at ...
7
votes
1answer
2k views

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 ...
6
votes
1answer
8k views

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 ...
6
votes
2answers
10k views

In Open Office, make 1st row of data “scroll lock” so it is always visible as you scroll down?

In Open Office, how do you make the first row of data "scroll lock" so it is always visible as you scroll down?
6
votes
2answers
4k views

In OpenOffice Calc, how do I drag and drop cells to insert rather than replace their destination?

I want to rearrange rows with the mouse in Calc. In Excel, I select the whole row, then drag and drop it while holding Shift. This causes the drag and drop cursor to turn into a bar rather than ...
6
votes
2answers
2k views

How to stop OpenOffice/LibreOffice from popping up toolbars when I click on stuff

When I import a picture or a chart into my document and click on it, LibreOffice spawns a toolbar, shifts the whole screen around for a second, and then allows me to move stuff again. It gets very ...
6
votes
1answer
3k views

OOo Display bullet points one at a time

How can I set up slides in my Open Office presentation to display bullet points one at a time? In this case I want to apply this to all bullet points in all slides but I don't mind adding it one text ...
6
votes
7answers
8k views

Which doc format should I use in LibreOffice if other users open it in MS Office

I often share documents with colleagues. I use LibreOffice (and OpenOffice). But my colleagues use Microsoft Office. My documents always look differently when opened in MS Office (.doc and .odt ...
5
votes
1answer
3k views

How do I create a multi-level numbered list with OpenOffice Writer?

I want to create a multi-level numbered (or bulleted) list with OpenOffice Writer. Eventually, I want to have something like this: 1 foo 1 bar 2 foobar 2 bar 1 bork 2 barfoo 3 huh? ...
5
votes
4answers
6k views

Inserting an image into a OpenOffice.org Calc cell

Is there a way to insert an image inside a cell? When I choose "Insert -> Picture" it inserts it so it's floating over the cells. That's not what I want. I want to be able to insert the image into ...
5
votes
2answers
831 views

Is it possible to create a “background bar” for a cell in OO calc?

I have a column in OpenOffice calc which contains number values (between 0 and 40). I'd like to add a bar in the background of the cell which shows the value (to give an obvious visual clue which ...
5
votes
2answers
985 views

Can I import OpenOffice.org settings into LibreOffice?

I'm considering migrating from OpenOffice.org to LibreOffice, and I want to make sure LibreOffice picks up all of the settings and customizations I've made. Will LibreOffice read the user profile ...
5
votes
1answer
123 views

disabling DoWhatIMean behavior in OpenOffice Writer

If I type "2-5" in a table column in OpenOffice Writer, it automagically converts it to 02/05/09. How do I give this program a dope slap and tell it to stop trying to figure out what I mean, and just ...
5
votes
1answer
408 views

How to open an OpenOffice document and scroll to a bookmark?

How to open an OpenOffice document and scroll to a bookmark or chosen page number? Can I do this with the command-line?
5
votes
4answers
5k views

Keyboard shortcut in OpenOffice to incrementally increase or decrease font size?

Is there a keyboard shortcut in OpenOffice Writer that will allow me to incrementally change the font size? If I'm switching between 12 and 14 and 16 often, it would be much easier to be able to tap ...
5
votes
1answer
289 views

Default font and cell padding when opening files in LibreOffice/OpenOffice Calc

I've seen solutions for setting a default font when creating new files. What about a default font (and cellpadding) when opening an existing CSV file? LibreOffice seems to always default to Liberation ...
5
votes
1answer
577 views

How to show full document path in Open Office title bar?

How can I automatically show the FULL PATH of the currently loaded document (not just only the file name) in the title bar of Apache Open Office 4, e.g. OO-Writer?
5
votes
1answer
705 views

Is it possible to remove the hyperlink background in OO Calc?

Hyperlinks in OpenOffice Calc are displayed with a solid background which covers the background color of the cell. I don't want a solid background; I want the background color of the cell to show ...
5
votes
2answers
1k views

Text folding in OpenOffice Writer

I'd like to be able to fold sections of a document in OpenOffice Writer. Is it possible to expand or collapse sections of a document in OpenOffice Writer (or any other word processor?) Many source ...
4
votes
1answer
6k views

How do I insert a newline within a long formula using OpenOffice.org Math?

I've the following formula: (x^6+x^4+x^2+x+1)(x^7+x+1) = x^13+x^11+x^9+x^8+x^7+ x^7+x^5+x^3+x^3+x^2+x+ x^6+x^4+x^2+x+1 = x^13+x^11+x^9+x^8+2x^7+x^6+x^5+x^4+2x^3+2x^2+2x+1 Putting this in ...
4
votes
5answers
11k views

Finding difference in time using OpenOffice.org Calc

I have data in this format: Action (A) | Time logged (B) ---------------------------------|----------------------- 1 |Policy converted successfully | 19-FEB-10 ...
4
votes
5answers
17k views

Batch Convert OpenOffice (ODT) to MS Word (DOC) files?

I have a directory full of OpenOffice.org odt files that I'd like to batch-convert to doc files. Is there an easy way to do this? (bonus points if your answer uses OpenOffice and a Linux ...
4
votes
3answers
4k views

Delete extra page from PDF used for my resume

I use OpenOffice.org to make my résumés and cover letters and there's always an extra page at the bottom that forces me to have to copy all of the contents of it to a new document. How can I remove ...
4
votes
2answers
1k views

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 ...
4
votes
2answers
517 views

Standardizing Font Rendering Across Mac, Linux, and Windows

Is there any practical solution for standardizing the display of fonts across Mac, Linux, and Windows platforms? I work in a small office that uses Windows, Mac, and Linux. We mostly use Openoffice, ...
4
votes
4answers
11k views

How can I convert an OpenOffice document to PDF from the Linux command line?

I have students who, when asked for PDF, sometimes hand me an OpenOffice document or spreadsheet. file(1) can identify these documents, but I've been unable to discover how to convert them to PDF ...
4
votes
4answers
1k views

Spreadsheet forumula questions to pick a random DVD

I have a list of my (279) DVD’s in an OpenOffice Spreadsheet (version 3.3.0) on my Windows 7 laptop and I want to create a formula to randomly pick a film to watch (for occasions when I can’t make up ...
4
votes
1answer
2k views

Freeze both row and column in openoffice calc

how can i use freeze in openoffice calc for both row and column so that 1st row and 1st column will always be visible? :O
4
votes
4answers
9k views

How to create diagram in spreadsheet with dates on x-axis?

I recently became a father to twin boys. Naturally there is a lot of weighing and measuring, and we record these numbers in a spreadsheet. I use OpenOffice.org Calc (but I'm open to solutions for ...
4
votes
1answer
252 views

Is it Possible to not copy all 65,537 cells when copying a column in Open Office

I'm using Open Office 3.01 on OS X. When I select an entire column of data by clicking its header, and the copy that to the clipboard, Open Office appears to copy all 65,537 cells to the clipboard. ...
4
votes
3answers
175 views

Open Office tutorials [closed]

I've been teaching the Open Office suite to adults. I've found some tutorials online, but I don't like them very much. There is always the possibility of doing one myself, but instead I could ...