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

learn more… | top users | synonyms (1)

0
votes
1answer
18 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
1answer
20 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 ...
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
15 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
15 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 ...
0
votes
2answers
74 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
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
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
15 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 ...
1
vote
1answer
10 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 ...
0
votes
1answer
21 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 ...
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 ...
0
votes
0answers
28 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
36 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
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 ...
0
votes
0answers
21 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
46 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
87 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
103 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
1answer
23 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
69 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
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 ...
0
votes
0answers
17 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
127 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
76 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
22 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
25 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
49 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
154 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
65 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
166 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
139 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
32 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
44 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
28 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
70 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
84 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
1k 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 ...
1
vote
0answers
182 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
51 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
88 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
61 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
114 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
48 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
1k 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 ...