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

learn more… | top users | synonyms (1)

0
votes
2answers
1k views

How can I use extremely large numbers in my spreadsheet programs?

If I try to calculate large exponents in LibreOffice Calc or OpenOffice.org Calc, the results come out to be erroneous. See these two examples where I calculate 13^18, Using LibreOffice Calc Using ...
4
votes
4answers
5k 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
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
18 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 ...
2
votes
0answers
15 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 ...
-1
votes
1answer
30 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). ...
4
votes
2answers
1k 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 ...
5
votes
4answers
4k views

Keyboard shortcut in OpenOffice to incrementally increase or decrease font size?

Is there a keyboard shortcut in OpenOffice Writer that will allow me to incrementally change the font size? If I'm switching between 12 and 14 and 16 often, it would be much easier to be able to tap ...
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 ...
3
votes
2answers
9k views

How to disable OpenOffice spell checking?

I have constant headaches disabling OpenOffice spell checking. There are several instructions on Internet, but I feel like each one depends on which OpenOffice application and which version you are ...
4
votes
1answer
5k views

OpenOffice Calc - how to insert BLANK in a formula?

In Calc, as in most spreadsheet applications, an IF() function exists that can be used to control behaviour, for example inserting this formula in cell C1. =IF(A1>B1;"A";"B") will display A in ...
0
votes
0answers
17 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 ...
0
votes
1answer
224 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 ...
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 ...
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 ...
2
votes
1answer
39 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
42 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
2answers
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
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
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 ...
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 ...
7
votes
1answer
2k views

Preventing LibreOffice from using smart quotes (“ ”) instead of (dumb) straight quotes?

I use LibreOffice Calc to make lists of programs with different parameters to run on an hpc cluster. For each batch of commands I must do a find and replace on the smart quotes, as they cause errors ...
1
vote
0answers
68 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
38 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 ...
2
votes
1answer
3k views

Is there a way to change the background color of a slide in OpenOffice.org Impress using hexadecimal values?

So far I've only found a way to change the background color by right-clicking the slide and going to Slide > Page Setup > Background > Color, but it only shows a fixed selection of colors, like this: ...
3
votes
3answers
412 views

Separating text and links from a hyperlink in OpenOffice

I have a list of bookmarks which is converted into an OpenOffice spreadsheet. Now I want to separate the link URL (in blue below) and its text (in black) separately into two columns. Is there any ...
1
vote
1answer
698 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 ...
1
vote
1answer
82 views

How can I create a PDF with a different full-page background image for each page, perhaps using Word 2011 or OpenOffice Writer 4?

I've searched and seen how I can create a watermarked Word document with a background image that applies to the whole document. What I have not yet found, for Mac Word, 2011 OpenOffice 4.x, or other ...
3
votes
3answers
16k views

How to stop OpenOffice Calc from rounding numbers?

I have a cell which contains a formula "=A1/A2" and I just want it to truncate the number after two decimal places instead of rounding it off. How do you stop Open Office Calc from automatically ...
5
votes
1answer
255 views

Default font and cell padding when opening files in LibreOffice/OpenOffice Calc

I've seen solutions for setting a default font when creating new files. What about a default font (and cellpadding) when opening an existing CSV file? LibreOffice seems to always default to Liberation ...
0
votes
2answers
49 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 ...
2
votes
2answers
3k views

Referencing equations in LibreOffice/OpenOffice

Equations in LibreOffice (OpenOffice) can be autonumbered. How can I reference equations in text by that numbers so when equation numbers then references in document updated automaticaly. For example ...
2
votes
1answer
231 views

Controling number of spaces per tab character in openoffice

I want to print a program file from OpenOffice Writer, so I use a mono font and adjust size and margins to my liking. The indentation in the program file is based on tab characters, so I would like ...
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 ...
0
votes
1answer
3k views

How to quicky connect to a sqlite database with OpenOffice.org Base?

With Ubuntu:How to quicky connect to a sqlite database with OpenOffice.org Base?
1
vote
2answers
158 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 ...
1
vote
0answers
100 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
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
63 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
2answers
493 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 ...
7
votes
4answers
1k views

Math equation formats

I need to store equations in a text file, in a source format that can be converted to something that can be rendered (e.g. mathML). I like the format used in OpenOffice. I don't want to use TeX, or at ...
0
votes
1answer
60 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 ...