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
84 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.). ...
4
votes
2answers
5k 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
49 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
529 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 ...
-1
votes
1answer
48 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: ...
5
votes
1answer
255 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 ...
2
votes
0answers
188 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
2k 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
2k 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
444 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 ...
1
vote
1answer
1k 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 ...
3
votes
0answers
2k 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
500 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
1answer
442 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
61 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
46 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
141 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
2k 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
1k 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
32 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 ...
3
votes
1answer
2k 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
732 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
273 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
1k 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 ...
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 ...
0
votes
1answer
69 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 ...
9
votes
3answers
14k 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
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 ...
1
vote
1answer
146 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
1answer
3k 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
477 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
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 ...
0
votes
1answer
47 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 ...
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 ...
2
votes
0answers
31 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
144 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
130 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. ...
4
votes
3answers
2k 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
149 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
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 ...
4
votes
2answers
9k 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
518 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
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, ...
2
votes
1answer
5k views

PDF file opened with LibreOffice, now conversion to Word needed

Of all the software I ever tried to handle PDF files, I found LibreOffice by far the best (at least for the files tested). The number of codes when importing the odg file into DVX2 (this is a CAT ...
2
votes
1answer
879 views

What character encoding does ODT use?

Whenever I open an ODT file saved by LibreOffice with default settings, and open it in a plain text editor, I get a bunch of nonsense. Not a single trace of the text I typed. In what character ...
1
vote
0answers
553 views

Libre Office Calc, User-defined Number format permille

I know that LibreOffice allows you to define custom number formats. I have a spreadsheet that displays some smallish percentages (all are less than 1%). I would like to use permille ‰ instead. ...
1
vote
0answers
62 views

Header from top equivelant in LibreOffice

I try to follow some formation instructions for a few documents I need to deliver to a customer. The documentation instructions are set for Office 2007 but I need to write the documentation in ...
0
votes
1answer
108 views

How to get the average of the higher M values in N cells?

I have a spreadsheet with values in a matrix with several rows. For each row I have a N numbers. I want to calculate the average of the M higher values of the row. With M<N. Is there a common ...