Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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
1 answer
21 views

Nested If statement. working in two sheets

its been a long time since I used Excell so my thinking may be complety wrong, but this wont work. Am I using the wrong Syntax for LibreOffice Calc =IF(M3>$'Shipping Profile'.$A$3,then $'Shipping ...
Stuart McLean's user avatar
0 votes
0 answers
13 views

LibreOffice Impress - add margins to text highlighted area

I am trying to add some margin around the highlighted area of a text within a table cell. Something along the line of LibreOffice presentation: wider text background, like html padding?. The problem ...
umbe1987's user avatar
  • 119
0 votes
1 answer
20 views

Libreoffice: Exit mail merge preview mode

I have made a mailmerge document. It looks like this: When I click > it previews the document with the first element: This is great, but how do I go back? I have tried manually entering -1 or 0 ...
Ole Tange's user avatar
  • 4,841
0 votes
0 answers
37 views

How Can LibreOffice Convert Milliseconds To Timestamp Or DateTime?

In LibreOffice I had converted timestamps into milliseconds because I didn't find a built-in way to naturally handle a standard time format. But now for real people, I want to convert that time easily ...
Zach's user avatar
  • 103
0 votes
0 answers
102 views

MS Word performance issues when editing large files

The problem: MS Word is very slow and freezes for a few minutes when editing large document [.DOCX] (1000+ pages). I've been unable to work on this document due to this issue for a couple of months ...
error404's user avatar
0 votes
0 answers
18 views

How to specific dark colour (color) scheme for all LibreOffice applications except LibreOffice Draw? (Linux)

I find dark mode most suitable for all the LibreOffice applications except LibreOffice Draw. How can one specify to use a dark application colour (color) scheme for all LibreOffice applications, ...
End Antisemitic Hate's user avatar
0 votes
0 answers
10 views

How do I put the series labels overlaying the graphics series lines in Libreoffice Calc?

As they say, a picture is worth a thousand words... so here goes: I want the series labels of my Libreoffice Calc spreadsheet to be like this: Instead of this Is this possible ? How do I do it ? I'...
Nelson Teixeira's user avatar
0 votes
0 answers
48 views

Running several instances of headless libreoffice: where's race?

I'm running libreoffice (headless) to make several hundreds of pdfs from odts. It's too slow, so I've tried to run some in parallel. SOME pdf files are generated without any error but with zero size. ...
Alex Povolotsky's user avatar
0 votes
1 answer
99 views

Use a subset of system fonts for LibreOffice, on GNU/Linux

I have a lot of system fonts in my GNU/Linux distribution (in /usr/share/fonts/): most of them are useless for me when I'm using LibreOffice to write or to open a document. I'm using my distribution ...
eliotlencelot's user avatar
0 votes
2 answers
25 views

Issues changing CSV column type to date in LibreOffice

I encountered some trouble changing cell types in LibreOffice Calc from text to dates. This happens when I import a CSV file. The import into rows and columns works fine. However, the dates are not ...
T.Krastev's user avatar
1 vote
0 answers
17 views

Libreoffice Scatter Plot - Gradient Fill Points

I'm using LibreOffice Calc and I'm trying to create a scatter plot with some data that I have. This is what my graph looks like so far I want to color the individual points by a gradient of their ...
Syed Zain Ali's user avatar
-3 votes
1 answer
33 views

Libre Office writer How to print only page 2 of a 5 page writer document

My operating system is Windows 10, Printer is HP color laser jet CM1312nfi MPF, LibreOffice 7.5 I have created a Libre Office writer 5 page text document with 1 "picture" a screen shot of a ...
krazykat501's user avatar
1 vote
0 answers
22 views

How to change font of all conditional styles?

I want to change a spreadsheet's font. The conditional styles are still using the old font. There are too many to change manually one at a time. What's a practical way to update all the conditional ...
latitude's user avatar
1 vote
1 answer
39 views

change language for pdf export in libreoffice calc

This must surely be obscure but I'd really like to fix it for an important document. My system language is in one European language. Still, I managed to change all the languages for a Libreoffice Calc ...
cardamom's user avatar
  • 175
0 votes
0 answers
40 views

Remove the dot before pages in the table of content entries in LibreOffice

I'm having a hard time removing the dots before the pages in the table of content entries in LibreOffice. The automatically generated table of content from Headings results in the following: 1. Name .....
verbessern's user avatar
-1 votes
1 answer
43 views

How can remove the space between lines?

My libreoffice version is Libreoffice Community 7.4.7.2. When i move cursor at the 'volume'] and press 'deletekey,and pressenter` key,it can't remove the space. How can remove the space between the ...
showkey's user avatar
  • 161
0 votes
1 answer
93 views

Libreoffice macro has infinite loop

Can someone point out what's wrong with this macro please? I'm trying to search for paragraphs with the token "vv", then change their paragraph style to "_Verse". This macro works ...
Paul B.'s user avatar
  • 69
2 votes
1 answer
124 views

