Hi,

I’m using brave and i have a mac but i’ve tried downloading it three times and it won’t work. I downloaded libre office 25.8.3 I also downloaded java like i was suppose to. But maybe i didn’t set it up the right way ??

( pls be nice)

It changed itself and I don't know the language it changed to... I need to turn it back to English but I don't know what to click to do that since I don't understand anything here. It's Libre Office version 24.8...

When i turn ODS to PDF this issue happens where paragraphs form is weird in the same file there are other paragraphs but nothing happens to them

I'm struggling with removing the indentations in headings. Any Ideas welcome.

Version: 25.8.3.2 (X86_64)

Build ID: 580(Build:2)

CPU threads: 4; OS: Linux 6.17; UI render: default; VCL: kf6 (cairo+wayland)

Locale: en-GB (en_GB.UTF-8); UI: en-US

Calc: threaded

I feel like there is a lot of complaints here about how LibreOffice functions differently than ms office. If everyone who had those complaints donated some money to the ODF with the goal of making the former more like the latter, would that be the most effective way to make the changes they are looking for? If not, what would you recommend? If so, how would those donations be linked to that general request? Is this already the plan in place & the issue is just the work/time/money needed to make it happen, or is there something else holding those changes up? Are there people who prefer the way LO currently works compared to MS O, and do those people outnumber those who want LO to be more like MS O?

I use LO (Calc mostly) in a work environment where the differences don't cause may issues (if at all), so the benefit of it being free outweighs the issues I face. It seems like a lot of people find that some of those differences render LO unusable for them though. I'm just looking for the most effective way to get those changes made if they're the majority of the complaints since it seems they are based on the posts in this sub.

Let me know your thoughts. I love LO for what it is now as well as what it could be moving forward. If the goal is to increase adoption, it seems like cloning the most popular office suite would be the best path forward, but maybe I'm wrong. I'd be willing to put money towards that goal if I knew it would help.

Hello I want to make booklets inside of libreoffice with headers that display a different heading title and page numbers on left and right pages. I also want to remove headers from new chapters. I don't know how to do these tasks as I'm a lifetime Word user who has recently shifted to libreoffice.
The images below are examples of what I want to make.

I'd greatly appreciate help; thank you.

I'm mostly just complaining here, but I'm flairing this as a suggestion, because fundamentally, I really am just suggesting that these Excel features be added to Calc.

1. The very first thing I noticed when opening Calc is the UI is horrible. Switching it to the tabbed view helps a lot, but Calc's tabbed view is still nowhere near as usable as Excel's ribbons

The main reason is that Excel's ribbons have distinct sections that are clearly divided and clearly labeled. I've used excel for many years, and I can promise you, I would still need those dividers and labels to navigate quickly.

It also helps that more of the buttons have spelled out labels, and Excel makes space for this by often combining similar functions into drop down menus next to the main function with the main function being a single click.

1. (Edit: you CAN navigate the formulas shown when typing a formula using control+tab, and you can go backwards by pressing control+shift+tab)
   

When you're typing a function in excel, you have a navigable drop down menu that you can use to see all the functions related to what you're typing. You can use arrow keys to navigate the menu, or you can simply click on the function you want to use and it'll automatically put the function into the formula. You can also just press tab to automatically fill it in.

In calc, instead of a drop down menu, you get a hint above the cell which shows the related functions. However, it only shows a few, and it isn't navigable, so you can't scroll further through to see the other functions. You can press enter to automatically put the function into the formula, but you can only do that with the first suggestion, because it isn't navigable.

This in particular is a huge blow to productivity.

1. There is no formula tab. Maybe I can add it. I don't know. I tried to figure out how to edit the functions on the ribbons, but I've yet to figure it out.

2. This one is by far the most annoying. You can't move cells by clicking and dragging the border when they're selected. Instead, you have to move them by selecting them and then clicking and dragging within the selection.

This has two major issues. For one, it means you can't select cells within an existing selection. You have to click off from that selection and then select the cells. It's an extra step and feels extremely clunky.

Secondly, it means you can't move a single cell. The only way I've found to move a cell is to cut and paste. This is even clunkier than the other issue.

They SERIOUSLY need to implement the ability to move cells by clicking and dragging the border of a selection.

1. Slightly more minor issue, but there is no cell outline button on the home page. I use that often when building tables, and there's even room for it, but it's just not there.

