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

learn more… | top users | synonyms (1)

2
votes
1answer
114 views

Tagging or defining automatically in an Excel or Libre office spreadsheet?

I want to review and sort my expenditures in a spreadsheet where I have all my transactions listed. Is there a way to automatically label or tag to categorize the transactions like in a budget ...
0
votes
1answer
2k views

Set row delimiter in Excel

How can I use row delimiter other than \n? CSV fields contain \n and the row delimiter is \n\n\n\n, to separate line breaks in fields from the row delimiter. I'm using Excel 2010, and in need to ...
-1
votes
1answer
794 views

How can I turn off auto-completion in word processing apps?

In both Word and Open Office, these word processors try to be clever and guess where you want to indent, or automatically complete a word you've started to type. In my experience, they are wrong a ...
0
votes
1answer
120 views

OpenOffice partial cell in-between value copy function?

I have a very long worksheet list with contact information of various companies and I need to create usernames for them, so I would use the middle part of their website URL for those. For example, in ...
0
votes
1answer
83 views

How do I search for a fixed date field in OpenOffice Writer?

Apache OpenOffice.org writer 3.4.1. I have a large file with many fixed date fields. (Menu: Insert/Fields/Date, and/or AutoText from such a field.) How do I search by field value? The Find (Find ...
2
votes
0answers
26 views

Indextable numbering space

There is no space between the outline numbering and the TEXT in my Table of Contents. My heading styles 1 - 3 have bullets_and_numbering/position/minimum_space_numbering<->text 0,38cm but the ...
2
votes
0answers
574 views

OpenOffice Calc weighted average

I need to find the result of ((C1 * 5) + (C2 * 4) + (C3 * 3) + (C4 * 2) + (C5 * 1))/(5*6/2). I need to do it for 200 columns, not only 5. I currently use two sheets with sheet 2 containing a ...
1
vote
0answers
460 views

OpenOffice, LibreOffice and NeoOffice all crashes on startup on OSX LIon

I tried all new versions of LibreOffice, OpenOffice, NeoOffice. When I install them without any problems and then I try to launch them, I get the following error: Process: soffice.bin [1178] ...
2
votes
2answers
2k views

OpenOffice Calc - Highlighting the higest value in a column

So I've got this spreadsheet open using OpenOffice Calc (ver 3.3.0) and its set up a little like this: A B C D 1.name quantity price total 2.foo 10 ...
2
votes
1answer
1k views

OpenOffice Base locked

I ran into an issue with my open office base file. It appears to be locked (I have file.odb and file.odb.lck). Now I can open the base file, but as soon as I select Tables it crashes on me and when ...
3
votes
1answer
6k views

Open Office Calc: Convert a date to timestamp

I have a column with dates in M/D/Y like this: 8/8/2007 8/9/2007 8/10/2007 8/13/2007 8/14/2007 8/15/2007 8/16/2007 I would like to convert them to a unix timestamp (in a new column). Would anyone ...
2
votes
2answers
441 views

Opening .docx, .pptx etc.. file formats?

Other than Microsoft Office is there any other Software Package available for Windows that is completely free and can also open .docx, .pptx, .xlsx etc... file formats?
2
votes
1answer
2k 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".
-1
votes
1answer
77 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 ...
5
votes
2answers
1k 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
348 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
719 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
689 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
3k 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
244 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
246 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
233 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 ...
6
votes
7answers
7k 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
4k 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
387 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
242 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
493 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
160 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
106 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
940 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
289 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
291 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
79 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
879 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
165 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?
6
votes
4answers
64k 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
69 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
138 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
643 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
3k 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
361 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
210 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 ...