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

learn more… | top users | synonyms (1)

3
votes
0answers
185 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 ...
2
votes
0answers
12 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
544 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
139 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
41 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
127 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
202 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
599 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
248 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 ...
2
votes
0answers
265 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 and its text separately into two columns. Is there any method to achieve this?
1
vote
0answers
23 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
31 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
42 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
129 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 ...
1
vote
0answers
346 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
171 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
18 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
647 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
137 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
464 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
450 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
547 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
163 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
119 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
63 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
219 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
445 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
125 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
23 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
24 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
10 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
12 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
10 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
16 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
24 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
38 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
33 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 ...
0
votes
0answers
23 views

Fonts broken in Libre/Open Office Math

Can't enter any complex formula like sigma summation: How to fix?
0
votes
0answers
202 views

Can not install OpenOffice on Windows 8.1 64 bit

Downloded Apache_OpenOffice_4.1.1_Win_x86_install_en-US.exe Right click Run as administrator But got Any ideas what to do? Read, that at first need to instal java. Tried to install java Version 8 ...
0
votes
0answers
37 views

can openoffice and libreoffice installed in parallel?

someone said install them both in ubuntu is going to mess up the system: https://forum.openoffice.org/en/forum/viewtopic.php?f=16&t=62509 ...
0
votes
0answers
28 views

Make Open Office Table of Contents Link to Page, not Heading

I have a Table of Contents in my (Apache) Open Office document. It works fine, except that the hyperlinks go to the headings used to generate the Table of Contents, not the top of the page they reside ...
0
votes
0answers
3 views

Open Office Search and replace but select by fonts size

In office can I do the following task? Replace text that has font size > 32 in all ppts, and change font size to x, x can be 23(whatever I give). I want this to be done in ppt.
0
votes
0answers
53 views

Convert Formula to Text in Libreoffice Writer

I have a Libreoffice Writer file. I have near to 1000 mathematical formulas. I want modify them because all of them have small font. So I want convert them (formulas) to normal text then I should be ...
0
votes
0answers
48 views

Open Office: Simple Chart with dates/numbers?

I'm using OpenOffice Calculator. I have some data like this: Date | Messages Jun 2 2011 | 345 Jun 4 2011 | 212 Jun 5 2011 | 221 I'd like a very simple graph with the dates on the x-axis and ...
0
votes
0answers
22 views

How to make caption not connected to figure in OpenOffice / LibreOffice (like in MS Word)?

When adding a caption to figure in LibreOffice (and I expect also in Apache OpenOffice.org), it is automatically "glued" to the figure, and stays with figure. From what I understand, it is done using ...
0
votes
0answers
28 views

Alternate row colors only if there are contents in them

I want to alternate row colors in an OpenOffice spreadsheet, but only if the first cell in the row has contents in it. The following function works great to return the correct value: ...
0
votes
0answers
303 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 ...
0
votes
0answers
10 views

input data that automatically finds and places in its position in another sheet(s)

What I want to do is create a simple data entry form at the start of a series of monthly sheets in one document. I need the date, amount(£) and a category(choice from drop list would be good) to be ...