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

learn more… | top users | synonyms (1)

22
votes
3answers
13k views

How to open Mac Keynote presentations on Ubuntu?

How to open Mac Keynote presentations on Ubuntu? Can it be imported to Impress?
19
votes
5answers
5k 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?
17
votes
3answers
23k 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. ...
12
votes
3answers
293 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
1answer
13k 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? ...
11
votes
4answers
21k 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
9k 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 ...
9
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 ...
9
votes
4answers
4k 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
1answer
6k 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 ...
8
votes
2answers
8k 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
1answer
8k 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?
7
votes
6answers
22k views

Is there anything to open .docx documents on Linux (Ubuntu)?

My mother has some serious issues using Windows (viruses, spywares, and so on) and I seriously think about setting up Ubuntu as a replacement. (That would ease my "job" as well) The only concern I ...
7
votes
7answers
4k 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
3answers
7k 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 ...
7
votes
1answer
2k 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 ...
6
votes
2answers
7k 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?
5
votes
5answers
8k 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?
5
votes
2answers
3k views

OpenOffice Vs Microsoft Office 2007/2010 [closed]

I have been asked to summarise the pros and cons in connection with the choices between Microsoft Office Vs OpenOffice. I have a broad idea of what needs to be said. However I would like to open a ...
5
votes
1answer
2k 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
3answers
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 ...
5
votes
2answers
1k 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 ...
5
votes
1answer
4k views

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 ...
5
votes
7answers
6k 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
4answers
59k 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 ...
5
votes
2answers
714 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
1answer
7k 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 ...
5
votes
1answer
118 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
309 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
1answer
286 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
1answer
250 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?
4
votes
5answers
8k 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
2answers
437 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
13k 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
2answers
567 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
3answers
9k 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
891 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
1k 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
1answer
231 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
1answer
529 views

Is there a way to set the default quotation mark in LibreOffice Calc from smart quotes (“ ”) to dumb quotes (the straight kind)?

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 ...
4
votes
1answer
2k 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 ...
4
votes
4answers
3k views

Openoffice.org: Mouse wheel one row at a time possible?

I noticed this in Excel, now in OpenOffice.org calc. One small change in mouse wheel leads to 3 rows (line) change. Is it possible to change in Calc OR/AND in Excel? EDIT: Yes, I know about system ...
4
votes
1answer
294 views

Set a row to follow my cursor anywhere in Calc

How do I make a whole row follow wherever I am in the Calc document when I scroll down/up? I'm looking for something that keeps a row from moving, or to make it stay put. This is so that when I ...
4
votes
3answers
4k 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 ...
4
votes
1answer
328 views

OpenOffice - alternative paragraphs (two PDFs, one source)

I use OpenOffice to produce a document in PDF format. This document is occasionally revised and reissued. I now need to produce a variant of this document with a small number of paragraphs replaced by ...
4
votes
3answers
858 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 ...
4
votes
3answers
4k 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 ...
4
votes
4answers
5k 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
2answers
718 views

What are 'Uno Packages'?

I found several 'uno_packages' folders on my PC. Searching the web, I find several mentions of uno packages, but I can't find a definition or description.
4
votes
1answer
22 views

Removing functions from a column, but keeping data (convert to normal text)?

I have a column that contains the results of a few different formulas. I want to convert all of these cells to normal text, getting rid of the formulas. I know I'm missing something obvious here.