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

learn more… | top users | synonyms (1)

1
vote
2answers
416 views

open office document conversion uses 100% CPU

When I try to convert a word document using the ooextract python script from open office like /usr/local/bin/ooextract.py myDocument.doc myDocument.pdf the open office deamon (sOffice.bin) takes ...
1
vote
1answer
134 views

Populating Writer document with spreadsheet (Calc) as data source

I have one page (in Writer) that contains 4 the same boxes (business cards) with label as field from spreadsheet. During print i get the same record from spreadsheet per page (on first page is record ...
0
votes
0answers
144 views

How to calculate stuff in OpenOffice Formula

Is it possible to do a calculation in OpenOffice formula? (It should be able to understand "cdot" as times, "over" as divide, etc.) Note: Not OpenOffice calc, but OpenOffice formula.
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 ...
3
votes
1answer
2k views

How do I make a random selection in a spreadsheet using more than one criteria

I have a spreadsheet created in OpenOffice (V3.3.0 in Windows 7 32 bit) that I use as a database of my DVD collection. After asking a question in SuperUser, I have it so it can pop up a random title ...
2
votes
1answer
3k views

How do I use conditional formatting in a spreadsheet based on dates?

I have a spreadsheet in OpenOffice V3.3.0 (used in Windows 7 32 bit). One column contains dates (in the format: 14 August 2011 ) and I want to use conditional formatting on those cells depending on ...
0
votes
1answer
38 views

Producing PDFs with non-Latin characters using OpenOffice.org Writer

I am using OpenOffice.org Writer, I can't export a document with non-Latin languages into a PDF file. All the characters disappear. Any help is appreciated. Thank you.
3
votes
1answer
69 views

OpenOffice migration: supported Office document formats?

We're considering a number of migration options for OpenOffice at the moment. Can anyone confirm if OpenOffice is capable of opening and converting all of the following Office file formats? doc ...
1
vote
1answer
852 views

how do I set default formatting with openOffice?

I type a lot and i like to have the background black and the text a soft green or gray. I can see how to change the background and text color for one document but i would like to set this up as the ...
2
votes
0answers
245 views

Separating text and links from a hyperlink in OpenOffice

I have a list of bookmarks which is converted into an OpenOffice spreadsheet. Now I want to separate the link URL and its text separately into two columns. Is there any method to achieve this?
1
vote
1answer
979 views

How to copy from PDF and paste to Open Office Writer on Linux?

When I try to copy a small portion of PDF that contains a graphic like a table or like a syntax highlighted program code listing, the writer only paste text context and even removes formatting/white ...
4
votes
2answers
433 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, ...
0
votes
1answer
2k views

How to remove a Page Break in a .docx file that was converted from an .odt file?

I recently converted an OpenOffice .odt (word-processing) file to an MS Word 2010 (.docx) file. The .odt document contained a page break. The page break appears in the .docx file in MS Word, but ...
-4
votes
3answers
140 views

Choosing office suite

Microsoft Office is not free. OpenOffice is free but really slow. IBM Lotus Symphony is free but really slow. What's the solution? EDIT: Is there any fast and free office suite?
2
votes
1answer
217 views

OpenDocument Presentation Viewer

In lines of Powerpoint Viewer from Microsoft is there any free viewer for Open Document Presentation(ODP) files? I prepare my presentations in LibreOffice in Ubuntu and am looking for an option to ...
0
votes
1answer
296 views

OpenOffice Calc getting slower and slower

I am running OpenOffice 3.2.0 Calc on my Ubuntu (10.04) desktop. I have a huge data entry task to complete today and Calc is getting slower and slower moving between cells on the sheet. When I rename ...
0
votes
1answer
25 views

Numbering to the right end of page

How can I put the content (like formula, figure) numering to the right edge of the page? I've seen it in many places, but can't seem to find how to do this the right way in OpenOffice.org writer. ...
1
vote
0answers
521 views

Copy “true” value from OpenOffice (for pasting in external app)

Is there some way to get OpenOffice Calc to copy the real value stored/calculated in a cell. I realize it must still be text, but is there some way to get OpenOffice to copy a higher precision value ...
1
vote
3answers
1k views

Is there a free Powerpoint to PDF converter that preserves mathematical formulae?

I'm on a Mac. I tried using OpenOffice, but mathematical symbols often get mangled.
1
vote
1answer
205 views

Mass-replace in a bunch of Word files?

Is there a way to do string replacement automatically in a large number of Word files? Bonus points if your answer includes a way to do it for OpenDocument files as well!
1
vote
1answer
1k views

Document structure navigation in LibreOffice/OpenOffice

Is there "Document structure" toolbar in Libre Office or Open Office? I would like to navigate documents inside Libre Office or Open Office by document structure (table of content) like I can do in ...
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 ...
1
vote
1answer
5k views

How to print word documents with comments using OpenOffice?

I received a word document that contains comments which are shown to the right of the page. When I print the document the comments are not printed, whereas the changes in the text are. How can I also ...
0
votes
1answer
675 views

open office - How to make a click on a line in an index of a document take me to the paragraph itself?

I am using OpenOffice 3.1.1 I have an index and I want that every click will take me to its paragraph.
2
votes
1answer
571 views

Copy only cell content in OOCalc

In OOCalc, when I copy a cell with ctrl-c ctrl-v, it copies everything, also the style, from source to destination. However, I want to copy only the content, leaving the formatting of the destination ...
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 ...
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 ...
4
votes
2answers
728 views

How can I split a formula into multiple lines in OpenOffice calc?

I have this simple formula: =CONCATENATE("foo";"bar") which renders foobar on the cell. How can I lay this formula in multiple lines in the same cell? I'd like to be able to do something like the ...
2
votes
1answer
5k views

How to conditionally highlight cells in OpenOffice Calc?

I have a big chunk of data in an OpenOffice spreadsheet. To make real information standout more, I would like cells with an absolute value over a certain threshold to be highlighted in red. Is there ...
2
votes
2answers
2k views

Referencing equations in LibreOffice/OpenOffice

Equations in LibreOffice (OpenOffice) can be autonumbered. How can I reference equations in text by that numbers so when equation numbers then references in document updated automaticaly. For example ...
2
votes
1answer
776 views

Remove “auto-corrected” line (---, ***) in OpenOffice.org Writer

this question answers the question on how to stop the line from being autocorrected from ---. I don't have a problem with that. I'm having a problem with a saved document containing such a line that I ...
3
votes
1answer
1k views

What is the best document standard to save to using Open/LibreOffice in order to maintain compatibility with Office?

For some reason I've always assumed the older formats (Office 2007/XP) DOC/XLS were the safest to maintain compatibility with Office simply due to them being aged and likely more mature, however I've ...
2
votes
2answers
703 views

LibreOffice/OpenOffice vs. MS-Office

What is the difference between them? ...I mean like if I create a document under MS-Office, what problems could occur if I want to edit it later with ooo.org?
3
votes
2answers
400 views

How do I access the search functionality in Open Office?

I am very new to oo and plodding slowly; never used a spreadsheet, etc.etc. I downloaded a document of botanical names for flowers/herbs, etc. The page was set in 3 columns and was 138 pages long (!) ...
1
vote
0answers
159 views

Opening .odf requires admin rights?

One of our users and one of her colleagues is getting an error when opening an ODF file (open office word), something about XML and then a second error message asking to repair the file (which does ...
0
votes
1answer
423 views

Count the number of contiguous empty cells at the end of a row

I have rows of data, some cells are empty and some contain a number. I need to identify how many contiguous empty cells exist at the end of each row. I've tried using a string of nested IF ...
0
votes
1answer
3k views

Changing UI language in OpenOffice.org

I'm trying to change the language in OpenOffice.org from German to English. However when I go to: Optionen > Sprachen (Options > Languages) the only possibility is German. How do I add ...
1
vote
0answers
117 views

What memory settings make a reasonable compromise for OpenOffice?

Regarding the settings at the OpenOffice dialog: Tools - Options - OpenOffice.org - Memory I'm on Ubuntu 10.10 and I have 4GB on a 2.8GHz quad core x86-64 architecture machine. I would consider my ...
1
vote
2answers
602 views

Make OpenOffice Portable the Default Program?

How do I make OpenOffice.org portable be my default document viewer on Windows?
1
vote
0answers
63 views

Different fonts for different weights in OpenOffice.org

I want the default font to be Gentium, but its bold is incomplete, so I want bold and bold-italic to be Gentium Basic. I want to have it set as the default font every time and not manually per usage. ...
0
votes
1answer
659 views

How to reformat text ignoring explicit line breaks in OpenOffice?

Quite often I find myself inserting text files in OpenOffice Writer documents, then spending inordinate amounts of time reformatting the result. The problem is that those text files contain newlines, ...
1
vote
1answer
58 views

How to change numbering of attachments

I am making bachelor thesis in Open Office and I wonder how to change numbering, which I use for marking headlines, to lettering in attachements. When I change numbering in attachements to lettering, ...
0
votes
2answers
403 views

Delete table in Writer but preserve the contents

Is there a way to "explode" a table in OpenOffice.org Writer? That is, delete the table, but preserve its contents in the document?
1
vote
3answers
1k views

Problem with running open office from the command line

Yesterday I installed OpenOffice on my Linux server. But when I go to run it through the command line, it says command cannot be found. I've also tried other things like OOWriter, etc. Has anyone had ...
1
vote
1answer
73 views

Reference a different part of the document and have it automatically update?

In my open office document I occasionally have little notes saying something like (see p31). Is there some way I could insert some kind of anchor for these so that they automatically update if I add ...
0
votes
0answers
76 views

OpenOffice autocorrect glitch

When entering the string "Jan" in Openoffice.org Calc, it is immediately replaced by "jan". This also happens if I Set the format of the cell to "text" Add an autocorrect-rule saying "jan" should be ...
1
vote
0answers
44 views

OpenOffice Styles & Formatting Preview?

Is there any way to "preview" a style in OpenOffice 3, like you can in Word? I mean, can you make the name of the style actually be shown in its own style and formatting?
0
votes
1answer
2k views

OOo Sheet: Keep one cell reference constant when copying formulae

First, I'm not sure if this is the right StackExchange site to be posting this on, although I've looked for better ones and couldn't find one. Anyway, my question is this: how can I keep a cell ...
0
votes
1answer
151 views

page-specific bullets in openoffice impress

I need to switch the bullets in an openoffice impress slideshow. In one page I need the "normal" round ball, in another I need a check sign, in another I need the x sign. What I do is select the list ...
0
votes
0answers
92 views

What's the proper way to use each style in office suites?

In LibreOffice 3.3, the default range of paragraph styles include the following: "Addresse, Bibliography, Caption, Complimentary Close, Contents…" and character styles include: "Bullets, ...