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.

Filter by
Sorted by
Tagged with
0
votes
0answers
4 views

LibreOffice Impress converts vector images to raster images

I am using LibreOffice Impress 7.1.2.2 on Arch Linux / Gnome and my problem is that Impress converts my vector images to blurry low resolution rastered images when changing and saving an existing ....
0
votes
0answers
10 views

Gedit spellchecking on Windows is not working properly

I am using Gedit, on Windows, to write a Latex document. I noticed that the windows installation of Gedit does not come with preinstalled dictionaries for spellchecking (I don't know why), so I found ...
0
votes
1answer
20 views

In LibreOffice Calc, why would sort buttons and menu items suddenly become disabled?

I was creating a spreadsheet in LibreOffice Calc. Several times, I used the "Sort Ascending" and "Sort Descending" toolbar buttons. All was well, and everything was working as ...
0
votes
1answer
18 views

How to get LibreOffice Calc to recognize dates in YYYY/MM/DD format?

I've been given a large tab-separated-values (TSV) text file that contains dates in the format YYYY/MM/DD. I tried copy and pasting the dates into LibreOffice Calc, but it didn't recognize the strings ...
0
votes
1answer
14 views

LibreOffice Calc: How to use OFFSET Function when Selection Intervals should increase?

Assumed we have this table style in sheet 1: A B C D E F G H 1 0.1 0.2 0.5 0.7 0.4 0.5 0.9 1.0 2 3 In sheet 2 there have to be averages made of cells ...
0
votes
0answers
9 views

How to fix the autofill with text on Libreoffice Calc?

Autofill isn't working on my libre office calc when I work with text instead. When for eg I input weeks of the day it just repeats the text before it
0
votes
0answers
8 views

Enabling wrap text by default on libreoffice calc with long CSV entries

I have a CSV file for i18n and entries take much longer than my screen space. Apparently the text wrap is stored inside the document, but I guess this doesn't work with CSV. Is it possible to ...
0
votes
0answers
184 views

Why are characters missing when copying hebrew characters?

I would like to write an article with some lines of the tanakh(hebrew)(would probably try lualatex for that). I downloaded SILEOT.fft and SILEOTSR.fft (Ezra SIL & Ezra SIL SR) and right click &...
0
votes
1answer
37 views

Retrieve European Central Bank currency rates XML into LibreOffice Calc cells

The premise is to retrieve current currency rates into a Libre/OpenOffice Calc spreadsheet. Previously I did it using a JSON service, with manual tweaking of substrings, which isn't all that user-...
0
votes
1answer
42 views

Why is Libreoffice calc 7.0.4.2 slow in Windows 10?

When opening Libreoffice Calc 7.0.4.2 as of today, in Windows 10 Pro 20H2, with Nvidia GPU 1070 Max-Q and i7-7700HQ, even on a blank sheet, the following actions induce a ~0.7s lag or more: clicking ...
0
votes
1answer
25 views

Fonts in Geany are bold after installing LibreOffice

I've installed LibreOffice 7.1.1.2 64-bit on Windows 10 20H2 Pro and now the default Monospace font in Geany 1.37.1 is always bold (some other fonts are also affected). Changing the Monospace in Geany ...
5
votes
1answer
118 views

Right-to-left columns in LibreOffice Writer

I'm writing a document in Arabic, a language that is written right to left. I have found the right-to-left direction button and enabled it throughout the document. Now, I would like to use two columns....
0
votes
0answers
12 views

Libre Office Writer, remove grey background of Asian Phonetic Guide

It seems that Writer draws grey background regardless of the "Rubies" style which is used for the Asian Phonetic Guide. Can I remove this grey background?
0
votes
1answer
13 views

In LibreOffice impress, how can I have a bullet-indentation no-bullet item?

I want to do something like the following in LibreOffice Impress: First item Second item start first subitem of second item second subitem of second item continuation of the second item. the &...
0
votes
0answers
9 views

In LibreOffice, how to ignore spell checking words containing a period (like stackexchange.com)?

Out of the box, LibreOffice's spell-checker successfully ignores strings like stackexchange_com, but it marks strings like stackexchange.com as spelling errors. How does one configure LirbreOffice to ...
0
votes
1answer
37 views

LibreOffice font styles (bold, semibold, condensed, etc)

I have switched to Linux but it don't support MS Office, so I found the alternative - LibreOffice. I need to open foreign presentations or documents that have fonts like "Bahnschrift ...
0
votes
0answers
21 views

Change how the default bullets and numbering looks in libreoffice writer?

When pressing the GUI buttons for bullets / numering or the associated hotkeys (F12, Shift+F12) the paragraph style remains unchanged as “Text Body”, but bullet formatting is added to the current ...
0
votes
1answer
21 views

How do you fill in the area under a data series in a line chart in LibreOffice Calc?

There is a line chart in an Excel spreadsheet that I'm trying to replicate in a native ODS spreadsheet. The chart has lines from multiple data series, and one of those lines has the area underneath it ...
1
vote
0answers
15 views

Create space AFTER each section in Libreoffice Writer

I want to leave some blank space at the end of each subsection of a document. +-----------------------1/2-+ +-----------------------2/2-+ | 1. SECTION | | text text text ...
0
votes
1answer
16 views

LibreOfficePortable - shared drive / multi user

I'd like to use the binaries of LibreOfficePortable with more users in one shared drive, example: Z:\LibreOfficePortable\LibreOfficeDrawPortable.exe By default this is not possible as the profile is ...
0
votes
0answers
30 views

Does LibreOffice Writer really not close itself when Windows is shut down?

I have LibreOffice Writer start on boot, like all my other daily used applications. When I shut down Windows, I do it properly with the nice command that does not "force" a shutdown, but ...
0
votes
0answers
16 views

Noto fonts (regular) are not displaying some characters in Libre Office (squares instead)

Noto Sans and Serif fonts (but only regular, not light or mono or black, etc.) in Libre Office Writer or Spreadsheets are not displaying '→' sign ("Long rightwards arrow"). Instead of → or ← ...
0
votes
0answers
18 views

LibreoOfice 6 freezes when Tools->Options

I've been using LibreOffice (LO) on a Linux machine for a long time. Lately I used LOdev and it worked perfectly. Now every time I try to access Tools -> Options, LO freezes. I cleaned and ...
0
votes
0answers
13 views

Slideshow ppt file using command line or using python

I want to slideshow the Presentation on ubuntu, I can open the Libre Office using the command libreoffice --impress <filename.pptx> This command opens a file in Libre office, But I need to open ...
0
votes
0answers
18 views

Trying to use code countif+countif/countblank

I tried couple of things but everything gives me an Error, does anyone know why? =COUNTIF(COUNTBLANK(A12:D12),0) But when I try to put them in two different cells it actually works =COUNTBLANK(A12:...
0
votes
0answers
34 views

How do I use LibreOffice to create a Bitcoin paper thing?

I have LibreOffice installed. I've opened each individual application, but I can't figure out which one would be the best one to use for this. I basically am trying to print out a standard-sized paper ...
0
votes
0answers
14 views

Libreoffice calc multiple horizontal window splits

On a libreoffice calc spreadsheet I would like to have two horizontal splits to yield three window areas. I have the top several lines split off and frozen to provide headings, title and unit ...
0
votes
0answers
54 views

LibreOffice supporting links between slides in a PowerPoint presentation

When a PowerPoint presentation (.pptx file) has internal links between slides, it is possible to get LibreOffice Impress to support these — such that the user displaying the presentation can be taken ...
0
votes
0answers
9 views

Adding comments and other content structure when using LibreOffice to convert HTML to Word 2007

Are there any HTML elements, attributes or styles that LibreOffice would interpret as a comment when converting from XHTML to Microsoft Word 2007 on the command line using the writerglobal8_HTML with ...
1
vote
1answer
21 views

How to enter user and password for WebDAV server on LibreOffice?

I am trying to configure a NextCloud WebDAV remote location on LibreOffice Writer 7.0 following these instructions: https://help.libreoffice.org/latest/en-US/text/shared/guide/digitalsign_receive.html ...
0
votes
1answer
30 views

How to incorporate an existing library of python functions into libreoffice calc so they can be used like user written BASIC function in cells

I'm a noob at using macros but have written a couple of user function in BASIC that I can use just like functions in LO Calc cells. I was looking to write more but found that a Caleb Bell has has ...
1
vote
0answers
9 views

LibreOffice - Is it possible to increase the contrast between the scroll bar sliders and the scroll bar background?

FreeBSD-12.1p12 LibreOffice-7.0.3.1 I am finding that the scroll bar sliders, both vertical and horizontal, are coloured with a washed out grey that is nearly indistinguishable from the colour of the ...
1
vote
1answer
27 views

Libreoffice: Get adress range from cell

I'm not sure what the correct terms would be, so I can't effectively search for a possibly already answered question, but here it comes: I'm looking for a way to have in cell A1 a formula (lets say ...
1
vote
1answer
25 views

Calc/Excel aggregating data with same ID

Hello i have to solve this problem in Libreoffice Writer or excel. I have a table like this: ID V1 V2 V3 ... 1 10 20 30 ... 1 30 40 50 ... 1 5 7 8 ... .. .. .. ....
0
votes
1answer
23 views

How to make automatic numbering using format A. B. C. in Libre Office Writter?

I want to make this kind of automatic numbering: A. List item B. List item C. List item It's easy to make it using Microsoft Word. However, libre office writter seems don't have that style but these:
0
votes
0answers
26 views

In a LibreOffice Calc (or OpenOffice Calc) spreadsheet, how can you maintain multiple groups of columnar data?

I have a LibreOffice Calc spreadsheet that contains 3 sets of data. It is organized like this: SUBJECT A SUBJECT B SUBJECT C Date X Y Date X Y Date X Y Date X Y ...
0
votes
1answer
17 views

Replace multiple occurences of a string in cells

Is it possible to replace a certain string that can occur multiple times in a single cell, but also in multiple cells? I'd like to prefix the first character / with another string :: in comma ...
0
votes
1answer
24 views

In LibreOffice Calc, is it possible to use a complex function and a data range as arguments for a MIN() function?

I'm going to simplify a bit to hopefully get at the crux of my question. I have a spreadsheet in which a cell has a massive formula. (Again, I'm simplifying to avoid a question that is so long no one ...
0
votes
0answers
24 views

Printing multiple pages per sheet to scale in LibreOffice Writer

I have 6.5x4.63" pages in a document. I want to print them two up on 8.5x11" paper. When I open the print dialog in LibreOffice Writer and select 2 pages per sheet and "Draw a border ...
0
votes
1answer
75 views

Libreoffice Calc : Fill in a range of cells with a known start and end value. Automatically

I have two cells separated by some empty cells. Values in parentheses. A1 [ 23 ] A23 [ 433 ] I want the spreadsheet to figure out the best way to increment the values between them, based on how many ...
0
votes
0answers
9 views

LibreOffice Impress paste messes up formatting

Using LibreOffice Impress 6.3.1.2 (and FWIW ever before) I have a recurring, very annoying problem editing text in a bullet point item list (numbered list I think, too): When I try to move a bullet ...
0
votes
0answers
5 views

Libre office preserves some characteristics when changing parragraph style

I have a document, which has rather strict formating and for that I created my own paragraph styles. But sometimes when I copy and paste some text from somwhere else and change the paragraph style, ...
0
votes
0answers
19 views

How to insert a margin free page in a Libreoffice doc

I am using Libreoffice and would like to insert a big photo on page 1, therefore I do not want any margins. Other pages will have margins. How can I do this? All my efforts won't work. When I try to ...
0
votes
0answers
119 views

How to set dark theme in LibreOffice?

I am trying to get a dark theme appearance in LibreOffice. Windows 10 Same issue on LibreOffice 6.4.7 & 7.0.3 I have set: Tools -> Options -> Personalization -> Theme -> Dark which ...
0
votes
1answer
38 views

Fix file associations in LibreOffice Calc

How do you fix the file extension associations with LibreOffice Calc? I have a CSV-like file with a *.dsv file extension. Ubuntu has that file type set as a CSV document. When I explicitly try to open ...
0
votes
0answers
30 views

Why does LibreOffice Writer show a “Document Recovery” box every other day when I start the computer?

I keep LibreOffice Writer open during each day and write on my long document. I save all the time. Not every day, but basically every other day, when I start my computer, it shows a "Document ...
0
votes
0answers
50 views

Libreoffice draw forms: how to auto populate combo boxes from linked database

I am currently working on a pdf form in libre office draw that I will use on a website. The form inputs amongst other things “department”, “address”, “phone number”, etc in combo boxes. For the about ...
0
votes
0answers
25 views

How do I keep just the first row of each unique occurence of a value in a column in LibreOffice Calc?

I have a sheet in Calc that looks like this: A B C D E 1 Call # Title Barcode Status Check-out date 2 070.49 GUIB The ...
0
votes
2answers
52 views

At work my Word 2016 tells a .docx corrupted. LibreOffice 6.1 opens it well at home. docx file format exist for long. Word 2016 doesn't handle it?

At work, I'm trying to open a .docx file I received. My Word 2016 tells that it is corrupted. But when I try at home with LibreOffice 6.1 it opens well. Has the Word file format changed since the ...
0
votes
0answers
46 views

How to set the color of the input bar in LibreOffice Calc spreadsheets (for dark theme/mode)?

In LibreOffice Calc, I have been able to almost configure a usable dark theme/mode. To accomplish this, go to Tools > Options... > LibreOffice > Personalization and set the dark theme, and ...

1
2 3 4 5
16