I know the shortcut key exists but I want it always fully expanded

I made a template with custom styles that I'd like to use for all my future file editing... but that only works when I create a new file. I wanted it work as soon as I open a file that already has text in it. Is there a way for this to work?

Working on a final project for my data visualization class, attempting to convert whole numbers (0-23) into a time format (00:00 - 23:00). I've found the HOUR function which does the inverse of what I'm trying to do, and can't seem to find a different function that does what I'm asking.

Hi everyone!

I have a simple spreadsheet with two columns - date and number. These are in a line chart, X is date, Y is number.

I wondered, is there a feature where I can forecast say the next two numbers in the chart (or even in a column)? I did see something about a trendline but wasn't too sure

Many thanks for your help

INDIRECT doesn't do this. Instead of providing the content "Ax" of the cell ZZ to be used as an address, it directly looks into the address Ax and retrieves the content.

Basically I need to sum subsets of a column to manually create an increment that is capable of skipping empty lines (I didn't find a way to look up the last cell containing a number value in that column and adding 1 to it), starting a new subset and counting from 1 again each time there's a change in another column. To do that I used COUNT.IF but I can't find a way to make the range dynamic.

EDIT: sorry I forgot; this is Calc

Version: 24.2.2.2 (X86_64) / LibreOffice Community

Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01

CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win

Locale: it-IT (it_IT); UI: it-IT

Calc: CL threaded

title

For few weeks I can't access their site.

Any known problem?

So, I was recently assisting my girlfriend in further setting up her new computer, and so I decided to give her my copy of LibreOffice 5 that was on my laptop. She's familiar with it and thus she didn't want to have to figure out a new version.

So, I grabbed everything relating to Libre from my system files and copied them onto her computer.

Anyway, as I was editing a document on her computer I realized that the version I copied onto her computer doesn't have the bottom task bar, the one that keeps track of word count and the like, and secondly it doesn't seem like spell check even works.

Like, it will inform me that a space is doubled, or if a word is repeated with the blue underline, however when I purposefully mistype a word, there is no red mark for me to fix it. And, even if I use the manual spell check, it completely ignores the word that is incorrect.

Is there any way for me to fix this? Is it a problem because I moved a program that was being used in Windows 10 to a computer that had Windows 11?

What am I doing wrong?

I have a 60-page Writer document. I want to number the first 10 pages in Roman numerals and the rest in Arabic numerals. It is acceptable if the first/title page does not have a page number.

The required details:

Version:  (X86_64) / LibreOffice Community
Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
CPU threads: 8; OS: Windows 7 Service Pack 1 X86_64 (6.1 build 7601); 
UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-US
Calc: CL threaded24.8.3.2

The title really say is all.

I've got a 17-sheet ODS file, mostly for my own use, that has organically grown over the last, probably, decade. It works flawlessly, well most of the time, but it contains a hell of a lot of absolute references, and named ranges like

INDIRECT("$Daysall.$R$2:$R"&$Rides.$X$2+1)

where even the named sheet is absolute, but can be moved without problems.

However, I now want to add a new, why the fluckin 'ell didn't you do that straight way, first column to one of the sheets and just doing so invalidates all named ranges on that sheet, and in the above formulas to make up the names ranges I have to change the references to column R to S, which is even more cumbersome, because the dialog to edit named ranges only has "OK" and "Cancel" buttons, and lacks an "Apply" button, which mean I have to open, and open, and open it again ad nauseam...

So question, "Why can I move a sheet, even though it's referenced absolutely, but when I do the same for columns, I have to manually edit the ranges?" Inserting a new column (or row) should automagically do this.

And of course, as a more advanced user, I know that there's another way, which is to just write a bit of code to unzip the ODS, and use "sed" to actually make the changes, but for your usual Tom, Dafne, and some gender-neutral person whose name starts with "H" ;) this is way, way, way to much to even contemplate.

If it's needed, the ODS is here: https://prino.neocities.org/resources/lift%20&%20v100+.ods and I need to add a new initial column in the "Daysall" sheet.

Any suggestions?

I've been working with data from a lab experiment and would like to find out, which x value corresponds to the y value of -3 in my graph. Is there a way to add a custom data point at y=-3 that is automatically lined up with my graph? Or a way to have two lines, one at y=-3 and another at the corresponding x value and add a data point to their intersection? If not, does anyone have another soluion?

I'm using the latest version of Libreoffice and my OS is Windows 11. Thanks in advance!

I'm making envelopes and using a mail merge. I'd like to center the Recipient on the page but leave the address Aligned under that. How would I go about this?

How do I remove a header from consecutive pages after the first page?

Brand new to Libre Office (used Open Office briefly way back in the day), having come from M365 and decades of using MS Office generally.

Delighted that LO is such a full featured suite, and enjoying my use so far. Kudos to the team and community that have helped to build these awesome products.

My question is, can the UI elements (mainly the toolbars and tabs) have additional padding and spacing? I'm on Windows (yes, I know), and the toolbars look very smushed together, with all of the icons (I'm using Colibre) very tightly packed together. On a 32" screen here so I have plenty of real estate, but I can't seem to find any way to increase the UI font, icon/tab padding? Some elements also seem to clip into each other, and having some sort of increased spacing between them might help address that.

