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

learn more… | top users | synonyms (1)

2
votes
1answer
1k views

Professional templates pack in LibreOffice

I have installed the Professional Template Pack II - English OpenOffice.org extension in LibreOffice 3.5.5.3 on Windows 7. However, when I try to select a template, I don't see anything new. Is the ...
1
vote
1answer
79 views

How do I turn off auto correction?

When typing text in a spreadsheet I don't want the program to change anything I write in a cell. Eg "IEx" should not be translated to "Iex".
-2
votes
1answer
74 views

OpenOffice Writer page style bug?

I have a large Open Office odt document. It uses (mostly) four page styles: Left Page, Right Page, Left Chapter, and Right Chapter. The last two are custom styles that simply remove the header. But I ...
4
votes
2answers
894 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 ...
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 ...
4
votes
2answers
568 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 ...
0
votes
1answer
634 views

How to remove Unicode characters and/or convert OpenOffice spreadsheet cells to plaintext?

I have an OpenOffice spreadsheet into which I occasionally copy/paste snippets from web pages. However, I need the file, as a whole, to be free of fancy formatting and non-ASCII text. Is tried ...
-1
votes
1answer
4k views

Calculate age in days/months/years in OpenOffice

In need to find the age in days - months - years in OpenOffice. There is DATEDIF() in Microsoft Excel. You can use it to find the difference in days/months/years between two dates. Age Calculation ...
3
votes
3answers
2k 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 ...
2
votes
1answer
231 views

Command line utility for the LibreOffice Mythes library

(Open|Libre)Office provides a thesaurus using the Myth library. Is there a command line tool to access these thesaurus data ?
2
votes
0answers
234 views

How are the 2010 OpenDocument Text (.odt) from OpenOffice and the 2012 one from LibreOffice different?

As you probably know when you're reading this question, an .odt file is just a .zip file containing some folders and .xml files. I used to appreciate this, for I could make a document with keywords ...
0
votes
2answers
2k views

Libre Office (or Open Office) create a Writer template with image background

I am seeking a Writer-type application that will allow me to set an image page background (for stationery papers) and save it as a template. I have Libre Office right now and I choose ...
0
votes
1answer
219 views

.ppt file created on a Mac using PowerPoint 12 can't be opened in OpenOffice or NeoOffice

Is it possible to save a file in Microsoft PowerPoint 12 in a format that can be opened by OpenOffice or NeoOffice? I get the error message "Input/output error" when I try to open the file with ...
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 ...
1
vote
1answer
3k views

How to open/import a local HTML file in OpenOffice writer? (as rich, not plain, text)

I'm completely puzzled - I'm sure I've done this before, but now I fail. I have a local .html text, which opens up in Firefox just fine. Then I try to open the same file in swriter (or lowriter); ...
1
vote
1answer
335 views

Unlink chart from data series in OpenOffice Calc

Is it possible to create a chart on a data series in Calc, and then unlink it so that if I sort that same data a different way, my chart wont change? i am trying to show some trends based on several ...
1
vote
2answers
241 views

Is there a Microsoft Office alternative for Linux that allows users to retain the formatting as is?

We have been migrating several PCs, laptops, etc to Linux and one of the most common issue we have is with users attempting to format documents previously created with Microsoft Office of varying ...
0
votes
0answers
458 views

sal3.dll error message when launching OpenOffice on Windows Vista

I installed Open Office 3.3 on my computer running Windows Vista (Home Premium). I did so after system restoration, and because OpenOffice 3.2 could not be reinstalled (NSIS error), so I downloaded ...
0
votes
1answer
150 views

How do I get “Open Office” menu items to appear in English?

I'm using my boyfriend's computer, so Open Office is in Japanese. Do I need to un-instal the Japanese version to be able to work in English? or is there a setting I can change?
0
votes
1answer
104 views

Referncing a cell, based on a cell's value in Spreadsheet

I understand how referencing a cell works, example being =Sheet1.A1 However, if I'm in Sheet2 and cell B1 contains Sheet1, and cell C1 contains A1. Is there any way to write the reference such ...
1
vote
1answer
918 views

OpenOffice 3.3.0 menu entry “Send -> Document as e-mail” does not work with Zarafa Web-Client

We have a Windows XP SP3 (German) with OpenOffice 3.3.0 installed and use Zarafa as Groupware. We modified the registry in order to set Zarafa WebAccess (Browser -> website) as the default mail ...
2
votes
1answer
1k views

OpenOffice: Replace text with new-line

In my OpenOffice spreadsheet, there are cells containing "\n" text. Each "\n" occurrence needs to be replaced with a new line or line break. The Find-and-Replace dialog does offer regular ...
0
votes
0answers
253 views

Can OpenOffice avoid most Microsoft VBA virus?

