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

learn more… | top users | synonyms (1)

0
votes
0answers
10 views

LibreOffice Writer's “Background Color” setting not working

I have recently upgraded to LibreOffice Writer Version: 5.0.2.2 on Ubuntu 15.10. Before, I was using an unknown version of LibreOffice Writer on Ubuntu 12 and I had a document (with a .doc extension) ...
0
votes
0answers
14 views

LibreOffice Writer in Windows missed images from Linux

I'm using LibreOffice Writer in Linux to edit a document with images. But when I move file created under Linux to Windows not show images inside the document. My LibreOffice version: LibreOffice ...
1
vote
1answer
16 views

Open office calc defaults to 19XX

I'm using Nuance 8.1 Pro pdf converter to dump into Open Office .xlsx It takes 12/15/15 and makes it 12/15/1915. I need a (4) digit year for the final result but need the right century.
0
votes
0answers
16 views

Open linked document instead of current one

When clicking on a link (in MS Word) to another document, is there a way to have Word open the new one in the same window as the current one instead of the current one? If not, is there a way in ...
-1
votes
1answer
28 views

How to stop OpenOffice 4 from replacing your — double-dash with a single long dash

I was trying to document some command lines in Linux that use a double dash --option-name and was annoyed that OpenOffice/LibreOffice was replacing the double-dash with a single long dash (U+2013). ...
2
votes
2answers
22 views

Why do photos change color when you open an .odt file in Microsoft Word?

I have an .odt document (OpenOffice) containing photos. When I open the document with Microsoft Word, the photos are displayed darker then they were. Why is this the case? I would like to be able to ...
0
votes
0answers
16 views

Separate layer for PDF forms in OpenOffice

There is possibility to prepare PDF forms in OpenOffice that works good in whole. But Adobe Acrobat DC places form elements (text inputs) in a separate layer. In contrast, OO places form elements ...
3
votes
0answers
31 views

Disabling spell checker in OpenOffice Calc (or LibreOfffice Calc)

Is there a way to disable the spell checker in OpenOffice Calc (or LibreOffice Calc) without disabling it for the other programs in the office suite? I would prefer to just disable it for a range of ...
2
votes
1answer
38 views

How to fix a corrupted LibreOffice spreadsheet

I have a substantial multi-sheet LibreOffice worksheet that seems to be throwing a lot of errors in LibreOffice, including crashes. Any idea of how to get it to work as expected? I'm thinking ...
1
vote
1answer
40 views

Assigning rank in OpenOffice (or LibreOffice)

In OpenOffice (or LibreOffice), is there a way to rank rows? For example, let's say you have a spreadsheet where cell A1=20, A2=30, and A3=10. I want to B1 to get a value of 2, B2 to get a value of ...
2
votes
0answers
14 views

Prevent OpenOffice Calc from converting pasted numbers with decimals into dates

Whenever I paste numbers that have dotted decimals in them (let's say, 5.05) into an OpenOffice Calc Spreadsheet, it insists on converting them into dates (the above becomes 15-05-05). I usually set ...
0
votes
1answer
58 views

PDF: is it possible to batch replace text-boxes content?

Ok, let me explain the situation: I have huge pdfs (100 pages with lots of text) that need to be translated. The pdf has the text in textboxes and these textboxes are scattered everywhere. The ideal ...
0
votes
0answers
8 views

OpenOffice - Setting multiple fill characters in tab

Under "Format → Paragraph → Tabs → Fill Character", there's an option to draw dot leaders joining the contents from the left corner to the contents from the right corner: Is there a ...
0
votes
0answers
14 views

Setting color of dot leaders in OpenOffice

Under "Format → Paragraph → Tabs → Fill Character", there's an option to draw dot leaders joining the contents from the left corner to the contents from the right corner: How can the ...
1
vote
0answers
62 views

OpenOffice / LibreOffice ugly font rendering

I'm using Calc to generate some graphs of data I have collected. But somehow the font looks increadibly ugly in all of LibreOffice. I'm using Noto Sans CJK JP Light in this chart but pretty much every ...
1
vote
1answer
36 views

Duplicate Chart in OpenOffice Calc without losing link to the sheet's data

I have created and formatted a chart and need the same one again to be filled with other data. The problem: In OpenOffice Calc 4.1.1, a chart's data is unlinked from the original data/sheet, as soon ...
0
votes
0answers
16 views

How do I quickly convert a block of text to an image in Open Office Writer?

I'm currently in a writing class doing short stories. As part of my story, I'm using custom fonts to represent specific languages. I'm writing everything with Open Office Writer, as I don't have MS ...
1
vote
1answer
23 views

Add new hyphenation rule to MS Word/OpenOffice

I've noticed that the automatic hyphenation doesn't work optimally in MS Word. The problem is that it doesn't hyphenate some words that can be hyphenated. Can I somehow get it to hyphenate such words, ...
0
votes
2answers
47 views

Alternating text in word documents

I often want to alter my CV for different purposes, like only mention my German skills when it is relevant. Is there a way I can have such alternate versions in one Word Document? OR Alternatively ...
1
vote
0answers
97 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
31 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
48 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 notes relevant to the ...
0
votes
1answer
84 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
58 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
28 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
32 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
21 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
64 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
58 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
455 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
123 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
39 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
80 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
12 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
58 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
39 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
48 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
71 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
38 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
698 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
68 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
93 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
64 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
52 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
24 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
32 views

Fonts broken in Libre/Open Office Math

Can't enter any complex formula like sigma summation: How to fix?
0
votes
0answers
443 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
22 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 ...
1
vote
1answer
201 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 ...