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

learn more… | top users | synonyms (1)

0
votes
0answers
422 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
138 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
103 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
870 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
885 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
223 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
997 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
214 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
72 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
684 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
142 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
53k 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
31 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
56 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
116 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
515 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.
3
votes
1answer
292 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
206 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
876 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
392 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
809 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
283 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
1k 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
791 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 ...
0
votes
1answer
3k 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
693 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
611 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
610 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
1k 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
363 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
151 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 ...
1
vote
1answer
3k views

How do I create a line graph which ignores zero values?

I want to create a graph showing trends over time, calculated from a formula of various data. However, some data is missing, resulting in zeroes in the calculated data which the chart uses. When ...
2
votes
1answer
705 views

Enable logging for OpenOffice daemon sOffice.bin

We have problems converting a document with the openoffice daemon sOffice.bin. Where can I find / enable logfiles for this process?
1
vote
2answers
384 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
122 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
137 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
1k 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
2k 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
67 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
719 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
233 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
823 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
407 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
138 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
199 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 ...