Our office often get infected with VBA virus (don't know why). We have encountered VBA virus that inject macro to excel sheets, there have been macro that run whenever a new excel sheet is open etc. ...
2
votes
2answers
1k views

Is there a subversion plugin available for LibreOffice/OpenOffice similar to MagnetSVN?

I recently came across the plugin, MagnetSVN, for MS Office which allows for svn interaction directly from MS Word. I'm looking for something similar for LibreOffice and/or OpenOffice. I came across ...
0
votes
1answer
257 views

Writer: Highlight matches

LibreOffice 3.4 seems to have a simplified Search toolbar instead of the old popup dialogue. This toolbar does not have a "Highlight matches" function, nor can I find such an option or button to add ...
2
votes
2answers
2k views

OpenOffice “Java framework” Error in function createSettingsDocument (elements.cxx)

I have a problem with my openoffice.org on a RedHad version of linux. OpenOffice is successfully installed and from the command line if I run the following as root I get: [root@s15548792 ~]# ...
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 ...
1
vote
1answer
792 views

Remotely control Powerpoint/OpenOffice Impress over network

I need to remotely control a Microsoft Powerpoint or OpenOffice.org Impress presentation over the network. I am having a presentation running and I won't have physical access (and I cannot use an IR ...
2
votes
2answers
161 views

End comment mode via keyboard shortcut in OpenOffice.org Writer

To enter comment mode in Writer one can use a shortcut Ctrl + Alt + N. However, to end the comment I seem to be forced to utilize my mouse. How can I avoid the mouse?
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 ...
1
vote
1answer
33 views

OpenOffice Writer - Apply same style

I have a chunk of text that has style "JBody" (custom). However JBody is defined with Times New Roman, and the text is using Arial. When I select the text and click JBody (again) -- nothing happens. ...
1
vote
1answer
64 views

Comments grey in OpenOffice

I want to read comments in documents someone else edited with Word and saved as rtf Everything shows except comments. The Comments option in my OpenOffice View menu is grey and so is the Comments ...
2
votes
1answer
128 views

how can i insert plain words into a open math equation?

Question: How do i use keywords in open math equations as the words not the symbols they represent? Info: I'm trying to write up a proof in open Math, it goes well until I try to say something like ...
3
votes
1answer
581 views

Memory Issue using OO (soffice) as batch conversion service

I have a Java Web Application that uses an OOo instance (on the same environment) started in headless mode as batch converter. environment is RHEL 5.5. The OpenOffice version is 3.1. I've run some ...
0
votes
1answer
2k views

How do I determine the version of OpenOffice from the command line in Ubuntu and OS X

How can I determine which version of open office is installed? I'd like to be able to issue this command on an Ubuntu machine as well as a Mac OS X machine.
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 ...
0
votes
0answers
209 views

OpenOffice3 with 32bit JRE in CentOS6 64bit

I want to know if it is possible and how to install headless Open Office 3 with 32 bit JRE on CentOS6 64 bit. I need to set it in $HOME directory on Webfaction hosting. Open Office they already ...
0
votes
1answer
1k 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
416 views

Are there clip arts for LibreOffice or OpenOffice?

Is there a standard set of clip arts for LibreOffice (or OpenOffice), like the ones coming with Microsoft Office? I am running Debian and LibreOffice from the standard repository, if it makes any ...
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 ...
5
votes
1answer
310 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?
1
vote
3answers
2k views

Convert ZIP code to state in OpenOffice

I'm trying to move data from two of our old systems into a new system. Problem is, somewhere along the line the 'state' column of our DB was corrupted. I have a column of ZIP codes I need to ...
2
votes
1answer
880 views

Automatically insert citations as hyperlinks to their respective bibliography entry in OpenOffice?

I have found out how to do that manually for each citation: unlock the bibliography for manual editing Insert → Bookmark before each entry then for each citation Insert → Hyperlink with the ...
1
vote
1answer
4k views

OpenOffice Calc - how to insert BLANK in a formula?

In Calc, as in most spreadsheet applications, an IF() function exists that can be used to control behaviour, for example inserting this formula in cell C1. =IF(A1>B1;"A";"B") will display A in ...
2
votes
1answer
759 views

Word 2010 content control compatibility with OpenOffice

I have documents created in Word 2010 with plain text content controls which are used as templates for letters. However when I open the documents in OpenOffice 3.3 Writer the text in these content ...
4
votes
2answers
719 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.
2
votes
1answer
759 views

How can I bypass the import dialog when opening CSV with OpenOffice?

A (Python, but that's not really relevant) script I'm writing will issue a command line call to open a CSV file with OpenOffice (OO). I need OO to skip over the import dialog box while opening the ...
3
votes
2answers
2k views

How to change an image resolution in Libre Office or Open Office?

I have a odt file with many heavy images and to be friendly with some one i want to forward the odt i want to decrease the images resolution by hand. How to do it?
1
vote
0answers
411 views

How can I create a PDF with form fields from a collaboratively edited source document?

I want to create a PDF document with a fill-in form. The source of the document is right now Google Docs, so that my team can edit it collaboratively with ease. However, Google docs doesn't support ...
0
votes
2answers
159 views

OpenOffice crashes after I run it after installation

I've installed OpenOffice 3.2.1 on Linux s390x System z server after downloading the OOo_3.2.1_Linux_S390X_install-rpm_en-US.tar.gz file from http://download.openoffice.org/other.html. I installed it ...