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

learn more… | top users | synonyms (1)

4
votes
6answers
17k views

Batch Convert OpenOffice (ODT) to MS Word (DOC) files?

I have a directory full of OpenOffice.org odt files that I'd like to batch-convert to doc files. Is there an easy way to do this? (bonus points if your answer uses OpenOffice and a Linux ...
0
votes
1answer
16 views

Audio Embedded In Powerpoint

I have a powerpoint file which has embedded audio that I am trying to view. The problem is, I don't have powerpoint, but I do have openoffice. While I am able to view the slides in openoffice, the ...
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 ...
1
vote
0answers
10 views

Is there an accessible LOG of REPAIR procedure in OpenOffice.org or LibreOffice?

I'm developing a PL/SQL tool for Oracle to export a query result set to a ODS file. It seems to work but when I try to open the document, I get the message that something is wrong so OpenOffice ask me ...
1
vote
1answer
14 views

How to open StarOffice Writer files in OS X

I came across some old StarOffice Writer (.sdw) files that I really would like to open. I have tried opening them with Apache Open Office and LibreOffice. The first one doesn't seem to support .sdw ...
0
votes
1answer
51 views

#VALUE! Error while trying to use a referencing cell in a formula

I would like to use the value inside a cell which continuously gets updated from a web page. The cell called C20 linked to another sheet called ratedatasheet and that sheet displays a page and table ...
1
vote
0answers
11 views

How to edit google spreadsheet offline with Libre Office / Open Office

I am working with my team on a spreadsheet on google docs. Is it possible to edit this file offline (with e.g. LibreOffice) and sync and merge it later (like clone and push for github)? Platform ...
2
votes
1answer
22 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
vote
0answers
8 views

Open Office Writer certain documents don't appear in recent documents list

I have a file I copied from another PC, it's password protected and I always have to look it up to open it because it is never saved in recent documents list in Open Office->File. It is not hidden, ...
1
vote
1answer
141 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)?
0
votes
2answers
1k views

How to make openoffice “comments” box bigger?

A friend made comments on an essay I wrote using openoffice's "Comments" feature. (Insert > Comment). Those comments appear in little boxes on the right-hand side. But some times the comments get cut ...
1
vote
1answer
15 views

Fill right in open/libreoffice

I'm using Libreoffice calc for an application where it's necessary form me to fill right. I know that fill down is Ctrl d but is there a way to fill across to the right? Thanks in advance
0
votes
2answers
14 views

Open Office Calc setting an additional number format menu choice on the toolbar

Is there some way that I can set a user defined number format (2 decimal place, comma separated thousands) as one of the formatting choices on my toolbar? Thanks
0
votes
1answer
12 views

Is it possible to have a sum of text REPLACE'd cells in openoffice.org calc?

I have a spreadsheet in calc where I paste dollar values ("$2.50") from another source, but sometimes these are in CAD and appear as "C $3.75", so I would like to be able to keep those strings as they ...
0
votes
1answer
16 views

Can not set default template in openoffice for Mac

The following reference attempts to explain how to set a new default template for Calc. https://help.libreoffice.org/Writer/Changing_the_Default_Template I have followed the directions but there ...
1
vote
1answer
9 views

Add multiple rows to an OpenOffice Calc spreadsheet on mac

What is up with both Excel and Calc with adding multiple rows on Mac? In both cases the Insert|Rows simply adds one row - without any option to enter a count of rows to add. So what are we ...
8
votes
2answers
10k views

Converting Open Office (odt) files to Latex

How do you convert Open Office (ODT) documents to tex files? I have made a report using libre office. Now I wish to continue editing the document using lyx (latex front end). So the ODT file needs to ...
0
votes
0answers
16 views

Openoffice doesn't show open window

I use Open Calc to open some CSV files directly from Windows Explorer but the open window doesn't show up over all the rest of opened windows and I must to minimize all the other windows one by one to ...
2
votes
5answers
2k views

How to turn off the cursor in OpenOffice

When OpenOffice opens a file in read-only mode, it does not show a cursor, and the arrow keys (up and down) will move the page instead of the cursor. (By "cursor", I mean the blinking thing also ...
1
vote
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 ...
5
votes
4answers
6k 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
23 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
21 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
17 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
34 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
5k 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
35 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
20 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
229 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
42 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 ...
1
vote
1answer
73 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
83 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
67 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
15 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
11 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
115 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
65 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
19 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
4k 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
436 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
877 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
97 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
17k 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
289 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 ...