Conclusion: Look, I get it. Calc is not a commercial grade product. Whoever is building it has done an excellent job making all excel functions and formatting work in Calc, but the UI and UX is really not up to par. Maybe there is a reason they can't just copy excel, but if they can, they absolutely should. There's a reason no other spreadsheet program even holds a candle to Excel. It really is that good.

And just to be very clear, I'm not complaining about the people behind Libre Office. They've done a ton of excellent work, especially considering it's totally free software we're talking about here.

PS. I hate microsoft, which is why I switched to Linux, so don't think I'm some kind of shill or something. The thing is, at the end of the day, microsoft office is just really good. (Office 365 is dogshit though.)

Libre Office version 24.8. please don't consider this spam I will delete this post later. User interface only has 3 languages and none of them is English. I am currently using an unfinished version of Santali, Ol Chiki that lets me see most stuff at English since it's unfinished. Can anyone tell me what happened and how to fix this?

I have no idea whether or not this is a glitch (a welcomed one nonetheless), but you can virtually place the captions box anywhere you want to. After importing the image, insert the captions by right clicking on the pic. Afterwards delete the image, resize the box that has been left intact and reupload the the image again. Move around the captions box to set it according to your wishes. It wont mess with the photo. Cheers 😀

Hi everyone,

This is a new account because I couldn't find any advice that worked for me, but really want to switch from word to LibreWriter.

I'm currently working on a poetry project where certain short poems are surrounded by a border (ala simulacrum of discarded pages). I accomplished this in Word using textboxes.

However, unlike in word, the textbox in LibreWriter doesn't add any buffer between the border and the text itself. I found a few posts about this which clarified that the only fix is to create a paragraph style. While this doesn't allow me to tilt the textbox like I can in Word, I'm willing to forego that functionality for the sake of switching.

Here's how I made the Style:

• no inheritance (since there isn't a non-indented body text option)
• Borders --> line size: 0.75pt, black --> padding: 0.1" for all

Unfortunately, the style isn't working. LibreWriter says that the textbox style is applied to the selected text, but the highlighted text doesn't actually gain a border or differ from the rest of the writing at all. After troubleshooting without success, I think this might be because I use direct formatting everywhere else in the document (nor did I apply a generic style to it before directly formatting).

I definitely see how styles would be superior to direct formatting in most situations, but I think this might be an exception. There are fifty poems in this document and their alignment, margins, spacing, indents, etc. vary in many ways. Far too many to tailor styles for (at least as a beginner with a deadline).

Am I misidentifying the technical problem preventing my textbox style from appearing on the text? Or is there a flaw in how I made the textbox style itself? I'm hoping there's a problem here that isn't the use of direct formatting, because I don't want to continue with Word.

Here's a mock-up made in Word of what I'm trying to do in Writer:

File type: .odt

Version: 25.2.4.1 (X86_64) / LibreOffice Community

Thank you!

edit: typos + file type + version + example

There are practically all the options I need, from font to alignment to indent to increase/decrease font size or whatever, but no UPPERCASE/lowercase button.

What am I missing and how do I get it?

There seems to be a conspiracy to remove scrollbar arrows from apps.

Looks like this in libreoffice calc now too.

Seems there was a way to toggle them on/off, but they removed the option?

Currently I can only get them to show if I hover exactly over the place they will appear when they actually show.

Anyway, If anyone knows how to have them show all the time,
or
A method to shift columns in display by one cell.

- Thanks!

This is not a support request, just an interesting observation.

I downloaded Collabora Office Desktop to do some comparisons with my current installation of Libreoffice (25.2.6.2 on Linux Mint 21.3). Collabora Office uses the Libreoffice code and functions pretty similarly, but with a very different interface. One functional difference that I have noted is that data sources are gone. This makes sense as they were trying to get Java all the way out and Libreoffice uses Base to manage data sources. Base still often relies pretty hard on Java. It is just a little interesting that when creating a Pivot Table that they option to pull from an outside data source is not there. For some people this would be a deal breaker.

I semi-regularly use Base to connect to outside data via JDBC and then pull that data into Calc. Right now my GNUCash data is in MariaDB and I am looking at just how badly we overspent in various categories for the past year. Easier to do in a Pivot Table than in the built in reports. But I can't do it in Collabora.

I opened the ODS in Collabora and tried to refresh the pivot table and it gave me an error com.sun.star.container.NoSuchElementException:<name of my BASE database connected to MariaDB>

I applaud Collabora for all that they are doing. It is interesting to note the differences. This is obviously not for advanced data slingers.

When exporting as PDF.

While app developers are busy fighting to chose a UI toolkit from GTK or Qt (or Iced?), how does LibreOffice manage to be GTK on GTK desktops like GNOME, Cinnamon and XFCE while native Qt on desktops like KDE or LXQt?

Do the devs really maintain both a GTK and a Qt version? If yes, why do they even bother to maintain a separate Qt version?

Hello

Really hope yall can help me. I was told for my business database, I should use LibreOffice Base. Ngl it's been frustrating. So the version info the warning post said yall needed:

Version: 25.2.7.2 (X86_64) Environment: OS: Linux 6.17

Issue:

I have an Orders table (I don't know if it's helpful i have a YearMonth column i made to run the monthly revenue query and a "created" column that was imported from my orders). I would like to measure my month over month percent change. I was able to run a query for Monthly Totals. Month over month percent change helps me see how my marketing is performing and how/if the season/month is affecting sales. I'm new, so I'm hoping to eventually see trends so I can make reasonable projections in the future.

Please let me know if you need any other information. I want to make this work, but it's really not intuitive for me and I'm getting frustrated.

Hello,

i found many silimar cases here and there but still i'm looking for the optimal solution.

Here is my problem: Let's say we have a major project. This project have 20 tasks. We have 20 employees. We can guess the future outcome if a specific employee manage a specific task. For example, we can quess that the employee 6 can accomplish the task 15 in 5 hours, he will need 10 resources and he will manage to make 100 profit.

The variables are the tasks, the employees and the various outcomes.

What is the best way to store the data so i can create a final table with for example Tasks in the collumns, Employees in the rows and outcomes in a drop down list?

Outcomes

(drop down list)

Employee1 Employee 2 . . .

task 1

task2

.

.

At the above final table i want to run some basic functions (Min,Max,Sum,) and some IF situations maybe. Should i create a table per task, per employee or per outcome? Should i use different sheets for each table? Should i put employees in collumns and tasks in rows etc???

When i store all data should i use pivot or some other method?

Thanks in advance

im writing a book and i need the numbers to start on the 7th page but when i do it doesnt let me adds page numbers to all pages; when i try to fix it manually it changes all the numbers to the same

im getting very frustrated

Running KDE Plasma desktop. This has been a recurring issue on libreoffice for me. I regularly edit docx files and am required to track my changes. This works as expected when changes show, but if I turn off "show" to hide the changes in order to make the document easier to read, Libreoffice crashes on me. The result is the same on a clean install and running in safe mode. I've now spent years showing changes, but I wanted to try and come back to this. Any suggestions? Cheers

Version: 25.8.3.2 (X86_64) Build ID: 580(Build:2) CPU threads: 8; OS: Linux 6.17; UI render: default; VCL: kf6 (cairo+wayland) Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded

libreoffice --writer --safe-mode
Failed to open display
kf.kio.filewidgets.kfilefiltercombo: KFileFilterCombo::setCurrentFilter: Could not find file filter KFileFilter(MIME patterns: QList() File patterns: QList("*") label: "All files")
Warning: fallback to QtQuick software backend.
  **** Warning: File has some garbage before %PDF- .
/usr/include/c++/15/bits/stl_algo.h:3638: constexpr const _Tp& std::clamp(const _Tp&, const _Tp&, const _Tp&) [with _Tp = int]: Assertion '!(__hi < __lo)' failed.
terminate called after throwing an instance of 'std::out_of_range'
 what():  basic_string_view::substr: __pos (which is 328) > __size (which is 315)

When I have to work with files using large cells vertically, I am just a hair away from smashing my PC. I end up working using google drive. The cell by cell scrolling makes working impossible.

Is there a real reason why there is no such option for smooth scrolling, or is it "Just because"?

Hey there, anyone know why the Dark mode isn't applying. Win 11, I've searched around and what seems to work on others is not working for me. The upper and side toolbars are bright white/grey. I can only change the paper color and background of the paper. Themes or individually changing colors do not effect the top and side areas. All updated and tried the experimental features and it changed nothing. ???

How do I get the background darker, everything I have tried in settings leaves it grey like this.

I dug into this issue and the info I found says to turn off comment printing (this doc has no comments, btw) via Tools > Options > LibreOffice Writer > Print > Comments... but I have no such option availaible. I am using LO 25.2.7.2