LibreOffice is a cross-platform office suite that originated as a fork of OpenOffice.

learn more… | top users | synonyms

0
votes
2answers
33 views

simplest cell addition formula on column in libreoffice 5

sharing as an example. I have data starting from column b2 to b8 where I want to add the values (sum) and get the output in another cell, say b10. The most logical way should have been =SUM(B2,B8) ...
2
votes
1answer
47 views

libreoffice calc: formatting hyperlinks (advice outdated)

My installation of libreoffice calc 5.1.1.3 doesn't seem to alter the formatting of hyperlinks, i.e. it looks the same as any other text by default. When doing searches for how to format said links, ...
0
votes
1answer
14 views

choose ODF vs OOXML [closed]

I just found out about the "war" between ODF and OOXML and I was wondering which was "winning" and whether I should support one over the other in an project that I am about to start up soon. I have a ...
0
votes
0answers
9 views

How to stop LibreOffice Writer from coming to the front?

"Coming to the front", "popping up", "z-stack appearance" - I don't know what you call it, but I want Writer to stop doing it! I've been writing some correspondence, I'm doing other things with other ...
1
vote
0answers
23 views

libreoffice calc failing to autosave despite configured to, losing hours of progress

UPDATE: I've finally beared witness to it failing to observe the auto-save settings (even though it did earlier, and I've changed nothing in the config file). I type something into a cell and hit ...
0
votes
1answer
30 views

Create a pdf from which images cannot be extracted [closed]

I would like to make a PDF (of a Libre-Office document) that has the following properties: The images it contains cannot be extracted and saved; It contains hyperlinks that should be keep on ...
1
vote
1answer
151 views

How to upgrade LibreOffice to Ver 5 in Debian Wheezy?

Debian Wheezy came with LibreOffice 3 (now two generations old). I want to upgrade or replace this with LO Ver 5 and manage this through the package manager. Online search for LibreOffice and Debian ...
0
votes
1answer
181 views

Gnome 3.18 on Fedora 23: LibreOffice ugly appareance when change GTK theme

When i change the GTK theme (Gnome 3.18, Fedora 23) the LibreOffice appareance is completely changed, it's looks like the theme was removed. This is how LO looks with the Arc theme: How can I ...
3
votes
1answer
31 views

LibreOffice Writer Numbered headings

I can't seem to get LibreOffice to consistently number my headings. I created a new document on one computer, with my headings set up to number thusly: 1 First Heading 1 1.1 Heading 2 2 Second ...
0
votes
1answer
51 views

how to use libreoffice --headless export more than one png image from ppt or pptx

I use libreoffice export images, command like: $ libreoffice --headless --convert-to png ./ /tmp/example.ppt but this command only export one page, is first page image, how can export few image or ...
1
vote
0answers
28 views

Freeze slide on external display (projecter), when using OpenOffice, and use laptop to do other (secret) thing

I am running kde on debian jessie (X11+Gnu+Linux). When doing a presentation, using LibreOffice (OpenOffice) presenter, the audience sees the external display, and I see the presentation console on ...
0
votes
0answers
23 views

LibreOffice will not start in fluxbox(no desktop environment)

So I started setting up a new build for arch and all I wanted on it was LibreOffice. However, unlike other programs(e.g firefox) it would not start in a plain fluxbox session. When I ran the command ...
4
votes
2answers
307 views

Specify encoding with libreoffice --convert-to csv

Excel files can be converted to CSV using: $ libreoffice --convert-to csv --headless --outdir dir file.xlsx Everything appears to work just fine. The encoding, though, is set to something wonky. ...
0
votes
1answer
79 views

Install 32 Bit Application on 64 Bit Arch Linux

I have an ancient openoffice plugin which requires the 32bit version of openoffice/libreoffice and does not work with the 64 bit version. So I would like to know, if there is any way to install the ...
0
votes
1answer
25 views

sync on Firefox between Linux Mint and different platforms

I use Mozilla Firefox and LibreOffice on several different platforms (Windows 10, Android,etc) and I love them both. I recently installed Linux Mint and Firefox and LibreOffice of course came with it ...
0
votes
1answer
66 views

Calc: display name of cell instead of its value or formula

Libreoffice Calc 'normally' displays the value of the cell. A user can change the display from values to formulas by putting a check mark in the config-box called Formulas in the config popup: ...
3
votes
1answer
68 views

