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

learn more… | top users | synonyms (1)

0
votes
2answers
34 views

Where can I find a zip.exe (that works in Windows 7)?

I am trying to get the OpenOffice SDK installed. Its requirements are a number of programs I ran into a "simple" problem: I can't find a zip program ! Quote: zip tool (2.3 or higher) The ...
0
votes
0answers
19 views

Concatenate a reversed range in Libre Office

I'm kind of new with programming, but I have to make an excel document, that I can use interactively because the output of one of my programs doesn't fit with the input of the others... I have lot of ...
13
votes
1answer
15k views

How NOT to print sheet name and page number in OpenOffice.org Calc?

When I print a spreadsheet in OpenOffice.org Calc (latest version), it keeps adding the name of my current sheet to the top, and a page number to the bottom of my print out. How do I turn this off? ...
0
votes
0answers
15 views

open office portable - Fatal Error User Installation can not be completed

i have to maintain a legacy application which uses a portable open office in a headless mode. It uses this to convert odf Files to RTF Files. Everything was running fine on my machine on my machine ...
1
vote
1answer
20 views

OpenOffice Rounding: How can I make the displayed version of a number count as it is and not as it was before the format?

My problem is basically this: I can successfully make the number 7,5 be displayed as 8, BUT it still gets calculated as 7,5 when I try to use it. How can I make it count as it is displayed and not as ...
3
votes
2answers
698 views

Copying / applying styles by keyboard shortcut in Open Office - similar to Format Paintbrush?

I would like to achieve a similar effect of using the Format Paintbrush without having to actually press the button each time. Is it possible to select the Format Paintbrush Tool by keyboard ...
3
votes
1answer
3k views

Ubuntu: Convert OpenOffice Calc to Excel workbook using CLI

I need to create an automated report in a spreadsheet format. Unfortunately, There seems to be an easy way to create these reports using OpenOffice Calc, but upper managements wants them in MS Excel ...
1
vote
2answers
146 views

.odt vs .fodt: which is most space effective for git repositories?

Which is most space effective for git repositories: LibreOffice/OpenOffice .odt files or .fodt files? I think that it should be .fodt, since with the uncompressed XML format .fodt the repository ...
0
votes
1answer
13 views

Bullet point with different color on OpenOffice Writer

I've found myself in need to do something I've never though about before. I needed to put a different color on some bullets. I've found a way to do this, but I find it so hacky... (It's a very ...
0
votes
0answers
23 views

Using Java-based Extensions (zotero) in OpenOffice on Mac OSX 10.6

I wanted to help a friend to setup zotero (Citation and bibliography management) on her Mac. The browser-add-on for Firefox works flawlessly but the installation of the zotero openoffice integration ...
0
votes
1answer
11 views

OpenOffice Calc - 11 Pages in spreadsheet, but print interface only shows 2

I am working on a spreadsheet using OpenOffice and need the pages to be printable. You can print the first two, but thats it. If in the print interface I select all sheets it only shows 1 and 2 with ...
0
votes
0answers
17 views
0
votes
1answer
2k views

The JPG file on my Open Office document is blurry when exported to PDF

I have tried both Open Office and Word, and the issue is the same. All looks fine until the document is exported to PDF, then the JPG image on the document becomes blurry. I hope someone can help.
0
votes
2answers
659 views

Lock file permanently as read-only in Writer

Is it possible to lock a file in OpenOffice.org Writer permanently? Giving it a "read only" status forever?
0
votes
0answers
105 views

Can not install OpenOffice on Windows 8.1 64 bit

Downloded Apache_OpenOffice_4.1.1_Win_x86_install_en-US.exe Right click Run as administrator But got Any ideas what to do? Read, that at first need to instal java. Tried to install java Version 8 ...
3
votes
2answers
4k views

Set CSV import default to UTF-8 in Calc

