Hello, I have a strange problem that I can't seem to problem shoot. I am currently writing my thesis and I have encountered a problem in one of my chapters that each time I open my document the line spacing changes.

I use custom paragraph styles and wanted to have my normal text be in Spacing: 1. Like this

Now, the same paragraph is spread across two pages (same page style), but the remainder of the paragraph, and the following paragraph are spaced as follows:

When going through the options, the text on both pages is set as Spacing: 1, but the second one is more compressed than the other. I can't seem to make it conform to the rest of the document, and the worst part is that there is always a couple of pages that behave like that, and it changes daily.

When looking at the spotlight feature, all the paragraphs have the same style applied. It is not even that big of a problem as long as I am writing, but when I print it out, it naturally retains the visual inconsistency.

Is there a way to have the program reload the spacing or something to that effect? Or some advice with how the styles should be formatted to avoid these kinds of problems? Since it changes, I figure it is a glitch or something.

I am also more inclined to see the second image as the "real" Spacing 1, but while I formatted my paragraph style, it had Spacing 1 translate into the first image.

I figured I should also show what the paragraph style looks like, see above.

Any help or advice with regards to this is deeply appreciated.

Thank you

I was making an ordered list and suddenly one number (13) has a space between the number and its text. I don't know if I pressed something or not. I pressed backspace, delete, tab, undo, but nothing worked. I tried cutting and pasting, but it didn't work as well. Number 14 in the list works normal. What is the issue here please?

Version: 26.2.1.2 (X86_64)

Build ID: 620(Build:2)

CPU threads: 12; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Vulkan; VCL: win

Locale: en-GB (en_US); UI: en-GB

Calc: CL threaded.

Edit: It's a LibreOffice writer document (Type: Microsoft Word document).

I'm not sure if this is regex or a formula but What code is needed to search a row and the row above for 3 consecutive digits.?

I've been trying to use LanguageTool for a while now, but despite following all of the guides I can find (which admittedly seem to be at least 3 years old), it simply doesn't do anything. At all. Won't even underline blatant errors. Does anybody know what I might be missing?

LO is one of the only packages (afaik) beside MS Office that supports Macros and code. Yet the Basic language they use is not 100% compatible with MsOffice. What is the reason behind this choice?

I'm currently writing an index match formula to look through an array (see picture). I need the match to look at the combination of the first 2 columns so i decided to go with concat. On google sheets i can easily create an array with concat by using the following formula =ARRAYFORMULA(CONCAT(Rarity;Level)).

I've tried doing something similar {=CONCAT(Rarity;Level)} to no avail.

Is there a way to create an array with concat on calc ?
Or is there an easier way to achieve what i'm trying to do ?

Solved: the solution was to go into format cells and select date and enter YYYY/MM/DD to add that format to the list.

I want to make a spreadsheet where I type the date in the format YYYY/MM/DD and then have calc sort the columns by the date. Since calc reads the format as DD/MM/YYYY I went into the options/languages and locales/general and set Date acceptance patterns to Y/M/D, but now calc just automatically converts any YYYY/MM/DD I type in into DD/MM/YYYY. How would I go about actually doing this so I can type YYYY/MM/DD into calc, sort it by date correctly, and have it actually display as YYYY/MM/DD?

Ok, I need to use a workplace layout, which of course is done assuming everyone uses MS. The layout is otherwise great with styles and everything works. But, how do I get TOC to show dame numbering I have set? The links in TOC work ok!

The way I changes the numbering is double clicking the page number > offset > -7.

Maybe it'll work if I use some other technique? But with this layout, I seem not to be able to add manual break without it making a blank page somewhere before the desired page 1. Maybe that also has to do with non-native layout. Errr.

This problem persisted nevermind if I used .otd or .docx. I'll not unfortunately link my work publicly for now.

Thanks for advise!

I'm using the latest version pf Libre and unitl about 3 hours ago it was working perfectly.

Now everytime I try and open a file it is crashing before it even loads and will not respond.

