Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [libreoffice]

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
0answers
13 views

A change to a LibreOffice style does not get applied to the document?

Not sure if I'm doing something wrong: I have a text document written in LibreOffice Writer (v6.0.4.2, German). The document uses only basic styles - Title, Heading 1, Text Block. Now I would expect ...
0
votes
0answers
26 views

Libreoffice named sections?

How do I create 'named' sections that have a header with a particular style? Ideally I'd like to be able to update the style of all sections in my document in the future.
0
votes
0answers
23 views

LibreOffice set file revision number

How do I set the revision number of my document? I have a tendency to hit CTRL+S a lot and this causes the revision counter to go up drastically. Ideally, I'd like to have a revision number for every ...
2
votes
1answer
42 views

Can I change format of text between '' in Libre Office?

I have a document in LibreOffice where I use ‘’ to mark inner thoughts. Once I finish with edits, I turn this text along with ‘’ into italic. However, I know only about manual way, and I'm wondering ...
1
vote
0answers
31 views

Why font is changed automatically in LibreOffice for Linux?

I'm using LibreOffice 6.1 on Linux Mint 17. I would like to create a presentation using Impress. I set the font to Droid Arabic Naskh. Then, I save and close the file. When I open it again, the font ...
0
votes
0answers
12 views

Conditional Output

I have a 4-column data set (part of which I am attaching as an image below), and I want to output a piece of text in the fifth column according to the rules in the image. The correct data is shown in ...
2
votes
1answer
26 views

LibreOffice how to add a rating using dots

I'm need to rate things on a scale from 1 to 5, 1 being the lowest and 5 the highest rating using dots in a table. a xxx b x c xxxxx where the x are placeholders for dots. So ...
0
votes
1answer
46 views

How to hide the menubar in LibreOffice with the standard toolbar UI?

