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

learn more… | top users | synonyms (1)

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 ...
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
1answer
6k 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 ...
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, ...
0
votes
1answer
73 views

How do I generate a column of dates.

I want to generate a column of dates that are staggered by one month like this: 7/01/13 8/01/13 9/01/13 Right now what I've tried is dragging down the black dot in the lower right hand corner of ...
1
vote
2answers
635 views

How do I drag down complex calculations in open office.

For example if A1 contains 30 and in A2 I write =A1-6 then I'll get 27 in A2 and if I click the little black squair in the lower right hand corner of A2 and drag it down then I get a column that looks ...
1
vote
0answers
650 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 ...
0
votes
2answers
120 views

How to automatically update (promote/demote) heading sub-levels

How can the heading sub-levels can be automatically updated when promoting/demoting a section? Imagine I have a document structured like this: (1)Chapter A (2)Section B (2)Section ...
1
vote
1answer
142 views

How does Open Office Calc make this conversion?

In a column, I have dates of the format 2013-05-27. When I selected "Default Formatting", the dates got changed to five digits, for example, 41422. Where does this number come from? It's not even ...
0
votes
0answers
210 views

enteries in column are automatically changed to upper case letters

I am very new with Open Office and spread sheets in general. In a column whenever I add a new entry it changes all the letters to upper case. Is there a way to disable this? If not, many entries ...
2
votes
1answer
83 views

Dragon Naturally Speaking 10 enters bad characters in certain text editors in Windows XP

I use DNS 10 in Win 7 without any problems for dictating in office XP and office 2007. I have installed it too on a computer under WinXP and there, with office XP and office 2003 it enters wrong ...
3
votes
2answers
3k views

Which fonts come with OpenOffice / LibreOffice? [closed]

Is there a list of all the fonts which come with OpenOffice / LibreOffice ?
2
votes
1answer
760 views

How compatible is LibreOffice with OpenOffice?

LibreOffice and OpenOffice both use the OpenDocument format, and LibreOffice is based on OpenOffice. But how compatible are they which each other?
0
votes
1answer
256 views

Open Office Calc formating table

Instead of data, I would like the first row to be the names of the columns. How can I do this? One of the reasons I want this is so that if the rows are rearranged the names wont be jumbled up. I ...
-3
votes
2answers
602 views

Office tool for editting XML files [closed]

I have developed an app solution where customers can update data themselves through XML files. While this is kinda great, it still leaves customers to editing XML files which is probably requiring too ...
0
votes
1answer
138 views

Why is Openoffice Calc automatically rounding the sum of two sums?

I have two columns which have been summed. When I sum the two cells with those results, openoffice rounds the sum every time. If I only enter two numbers and then sum them, it operates normally. ...
2
votes
1answer
947 views

Autocomplete only on demand in OpenOffice Calc

In Open-/Libreoffice Calc, it is possible to enable the auto-completion of cells. That means the cell is filled e.g. with a string that starts with the characters already typed. This may give unwanted ...
0
votes
1answer
828 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 ...
0
votes
1answer
52 views

Move single point with keyboard in OpenOffice/LibreOffice Draw

Consider a polygon, which has points. How can I move an individual point, with arrow keys of the keyboard, but not with mouse? I tried to select a single point and to move it by pressing arrow key, ...
2
votes
1answer
580 views

Find the Nth instance of a text string within a range?

I have a list of names next to a list of shifts. I want to collate a list of people on each shift by day, which will automatically and dynamically update. I can't work out the best way to do it. In ...
2
votes
3answers
3k views

libreoffice what is a fast way to paste special > text and numbers only (aka paste special values)?

I copy and then paste values in excel quite a bit (when I use Excel). When I use LibreOffice you can do the same thing (see related question here) but it is oh so tedious! It gets especially tedious ...
0
votes
1answer
43 views

Excel/Calc: Pivot table with (almost) identical row: how to identify them?

I need to examine via pivot a datasource from a sheet. This datasource sheet is something like this: | Field 1 | Field 1 | Field 3 | | AAAA | BBBB | CCCC | | DDDD | EEEE | FFFF | | GGGG ...
1
vote
2answers
70 views

Potential issues with working on the same document with Open Office and Word

I'm writing a report and plan to edit it using Open Office 3 and Word 2013. Open Office 3 can save in the .doc format but not .docx, which is the default of Word 2013. Will there be any compatibility ...
0
votes
0answers
220 views

How do I make a document fully read only on Open Office

When I use the security setting and set the password, I can still overwrite my original document. What am I doing wrong?
0
votes
2answers
6k views

Why can I open .docx with OpenOffice but not .odt with Word?

I am using Office 2007 and OpenOffice 3.3. I have to be able to open and save documents in both formats .docx and .odt. As .odt is an open format why can't Word open and save documents in that Format? ...
1
vote
2answers
1k views

Decrypt .docx file to view in OpenOffice.Org

I have been sent an encrypted .docx file as it contains confidential information, but I am on linux. I have the password, but OpenOffice.Org doesn't seem to even recognize that it is an encrypted ...
2
votes
1answer
566 views

Where does open office writer save its default template

