Thanks to Juan José Gonzales!

SOLVED, with a huge thank you to [email protected]
https://lemmy.world/comment/6271130

Hiyo Librecalc pros. Hoping someone has an idea how to automate or minimize the steps for this. Or where should I start? I'm trying to automate transcribing a list from:
Closet_01
Cartridge123
Cartridge234
Garagenook_01
Cartridge456
Toolbox567
Toolbox789
Garagenook_02
Cartridge890

Into an array/table like:
Cartridge123, Closet_01
Cartridge234, Closet_01
Cartridge456, Garagenook_01
Toolbox567, Garagenook_01
Toolbox789, Garagenook_01
Cartridge890, Garagenook_02

I get it; I should just carry around a barcode list of all my shelf names and take turns between scanning the list, tabbing over on my phone, scanning a box, then tabbing back again. But... what if I want to be lazier and just scan things in an order and automate the rest later?

Is there a faster way than copy-pasting my way down?

I got as far as making an adjacent column with a formula to check for "_", then copying the location if "_" was found.

I'm looking for a good, all around, diagramming software to use. Libreoffice draw is quite nice, but it doesn't appear to support UML; however, I may just be missing something.

EDIT: It appears that there may be an extension that offers this functionality?

Today we are announcing the first release of a very important document that describes – in language accessible to everyone, including non-security specialists – the impressive work done by developers and quality assurance specialists in the area of LibreOffice security.

From now on, the LibreOffice Security Backgrounder will be updated on the occasion of each major release of LibreOffice, i.e. in February and August each year (as things stand). For this reason, the full name of this document is LibreOffice Security Backgrounder 2023.12.

It is important to stress that the purpose of this document is purely informational, to clarify aspects and steps in the development process that have not been sufficiently documented in the past. Software security is a fundamental aspect, but not a competitive advantage.

The security of LibreOffice and the documents it generates is very important to all of us, and especially to the users of the suite, which is why there are dozens of people with advanced computer security skills who dedicate their time to protecting and improving it.

We hope that this document, which has been produced with the help of a number of companies and individuals, some of whom are mentioned in the document itself, will help to improve knowledge of the security processes involved in the development of free and open source software.

Download LibreOffice Security Backgrounder 2023.12

Love LibreOffice development? Want to turn your passion into a paid job? We are The Document Foundation (TDF), the non-profit entity behind LibreOffice. We’re passionate about free software, the open source culture and about bringing new companies and people with fresh ideas into our community.

To improve language support features in LibreOffice, the office productivity suite for over 200 million users around the globe, we’re searching for a developer (m/f/d) to start work (from home) as soon as possible. This is what you’ll do:

• Work on the LibreOffice codebase (mostly C++)
• Focus (initially) on right-to-left (RTL), complex text layout (CTL) and CJK (Chinese, Japanese, and Korean) languages in the LibreOffice code
• Fix bugs, implement new features, and improve language support in LibreOffice

What we want from you:

• Very good C++ development skills
• Proven experience working on either RTL/CTL and/or CJK topics, or both
• Good understanding of Unicode and internationalization (i18n)
• Good understanding of text rendering and font issues
• Proven contributions to FOSS projects (show us your repos!)
• Good team-playing skills
• Experience with LibreOffice development is a plus

Speaking and writing English is a mandatory requirement. Another language (for example: German, Spanish or Arabic) is a bonus.

A previously established relationship within the developer community, as well as with other teams such as QA is a plus, but it is not mandatory at the start and can be achieved during the work itself.

As always, TDF will give some preference to individuals who have previously shown a commitment to TDF, including but not limited to members of TDF. Not being a member does not exclude any applicants from consideration.

Join us!

All jobs at The Document Foundation are remote jobs, where you can work from your home office or a co-working space. The work time during the day is flexible, apart from a few fixed meetings. The role is offered as full-time (ideally 40 hours per week). Candidates that are resident in (or willing to relocate to) Germany will be employed directly by TDF. Otherwise, external payroll services will be used if available in the candidate’s country of residence.

Are you interested? Get in touch! We aim to schedule the first interview within two weeks of your application. You can also approach us any time for an informal chat, to learn about the role or in case of questions.

TDF welcomes applications from all suitably qualified persons regardless of their race, sex, gender, disability, religion/belief, sexual orientation or age. Don’t be afraid to be different, and stay true to yourself. We like you that way! 😊

We’re looking forward to receiving your application, including information about you (your resume), when you are available for the job, and of course your financial expectations. Pointing to public repositories with your code is very helpful. Please send us an e-mail to [email protected] no later than January 8, 2024. If you haven’t received feedback by February 9, 2024, your application could not be considered.

Also note: we only accept applications from the applicant, and not from any intermediary. We do not accept agency resumes. Please do not forward resumes to any recruiting alias or employee.

currently they're white and i want to change them to black or something

Download them now:

https://documentation.libreoffice.org/assets/Uploads/Documentation/en/DG7.6/DG76-DrawGuide.pdf

https://documentation.libreoffice.org/assets/Uploads/Documentation/en/IG7.6/IG76-ImpressGuide.pdf

This will be the last in the series before version 7.6.

Hey! I'm new to LibreOffice and I was wondering if this is possible. I have a big spreadsheet where each line refers to an object for which I actually have a corresponding .webp image, and it would really help me for visual reference if such a hover tooltip (or click tooltip) would be possible in LibreOffice. Does anyone know?