Calc: How to convert a numeric column in-place?

In Libreoffice Calc, is there a way to convert a column of numbers "in-place", such as converting from miles to kilometers, or percent to decimal? I know how to do it by: adding a temporary column, ...
2
votes
2answers
87 views

Issue Converting to .ods When Viewing Another .ods File

My Python software regularly uses the commands:- soffice --headless --convert-to ods --outdir /tmp tblIssues.csv soffice --view /tmp/tblIssues.ods rm /tmp/tblIssues.ods given in answer to my ...
1
vote
1answer
420 views

Can't install LibreOffice 5 on Linux Mint 17.2, policy rule not taken into account?

I'm trying to install the package by following web upd8 article Install LibreOffice 5.0 In Ubuntu Or Linux Mint Via PPA, with the difference I use the Fresh PPA. Environment $ lsb_release -a No LSB ...
0
votes
0answers
47 views

LibreOffice crash my KDE 5.9

Every time I open any of the program from LibreOffice Suite, it makes my KDE crash. I see the interface going away (closing all my opened programs) and being replaced by the default black background ...
1
vote
0answers
79 views

Libreoffice missing menus in XFCE4

I have Linux Mint 17.2 64 bit (14.04 base) originally a KDE install. I installed XFCE4 from repos (4.10.1) and other desktops recently, but Libreoffice (4.4.3.2 40m0(Build:2) is not showing the Menus ...
0
votes
0answers
19 views

Losing LibreOffice Writer configuration

From time to time, the configurations of LibreOffice Writer is lost for no known reasons. Macros, Shorcut Keys, etc all are lost as if it's fresh new installation. Why does it happen and how can I ...
4
votes
1answer
118 views

Making graphs from database with Time/Date field

I've been trying to make a diagram from a LibreOffice (version 4.2.8.2) Base database with a date/time field, by copying the table in Calc. But the graph completely ignores the time part. To explain ...
1
vote
2answers
2k views

Open CSV File And Go Straight To Spreadsheet

Part of my software issues various commands to open and view different file types. For instance I use atril for PDFs and eom for PNGs. However I have a slight problem with CSV files. I can open them ...
0
votes
0answers
87 views

Table of Scenarios for Sensitivity Analysis

I want a table of scenarios, including columns not only for the input variables for each scenario but also critical result variables for sensitivity analysis. How can I do this in LibreCalc? Allow ...
1
vote
1answer
42 views

How to link .doc files with LibreOffice Writer

I received a .doc file in IceDove, double-clicked it and it asks if I want to save/open it, the only option for opening is caligraauthor. I want to use LibreOffice Writer for these documents, but when ...
1
vote
1answer
74 views

Recover File Libreoffice

So, here's my case: I do have a Writer file, in this Libreoffice Writer file, I copied a few tables from Libreoffice Calc(I actually did this for 6 hours) and pasted on Writer. When I went to see my ...
0
votes
1answer
36 views

Issue on updating Linux Ubuntu

As LU is strongly suggesting me, I want to update my packages but a problem (which I hadn't encountered before) interrupts upgrading process. Some specific packages fail to be downloaded. They are: ...
1
vote
0answers
124 views

About Libre Office Writer getting slow in Debian

I have recently installed Linux Debian and I have copied from an old windows-xp pc some .doc(word documents) archives. When I first opened them, they ran smoothly-just fine. 1) When I changed them to ...
0
votes
2answers
112 views

Installing OpenType font

I bought a full copy of Hoefler Txt, which is an OpenType font, and I'm trying to install it now on my system (Mint 17). However, the results are inconsistent between programs. Here are the steps I'm ...
1
vote
1answer
109 views

Fully MS-compatible office

I am using LibreOffice 3.4.5 on CentOS. Unfortunately, it's not fully compatible with MS Office. In particular, reading docx files leads to loosing all of the embedded formulae and some of the ...
1
vote
0answers
75 views

LibreOffice introducing random page breaks

I normally use LaTeX, but currently I'm collaborating with a couple of people who don't, so I'm forced to use LibreOffice (v. 3.5.7.2 running on Ubuntu 12.04 LTS). I'm saving the file as .docx so that ...
6
votes
2answers
2k views

How to convert libreoffice ODT to PDF in bash

I am using libreoffice under CentOS 6. I can convert ODT files to PDF with: libreoffice --headless --convert-to pdf *.odt but the problem is that it only works when no document is open in ...
1
vote
1answer
55 views

How to plot one dimensional data with margin of error in LibreOffice Calc?

I have some one dimensional classified data from several benchmarks with a margin of error. How can I plot them in LibreOffice Calc 4.3 with error bars? The data follows this scheme with more ...
3
votes
1answer
515 views

How to convert all odt files in a folder into microsoft word files ?

I have a folder with a lot of odt files from LibreOffice, I could open each one by hand and save it as a microsoft word file, but that would take a long time, is it possible to reach this goal using ...
1
vote
1answer
13 views

Which format in office libre writer to choose in order to omit problems when opening in word on windows ?

I have written a document in Libre Office Writer, it is crucial to me to keep the documents format. Now I am clueless in which format to save it, since there is a plethora of options, even different ...
2
votes
1answer
416 views

Convert Tab Separated csv using unoconv

I am attempting to convert a tab separated csv into an xls file using unoconv. However, the tabs are not being recognized as the field separator. Can someone please tell me how this can be done. I've ...
1
vote
1answer
199 views

XML Microsoft Word Document

I have a .xml file generated by someone with MS Word and I cannot manage to open it with LibreOffice or other app or change its format. I tried to save a LibreOffice document as "Word 2003 xml" and ...
0
votes
1answer
80 views

Syntax highlighting and export EPUB format

I need to write RTL format and finaly export as Epub (pdf as freedom).I need to explain my codes and somthing such as syntax highlighting, Do you have any solution? UPDATE: My question has 2 aspect: ...
3
votes
0answers
91 views

How is This Symbolic Link Not Being Followed?

I have LibreOffice Writer and OpenOffice Calc installed on my OpenSuSE system. This is arguably not ideal, but before I fully switch to one or the other, I noticed some strange behaviour when calling ...
-7
votes
1answer
751 views

Merging spreadsheets?

I have a list of LibreOffice spreadsheets (xls files) each one has one sheet. I wanted to merge all those spreadsheets in one big spreadsheet including all the tabs/sheets inside it. For example: lets ...
1
vote
3answers
140 views

Search for variable in OpenOffice/LibreOffice

I am using OpenOffice.org Writer to write a book. I foresee the possibility of some characters' names changing, so I am using variables where their names go "Insert > Fields > Other". However, I ...
1
vote
1answer
3k views

Converting documents to text with UTF-8 encoding

unoconv uses LibreOffice to convert any file that LibreOffice can convert. Now I need export to text with the UTF-8 character encoding. I use the following command: unoconv -f txt -e ...
1
vote
0answers
182 views

How to paste an HTML table into Libre Office Calc without losing structure

I want to paste an HTML table into Libre Office Calc. The HTML table rows contain images (in column 1) that should stay with their appropriate row. However, when I paste my HTML into Calc, the images ...
4
votes
1answer
8k views

Headless use of open office or libreoffice in Ubuntu 14.04

I want to install openoffice headless in Ubuntu 14.10, but when I try to install it, it says there is no package for that name. I installed libreoffice-common using apt-get, but I can't find ...
2
votes
1answer
776 views

LibreOffice Writer Go to page

Is there a go to page feature in LibreOffice writer so one can type a page number to go to that page? There similar feature in MS Word.
2
votes
2answers
358 views

Converting .odm to .odt

How can I convert LibreOffice Master Document which consists of several .odt files into a single .odt file‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌‌?
2
votes
1answer
255 views

Document save instead of autorecovery save

In a LibreOffice Writer document, I want to disable autorecovery save but I want automatic save be enabled. Is there any way to do this? Saving takes time for large documents. Saving both the ...
1
vote
0answers
51 views

Language change macro in LibreOffice Writer

As the cursor moves in a LibreOffice Writer document, the status below the window shows the language of the characters around the cursor (e.g. English(USA)). Is there a way to run a Macro (named e.g. ...
1
vote
1answer
523 views

Upload libreoffice impress presentation to youtube?

I am interested in creating a presentation in Libreoffice Impress, exporting in X format, and uploading it to Youtube with little hassle. How do I do this? What should X be? Have you done this ...