LibreOffice is a free and open-source cross-platform office software suite, developed by the Document Foundation. It is the default office suite in many Linux distributions.

learn more… | top users | synonyms

0
votes
1answer
7 views

How to auto-resize and fit copy pasted content from a webpage into document file?

I copy pasted some text with tables into an OpenDocument Text file, but for some reason the text, tables and images run off the ride side of the pages. Is there any way to make LibreOffice to ...
0
votes
1answer
9 views

Dedupe drawing objects in SVG/vector graphics files

I have an exported image consisting of ~35000 objects (the only way to get it out of the source application was as a copy-pasted "metafile"). By pasting into libreoffice draw and converting to ...
0
votes
0answers
22 views

php shell_exec not working in centos

i would like to convert .docx file to .html using php shell_exec my php code: $command = "libreoffice --headless -convert-to html resume.docx 2>&1"; $result = shell_exec($command); echo ...
0
votes
0answers
13 views

Automatic backups (history) in LibreOffice (OpenOffice)

LibreOffice can create a backup copy when you enable it in settings (Options > Load/Save > General), but it saves only the previous state (one only). It has also an versioning feature (File -> ...
0
votes
0answers
29 views

Search and replace with different formatting style

In LibreOffice or OpenOffice Calc spreadsheet, is it possible to search-replace while changing formatting of the replacement text to subscript or superscript at the same time? I have a spreadsheet ...
0
votes
2answers
21 views

LibreOffice Calc, Fill in Differenet Numbers of Empty Cells with Above Value

I have two columns of data currently in data like this (i.e., varying number of blank cells in Column B): Column A       Column B ...
0
votes
1answer
22 views

Download LibreOffice 4.1.3 EXACT version [closed]

I need to quickly download LibreOffice 4.1.3 or I'll lose out on something important. I've tried renaming the older installs that are close to that version number. I'm not seeing any archives (like ...
0
votes
1answer
28 views

LibreOffice for Windows Security

I use Windows and would like to install LibreOffice. Is there a "security team" checking the code for malware? In Linux I think it's done by the security team of the linux distribution. Who is doing ...
1
vote
4answers
90 views

Source code line endings in LibreOffice Writer

I have a paragraph style called "Source". It has no spacing above and below, and it uses a mono-space font and gray background. I want to paste text with some longer lines into my document and it ...
0
votes
1answer
21 views

Spacing before the paragraph right after a table?

I sometimes use Microsoft Word 2010 (and sometimes 2003). My Body Text style has space below, but not above, and I want it to stay that way. Now, when I insert a table between two paragraphs of Body ...
0
votes
1answer
77 views

LibreOffice 4.2.1.1: do not display list of recent documents

Today I installed LibreOffice 4.2.1.1. When opening LO, it displays a list of recent documents with screenshots, similar to Firefox and Chrome. I don't want this. How can I disable this setting?
1
vote
1answer
28 views

How to create a new file from Finder's context menu?

Could you tell me how to add a menu item into Finder's contextual menu (the one I get when I Control-click in a folder)? When I create a document or spreadsheet using LibreOffice, I usually run ...
0
votes
0answers
6 views

Quickly paste image inline

Sometimes I want to paste an image into a LibreOffice Writer document inline ("as character") at the current cursor position. One way to do this is: Paste the image. LibreOffice pastes it as a ...
0
votes
1answer
12 views

Style not sticking in LibreOffice Writer

I'm using Writer to modify a .docx file. The file was originally a "template" made by my professor with pre-configured styles for different parts of the document (spacing and indentations, etc.). ...
0
votes
2answers
104 views

LibreOffice is saving CSV files with tabs as separators

I just opened a CSV file in LibreOffice, made a small change and hit save, saying "yes, keep using CSV". The file is now filled with tabs instead of commas. My scripts (using Python's CSV lib) won't ...
0
votes
1answer
8 views

Libre office Writer: image linking latex-like

As with latex, is it possible to write the path to an image and then get its content automatically updated by the program? I would need something like this tool without changing editor.
-1
votes
1answer
53 views

Change background fill of cells in LibreOffice worksheet containing specific text

How can I change the background fill of all the cells of a LibreOffice spreadsheet worksheet that contain a specified text? In Excel that could be done by configuring the settings in the find and ...
0
votes
0answers
24 views

Recover a lost LibreOffice document [duplicate]

I was working in LibreOffice Writer with an .odt document yesterday, was saving it regularly, but today it looks like I did nothing! I think, the reason is in me accidantally saving it in /tmp all the ...
-2
votes
1answer
29 views

How can I type certain days (such as Monday, Wednesday) in an easy way for the next 5 months without typing them one by one?

I am trying to input in a libreoffice calc file only Mondays and Wednesdays for the next 5 months, but I dont wanna do it typing the dates one by one. So..I thought I would type 4 dates like this: ...
1
vote
0answers
23 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 ...
0
votes
0answers
27 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 ...
0
votes
1answer
38 views

In two columns layout, how to keep text in each column separate from the other?

I am editing odt document in LibreOffice Writer. I have the following, very simple layout, it looks like this: I would like to text in each column to stay separate from the other column. So the ...
2
votes
1answer
34 views

Excel/Libreoffice returning TRUE for IF() instead of expression

See the following situation: For some Here cells A1:E3 have plain text data (no formulas), and C4:E4 have the same formula (i.e. typed in one cell and then autofilled to another ones). I wanted ...
0
votes
0answers
15 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
18 views

Hide slide numbers and slide footer on first and second slide in LibreOffice Impress

I use LibreOffice Impress for to create my presentations. I am wondering how I can choose not to show the slide footer (including e.g. the slide numbers, presentation title and date) not only on the ...
0
votes
0answers
50 views

How to batch convert .sxw to .odt on OSX

I have a lot of old .sxw file than I want to convert to the Open Document Format (.odt). In libre office I found the "File" -> "Wizzards" -> "Document Converter" but it's only allow conversion from ...
0
votes
1answer
84 views

Printing problems with libreoffice and (remote) cups server

we have cups running on an ubuntu server managing all printing jobs. on the ubuntu clients the server is set in client.conf Printing works from every tested program, but not from libreoffice. (tested ...
0
votes
0answers
27 views

Display rows of table control differently

I have a LibreOffice-Base form with a table control displaying contents of a database view. Is it possible to display the rows of this control in e.g. different colors or fonts depending on the ...
0
votes
0answers
268 views

Libreoffice Base: How have a combobox linked to a related table linked to or in the form table control

I could not sum up, what I really want in the title. But here I am going to try to explain what is it about. I have switched from MS Access to Libreoffice Base because it is open source, free and ...
0
votes
1answer
49 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 ...
2
votes
0answers
92 views

Open only the first 10 lines of large CSV file in LibreOffice Calc

I will start receiving many large CSV files, of which only the first few lines are of interest to me. I was hoping to open them by piping only the first few lines to Calc, but this doesn't work: $ ...
2
votes
2answers
47 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
16 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
1answer
48 views

What setting change would cause my Libre Office document to decrease the usable size of the page?

I must have accidentally hit some key combination that caused the settings for my document to change, because all of a sudden I went from around page 420 to page 450, and the text no longer fit on the ...
0
votes
2answers
84 views

How to make Libreoffice integrate better with KDE graphic environment

I'm running Libreoffice 4 in Kubuntu 12.04, hence inside a KDE environment. The graphic isn't at its best, as you can see the menu borders aren't drawn at all, making the interface plain and not very ...
0
votes
2answers
68 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.
1
vote
0answers
24 views

Optimal format for office suites portability

I really don't know how to ask this a better way. I have tried googling, but even Google isn't of much help if you don't know what exactly to search for. For some reason, LibreOffice seems to ...
1
vote
0answers
225 views

Exporting high quality PNG from LibreOffice Draw

I need to generate a PNG file of an image composed in LibreOffice Draw. When I export to PNG directly, the quality is almost perfect, but it's just slightly blurry. However, when I export directly ...
0
votes
0answers
15 views

Can I make an auto naunced document? Change title, and variables and functional fields setup a slightly different document to export?

I would find it useful to have a master document, on which I could centralise the text for a number of similar documents. Then using variables & conditions, set it up so changing a field like the ...
0
votes
0answers
78 views

How to resize page to fit drawing contents in Open office/Libre Office Draw

I am programmatically drawing a flowchart in open office draw by means of Java UNO Runtime Reference api.After I have drawn the flowchart I want to resize the page according to the area aquired by the ...
2
votes
1answer
63 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
0answers
17 views

Is there a way to change the query a report uses in Libreoffice Base or better yet to select the query at the time a report is run?

I have a standard set of data that I always want out of a report, however it could be based on a query of any of the values. Is it possible to set it up so I double click on a report and it would let ...
0
votes
2answers
256 views

Can't install LibreOffice on Windows 7

I've just downloaded LibreOffice 4.1.3 (twice) on a newly refurbished Windows 7 Thinkpad. When I click the .msi to install, I get "This installation package could not be opened. Contact the ...
0
votes
0answers
200 views

Fix for: Xlib: extension “XINERAMA” missing on display

I am using Xming 6.9 with putty trying to run libreoffice remotely. It works well, but an error line appears in the terminal from where I launch it: Xlib: extension "XINERAMA" missing on display ...
1
vote
1answer
161 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 ...
0
votes
1answer
34 views

Libreoffice readonly document with one specified name

I can't edit file with one name on my computer. When I try to save new file with name /home/lissin/Рабочий стол/Без имени 1.odt I got error can't save file. When I rename any other document to that ...
2
votes
3answers
518 views

LibreOffice Writer: How to apply strikethrough text formatting?

Version: LibreOffice 4.0.2.2 Is it possible to apply strikethrough text formatting in LibreOffice Writer?
3
votes
1answer
129 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 ...
1
vote
1answer
57 views

How can i reset my Libre Office Calc setting

I am using Libre Office Calc for my Excel work. Image 1: Image 2 I can not see the format color in on Libre office installed @My System. but on my Colleague System who uses the same Libre ...
0
votes
0answers
129 views

Character count instead of word count in libreoffice status bar

Is it possible, and if so how, to change the word count in the status bar of libreoffice to display a character count instead?