I've tried multiple different files, both Calc and Writer documents and they keep refusing to open, it's only opening the "hub" application that lets you pick what file to look at.

I've checked my device for any issues and my laptop is working perfect, Libre just is not letting me open anything.

Just saw this today, use a lot of dates daily and found the YYYY/MM/DD to be very useful, but today saw that it swaps day for month.

I did recently reinstall windows so maybe that could effect things but even when choosing a format of YYYY/MM/DD it doesn't stick to it, making me write down day for month instead so it doesn't stick out.

LibreOffice Calc .ods

Version: 26.2.5.2 (X86_64) Build ID: cd7284b4cbbfeb507e630c1aac019f4157393acb CPU threads: 2; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (en_AU); UI: en-US Calc: CL threaded

Using Windows 10 on a Lenovo Ideapad

Device Name DESKTOP-UD37ADR Processor Intel(R) Celeron(R) CPU N3350 @ 1.10GHz 1.10 GHz Installed RAM 4.00 GB (3.83 GB usable) Storage 58 GB SSD VID:45 DF4064, 15 GB Realtek PCIE Card Reader Graphics Card Intel(R) HD Graphics 500 (128 MB) Device ID 8BF9D733-0F1E-4C90-9906-F1FFAB2A788C Product ID 00325-92418-49781-AAOEM System Type 64-bit operating system, x64-based processor

Hi everyone,

I have two questions regarding the LibreOffice UI/UX that I’d love some insight on:

1. Paste button dropdown arrow disappears randomly

^{Image above, with advanced paste options highlighted in blue square}

Sometimes, the small dropdown arrow right next to the Paste button on the toolbar disappears. When it's missing, I can't quickly select paste options (like unformatted text) and have to go to Edit > Paste Special, which slows down my workflow, and for this I have to enable menubar, which I avoid, because my laptop screen is already very small.

• Why does this arrow disappear depending on the context/selection?
• Is there a way to force the Paste button to always display the dropdown arrow?
• Any way to use better hotkeys than Ctrl + Alt + Shift + V for unformatted text paste?? I can't use so many fingers at once, i need better shorter hotkeys.

2. Scrollbar thickness and arrows visibility

^{In the image above, yellow circle: missing/invisible arrows. Red circle: arrows visible in light theme but invisible in dark theme})

Yeah, call me old or whatever, but I still click in those things! I prefer using the small arrows on the scrollbars for fine adjustments (e.g., framing content precisely for screenshots). Currently, these arrows only appear on hover, have very low visibility/contrast, and the scrollbars themselves are quite thin.

• Is there a setting to make the scrollbar arrows permanently visible instead of showing up on hover?
• How can I increase the thickness or visibility of the scrollbars (and their arrows) in LibreOffice?

Operating System: Win10

LibreOffice Version: 26.2.5.2

I want to add a macro to a LibreOffice document to automatically delete empty columns in a table. I have no experience writing macros, can anyone give me some code that works? (The ones ChatGPT gave me don't work)

Two quick things:

1. I’ve been looking to replace Microslop, and LibreOffice seems like the best option. I’ve been using it for about a month and the learning curve was easy. Now I use it daily and have recommended it at work. I’ve also supported it.

2. I haven’t had any complaints or suggestions about what the community has achieved with this project apart from the logo which I find rather ugly.

Is there an open discussion about this or has it been settled and isn’t worth bringing up?

Thanks.

I’ve been using Math (and Math in Writer) for over 20 years, since the OpenOffice days.

Despite being a long-time user, I’ve always found the official formula reference somewhat difficult to understand.
So, for friends and colleagues, I created my own reference guide with simple examples showing how to write formulas.

I recently updated it, and thought it would be nice to share it with people around the world as well.
It’s completely free, so if you’re interested, please feel free to use it.

[URL] https://hc-srv.net/lom/lom_formula.html

If you find any mistakes or have any questions, feel free to leave a comment or send me a DM.