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

1
vote
4answers
134 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
690 views

Spacing before the paragraph right after a table?

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 Text, I get no space between the table and the subsequent ...
0
votes
1answer
8k views

Unzip error “End-of-central-directory signature not found”

I have a ZIP file that open in Windown/MS Word, (actually it is a .DOCX file). Opening it with LibreOffice / Mac produces: General Error. General input/output error. File says: ../Commission ...
2
votes
1answer
2k 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
2k 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
28 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
49 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.). ...
3
votes
2answers
3k 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
38 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
305 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
39 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: ...
2
votes
0answers
148 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 ...
1
vote
0answers
113 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
794 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
581 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
1answer
178 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
1answer
726 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 ...
1
vote
0answers
1k 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
246 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 ...
3
votes
0answers
265 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
55 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
36 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
109 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
892 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
542 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
30 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 ...
2
votes
0answers
852 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 ...
3
votes
3answers
286 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
126 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
3answers
797 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 ...
1
vote
2answers
2k 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
54 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 ...
5
votes
3answers
6k 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
212 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
88 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 ...
2
votes
0answers
1k views

How to copy a column with conditional format by “value” - Libreoffice 4.1

I have a column that contains the data and a set of rules for the conditional format of the cells. i.e. the conditional format changes the background colour of some cells if they are negative. I ...
1
vote
0answers
297 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 ...
0
votes
1answer
136 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 ...
0
votes
1answer
36 views

Recover a file with a wrong suffix? [closed]

I wrote a text Under Libre Office and wrongly named the file with a .txt suffix. And closed it. When I tried to open it. it was said corrupt. And was displayed in non understandable characters. What ...
5
votes
1answer
693 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 ...
2
votes
0answers
30 views

Libreoffice calc: pagebreak within row?

When printing a LibreOffice Table, LibreOffice will automaticaly place the pagebreaks so that they appear after/before a row. When having many tall rows this results in a heavy paper-usage. How can I ...
0
votes
0answers
122 views

Latest version Libreoffice Headless CentOS

I am somewhat new to using Linux so my apologies if this seems like a simple question. The problem I am facing right now is an outdated version of Libreoffice. The server is running CentOS 6 ...
0
votes
0answers
110 views

Libreoffice PPT to PDF Place Holder Text Removal

I am using Libreoffice headless version for CentOS to convert .pptx to PDF. But the PDF produced have placeholder text that says "Click to edit master text styles", "First Level", "Second Level", etc. ...
3
votes
2answers
1k views

Is there a CLI-only package to convert MS Office files to PDF?

Is there a command-line interface only package to convert Microsoft Office files to PDF? Specifically, I need to be able to export doc/docx (Word), ppt/pptx (PowerPoint), xls/xlsx (Excel), and ...
0
votes
1answer
109 views

How to fix the strange character in libreoffice?

I have a docx file with mathtype 6.8 The docx only has this equation. But when I load in libreoffice 3.6.2.2, it becomes Here is the doc file: ...
2
votes
0answers
113 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 ...
3
votes
2answers
5k views

Convert file to PDF using LibreOffice under user apache (i.e. when using PHP)

I installed libreoffice-headless and can convert documents when logged on into the shell as a normal user. [root@desktop ~]# yum install libreoffice-headless [root@desktop ~]# yum install ...
1
vote
1answer
359 views

Effect of HOME on libreoffice to convert to pdf as non-root user

I installed libreoffice-headless and can convert documents when logged on as root. I then tried doing so as another user, and it didn't show an error, but didn't convert the file. I then found that ...
1
vote
1answer
5k 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 ...