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

learn more… | top users | synonyms (1)

1
vote
0answers
100 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
1answer
36 views

How do I check if the document formatting is right?

I have to submit a paper to a competition. They have strict rules on the formatting that is to be used. For example, the size of the font, the margin, the space between the paragraph and so on. I ...
0
votes
0answers
95 views

Printer shows up in control panel but not in office programs

So the printer is setup and working, shows up in the control panel, but on programs like openoffice libreoffice, and another one I can't remember at the moment it's just gone. I reinstalled it and it ...
0
votes
0answers
37 views

Inserting a web page in an OpenOffice Writer document and keeping (some) style

I'm writing a report for school and I would like to include a html document as an appendix. So far all my attempts have resulted in a seriously malformed appearance. The results are hardly readable ...
2
votes
1answer
436 views

How to count the number of review comments from a specific author in Word?

I have a large MS Word document with a high number of review comments (track changes feature). I'd now like to get a list of authors and the number of review comments. The number of authors is not too ...
0
votes
1answer
44 views

I've created a “section” in Open Office Org, but how to I exit from it & continue with my regular page parameters?

Using Open Office Org on my Mac os x 10.5.8, I typed text into my page, using my regular document parameters/margins, then I inserted a "section" so that what I typed in next could be entered in 2 ...
0
votes
1answer
210 views

Libre Calc error on a float in decimal notation. Err. 519 (#value error)

There is a problem with my libreoffice. I doesn't calculate cells with decimal points, possibly seeing them as text. I have checked my locale settings (you can see them in the picture above) that ...
0
votes
0answers
10 views

How can I include a chapter title in a header in Word or OO Writer? [duplicate]

I would like to include a chapter title in a page header in either (Mac) MS Word 2011, or OpenOffice writer. How can I set a segment of text (the title) on either a chapter-by-chapter basis, or ...
2
votes
2answers
53 views

How to autofilter for given strings in common spreadsheet softwares?

I know I can create an "autofilter" at the top of an XLS table.. But how can I create a filter that filters for given strings? example TABLE input: LASFD@FOO.COM LKXYCVER@FOO.COM ...
2
votes
0answers
30 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. ...
0
votes
2answers
401 views

How to hide paragraph marks in OpenOffice.org Writer?

How do I remove the blue P-marks that indicate paragraphs from my documents when working? I have looked under the 'Tools' menu but have been unsuccessful.
5
votes
1answer
249 views

How to show full document path in Open Office title bar?

How can I automatically show the FULL PATH of the currently loaded document (not just only the file name) in the title bar of Apache Open Office 4, e.g. OO-Writer?
5
votes
1answer
284 views

Is it possible to remove the hyperlink background in OO Calc?

Hyperlinks in OpenOffice Calc are displayed with a solid background which covers the background color of the cell. I don't want a solid background; I want the background color of the cell to show ...
2
votes
3answers
214 views

How to embed formulas in a line of text using OpenOffice Impress?

I want to create a presentation in Impress and need to embed a formula in text. I only found very old forum posts (over five years old), which said it is not possible. Has this changed by now? How ...
1
vote
1answer
60 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
845 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
82 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 ...
1
vote
2answers
1k 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 ...
1
vote
2answers
96 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 to ...
3
votes
1answer
191 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
1k 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
871 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
263 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
28 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
123 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 ...
4
votes
1answer
516 views

Is there a way to set the default quotation mark in LibreOffice Calc from smart quotes (“ ”) to dumb quotes (the straight kind)?

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
132 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
117 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 ...
0
votes
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
191 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
106 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
66 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
100 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
17 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
4k 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
170 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
42 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
470 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
424 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
94 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
129 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
150 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
77 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
2k views

Which fonts come with OpenOffice / LibreOffice? [closed]

Is there a list of all the fonts which come with OpenOffice / LibreOffice ?
3
votes
1answer
488 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
176 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 ...
-2
votes
2answers
440 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
119 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. ...
1
vote
1answer
608 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
550 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 ...