Any suggestions on how to achieve this? Most screenshots I've seen seem to be from what I presume are various Linux distros, and the UI looks much, much better.

On what I believe to be the latest version (just updated this morning):

Version: 24.8.3.2 (X86_64) / LibreOffice Community

Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92

CPU threads: 28; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Vulkan; VCL: win

Probably a pretty dumb question, but here goes.

I am trying to input a list of photo titles into an online text-only portal (with an example file being "C:\RedlineFan\Photos\Thing1.jpg", just the "Thing1" is all I need). These are all in one folder and there are quite a lot of them. Instead of typing them all up by hand in Notepad and copying them from there (Thing1, Thing2, Thing3, etc.) I thought I'd just use the "copy as path" function in Explorer and then "find and replace" the path and file extension out in Writer.

However this doesn't seem to work as I can't get Writer to replace the backslash or period symbols. Is this possible? Better yet, is it possible to just type in the whole path minus the file name ("C:\RedlineFan\Photos") into the "find and replace" function? Haven't had much luck with that either.

Thanks in advance.

Hi everyone!

After updated from 24.8.3.1 to 24.8.3.2, taskbar's icons isn't showing anymore.
I have already tried to repair the installation but it doesn't work.

Any help?

Edit: I completely unnistall and reinstall but it doesn't work too.

https://preview.redd.it/renkhgkxeu3e1.png?width=274&format=png&auto=webp&s=45a7ee10e1e9b7446039a91462c305b7dfef4875

https://preview.redd.it/qmduzdkxeu3e1.png?width=273&format=png&auto=webp&s=2aa04ae1254691c1fdae0e21885ae5281bf91c9e

Edit 2: I'm using Windows 11

Yes, I know there is a "Edit->(something)->compare documents". But what I actually need would be a kind of diff-like output[1] instead of the clickable list that comes up, as I have to edit and send this list to someone. In the end, I have to turn in a document with a three-column table (original, change, comment), but that I can handle from a diff-like start.

My current solution is to export both documents as text and actually do a diff, but then I still have to hunt through the "compare files" list to find the places where I e.g. only changed the plain text to italics and similar style changes.

[1] for those who don't know "diff": It compares two text files and produces a text listing with which lines to remove and which to add.

As requested by the bot: Version: 24.2.6.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Ubuntu package version: 4:24.2.6-0ubuntu0.24.04.1 Calc: threaded

Document type is .odt

So I just digitally signed an ODT file to make sure it's genuine before uploading it to a Google Drive folder, and when I downloaded it at work, LibreOffice says the document was no longer valid and was modified. What the heck? Did Google Drive just mess with the cryptographic integrity of my ODT file? No one has access to that folder. Anyone else have the same experience? I'll try to experiment with this today?

Basically I have a spreadsheet with many rows having repeated names and some squares in the same column are empty, and others aren't.

Is there a quick way to merge all these rows? Making sure the name of the person stays the same, but the information that is missing in some rows and not missing in others is properly merged to make sure one row has all the information?

Windows 10 x64
LibreOffice Calc v24.2.7.2

When I edit a cell, there is no text in it, its absolutely blank. I can only see the text after I hit enter and confirm the changes.

Happens in all cells in all tables.

If the cell already contains something, when I doubleclick to edit it, the contents disappear. I can only see what I am typing in the "Input line" field in the toolbar.

How to fix?

The context is a large spreadsheet that will not ever be printed.

I would like it to display without showing page break dashed lines

Example of what I want *not* to see. |

vertical line on the right is page break.

Thank you.

Hey Reddit, I'm very, very new to LibreOffice and I'm having this odd issue where all my LibreOffice applications (Calc in picture) seems to have this white outline on all buttons, window options, outlines, everything. Is there a setting I've got on that's messing things up, or am I just confused and this is the way it's supposed to look?

I would love to fix this so I can actually use these applications, but the outline bothers me too much at the moment.

Version: 24.8.3.2 (X86_64) / LibreOffice Community

Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92

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

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

Calc: CL threaded

https://preview.redd.it/jcd1jb4daj3e1.png?width=1920&format=png&auto=webp&s=3e0dea7433bec5ba8224af3226a04e3f4f7ca8c8

I wan't to keep track of of things I'm watching without being relied on sites like imdb.

The problem is, I can't find anywhere any way to add images in to cells on Libre Calc and then have them for example be mass resized if I want to just by changing the cell size.

closest thing i found so far was inserting the image. Putting the anchor to the cell i want. And then selecting "Fit to cell size.

I've been given a list of more than 5,000 words that are Typed in LibreOffice Writer, and I've got to figure out which words are repeated there. I followed some of the links but the script given there didn't seem to work. That's why any of the friends present here, can you tell me what words have been repeated as a macro script that highlights them in one color.

Link-1

Link-2

Link-3

Version: 24.8.3.2 (X86_64) / LibreOffice Community

Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92

CPU threads: 12; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win

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

Calc: threaded