Every time I open a CSV (comma separated values) document in OpenOffice.org Calc I get a dialog with CSV preferences. The current default character set is "Eastern Europe (ISO-8859-2)". I would ...
21
votes
3answers
27k 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. ...
2
votes
0answers
11 views

Is it possible to style number/bullet lists separately in LibreOffice?

The "Text Body" style in my LibreOffice document uses a large margin above and below each paragraph. This is causing problems in my bulleted and numbered lists since each list item is considered to be ...
0
votes
1answer
49 views

Export first few pages of Doc to PDF using LibreOffice

I have been using LibreOffice in my rails app to convert my Doc to PDF using the command /Applications/LibreOffice.app/Contents/MacOS/soffice --headless --convert-to pdf --outdir ...
1
vote
1answer
376 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 ...
7
votes
1answer
5k 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
2answers
19 views

Can I have multiple views of spreadsheet data which extract and sort from a larger set?

Supposing I have a spreadsheet (Libreoffice ideally but Excel is ok) which has data like this ______| Age | Height | Shoe Size | etc... Adam | 14 | 180 | 11 | ... Beth | 21 | 205 | ...
0
votes
1answer
81 views

Automatic backups (history) in LibreOffice (OpenOffice)

LibreOffice can create a backup copy when you enable it in settings (Options > Load/Save > General), but it saves only the previous state (one only). It has also an versioning feature (File -> ...
3
votes
3answers
4k views

What are the differences between Lotus Symphony and OpenOffice.Org?

Is there any reason to use one over the other? From what I can tell, they are essentially the same product except for the fact that one has IBM branding and a different interface. From Wikipedia: ...
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?
0
votes
0answers
31 views

can openoffice and libreoffice installed in parallel?

someone said install them both in ubuntu is going to mess up the system: https://forum.openoffice.org/en/forum/viewtopic.php?f=16&t=62509 ...
0
votes
0answers
17 views

Make Open Office Table of Contents Link to Page, not Heading

I have a Table of Contents in my (Apache) Open Office document. It works fine, except that the hyperlinks go to the headings used to generate the Table of Contents, not the top of the page they reside ...
0
votes
0answers
3 views

Open Office Search and replace but select by fonts size

In office can I do the following task? Replace text that has font size > 32 in all ppts, and change font size to x, x can be 23(whatever I give). I want this to be done in ppt.
2
votes
1answer
22 views

Clear cell changed metadata in OOO Calc

I am trying to figure out how to clear the red highlighting around cells in Calc (OpenOffice 4). Here is an example: It is not affecting my work but I would like to clear them as they are ...
1
vote
1answer
90 views

How to accept LibreOffice Calc autocomplete suggestion without leaving the cell edit mode?

Whenever I start typing a sentence in a LibreOfice Calc cell it suggests autocomplete options based on other cells contents. I usually would like to accept it and make a slight modification but when I ...
0
votes
1answer
44 views

OO Calc: Detecting Blank Cells and Replacing with Cell above?

So annoyed I can't find a simple answer to this simple question! I'm using OpenOffice Calc. I want a formula which will detect if the cell is blank, and if it is to replace it with the contents in ...
0
votes
2answers
89 views

IF formula where the test is a logical value in OpenOffice

How can I do =IF(E2,-1,1) * D2 in OpenOffice, where D2 is Currency and E2 is TRUE/FALSE?
2
votes
1answer
3k 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 ...
3
votes
3answers
350 views

How to embed formulas in a line of text using OpenOffice Impress?

I want to create a presentation in Impress and need to embed a formula in text. I only found very old forum posts (over five years old), which said it is not possible. Has this changed by now? How ...
0
votes
1answer
2k views

Make cells automatically shrink to fit text in OpenOffice spreadsheet

Is there a way to get the widths of cells to automatically shrink themselves to fit the longest line in a column?
0
votes
0answers
38 views

Convert Formula to Text in Libreoffice Writer

I have a Libreoffice Writer file. I have near to 1000 mathematical formulas. I want modify them because all of them have small font. So I want convert them (formulas) to normal text then I should be ...
0
votes
0answers
31 views

Open Office: Simple Chart with dates/numbers?

I'm using OpenOffice Calculator. I have some data like this: Date | Messages Jun 2 2011 | 345 Jun 4 2011 | 212 Jun 5 2011 | 221 I'd like a very simple graph with the dates on the x-axis and ...
0
votes
1answer
234 views

Open Office Calc formating table

Instead of data, I would like the first row to be the names of the columns. How can I do this? One of the reasons I want this is so that if the rows are rearranged the names wont be jumbled up. I ...
0
votes
0answers
91 views

Excel or OpenOffice Table Summary: how to reconstruct a table from another, with “missing” values

I have a table of values (partial) with 3 columns: month (from 1 to 12), code and value. E.g., MONTH | CODE | VALUE 1 | aaa | 111 1 | bbb | 222 1 | ccc | 333 2 | aaa | 1111 2 ...
4
votes
3answers
4k views

Inserting an image into a OpenOffice.org Calc cell

Is there a way to insert an image inside a cell? When I choose "Insert -> Picture" it inserts it so it's floating over the cells. That's not what I want. I want to be able to insert the image into ...
0
votes
0answers
20 views

How to make caption not connected to figure in OpenOffice / LibreOffice (like in MS Word)?

When adding a caption to figure in LibreOffice (and I expect also in Apache OpenOffice.org), it is automatically "glued" to the figure, and stays with figure. From what I understand, it is done using ...
0
votes
1answer
353 views

OpenOffice Calc - calculating percentage for every cell in a column

I have a somewhat common task of calculating percentage of column. For example I have a column with 20 numbers on each row. I add 21st row with formula for the sum of all those 20 rows and then I need ...
4
votes
4answers
6k views

How to create diagram in spreadsheet with dates on x-axis?

I recently became a father to twin boys. Naturally there is a lot of weighing and measuring, and we record these numbers in a spreadsheet. I use OpenOffice.org Calc (but I'm open to solutions for ...
0
votes
0answers
22 views

Alternate row colors only if there are contents in them

I want to alternate row colors in an OpenOffice spreadsheet, but only if the first cell in the row has contents in it. The following function works great to return the correct value: ...
5
votes
1answer
365 views

Is it possible to remove the hyperlink background in OO Calc?

Hyperlinks in OpenOffice Calc are displayed with a solid background which covers the background color of the cell. I don't want a solid background; I want the background color of the cell to show ...
0
votes
2answers
212 views

How to change the default font in LibreOffice 4

How do I change the default font in LibreOffice / OpenOffice. So that when I open a new spreadsheet document it doesn't revert to use the standard default font (Liberation Sans/Serif) How to set the ...
2
votes
0answers
471 views

microsoft visual c++ 2008 redistributable package x64, error 1935

I am working on Alienware 17, OS Windows 10 preview. When I try to install Open office it in turn tries to Install Microsoft visual c++ 2008 redistributable package x64 which then gives me following ...
1
vote
1answer
370 views

Openoffice / Excel combine multiple worksheets into one

I have not yet found the exact answer to my specific problem, so let's give it a shot : The Layout : 1 SharePoint Farm on which a report was run, returning 6 Excel Files with each containing 250 ...
1
vote
3answers
4k views

OpenOffice ruined my CSV file - (how to save CSV on Linux with OpenOffice?)

I am running OpenOffice 3.2 on Ubuntu. I had a CSV (comma separated value) file which I had manually created. I opened it in OpenOffice, and entered about 100 items (to make use of using formulas to ...
0
votes
4answers
4k views

Where are openoffice templates stored?

My computer has somehow gotten out of sync. I can save a document as a template in a directory of my choosing, but when I go to use the Templates and Documents dialog, I get this: I have no idea ...