Can't find Developer Tools in LibreOffice Calc

I recently read that the Development Tools is available in LibreOffice since 7.2, but I can't find it in my 7.5.9.2 (and then updated to 7.6.4.1) installation... It should be found under menu item for ...
H3coder's user avatar
  • 121
1 vote
3 answers
135 views

Convert an Excel table from one structure to the other

Original table I have this table in Excel or LibreOffice. Unit number Type Name 1 Object Top 1 Object Bottom 1 Object Left 1 Object Right 1 Object Back 1 Object Front 1 Property Right-Fixed 1 ...
Megidd's user avatar
  • 270
0 votes
1 answer
143 views

How can insert spaces at the beginning of another line in libreoffice?

There are two lines in one paragraph: The cursor located at the beginning of the second line,ahead of the word long_window,now i want to add 4 spaces ahead of long_window as desired below: ,why can'...
showkey's user avatar
  • 161
0 votes
1 answer
11 views

How can I enable auto-replace patterns like :alpha: for "Language = [None]" text in LibreOffice Writer?

This question is written as Q&A after having found an answer. The feature of LibreOffice of inserting unicode characters using sequences such as :alpha: or :_1: could be useful for writing ...
kdb's user avatar
  • 2,282
2 votes
0 answers
24 views

LibreOffice Writer: Change all four page magins to the same value AT ONCE?

Instead of changing one by one, can I change all four at once? Google Bard said press Ctrl+Enter, but that did not work.
Damn Vegetables's user avatar
0 votes
1 answer
56 views

LibreCalc 7.6.4 Menu and Toolbar

Just downloaded LibreOffice 7.6.4 and I have created a quick access bar. This shows up on the right side of the top menu bar. How do I make into a floating toolbar or a docked toolbar, always on ...
sswcharlie's user avatar
2 votes
0 answers
42 views

How to update LibreOffice WEBSERVICE data automatically

I know I can force a manual update from Edit/Links. Is it possible to have LibreOffice update this data automatically, for example once per day?
Nikolay Yordanov's user avatar
1 vote
1 answer
114 views

LibreOffice Calc save to CIFS not working

I have an HP Compaq nx9420 that runs Debian 12/bookworm kernel 6.1.0-10-amd64. It's a default install with no extras or tweaks. I mount a CIFS-drive (fstab-line: "//[ip]/[share] /[mnt]/[point] ...
Jon S's user avatar
  • 21
1 vote
1 answer
64 views

How to clone conditional formatting to another column?

I want to highlight values that are in the bottom 5th percentile in each column, for about 60 columns. I set this conditional formatting for the first column, but I see no way to apply this to every ...
Edward's user avatar
  • 163
1 vote
2 answers
121 views

Associate .docx with swriter.exe LibreOffice (with PowerShell)

