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.

3
votes
1answer
27 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
22 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
49 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
4 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
7 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
28 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
26 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
23 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
24 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
42 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
27 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
35 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
52 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
44 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
22 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
83 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
29 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
77 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
29 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
23 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
48 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
52 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
51 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
62 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 ...
0
votes
0answers
125 views

Is it possible to invert picture colors in Libre Office?

I'm looking for ways to invert picture colors in Libre Office. Is there a tool/extension/build-in abilities to invert picture colors automatically(via macro) and how to do it? I would appreciate ...
2
votes
0answers
39 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
80 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
88 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
69 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
41 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
475 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
0answers
16 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
181 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
38 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 ...
1
vote
1answer
19 views

Libre Office form — need data sheet layout with a lookup field

I am trying to develop a timecard form. The fields are ID, task, date, start time, and stop time. I want to create the form as a datasheet. I don't know the specific name for this, but I want it to ...
1
vote
0answers
29 views

mixing roman numbers and arabic numbers in page numbering in libreoffice

In libreoffice, my first couple pages should have page numbering in roman numbers: i, ii Then, after a couple of pages later, it should start with arabic numbers; 1, 2 ... I applied what is written ...
1
vote
1answer
32 views

remove numbering in heading but keep the sub-heading numbering

Problem: If I remove the numbering from Heading1 with backspace, Heading2 numbering becomes 0.2. Question:I want to remove the heading number from Heading1 but I want to keep Heading2 as it is.
1
vote
1answer
105 views

LibreOffice Calc color-coding cells categorically

I have a spreadsheet of text data; each column has a limited allowable set of string values. I have a second sheet in the file which, for each column in the first sheet, contains each allowed value ...
0
votes
1answer
180 views

Background image for Libre Office Writer heading not working

My objective: I'm applying background image to both Heading 1 and Heading 2 in a Libre Office Writer document. My problem: The behaviour of the background image for Heading 2 is inconsistent with ...
0
votes
1answer
97 views

Lag with LibreOffice Calc when scrolling quickly through rows/columns

I have moved to LibreOffice from Microsoft Office, basically because I refuse to pay the Price for Microsoft Office. I like LibreOffice as it offers everything I need and does pretty much the same ...
1
vote
0answers
15 views

How to Background images in Libre Office (Writer) [duplicate]

I have added a background image in my heading, the image is life-like size to make a letterhead, I have added it as background in the page header, however when I try to use the document I found I'm ...
0
votes
0answers
48 views

Windows: Saving program states on update or restart

Windows often wants to automatically restart your machine after many Windows updates, and even if you set Windows Update Advanced so that it can not, it still restarts my machine occasionally. In ...
1
vote
1answer
76 views

How do I lock some columns and some rows in a Libreoffice Calc worksheet?

I am using Libreoffice Calc 5.2.0.4. I am building an appointment book. This book has many sheets/ pages. I am not experienced, so I was experimenting on different sheets. And now I have three ...
0
votes
1answer
31 views

LibreOffice in Windows 10 shows Red spelling correction line under all Hebrew words in all Hebrew passages

I have installed latest LibreOffice on Windows 10 and opened some documents that contain Hebrew passages. There is a red correction line under all Hebrew words in all Hebrew passages. Why is there a ...