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

learn more… | top users | synonyms (1)

0
votes
1answer
780 views

Excel/OOCalc: finding rows that have matching values in one field but different values in another

I have a large table (20-30 cols, 10-15K rows). What I need to do is to find the number of rows that match identically in one (or two) particular field(s), but not in another specific field (rest of ...
4
votes
1answer
2k views

How do I copy the results of a calculation without copying the formula behind it? Open Office Calc

How do I copy and paste only the results of a calculation without copying the formula behind it? I'm learning to use Open Office Calc. I remember other spreadsheets that had a values function, or ...
0
votes
0answers
25 views

Combined Open Source Office Suite?

Are there any programs that can combine Inkscape, Scribus, and OpenOffice.org? For example, in OOo, the startup screen has options to create a new document in any of the OOo programs. Is there anyway ...
0
votes
2answers
57 views

Create selected lines into table in Microsoft Word/Openoffice

I want to move the entire content of an MS Word file into a table. The content consists of Objective Questions like: Question 1 a. option1   b. option2   c. option3   d. option4 ...
0
votes
3answers
166 views

Multiple “If” answers in one cell

I am trying to make a fishing tournament spreadsheet.... I would like to perform in once cell that if their position was first, they get 100 points. if their position is second, they get 90 points, ...
1
vote
2answers
787 views

Can MS Word read OpenOffice formats?

I am using Ubuntu 10.04.4 LTS, but am required to produce a document readable by MS Word. Can MS Word read .odt documents, or is OpenOffice capable of exporting into a .doc format so that it is ...
0
votes
1answer
53 views

How is the LOOKUP function named in German? [closed]

The english version of OpenOffice Calc does have the function LOOKUP. How is this function named in German (Deutsch)?
3
votes
1answer
333 views

How can I open a .mdb with a password in OpenOffice?

I'm trying to open a .mdb with a password in OpenOffice Base. I can connect to the .mdb, but I cannot specify a password (forums say this method doesn't support passwords). Is there a way I can open ...
1
vote
1answer
146 views

How to fix document broken content?

I have been sent several files in order to fix them - the issue is that when they are opened you are not seeing the correct text and my cousin is not able to prepare for his exam. So, I have found it ...
1
vote
1answer
438 views

Binary spreadsheets with bitwise operators [closed]

I am looking for a way to easily construct binary spreadsheets using bitwise operators such as SHIFT, AND, OR and XOR. I've looked at Gnumeric but can't find any function that'd allow you to set the ...
0
votes
2answers
60 views

OpenOffice.org Lowercases second capital letter

How can I turn of the feature in OpenOffice.org Calc which converts CCleaner to Ccleaner?
2
votes
1answer
50 views

How can I tell where an OpenOffice Writer document extends beyond set margins?

I am using OpenOffice.org Writer to create a PDF, and have explicitly set margins of 1" all around. CreateSpace, which I am creating the PDF for, has rejected my PDF on the claim that it does not have ...
0
votes
1answer
161 views

Split sheet by rule (filter) in Open Office

I want to split a large sheet. I have different products and for each of them I would like a new file. Is it possible to split the sheet by some rule? P.S. I am new in here, so if my question is ...
1
vote
1answer
391 views

running word count in OpenOffice writer

In OpenOffice Writer 3.4.1 is there a way to show the word count as you type without clicking anything? I'm new with OpenOffice and am use to word.
12
votes
3answers
265 views

Open Office makes my words bumpy

I'm using OpenOffice 3.4.1 on Windows 7, the Writer keeps giving me these weird bumps in my words. Sometimes, randomly, the words I type have little hills and/or valleys of about one pixel. I took a ...
1
vote
0answers
107 views

Is there a way to view a slideshow with OpenOffice Impress with a video embedded beneath the slide content?

I have a video clip I want to add slideshow content in order to gussy it up before producing it, but when I add the clip to OpenOffice.org's Impress software, the video always plays on top of all the ...
0
votes
1answer
50 views

How to apply a page style to a specific set of pages?

I want to split my document in three parts. The first part is the first document which has the style "First Page". The other ones have "Default". Now, I want the appendix to have the "Index" page ...
0
votes
0answers
147 views

Excel/OpenOffice spreadsheet template for expected and actual values

I would like to create a spreadsheet to generate graphs about cost items (anything with a cost, doesn't matter what) in order to have: expected values: these would be created using some formulas ...
1
vote
1answer
79 views

excel / open office - append an incrementing value to all non-unique fields

I have a large table of about 7500 store names. I need to search through those names and, if they are not unique, append an incrementing value, for example: store_1 store_2 etc. Anyone know how to ...
2
votes
1answer
102 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
827 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
517 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
99 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
66 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
357 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
404 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
933 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 ...
1
vote
0answers
279 views

Difference between Libre Office and Open Office [closed]

What's the difference between Libre Office and Open Office. Ubuntu 12.04 is shipped with Libre Office and before that all versions 10, 9, 8 were shipped with Open Office. If Libre Office is better ...
2
votes
1answer
764 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 ...
2
votes
1answer
3k 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
366 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
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
76 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
66 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
694 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
225 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 ...
3
votes
2answers
403 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
517 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
3k 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
206 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
217 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
198 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 ...
4
votes
6answers
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
2k 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
276 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
235 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
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 ...