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.
0
votes
1answer
25 views
How remove all characters after pattern in LibreOffice Calc
In LibreOffice Calc how can I use Regular Expressions to find and replace every character after a pattern, and remove the pattern itself.
Example:
123_2015970_etgn.jpg
124_2015971_etgn.png
...
1
vote
2answers
39 views
Is it possible to copy & paste a pivot table in a spreadsheet?
I have a spreadsheet where I use some pivot tables to summarize and highlight some relevant data.
Since I have to use multiple pivot tables, all with nearly the same data input but with slight ...
1
vote
1answer
23 views
How to color rows based on cell value in Open/Libre Office
How do you automatically set the background color of an entire row based on the value of a specific column in that row in Open/Libre Office? There are similar questions for Excel, but this doesn't ...
0
votes
1answer
23 views
sandboxing libreoffice on Linux
I want to build multiple versions of libreoffice on a machine (Debian 6) and want to test these versions against a set of test cases automatically. I also want to test the given libreoffice version by ...
0
votes
1answer
20 views
Libre office: How to format title pages for book (avoiding the missing blank-page when pdf-file exported)
How do you set up the i, ii, iii, iv... followed by the 1, 2, 3, 4... pages of the usual book format in Libre office? What is the logic of it?
Also how do you avoid the automatic BLANK PAGE appearing ...
0
votes
0answers
30 views
Convert HTML table into a native LibreOffice table
Sorry, I'm not quite sure where should I put this question.
I've visited ask.liberoffice.com, but I think it has different (although similar) mechanism to stack-overflow, and can't use my ...
1
vote
3answers
86 views
libreoffice what is a fast way to paste special > text and numbers only (aka paste special values)?
I copy and then paste values in excel quite a bit (when I use Excel). When I use LibreOffice you can do the same thing (see related question here) but it is oh so tedious!
It gets especially tedious ...
0
votes
1answer
17 views
Attempting to open TSV file in Libreoffice calc results in opened by writer
I have been working with tsv files for months, but I have one file that refuses to be opened in LibreOffice calc. It instead brings it up in writer. This behavior is consistent across command line and ...
0
votes
0answers
13 views
How to print directly to default printer in classical Linux applications?
It's kind of lost the print directly action in many applications like Firefox and Evince. This missing option is supposed to send the print job directly to the default printer with the default options ...
0
votes
0answers
11 views
How do I set the LibreOffice 4.0 Calc interface CTL font?
I use LibreOffice 4.0.x on Windows 7. When I was in Windows XP, the Hebrew font used in the Calc interface - for field values and for tab names for example - was Tahoma. Now it's David (or maybe David ...
-1
votes
0answers
38 views
Reshaping csv data with LibreOffice
Say I have a csv file with following data format:
ID, Name, Gender, Q1
1, ABC, Male, "A1;A2"
2, ACB, Male, "A2;A3"
3, BAC, Female, "A1"
I would like to transform it into following format so that my ...
0
votes
0answers
20 views
Libreoffice won't let me have a read-only ComboBox
I have a database table with some entries. I want to display all the fields of this table as a ComboBox. I want the user to be able to select this any entry in this ComboBox without modifying the ...
2
votes
1answer
70 views
How do I prevent LibreOffice saving the file with the thumbnails?
I am using LibreOffice 4.0 on Windows 7 and I have noticed that it saves files (for example Writer) with a preview. (The icon of the file shows what's inside it, it looks like a page).
How do I turn ...
1
vote
1answer
97 views
How to specify the target directory for LibreOffice 4.0.2.2 .msi file?
How can I specify the target directory for the LibreOffice 4.0.2.2 .msi installation?
The .msi file is here:
...
2
votes
1answer
273 views
Installing LibreOffice 4.0.1 on Fedora 17
I downloaded 'LibreOffice_4.0.1.2_Linux_x86-64_rpm.tar.gz' from official site of libreoffice and follow the readme to install.
The installation completed successfully, but when I entered ...
2
votes
2answers
135 views
Only root User is able to open LibreOffice
I am currently using Linux Mint 14 - Nadia as my Operating System.
The biggest inconvenience right now is not being able to open Libreoffice as a normal user or simply by just double clicking it. ...
1
vote
0answers
71 views
LibreOffice lock files and Dropbox
I use Dropbox for collaborative work between Windows workstations. One of the use is to share LibreOffice documents. Concurrent editings are normally forbidden by LibreOffice by creating a lock file ...
0
votes
1answer
35 views
Using LibreOffice and having problems, copying details
A staff member in our office is having trouble pasting details from a spreadsheet {In any format} to a template in .ott format.
When pasting and details from the spreadsheet, it removes some of the ...
2
votes
1answer
68 views
How to prevent LibreOffice running 'recover' at each startup?
How to prevent LibreOffice running 'recover' at each start-up?
On Ubuntu, each time I restart my computer, and then start LibreOffice, it asks me whether I want to recover documents. It does this ...
0
votes
1answer
58 views
Change date format in Libre Office
I have a column with date values with initial value as: '01.02.13' (in format DD.MM.YY) . Converted it to the required format (DD.MM.YYYY) '01.02.2013'. But when I focus on the cell it shows date as ...
1
vote
0answers
76 views
unoconv: export Excel file to PDF without any scripting
How to hide page header and footer during the Excel file export with unoconv?
I've tried to use a template (narrow margins, disabled header, disabled footer), but it does not work. I mean: margins ...
0
votes
1answer
33 views
Where can I get pre-reform spelling correction for Brazilian Portuguese in LibreOffice?
I've just made the change from Open Office to Libre Office (Windows 7), and have a problem with Brazilian Portuguese spelling.
Libre Office comes with dictionaries for the recently-reformed (some say ...
1
vote
3answers
77 views
Vim undoing text width formatting
I wrote a document in vim with textwidth=80. I would now like to paste this document into libreoffice for formatting. The problem is the line breaks. In libreoffice the lines are too short because of ...
1
vote
1answer
378 views
How to change the text direction in LibreOffice?
I need "right to left" text direction to write in Persian.
0
votes
0answers
244 views
init.d script for OpenOffice / LibreOffice headless does not stop process
I am using Ubuntu and found this init.d script for LibreOffice headless.
Problem is that it does not seem to be stopping the process when asked to "stop". Any help greatly appreciated.
Two other ...
1
vote
0answers
177 views
Creating a template for a Writer-based calendar (diary)
I'm currently working on a calendar for the new year – a daily planner, a diary! Something for GTD (Getting things done) based on a diary with planner options. It is created in OpenOffice or ...
0
votes
1answer
94 views
Batch Conversion to PDF with LibreOffice in Mac
I have LibreOffice installed on my new Mac. In Ubuntu you can directly access LibreOffice via command line. How do you access LibreOffice in mac via command line ?
2
votes
1answer
360 views
How to override GTK3 / Gnome Shell themes per application
I'm using both Cinnamon and Gnome Shell (Gnome 3) on Fedora 17 with the dark theme Blapple. Quite a few applications can't handle dark themes very good.
In Gnome 2 I had a simple solution for these ...
1
vote
0answers
23 views
How do I prevent LibreOffice update from reassigning the default program for .doc?
When using Ninite to silently update Windows XP computers in a lab environment, LibreOffice reassigns the default program for the .doc file type from MS Office 2010 to LibreOffice. How can this be ...
0
votes
1answer
32 views
How to apply a page style to a specific set of pages?
I want to split my document in three parts.
The first part is the first document which has the style "First Page". The other ones have "Default". Now, I want the appendix to have the "Index" page ...
1
vote
1answer
55 views
How to configure own shortcuts for styles?
When I Ctrl+B a selected text, it will become bold. Alas, this style is directly formatted, which means it gets lost once I default via Ctrl+M. Yet whenever I reset the whole document, I only want it ...
0
votes
1answer
159 views
How can I get the “After the Deadline” Libre Office extension to work
I have installed the "After the Deadline" extension for LibreOffice 3.6.3, but it does not pick up any grammatical errors, either as a wavy blue line while I type, or with a complete spell check of ...
2
votes
2answers
214 views
Horrible kerning in LibreOffice
You'd think that kerning would be the #1 thing to get right in a text processor, but LibreOffice shows me this:
Font is Palatino, with bold applied.
How to fix this? Note that the kerning is ...
1
vote
0answers
303 views
Creating fillable PDF form with dynamically updated fields
Is there a way to create fillable PDF forms where a set of fields gets their data when one of the fields is filled out?
The normal use case would be application form, where your name or membership ...
2
votes
1answer
299 views
Printing from the command line with LibreOffice, lpr commands?
I'm trying to print a word document from the command line, but I need to specify printing options that I would normally use lpr for. This is the command I'm using
libreoffice -p "filename.doc"
I ...
0
votes
0answers
32 views
How to reduce the number of spell-check languages/dialects
Even when I install Libre-Office (3.6.1) in advanced mode and only select Dutch, German, English and French as spell-check languages, I still find many more dialects (German-German + Austrian-German + ...
3
votes
1answer
101 views
How can I get LibreOffice to 'number' footnotes in the order *, †, ‡, § etc.?
With LaTeX, I can do:
\documentclass[10pt]{article}
\usepackage[symbol*]{footmisc}
\begin{document}
One\footnote{f1} Two \footnote{f2} Three \footnote{f3} Four \footnote{f4}
\end{document}
And ...
1
vote
3answers
429 views
What Excel formats are (most) compatible with LibreOffice and Google Docs? [closed]
I use Excel (and occasionally Numbers), but I want to be able to share with users of Google Docs and LibreOffice (and I may want to switch in the future). What's the most compatible format to save my ...
2
votes
0answers
246 views
MSI installer: Run in English instead of the system language
How can I make an MSI installer run in English?
I'm trying to install LibreOffice on a machine running a Korean version of Windows XP. I don't know Korean. I haven't used Windows with any frequency ...
1
vote
0answers
135 views
Typing math formulas in LaTex and getting them in MathType format?
I am asked to type some math formulas that can work in Microsoft Office and MathType equation editor.
But I only have access to Ubuntu 12.04 near me, there is LibreOffice available under Ubuntu as ...
1
vote
0answers
304 views
OpenOffice, LibreOffice and NeoOffice all crashes on startup on OSX LIon
I tried all new versions of LibreOffice, OpenOffice, NeoOffice. When I install them without any problems and then I try to launch them, I get the following error:
Process: soffice.bin [1178]
...
3
votes
3answers
524 views
How do you find the maximum value in a column, skipping to every nth value?
Using LibreOffice's Calc program (nearly the same functionality as Microsoft Excel) I have a set of numbers in column T, which represent numbers for the week (with labels in S). Each week's worth of ...
5
votes
5answers
463 views
Does any spreadsheet allow you to create your own functions?
I've always been frustrated when using spreadsheets by the inability to define my own functions when there is no existing function to (cleanly) do what I want. Does any spreadsheet offer this ...
0
votes
0answers
76 views
oDATA Explorer/Connector for Linux
Is there an open source / free oDATA explorer that either:
provides a stand alone oDATA viewer / editor,
plugs in to LibreOffice, or
a website that provides a nice ODATA interface (no SilverLight).
...
1
vote
0answers
252 views
Difference between Libre Office and Open Office [closed]
What's the difference between Libre Office and Open Office. Ubuntu 12.04 is shipped with Libre Office and before that all versions 10, 9, 8 were shipped with Open Office. If Libre Office is better ...
0
votes
0answers
37 views
How to disable LibreOffice from adding itself to start menu?
LibreOffice keeps pinning itself to the start menu even after I forcibly remove it. How can I disable this annoying "feature"?
0
votes
0answers
74 views
Can't change printer input tray from LibreOffice
I had CentOS 6.2 installed which came with OpenOffice, and in OO I was able to choose printer tray for input paper. My choice was respected.
Now CentOS got upgraded and I've got LibreOffice 3.4.5. ...
1
vote
0answers
58 views
Is there an easy way to view SVN changes in the OpenOffice/LibreOffice document compare view?
I store documents in a subversion repository. I would like to be able to see either my local yet to be checked-in modifications, or else the differences between two particular revisions, using the ...
0
votes
2answers
1k views
Can I make LibreOffice default program for all files
I have winXP LibreOffice and MS office installed.
How do I make LibreOffice the default opening program for all of its know document types?
I know that I can change one extension at a time. But is ...
1
vote
1answer
1k views
Open Office Calc: Convert a date to timestamp
I have a column with dates in M/D/Y like this:
8/8/2007
8/9/2007
8/10/2007
8/13/2007
8/14/2007
8/15/2007
8/16/2007
I would like to convert them to a unix timestamp (in a new column). Would anyone ...