I would like to associate .docx with OpenOffice $extension = ".docx" $executable = "$MyPrograms\LibreOffice\program\swriter.exe" $fileType = "docxfile" if (Test-Path $...
YorSubs's user avatar
  • 929
0 votes
1 answer
49 views

Macro to keep 3 rows visible under the selected row in LibreOffice Calc

In Calc or MS Excel when one is finished editing a cell in a row, pressing Enter leads to the next row below. Keep doing that and eventually you arrive at the last row visible on the screen. Here when ...
Shakir's user avatar
  • 103
1 vote
1 answer
1k views

How do I apply the MATCH() function only to a filtered range? Or is there another way to do that?

I have a filtered list of values. Let's say I have the numbers from 0 to 5, and 2 is filtered out: A (with auto-filter against "2") 0 1 3 4 5 Now I want to find out whether one of the ...
questionto42's user avatar
  • 2,361
0 votes
0 answers
63 views

Having problems with nested numbered and bulleted list

Using the LibreOffice Writer, I am formatting a rather long lists of items where the first level is numbered, and the most of the numbered items contain next level items -- with bullets in the case. ...
pepr's user avatar
  • 119
1 vote
1 answer
64 views

cannot scroll down to click okay in libreoffice settings

I tried to follow the instructions here - LibreOffice 4.2.1.1: do not display list of recent documents Open the LibreOffice config: Menu "Tools" -> "Config"; In the TreeView: &...
cardamom's user avatar
  • 175
1 vote
1 answer
77 views

Automatically center Japanese ruby text in LibreOffice

I have activated Asian Phonetic Guide in LibreOffice to add furigana to Japanese words but every time I open it up, it adds the furigana on the left (which I assume is a result of the style I have ...
Saegusa's user avatar
  • 111
0 votes
1 answer
139 views

Can libreoffice differentiate between .txt and .csv files?

Can libreoffice differentiate between .txt and .csv files? I have two file's that have a mime type of 'plain text document' text/plain detected. One file ends in .txt and the other ends in .csv. Is it ...
turtle's user avatar
  • 101
1 vote
2 answers
6k views

Upgrading from Ubuntu 16.04 to Ubuntu 22.04

My friend is going to help me upgrade my operating system tomorrow, from Ubuntu 16.04 to Ubuntu 22.04 (or perhaps Lubuntu, I'm not quite sure). I'm going to back up all my files tonight and put them ...
Beaver's user avatar
  • 61
0 votes
1 answer
111 views

Procedure to update portable LibreOffice

Having "installed" (i.e.: unpacked) LibreOfficePortable, I got a message that an update is availble. So far, so good. However when I clicked the button to get the update, the "normal&...
U. Windl's user avatar
  • 639
0 votes
0 answers
81 views

LibreOffice Impress: master slide font size not respected?

I am trying to create a default master slide in LibreOffice Impress, where I want to set color/font size of the title and of the first level list. This works for the title, as well as for the color of ...
Matifou's user avatar
  • 141
1 vote
1 answer
117 views

Access LibreOffice Autotext templates from command line

I want to use the Autotext templates from the command line. The location are this: %APPDATA%\LibreOffice\4\user\autotext\mytexts.bau C:\Program Files\LibreOffice\share\autotext\en-US\template.bau C:\...
ranemirusG's user avatar
0 votes
0 answers
97 views

LibreOffice Impress: Distorted image in presentation mode

When using the SlideShow option in LibreOffice Impress, some images that were totally fine on the document appear distorted on the slide show (see example below). The problem doesn't happen when ...
Matifou's user avatar
  • 141
0 votes
0 answers
66 views

Does libre office writer encrypt temp files when .odt file is encrypted?

I used Libre Office Writer to create an encrypted .odt file. LibreOffice uses temp files by default. Are the temp files encrypted while working with the file if the file has been encrypted in the ...
ThomasHunter's user avatar
1 vote
1 answer
181 views

Is there a way I can get previous messages from a mailing list into my mailbox?

I've just joined a certain mailing list. The list has a web archive, which is nice, but I would like to have past messages from that list - all of them or a just a few months back - in my own mailbox, ...
einpoklum's user avatar
  • 9,588
0 votes
1 answer
83 views

LibreOffice Impress macro is only half functional when used in presentation as opposed to outside

I made an .odp file that contains two slides. In Slide 1, there is a single circle that when clicked on moves to Slide 2. This circle uses a simple interaction and no macro. In Slide 2, there is a ...
wc80399's user avatar
1 vote
0 answers
144 views

Converting RTF to PDF in LibreOffice changes the margins

When converting from RTF to PDF in LibreOffice, the bottom margin moves up about 3% of the page, leaving 3% more blank space at the bottom of the page. This causes some text to flow onto the next page,...
colej1390's user avatar
  • 111
0 votes
0 answers
91 views

How to write a macro that iterates an array of strings and displays one of them at any given time in LibreOffice Impress?

I teach Spelling at an elementary school. To make class more entertaining, I decided to add interactive content. In this example, students are given a presentation. The picture in the slide is an ...
zz763's user avatar
  • 1
0 votes
1 answer
130 views

How to make an object permanently disappear after clicking on it once in Libreoffice Impress?

I am hosting a trivia night in my middle school next week. I plan to use LibreOffice Impress. In the first slide there are multiple topics to choose from. When I click on one, it moves to the slide ...
mhgx676's user avatar
1 vote
1 answer
99 views

LibreOffice Calc clears clipboard

My use case is: I am running Chrome and filling in a web form. For one text box that I need to fill, I need to get the data from a spreadsheet. So I open the spreadsheet using LibreOffice Calc, copy ...
k314159's user avatar
  • 307
2 votes
1 answer
59 views

Postscript mutilates font

I am using the DejaVu Serif font in LibreOffice 7.5.4.2. An exported PDF looks like this: However, when I print that PDF (or export it into PostScript), it transforms to: The italic "M" is ...
Greendrake's user avatar
1 vote
1 answer
281 views

How can I stop libre office sheets jumping when scrolling wide columns?

Long time sufferer of Windows, moved to Linux Mint around a month ago and I am still getting used to the changes. One very annoying thing that I have Googled, looked at the questions here marked libre ...
JamesT's user avatar
  • 59
1 vote
0 answers
68 views

how to find the undesirable formatting in a presentation/slides such as bold or Symbol font

My manager told me he think in some places of my presentation file he noticed inappropriate formats such as bold and Symbol font. Is there an easy way, preferably free like in free beer way to search ...
Serge's user avatar
  • 156
1 vote
2 answers
1k views

Open link from other application does not open the URL in Firefox

Clicking a link in Thunderbird or Libre Office Writer opens a new instance of Firefox with my home page and not the required URL. My home page always opens, whether I use left-click, ctrl+left-click ...
Peter bill's user avatar
1 vote
0 answers
36 views

Libreoffice base design of Time-Table for College [closed]

I am supposed to work on THE Time-Table of my college which people have been doing manually so far. A college time-table is a mapping of a faculty to the class, day of the week, period of the day and ...
Mukund's user avatar
  • 11

1
2 3 4 5
18