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

learn more… | top users | synonyms (1)

2
votes
1answer
393 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 ...
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. ...
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
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?
1
vote
1answer
277 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
2answers
107 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 ...
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 ...
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 ...
2
votes
2answers
1k 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 ...
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 ...
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?
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
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 ...
2
votes
1answer
77 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 ...
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 ...
2
votes
1answer
250 views

Multimedia keys don't work in Foobar2000 when LibreOffice is in focus (Winamp is not affected)

Multimedia keys are ignored while focus is on Calc from LibreOffice. Media keys work in foobar when it's focused, also while other programs are focused. I use Windows 7 Home Premium SP 1. My Foobar ...
2
votes
1answer
801 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 ...
2
votes
1answer
635 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 ...
1
vote
0answers
428 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
3answers
1k 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 ...
1
vote
1answer
357 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 ...
0
votes
1answer
73 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
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 ...
0
votes
2answers
542 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 ...