Posted in order to provide the answer. Can the menus (titles of menus with options) be hidden behind one single button? I see that at least in some of the "User interfaces" (a newer feature that can ...
0
votes
0answers
15 views

LibreOffice stack on save

I use Linux-Mint.I have been working all day on a .ppt presentation on LibreOffice and i haven't saved my work. When i tried to save it , LibreOffice stuck. Now i can not do nothing, even can not ...
-2
votes
1answer
43 views

Word Processors: How to keep previous style when moving cursor position?

This is a general question about word processors, and I need an answer of some word processor, especially the tagged editors. How to keep the previous style when moving the cursor position? For ...
3
votes
1answer
38 views

How do identify the source of a #NAME? error in Libreoffice Calc?

My LibreOffice Calc spreadsheet contains the following formula: =IF(D8=0,'',C8*D8/B8) If B8, C8, and D8 all have values, then this works. But if they are empty it doesn't work, I get a #NAME? error ...
1
vote
0answers
30 views

Can I use Excel keybindings in Libreoffice Calc?

LibreOffice Calc has its own set of keybindings, which is different to those in Excel. Is there a "compatibility mode", or some way to match Excel's keybindings? I know I can change the bindings one ...
0
votes
0answers
88 views

Linear interpolation lookup table in LibreOffice Calc

I have a table of data like this 0 -105.0 10 -114.3 20 -121.8 30 -127.0 40 -129.6 50 -130.8 60 -131.2 I've discovered the LOOKUP() function, which lets me input a value from the first column ...
0
votes
0answers
10 views

Autosize text in PDF forms with LibreOffice Draw

I'm using LibreOffice Draw v5.3.7.2 to create some PDF forms. I found the form toolbar and I can create forms just fine. I want to have a text form field, where the text is automatically scaled to ...
0
votes
0answers
19 views

HyperSQL “user lacks privilege or object not found” error when Java access its table

I created a HSQLDB file using LibreOffice Base 4.4.7.2. In the Tool>Option>Advanced, the JRE class path is set to my JDK 1.7.0_80 & it is selected. The database contains a table named TABLE1. In ...
0
votes
1answer
45 views

How to decompress and compress .odt and .docx?

I have a LibreOffice text document that I need to decompress to edit some of the meta files, and after that I need to rebuild the text document. I can decompress it with 7zip, but after that I'm not ...
0
votes
0answers
32 views

Libreoffice: How to have right-to-left text and chess notation in 1 paragraph i

I am seeking to use both persian, and chess notation inside a single paragraph in Libre office. Is it possible?
2
votes
2answers
45 views

LibreOffice Calc: conditional formatting based of column / cell value

Unfortunately I cannot grasp how the conditional formatting works. I have a sheet like that: I have defined 2 cell styles "Low" and "High" and I want cells in columns A-E to have one of these styles ...
0
votes
1answer
100 views

What to Save As when exporting Visio .vsd to OpenOffice or LibreOffice to minimize differences?

I have a Microsoft Visio Pro. 2010 file (.vsd), and I want to work with it in LibreOffice (or OpenOffice, as a secondary option). When I import the .vsd file to LibreOffice, there are many ...
0
votes
0answers
47 views

Summing Euro amounts in Libreoffice calc

I have a spreadsheet with a column full of Euro amounts. This spreadsheet is created from a CSV and the amounts are interpreted as strings (text) rather than as numbers. I've been trying to get the ...
0
votes
0answers
33 views

libreOffice calc prefixes the name of the sheet into all the cells that are an equation

LibreOffice calc prefixes the name of the sheet into all the cells that are an equation. This is really annoying. Not only it makes the size of the spreadsheet enormous, but if I want to make a copy ...
1
vote
1answer
41 views

Opening a .doc file, which is actually an HTML file, as a .doc file

My software generates .doc files which are actually HTML files but with the ".doc" extension. When I open them in Microsoft Office they open as a .doc file and the user does not know that it is ...
0
votes
1answer
99 views

How do you draw freehand (like a pencil tool) in LibreOffice Draw?

How do you draw freehand in LibreOffice Draw? Is there a "pencil tool"? I can see on the left that there's a button to change the "Line Color" and it looks like a pencil, but clicking this doesn't ...
0
votes
1answer
45 views

spreadsheet formula for returning parts of filtered cells in column

I use Libreoffice. (If Excel or GoogleSpreadsheets would be the only way to get a solution, I would be willing to switch. But the preferred platform is LibreOffice, I'm looking for a solution on this ...
0
votes
0answers
23 views

How can made MS-Excel Find and Replace dialog box as a bar which is docked below the window same as LibreOffice Calc interface option?

I have an opportunity in LibreOffice Calc which is very attractive for me. That is an option for UI interface. Made the Find and Replace dialog box to a sub-bar. And possible to dock it below the ...
3
votes
2answers
91 views

Align data columns in LibreOffice Calc according to numbers in another column

I have three columns: Column A contains a count from 1 to 100, representing different sample stations. The numbers are in sequence. Column B is independent of column A. It contains selected ...
1
vote
1answer
26 views

Why is Linux Mint corrupting certain application icons?

Linux Mint 18.3, in both Cinnamon and KDE desktops, is doing something strange to the icons for LibreOffice (and only that application). I tested the most recent versions of various other distros and ...
0
votes
1answer
6 views

LiberOffice Calc apply style with only specifc attributes

Consider this simple time tracking spreadsheet: I figured out how to use conditional format to apply a selected style to a region, in this case I use "Accent" for Fridays and Saturdays, and this ...
1
vote
2answers
23 views

define newline in autocorrect of libreoffice

I use Ubuntu 16.04 and want to define new line in AutoCorrect of LibreOffice. In LibreOffice 5.1.6.2 I selected tools -> Autocorrect -> Autocorrect options -> replace tab then in Replace ...
0
votes
1answer
34 views

Libreoffice CSS for HTML?

I'm trying to convert a Docx file to HTML for eventual publishing as a web page. Libreoffice does a pretty good job converting the Docx file to HTML. When viewing the HTML in Libreoffice, it looks ...
0
votes
1answer
120 views

LibreOffice Calc: What is the data range syntax?

I want to specify a graph's data ranges, but I don't know what format the data range specifier strings are in. Specifically, I'd like to specify all cells in Column A starting and including row 2 for ...
0
votes
1answer
43 views

LibreOffice base table lookup

I am recently transitioning from MS Access to LibreOffice base. I am trying to create a new DB with table lookups. I have searched google, YouTube and stack exchange but I think I don't know the ...
0
votes
0answers
33 views

How to persist pivot table formatting in Libreoffice?

Is it possible to persist pivot table formatting in Libreoffice? I've created a pivot table, and I've formatted a summation column as a percent with no decimals. However, when I refresh the pivot ...
3
votes
0answers
58 views

In LibreOffice Calc, how can I change the cell selection black ring to something lighter for dark backgrounds?

In LibreOffice Calc, how can I change the cell selection black ring to something lighter so it can be easier to see for dark backgrounds? I will attach an image to show what I mean. It would be nice ...
2
votes
1answer
54 views

References in color-scale conditional formatting formulae for ranges

I'm using Libreoffice Calc (v6.1b). Suppose I have numeric data in sheet column, A and I'm applying conditional formatting to sheet column B. I want each cell of B to have a color on a scale ...
0
votes
0answers
74 views

LibreOffice - Can't open files, Terminal issues JRE-Warnings

So I'm using Linux Mint and as of yesterday, LibreOffice can't seem to open files anymore. Libre itself seems to work just fine (when started from Terminal), it just doesn't display anything. This is ...
2
votes
1answer
65 views

I want to feature faded images behind the text on some pages in LibreOffice

Can anyone tell me please how to simply insert one specific image behind the text etc on single page in LibreOffice 5.0.4/2? I've tried various configurations and looked at many forums, but I keep ...
-1
votes
1answer
230 views

Is it possible to automatically invert picture colors in LibreOffice using macros?

I was looking for a tool/extension/build-in abilities to invert picture colors automatically (via macro) in LibreOffice and how to do it, and posted the question here. Then I just discovered Invert ...
2
votes
0answers
48 views

LibreOffice creates tmp file every save

When opening a LibreOffice document on a remote share, the title bar says "Title.ods (remote)", and whenever I save the document a new temporary file is created, with a name like ~gvfry9s.tmp. I ...
0
votes
0answers
105 views

Libreoffice - Find export filter parameters

Given this command line to convert a file into a jpeg image with LibreOffice: soffice --headless --convert-to jpeg --outdir . odf-file I saw you can set some options like quality compression when ...
1
vote
1answer
150 views

How can I add duplicate rows to LibreOffice Calc to make there be one per day?

I have some data like this (it's stock market data) 29/07/2015 35972.82 32056.2 17751.39 30/07/2015 35961.86 32046.43 17745.98 31/07/2015 35848.13 31945.08 17689.86 03/08/2015 ...
1
vote
1answer
73 views

.csv file from Excel vs .csv file from Libre Office

I created a simple .csv file with Excel which looks like this: I also created the same .csv file by using Libre Office. Both .csv files are looking absolutely the same at TextEdit: id, questions 1,...
0
votes
1answer
46 views

libreoffice cannot find -lstdc++

when I try to open the application LibreOffice on linux it shows the Openning Logo then crashes and prints this lines : /usr/bin/ld: cannot find -lstdc++ clang: error: linker command failed with ...
1
vote
1answer
683 views

Find string surrounded by specific character, replace the characters but keep the string intact

I have several documents that contains variables which need need to be changed from this: @CapitalPx@ To this: ${CapitalPx} I found out about finding and replacing using regex, and came out with ...
0
votes
1answer
47 views

Inline chapters' names in page header

Probably not a very precise title for a question but I couldn't figure out a better one... Let me explain. I have a document with a number of chapters in it (their names are defined by "Heading 1" ...
0
votes
0answers
61 views

I hid Heading 1, but I want it to be shown in ToC

I changed the "Heading 1" configuration and "Heading 1" is hidden now. But, it disappeared from Table of Contents. How can I show it in ToC?
0
votes
0answers
46 views

Exce/LibreOffice: Apply function to highlighted region

In Excel, a few summary statistics are calculated automatically when you select a region with the mouse. I know that by right clicking this, a few more, like max and min, can be included. I want to ...
1
vote
2answers
264 views

Can I split the editing window in Libreoffice Writer?

In MS-Word, you can split a window with a horizontal bar, so that you can look at, and edit, two places in the same file (sort of) simultaneously. I vaguely seem to recall LibreOffice should also have ...
0
votes
1answer
46 views

Subtracting two times in libre office base

How can I subtract two times in a query in libre office base? For instance, 10:30 - 9:00 should give 1:30. Thanks. EDIT: As it says in the question, I am having this problem in "base", not with the ...
0
votes
1answer
18 views

Query that needs input from two different records

I have a "timecard" table. A few typical entries might look like ID task date start time 1 proj_XDFR 4/5/18 8:30 2 proj_PEIRN 4/5/18 9:45 3 proj_ERU54 ...