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

learn more… | top users | synonyms (1)

1
vote
0answers
21 views

How to embed (not insert) MP3 in OpenOffice Impress

My question is similar to this, Photos and Animated .gif disappear in Open Office Impress But unfortunately when I go to Edit, the Links option is greyed out. Is there another way to embed mp3 ...
0
votes
0answers
22 views

Attn: J.Q. Public: Your “list index” is “out of range”

I have been using OpenOffice (presently 4.0) to expand and maintain the collection of my favorites that I have written, which is presently 600-700 pages in length and has been modified over time by ...
0
votes
2answers
13 views

Entering notes into LibreOffice Calc and OpenOffice Calc

In LibreOffice Calc and OpenOffice Calc, there is often a need to quickly enter several rows of text that will not be part of any calculation area. This is often done to write relevant notes. When ...
0
votes
1answer
22 views

Photos and Animated .gif disappear in Open Office Impress

I use Open Office on Windows 8. When I create Presentation using Impress, I insert photos and animated .gifs. However, if I move that Impress presentation, or delete the referring photos and ...
0
votes
1answer
18 views

How to color rows based on a check box - Open Office

How do you color the background of a cell based on a check box? More to the point, I have created a check box that is in a cell. I want that cell to be green when the check box is checked and red when ...
1
vote
1answer
12 views

Syntax for proper use of INDIRECT function using SUMIF in Openoffice spreadsheet to specify a functional range

Similar to others who have asked related questions, I have a spreadsheet sheet which summarizes different expense categories on a different sheet (called PC activity)in the same file. PC activity is ...
0
votes
0answers
17 views

Text is being duplicated in OpenOffice - How can I stop it?

I generally do not use OpenOffice. However, my Microsoft Office decided to deactivate itself recently, and will not reactivate due to the product key being used too many times (which it hasn't). I am ...
0
votes
1answer
15 views

How do I look up data from another table?

In this fictional example, I have two tables; one with employee information and pay rate: The second with dates and the corresponding number of hours the employee has worked on that day (note that ...
1
vote
0answers
42 views

Spell check turned off in Windows 8.1

I have an Acer Aspire "E15 Start" laptop running Windows 8.1. Recently, it seems that somehow the spell check feature on all applications and websites has been "globally" turned off. No misspelled ...
0
votes
1answer
31 views

Assign number values to certain letters in Excel or OpenOffice

I'd like like to know how to assign to some letters a number value for a monthly Hospital schedule. For example: N for night = 12h M for morning = 6h P for afternoon = 6h CS for day off = 6h R for ...
1
vote
1answer
69 views

Converting OpenOffice Impress presentation to video without screen recording

how can I convert OO Impress presentation to video without setting up screen recording? The goal is to have a server that produces a MPEG stream with the presentation. I want to avoid screen recording ...
0
votes
0answers
38 views

Convert PPTX to HTML while preserving text

I need to convert PowerPoint PPTX files into HTML using the command-line. The HTML file should preserve text as text (not image) while converting all Shapes, Smart-arts and Graphs into images (or if ...
1
vote
1answer
26 views

How to put text in the middle in OpenOffice?

How can we vertically set a text to the middle of an empty page in OpenOffice 4.1?
0
votes
0answers
37 views

Histogram of dates in Google Sheets or OpenOffice

I have a list of dates that I would like create a histogram of. date 5/21/2014 5/20/2014 9/16/2014 5/28/2014 6/8/2014 6/8/2014 5/28/2014 5/20/2014 8/11/2014 7/19/2014 8/11/2014 The chart's x-axis ...
0
votes
0answers
11 views

How to fill table contents in subsequent slides in LibreOffice?

I'm interested in making a slideshow featuring a 3 column chart someone like the photo above, using libre/open office. So far what I've done is create a 3 column table in writer. And my plan is to ...
0
votes
0answers
24 views

Enable LibreOffice “smart” single quotes?

I was wondering how to make a curly single quote instead of a straight one. I found a 3-year-old forum post [Open]from back when LibreOffice was called OpenOffice, but not anything newer. Of course, ...
0
votes
0answers
21 views

Apache OpenOffice 4.1.1 OSX 10.8.5

After losing an extensive spreadsheet last night, I started all over today. Got it completed. Had saved (as .xls) manually using save/save all in the dropdown menu periodically throughout. Closed. ...
0
votes
0answers
25 views

Lost file Apache Open Office

I'm using Apache OpenOffice. Lost an extensive spreadsheet when OO crashed. Is there a possibility it's still on my OSX 10.8.5 system somewhere? Can't find it. Document was saved numerous times. ...
0
votes
1answer
31 views

Remove vertical lines from openoffice table

As a follow up question to How to make a 3 column chart with dividers using openoffice , I created a table which looks like: Is it possible to make horizontal lines invisible, to give the effect of ...
2
votes
1answer
25 views

How to make a 3 column chart with dividers using openoffice

I'm interested in making a chart someone like the photo above using open office. Any idea how to go about this?
0
votes
2answers
179 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
31 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 ...
0
votes
0answers
50 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
23 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 ...
0
votes
1answer
33 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
40 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
20 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
26 views

Fonts broken in Libre/Open Office Math

Can't enter any complex formula like sigma summation: How to fix?
0
votes
0answers
294 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 ...
2
votes
0answers
15 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
123 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 ...
0
votes
2answers
31 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
0answers
45 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
38 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
27 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 ...
0
votes
0answers
67 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
60 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
0answers
23 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
650 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 ...
0
votes
0answers
30 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: ...
0
votes
2answers
508 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
617 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
588 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
2answers
252 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
0answers
392 views

How to convert html to doc/docx with OpenOffice or LibreOffice?

I am trying to convert a html to doc or docx. I used some of the available php classes but the results are not good. I wonder if I can convert a html file to doc using some office software like ...
0
votes
1answer
66 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 ...
4
votes
1answer
38 views

Removing functions from a column, but keeping data (convert to normal text)?

I have a column that contains the results of a few different formulas. I want to convert all of these cells to normal text, getting rid of the formulas. I know I'm missing something obvious here.
1
vote
0answers
31 views

OpenOffice doesn't copy charts properly

I'm using OpenOffice 4.0.0 and I have charts in them. Whenever I try to copy and paste them into another program it just copies and pastes a white rectangle (of the same size as the chart). I've tried ...
0
votes
2answers
71 views

OOO: Increment sheets for fill down

I have a row of cells on "sheet1" referencing a set of cells on a different sheet. I want to fill down identical sets of cells while incrementing only the sheet. Another way to describe the problem: ...