Does anybody know where Openoffice saves its configuration for standard font, size etc? I know i can create a template which gets used as a standard for new documents, but how do i get the location ...
2
votes
2answers
197 views

OpenOffice Calc regex returns wrong value - what's wrong with my regex?

I have a column of text with values concatenated by my bank, as in a typical monthly statement. Here is an example (column A240): OCT 26 BALANCEPROTECTOR PREMIUM $10.05 I'm trying to set the ...
2
votes
1answer
565 views

Remove a word from OpenOffice.org standard dictionary

Our company has just named some new software using a regular English word. My fingers are determined to misspell this word. Unfortunately, the misspelled word is also a place name that is in the ...
0
votes
1answer
123 views

Duplicate an Open Office document in a new window

I am using Open Office 3.4.1. Is there a way (via key combination or something) to duplicate the current document and open it in a new window? Edit: I mean a more convenient way than pressing CTRL + ...
0
votes
3answers
4k views

Check for one value in column A exist in another column B in open office

suppose I have values like A B C abc cde bcd abc cde afg mn mn for column C I have used formula =IF(MATCH(A1;B2:B4;0);A1) But its giving wrong ouput like below A B C abc cde #N/A bcd ...
0
votes
2answers
69 views

OpenOffice - Regex for reformatting line with word + numbers

I have a document with sections headed "Chapter 1"-"Chapter 45". I want to make them all caps and all in bold font by using a regex. I am stuck. I keep ending up with things like "CHAPTER "[0-9]" ...
2
votes
1answer
254 views

OpenOffice Mail Merger - 530 Authenthication Required

In OpenOffice Writer, I'm trying to to do a mail merge with OpenOffice Base. When I test the email settings, OpenOffice claims they work. However, when I try to do the actual mail merge, OpenOffice ...
0
votes
0answers
110 views

openoffice base report

I'm using open office Base to create a stand alone database for my service record. the problem is when i try to create a specific report, i cannot get the output that i want. lets says, I want to open ...
2
votes
1answer
917 views

How to prevent OpenOffice from running file recovery every time at startup?

Whenever I start my computer and start OpenOffice, the file recovery option is always displayed. How do I turn this off?
0
votes
1answer
1k views

Excel/OOCalc: finding rows that have matching values in one field but different values in another

I have a large table (20-30 cols, 10-15K rows). What I need to do is to find the number of rows that match identically in one (or two) particular field(s), but not in another specific field (rest of ...
7
votes
1answer
5k views

How do I copy the results of a calculation without copying the formula behind it? Open Office Calc

How do I copy and paste only the results of a calculation without copying the formula behind it? I'm learning to use Open Office Calc. I remember other spreadsheets that had a values function, or ...
1
vote
2answers
62 views

Create selected lines into table in Microsoft Word/Openoffice

I want to move the entire content of an MS Word file into a table. The content consists of Objective Questions like: Question 1 a. option1   b. option2   c. option3   d. option4 ...
0
votes
3answers
238 views

Multiple “If” answers in one cell

I am trying to make a fishing tournament spreadsheet.... I would like to perform in once cell that if their position was first, they get 100 points. if their position is second, they get 90 points, ...
1
vote
2answers
2k views

Can MS Word read OpenOffice formats?

I am using Ubuntu 10.04.4 LTS, but am required to produce a document readable by MS Word. Can MS Word read .odt documents, or is OpenOffice capable of exporting into a .doc format so that it is ...
1
vote
1answer
94 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)?
3
votes
1answer
1k views

How can I open a .mdb with a password in OpenOffice?

I'm trying to open a .mdb with a password in OpenOffice Base. I can connect to the .mdb, but I cannot specify a password (forums say this method doesn't support passwords). Is there a way I can open ...
1
vote
1answer
242 views

How to fix document broken content?

I have been sent several files in order to fix them - the issue is that when they are opened you are not seeing the correct text and my cousin is not able to prepare for his exam. So, I have found it ...
1
vote
1answer
850 views

Binary spreadsheets with bitwise operators [closed]

I am looking for a way to easily construct binary spreadsheets using bitwise operators such as SHIFT, AND, OR and XOR. I've looked at Gnumeric but can't find any function that'd allow you to set the ...
0
votes
2answers
96 views

OpenOffice.org Lowercases second capital letter

How can I turn of the feature in OpenOffice.org Calc which converts CCleaner to Ccleaner?
0
votes
1answer
207 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 ...
1
vote
1answer
552 views

running word count in OpenOffice writer

In OpenOffice Writer 3.4.1 is there a way to show the word count as you type without clicking anything? I'm new with OpenOffice and am use to word.
12
votes
3answers
357 views

Open Office makes my words bumpy

I'm using OpenOffice 3.4.1 on Windows 7, the Writer keeps giving me these weird bumps in my words. Sometimes, randomly, the words I type have little hills and/or valleys of about one pixel. I took a ...
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 ...
0
votes
1answer
60 views

How to apply a page style to a specific set of pages?

I want to split my document in three parts. The first part is the first document which has the style "First Page". The other ones have "Default". Now, I want the appendix to have the "Index" page ...