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

learn more… | top users | synonyms (1)

12
votes
2answers
13k 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?
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 ...
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 OpenOffice....
8
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 ...
1
vote
2answers
110 views

To apply Monaco -font to all header_1s in a master document in OO

This question is based on this thread. I would like to apply Monaco -font to all header_1s in a master document in Open Office 3. I have tried to change the Header 1 in Styles and Formatting ...
48
votes
3answers
51k 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. I'...
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 ...
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 ...
18
votes
1answer
26k 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? ...
2
votes
2answers
2k views

Using Ctrl+V to paste unformatted text by default in OpenOffice.org's Calc

Is there a way to change the Ctrl+V command in OpenOffice.org Calc to paste unformatted text? There is Ctrl + Shift + V, which puts up a dialog. But that is too much work. I just want to change 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 ...
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?
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 ...
2
votes
1answer
485 views

OpenOffice Writer default to Web Layout

Is there a way to get OpenOffice Writer to always open documents in Web Layout? Or, at least properly respect the view of the document? That is, if a document was in Web Layout when saved, then ...
2
votes
1answer
88 views

Dragon Naturally Speaking 10 enters bad characters in certain text editors in Windows XP

I use DNS 10 in Win 7 without any problems for dictating in office XP and office 2007. I have installed it too on a computer under WinXP and there, with office XP and office 2003 it enters wrong ...
2
votes
2answers
2k views

Database access through odbc driver and excel

Is it possible to access a database via ODBC and access this in MS Excel or OpenOffice, then exporting the database into a flat file? The program I am accessing data only allows an ODBC connection in....
2
votes
1answer
732 views

OpenOffice “line” for asterisks…how to delete the !#$ thing?

Silly question maybe but I'm tired of looking through the options to get rid of it. In open office, if I add a few ** in a line and hit enter, a bar appears. It seems that I can't turn it off, and I ...
2
votes
1answer
51 views

How to make a 3 column chart with dividers using openoffice

I'm interested in making a chart someone like the photo above using open office. Any idea how to go about this?
2
votes
1answer
1k 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 ...
1
vote
3answers
2k views

Unable to run openoffice in headless mode

I want to automoate some PPT -> PDF conversions, so I want to run openoffice in headless mode for scripting. On my machine with X running I can start opemoffice in headless mode via soffice -accept=...
1
vote
0answers
805 views

Why recovered .xls and .doc files show as symbols?

I formatted an NTFS drive (and re-installed windows) which had some important .doc and .xls files, I used 2 recovery software and both recovered my files but seem to be corrupt, when opened they ...
1
vote
1answer
376 views

To make a table of contents for many .odt -files

I have about one hundred files in Open Office's .odt -format such that 1 chapter 2 chapter ... 100 chapter I would like to make a table of contents for these files. However, the problem is that ...
1
vote
2answers
566 views

How to save table cell's background colour and styles of border line (OO.Org Writer)?

What I want I want to reuse table format by styles, but only table's text format is saved. How I try to do it How I save table style: I select cells styles and formatting > new style from ...
1
vote
0answers
183 views

How to embed (not insert) MP3 in OpenOffice Impress

My question is similar to this, Photos and Animated .gif disappear in Open Office Impress But unfortunately when I go to Edit, the Links option is greyed out. Is there another way to embed mp3 files?...
1
vote
1answer
3k 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 ...
0
votes
1answer
212 views

Photos and Animated .gif disappear in Open Office Impress

I use Open Office on Windows 8. When I create Presentation using Impress, I insert photos and animated .gifs. However, if I move that Impress presentation, or delete the referring photos and ...
0
votes
2answers
661 views

Linked code, syntax highlighting, frames, and captions

I would like to do the following: Link to external source code file (for example a SQL script in ASCII format) Automatically apply syntax highlighting to the imported text Place the highlighted text ...
0
votes
1answer
2k views

Batch rename multiple bookmarks in Word .docx file

Is it possible to rename multiple bookmarks in standard Word 97-2003 doc file? I just finished a 400 page document, in Word 2010, with several hundred bookmarks that must be renamed and I definitely ...
0
votes
1answer
488 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
82 views

Include the URL of all hyperlinks in the document's text

In an effort to go "all txt" I need to find a way to make the links in .doc files visible in the text, so that the URLs will remain accessible when I paste the the text into .txt documents. Will any ...
0
votes
1answer
4k 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 ...