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

learn more… | top users | synonyms (1)

1
vote
1answer
12 views

Limit number of rows and columns in OpenOffice Calc

Is there a way to limit the number of rows and columns shown in a sheet in OpenOffice Calc? I have resorted to manually hiding rows and columns outside the area that I want, but this is tedious, and ...
4
votes
1answer
306 views

Set a row to follow my cursor anywhere in Calc

How do I make a whole row follow wherever I am in the Calc document when I scroll down/up? I'm looking for something that keeps a row from moving, or to make it stay put. This is so that when I ...
1
vote
2answers
93 views

Exit Column Section To Continue Normal Editing

Using OpenOffice.Org on OSX 10.5.8 I typed text into my page, using my regular document parameters/margins, then I inserted a "section" so that what I typed in next could be entered in 2 columns. I ...
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 ...
5
votes
2answers
4k views

Move rows with the keyboard in Calc

How might one move a row to a different location with the keyboard? I have found this guide for the mouse but due to disability I have trouble using the mouse for this. Note that I am not looking to '...
0
votes
1answer
32 views

Make all instances of a word a hyperlink in OpenOffice

How can I make every instance of a word, a hyperlink to a file on my computer. I have managed to do it with one instance of the word, but repeating this be time consuming so I am hoping that the ...
0
votes
0answers
8 views

Oracle Open Office 3 for Mac Upgrade or transition?

I have long been using OpenOffice.org 3 for Mac created by Oracle. It seems no longer to be supported and offers no upgrade. What is the best way to move to a more modern open source word processor? ...
0
votes
2answers
463 views

linux: dual monitors for presentation

I'd like to setup dual monitors so that one monitor is a projector and the other is my laptop's screen. Then I'd like to show a full screen presentation (openoffice) on the projector and the same ...
3
votes
0answers
21 views

Unable to Open Open Office spreadsheet on Windows 10

It used to work fine a few months ago. So it must be one of the Win 10 updates. When I click on the .ods file, Open Office flashes up and then closes. If I start Open Office from its shortcut on ...
1
vote
2answers
9k views

How to fix X11 error: Can't open display

I installed libreoffice.x86_64 using yum from the CentOS repository on my CentOS basic server. When running the following command from the shell, I get the following X11 error. xhost is installed on ...
22
votes
4answers
19k views

How to open Mac Keynote presentations on Ubuntu?

How to open Mac Keynote presentations on Ubuntu? Can it be imported to Impress?
12
votes
2answers
13k views

Copying just text, not formulas, in OpenOffice Calc

How do I copy and paste the text (not the formulas) from one Calc sheet to another in OpenOffice?
0
votes
2answers
2k views

How to hide paragraph marks in OpenOffice.org Writer?

How do I remove the blue P-marks that indicate paragraphs from my documents when working? I have looked under the 'Tools' menu but have been unsuccessful.
6
votes
3answers
2k views

How to stop OpenOffice/LibreOffice from popping up toolbars when I click on stuff

When I import a picture or a chart into my document and click on it, LibreOffice spawns a toolbar, shifts the whole screen around for a second, and then allows me to move stuff again. It gets very ...
0
votes
1answer
40 views

Openoffice access files on NFS extremely slow and can not save file

I am using a Debian 7 box. I have an NFS network drive mounted on my "/mnt/drive_R". Everything works fine except Apache openoffice 4.1 and LibreOffice 3.5, yes I tried both version of openoffice. I ...
0
votes
2answers
75 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 ...
4
votes
6answers
18k 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 command-...
0
votes
1answer
22 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
2k 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
13 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
16 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 ...
1
vote
0answers
20 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
26 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
9 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
149 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
21 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
14 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
25 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
13 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 ...
9
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
7k 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
43 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
18 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
45 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 ...
2
votes
2answers
47 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 ...
4
votes
2answers
10k 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
22 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 in-...
0
votes
1answer
237 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
57 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
136 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
163 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 ...