ruby.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
If you are interested in the Ruby programming language, come join us! Tell us about yourself when signing up. If you just want to join Mastodon, another server will be a better place for you.

Administered by:

Server stats:

1.1K
active users

#libreoffice

17 posts16 participants0 posts today

This is terrible in so many ways, it's a huge waste of resources.
If you are an individual, there is a huge worldwide community that is happy to help you upgrade to #Linux and #LibreOffice
If you would like some help, HMU.
If you are an organisation, I do contact work helping companies migrate from M$ products to free alternatives. There is no reason to continue paying the M$ tax.
Avoid #eWaste!
windowslatest.com/2025/04/03/m

Windows Latest · Microsoft doc says recycle Windows 10 PCs if they can’t upgrade to Windows 11Have an old Windows 10 PC that can't be upgraded? According to Microsoft, you should dump it, recycle the hardware, and buy a Windows 11 PC.

Got a great, helpful answer to my last #LibreOffice question, but that led to a translation question

I use LibreOffice and find guides/answers in multiple languages

Calc provides language specific functions, which is fantastic!

But, is there a way to lookup calc functions in one language and determine what they are called in another language?

For example, converting text to a number -

French: CNUM("4:55")
German: WERT("4:55")
English: VALUE("4:55")

floss.social/@SGi@framapiaf.or

floss.socialFLOSS.social

in #LibreOffice spreadsheet is there an easy formula to convert 4:55.66 from minute, second, hundredths of second to a number?

I'm importing test results from another location, I could transform prior to input, but I'd like to do the conversion in the spreadsheet if I can

The conversion would give me 295.66 for the above time

The conversion value will go in another column

Alternatively, is there an easy way to do math on the original format, e.g. sort, greatest, lowest, etc.

Ask me how many times a day I get burned by the #LibreOffice race-ish condition where I hit C-f and then start typing but the C-f handler doesn't leap into action until after the other keystrokes have been processed as normal input, so I end up accidentally replacing the contents of a spreadsheet cell that I also can't easily find because where was focus...and then the cursor jumps to the search box.

I liked this youtube video from JCristina explaining why last year he switched to LibreOffice and Linux away from MS Office and Microsoft. I feel the same way as he does about Microsoft and most big proprietary software companies.
youtube.com/watch?v=NtgJi5DVxm

Even though things with Windows weren't as bad when I switched fully to Linux back around 2007 when it was still Win XP, Windows has just kept getting worse with all the spying, subscriptions, ads, AI, etc. while Linux has kept getting better and easier, with none of that invasive stuff.

The only thing I'd add to what he says, regarding the part where he mentions how you have to pay $10 a *month* to use MS Office (plus subs to other $ software): If you use FOSS, imagine how much money you've saved over the years! So if you can, why not donate some of that savings to the FOSS software projects you like or use the most to help keep them going.

Just ran into a brutal #UI / #UX problem in LibreOffice Calc, on a Debian bookworm system, fully up to date.

1. Decide to print spreadsheet
2. Open print dialog
3. Preview is in the left pane, options in the right.
4. Scroll down in the options pane to find an option near the bottom.
5. Change setting, or not.
6. Scroll back up to the top of the options pane, using the pointing device vertical scroll wheel.
7. If the "number of copies" scrollbox happens to pass under the mouse pointer, it will rapidly increase the number of copies. It's not particularly obvious this is happening; it's easy to miss the value is changing.
8. Move the mouse pointer slightly up and scrolling the options pane continues.
9. Click "print".

Voila! 23 copies of what you wanted to print a single copy of.

I actually ran into this while trying to debug a totally different UI / UX bug 😱

Replied in thread

@LifeHacker @all-the-latest-tech-news-reviews-hacks-LifeHacker

You can download LIBRE OFFICE for free !!!

For Mac, PC or Linux... FOR FREE!

No license, no open door for viruses and trojans into your system because Microsoft doesn't care.

@libreoffice if free. It's updated super regularly and it will open ANY office file you need.

99.9% of all users don't need M$ Office. #LibreOffice is the way to go!

libreoffice.org/

Donate that $43 to some charity

www.libreoffice.orgHome | LibreOffice - Free and private office suite - Based on OpenOffice - Compatible with MicrosoftFree office suite – the evolution of OpenOffice. Compatible with Microsoft .doc, .docx, .xls, .xlsx, .ppt, .pptx. Updated regularly, community powered.