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

learn more… | top users | synonyms (1)

1
vote
1answer
109 views

How to add a diagram in OO Writer

I would like to insert a diagram in OpenOffice Writer. Is there a toolbar to do it from Writer, or I would have to create it in OpenOffice Draw and then somehow add it to Writer. I also want to edit a ...
0
votes
1answer
3k views

Open office spreadsheet, export as PDF as single large page?

I have an open office spreadsheet. I need to export a selection as a PDF. Everything I do this it creates a PDF document with multiple pages and moves some columns to the next page as they dont fit. ...
0
votes
0answers
108 views

Excel or OpenOffice Table Summary: how to reconstruct a table from another, with “missing” values

I have a table of values (partial) with 3 columns: month (from 1 to 12), code and value. E.g., MONTH | CODE | VALUE 1 | aaa | 111 1 | bbb | 222 1 | ccc | 333 2 | aaa | 1111 2 ...
3
votes
2answers
3k 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 ...
2
votes
1answer
231 views

Controling number of spaces per tab character in openoffice

I want to print a program file from OpenOffice Writer, so I use a mono font and adjust size and margins to my liking. The indentation in the program file is based on tab characters, so I would like ...
3
votes
1answer
275 views

Chapter outline numbers as initials in LibreOffice Writer?

I am trying to have the chapter title (outline) level 1 numbers as initials in LibreOffice Writer. I have set up a character style which gives me the big title numbers, but they are all from the base ...
0
votes
1answer
2k views

The JPG file on my Open Office document is blurry when exported to PDF

I have tried both Open Office and Word, and the issue is the same. All looks fine until the document is exported to PDF, then the JPG image on the document becomes blurry. I hope someone can help.
0
votes
1answer
1k views

How to Custom Folder Access when users Login using SFTP,SSH,SCP?

I have problem when I want to config my SSH server, I have username root and guest. I want root still can access SSH and for guest users , only can transfer file (copy and paste) some directory. in ...
1
vote
0answers
478 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
1answer
29 views

Why do inserted photos not stay where I put them in Openoffice Writer 4.0?

I am trying to write an illustrated memoir of a recent trip, inserting photos into the text, sometimes several photos per page. Once my document gets to be more than about 10 pages, the photos seem to ...
0
votes
1answer
211 views

Set CSV as default import into a spreadsheet

In Libreoffice I can import a CSV file into a spreadsheet by simply double-clicking on the text file. In Openoffice 4.0 I have to click once on the text file to select it, then in the file type ...
7
votes
1answer
2k views

Preventing LibreOffice from using smart quotes (“ ”) instead of (dumb) straight quotes?

I use LibreOffice Calc to make lists of programs with different parameters to run on an hpc cluster. For each batch of commands I must do a find and replace on the smart quotes, as they cause errors ...
1
vote
0answers
230 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 ...
0
votes
1answer
207 views

Open Office Calc truncates my data on paste, how do I fix this?

Just as the title says, I am using Open Office Calc as a flat file to upload data. One column is my description and therefore can be a bit lengthy. Unfortunately it truncates this text. Anyway to ...
1
vote
4answers
2k views

How can I create a PDF file that my Nook Simple Touch won't reformat?

I've written a document in Open Office Writer and I'm trying to read it on my Nook Simple Touch. I'm exporting the .ODT file to a PDF file, and it works perfectly. The pages are all behaving as ...
3
votes
3answers
276 views

How do I convert a delimited list to a multicolumn table in excel?

I have a list like this: Friut;Taste;Color;Other;Apple;Good;Red and Blue;1;Orange;Really Good;Orange;12 And I want to convert it by selecting every 4 delimitations and turning them into rows like ...
1
vote
1answer
165 views

Is there another way to display a spreadsheet within OpenOffice Writer besides an OLE object?

I'm writing a paper for college in which I would like to either display or link to a large spreadsheet. I'm using OpenOffice Writer and Calc. I've tried importing the spreadsheet as an OLE object, ...
0
votes
2answers
70 views

Automating OpenOffice Installation

I am attempting to write a shell script which will download the latest version of OpenOffice using wget, and then use the command-line to install the application. I have seen that installing the ...
2
votes
0answers
153 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
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
1answer
8k 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
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, ...
0
votes
1answer
124 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
836 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
761 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
138 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
145 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
273 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
88 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 ...
4
votes
2answers
4k views

Which fonts come with OpenOffice / LibreOffice? [closed]

Is there a list of all the fonts which come with OpenOffice / LibreOffice ?
2
votes
1answer
1k 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
360 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
820 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
154 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
1k 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
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 ...
0
votes
1answer
54 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
739 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
4k 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
45 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
73 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
301 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
7k 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
2k 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
720 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
203 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
788 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
238 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
5k 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
72 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]" ...