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

learn more… | top users | synonyms (1)

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 ...
3
votes
0answers
784 views

microsoft visual c++ 2008 redistributable package x64, error 1935

I am working on Alienware 17, OS Windows 10 preview. When I try to install Open office it in turn tries to Install Microsoft visual c++ 2008 redistributable package x64 which then gives me following ...
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 ...
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 ...
2
votes
0answers
184 views

Convert rtf to pdf removing the hidden text of rtf file

I am using Ted on CentOS 6, for conversion of RTF to PDF documents via shell_exec command from php script like: shell_exec(rtf2pdf.sh test.rtf test.pdf) But the issue is that if the RTF file has any ...
2
votes
0answers
186 views

Disable prompt when opening a CSV file in LibreOffice/OpenOffice Calc

Every time I open a CSV file, LibreOffice presents me with a prompt asking to confirm Character Set, Language, and Separator options (tab, comma, semicolon etc). This prompt is not present in ...
2
votes
0answers
46 views

Evenly-spaced table rows, where table encompasses entire available height

Consider a page which may have a header, footer, and a list of questions with a heading: Some Company Header These are your questions: 1. What is your name? 2. What is your quest? 3. ...
2
votes
0answers
151 views

How to change size of embedded openoffice/libreoffice draw object in ms word document?

I am using MS Office 2010 and LibreOffice 4.1.0.4. I wanted to embed a few draw diagrams in my Word document (copy pasting from LibreOffice Draw into MS Word is not an option for me because I want to ...
2
votes
0answers
238 views

Numbering sheets (not pages) in MS Word or LibreOffice

I work at a Brazilian government office. Our paper processes, which are due to retirement in favour of an eletronic one but just not yet®, require us to number sheets, not pages. So pages 1, 2, 3, ...
2
votes
0answers
26 views

Indextable numbering space

There is no space between the outline numbering and the TEXT in my Table of Contents. My heading styles 1 - 3 have bullets_and_numbering/position/minimum_space_numbering<->text 0,38cm but the ...
2
votes
0answers
748 views

OpenOffice Calc weighted average

I need to find the result of ((C1 * 5) + (C2 * 4) + (C3 * 3) + (C4 * 2) + (C5 * 1))/(5*6/2). I need to do it for 200 columns, not only 5. I currently use two sheets with sheet 2 containing a ...
2
votes
0answers
258 views

How are the 2010 OpenDocument Text (.odt) from OpenOffice and the 2012 one from LibreOffice different?

As you probably know when you're reading this question, an .odt file is just a .zip file containing some folders and .xml files. I used to appreciate this, for I could make a document with keywords ...
1
vote
0answers
63 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
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 ...
1
vote
0answers
65 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 ...
1
vote
0answers
36 views

OpenOffice doesn't copy charts properly

I'm using OpenOffice 4.0.0 and I have charts in them. Whenever I try to copy and paste them into another program it just copies and pastes a white rectangle (of the same size as the chart). I've tried ...
1
vote
0answers
47 views

Merge duplicate text from two columns and put unique text in another column

I've got two columns of about 13,000 email addresses. One has members and the other has newsletter subscribers. There are duplicates between the two(ie. a member who also subscribes to the ...
1
vote
0answers
474 views

How can I debug formatting in LibreOffice?

I am using LibreOffice Writer 4.0.2.2 to edit a Word document sent to me by a Microsoft user. It contains certain formatting that I can't figure out how to change (a gray background on some of the ...
1
vote
0answers
228 views

Conditional Formatting a date/time comparison

The function I'm working on specifically compares & colors a daily recurring time range set in 2 different cells. A specific date in the target cells (produced by a formula) compare to that daily ...
1
vote
0answers
20 views

Ignore paragraphs in text-flow in OpenOffice

My goal is to place short summaries of a paragraph next to the paragraph (like, e.g., here: http://www.media-perspektiven.de/uploads/tx_mppublications/06-2013_Moebus_Heffler.pdf) - using OpenOffice. ...
1
vote
0answers
760 views

Why recovered .xls and .doc files show as symbols?

I formatted an NTFS drive (and re-installed windows) which had some important .doc and .xls files, I used 2 recovery software and both recovered my files but seem to be corrupt, when opened they ...
1
vote
0answers
145 views

Is there a way to view a slideshow with OpenOffice Impress with a video embedded beneath the slide content?

I have a video clip I want to add slideshow content in order to gussy it up before producing it, but when I add the clip to OpenOffice.org's Impress software, the video always plays on top of all the ...
1
vote
0answers
482 views

OpenOffice, LibreOffice and NeoOffice all crashes on startup on OSX LIon

I tried all new versions of LibreOffice, OpenOffice, NeoOffice. When I install them without any problems and then I try to launch them, I get the following error: Process: soffice.bin [1178] ...
1
vote
0answers
494 views

How can I create a PDF with form fields from a collaboratively edited source document?

I want to create a PDF document with a fill-in form. The source of the document is right now Google Docs, so that my team can edit it collaboratively with ease. However, Google docs doesn't support ...
1
vote
0answers
569 views

Copy “true” value from OpenOffice (for pasting in external app)

Is there some way to get OpenOffice Calc to copy the real value stored/calculated in a cell. I realize it must still be text, but is there some way to get OpenOffice to copy a higher precision value ...
1
vote
0answers
164 views

Opening .odf requires admin rights?

One of our users and one of her colleagues is getting an error when opening an ODF file (open office word), something about XML and then a second error message asking to repair the file (which does ...
1
vote
0answers
120 views

What memory settings make a reasonable compromise for OpenOffice?

Regarding the settings at the OpenOffice dialog: Tools - Options - OpenOffice.org - Memory I'm on Ubuntu 10.10 and I have 4GB on a 2.8GHz quad core x86-64 architecture machine. I would consider my ...
1
vote
0answers
65 views

Different fonts for different weights in OpenOffice.org

I want the default font to be Gentium, but its bold is incomplete, so I want bold and bold-italic to be Gentium Basic. I want to have it set as the default font every time and not manually per usage. ...
1
vote
0answers
45 views

OpenOffice Styles & Formatting Preview?

Is there any way to "preview" a style in OpenOffice 3, like you can in Word? I mean, can you make the name of the style actually be shown in its own style and formatting?
1
vote
0answers
222 views

Stop openoffice from launching browser, disable hyperlinks

I use openoffice to read xls... I do not want openoffice connect to internet, EVER if xls contains hyperlink, openoffice launches my default browser how do i stop this? I tried manual proxy options ...
1
vote
0answers
465 views

Split/Count comma delimited string in OpenCalc

I have a cell that is formatted like so : Jill,Bob,Stan etc. Is there a way to count the number of name present in the string?
1
vote
0answers
127 views

Unable to set a default language in OpenOffice.org programs

I'm having lots of problems with the default language in OpenOffice.org applications. I've set the language in Tools > Options > Language Settings but whenever I open the app it has no language set ...
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
17 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 ...
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 ...
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 ...
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 ...
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 ...
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
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
0answers
125 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 ...
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
60 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
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 ...
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 ...