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.

1
vote
2answers
22 views

How to restore Libreoffice 4 color palette (highlight colors, font colors, etc.) for use in Libreoffice 5 or 6

In 2017 or so (see here: https://design.blog.documentfoundation.org/2017/04/10/new-standard-color-palette/), LibreOffice decided to get rid of their LibreOffice 4.3 color palette, with the nice, ...
0
votes
0answers
4 views

How to change each page's style in libreoffice writer and impress?

Let's say I want the first and second page don't have page number in footer. Writer can set First page's style to "First page" in order to remove the footer. Here is the question: Q1: How can I ...
0
votes
0answers
17 views

Can I limit a range of cells to a specific set of values?

I'm creating a table in LibreOffice calc. One of my column is actually a choice among several fixed categories - let's say it's a choice of one of several possible strings. Can I constrain the set of ...
0
votes
0answers
11 views

Specify graphic resolution for output in LibreOffice

LibreOffice allows the resolution to be specified for any file when "exported" in a graphic format such as png. In other situations, such as mail merge output, the resolution of graphics formats ...
0
votes
0answers
16 views

How can I prevent and/or correct pagination miscounts under LibreOffice 6.0.x? [closed]

I presently have a LibreOffice document that doesn't count correctly in pagination either in editing or in export to PDF. I am noticing this behavior after defining separate page settings for left ...
0
votes
0answers
19 views

Change LibreOffice titlebar text

The LibreOffice titlebar shows the app's name, which just adds noise. And alt-tabbing would be easier if it weren't there. e.g. From My foo document.xls - LibreOffice Calc to My foo document.xls. ...
1
vote
1answer
24 views

Libreoffice Calc, macro set Text Alignment Indent, or property documentation?

In Libreoffice Calc it is possible to use macro's to set the text properties of each cell, to format the layout and font. I was able to find some property names online, in code examples and forums. ...
0
votes
1answer
74 views

Libreoffice Calc, print barcodes font, stretch font taller but not wider

I'm using Libreoffice Calc to print stock labels. I've encoded the texts for use with the code128 format, same as in this online tool, and I can print the barcodes using the Libre Barcode 128 font. ...
0
votes
0answers
3 views

How do I move around chapters in kingsoft office writer ?

Is there a way to acheive the same functionality as Libreoffice/OpenOffice Navigator's Chapter Up/Chapter Down button in Kingsoft office writer ? These buttons allow you to move around a header and ...
0
votes
2answers
28 views

Calc print several sheets in same page

I have a Libreoffice Calc spreadsheet that holds around fifty sheets (each one with no more than a dozen valued rows); this is good for data organization — each sheet holds a sequence of events ...
0
votes
2answers
53 views

OpenOffice/LibreOffice Calc how to not print column but show it in sheet?

I have a column with hyperlinks to other parts of the same spreadsheet and I want this column to be visible inside the program, but hidden when printed: it should not take up space. The only solution ...
0
votes
0answers
23 views

soffice --headless: Update .odt TOC from command line

soffice --headless is a powerful tool. With this command you can import and export files from several formats, etc. My issue: I have a .odt document and I would like to refresh TOC (Table of Contents)...
0
votes
2answers
43 views

Is there a way to show the directory your current document is located in Libreoffice?

I'm trying to figure out where the document I'm working on is located on the hard drive. Is there a command that opens the containing folder?
0
votes
0answers
18 views

How to create readonly table from raw data

If I have a large table of data, essentially like a database, can I create another sheet or range that is a filtered subset of the full dataset? If so, will it stay up to date when the main table ...
0
votes
1answer
77 views

Performance of LibreOffice in Ubuntu vs Windows [closed]

I have two laptops: Old HP Elitebook: 6th generation Intel CPU, 4 cores, 8 GB memory, 128 GB SSD, and Ubuntu 16.04; New Dell XPS: 8th generation Intel CPU, 8 cores, 32 GB memory, 512 SSD, and Windows ...
0
votes
0answers
16 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
28 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.
2
votes
1answer
49 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
35 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 ...
2
votes
1answer
28 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
97 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
16 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
64 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
33 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
182 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
18 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
1answer
77 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 ...
2
votes
2answers
151 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
202 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
50 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
35 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
42 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
187 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
60 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
25 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
112 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
31 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
8 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
24 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
36 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
234 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 ...
1
vote
1answer
82 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
60 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
72 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
56 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
106 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
72 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
274 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
61 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 ...