mastodon.ie is one of the many independent Mastodon servers you can use to participate in the fediverse.
Irish Mastodon - run from Ireland, we welcome all who respect the community rules and members.

Administered by:

Server stats:

1.8K
active users

#spreadsheet

1 post1 participant0 posts today

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 😱

If you're willing to help with working on this spreadsheet of key contact information for problematic U.S. officials and their associates for call/(e)mail campaigns, it would be much appreciated.
[2025 U.S. Officials' Contact Info for Public Communications] docs.google.com/spreadsheets/d I'm happy to provide editing access upon request.
#USPolitics #Government #Officials #Contact #Information #Musk #Trump #DOGE #Congress #Tesla #Crowdsource #Project #Spreadsheet #Effort #WhiteHouse #Cabinet #Democrats

Google Docs2025 U.S. Officials' Contact Info for Public Communications

Looks like this weekend will have to include time to review some #firefox alternatives after #mozilla 's last bit of madness... Can anyone else say #spreadsheet time?

Because I think there are definitely going to be that many options.

Side note: How the fuck is this all compatible with their pledge and #manifesto (mozilla.org/en-US/about/manife)?

MozillaThe Mozilla ManifestoThese are the principles that guide our mission to promote openness, innovation & opportunity on the web.
Replied in thread

@neauoire
I like it so much.

If the software development was done in a right way we'd end with the most often used tools which don't have a reason to get new features anymore (text editors, spreadsheets, file managers) rewritten in the most efficient way possible. Like, idk, in C with hot path in assembly (or in Rust for security-critcal parts) with tiny memory footprint on 90% trivial cases, milliseconds to first user input etc.
In fact we have exact the opposite - asm in the office apps was absolutely normal in the 90x and I can't imagine anyone doing this nowadays, memory footprint of an empty spreadsheet is 200MB and it takes 5sec. to load with cold cache on a 3Ghz 4 cores with 16G ram with SSD. And the most items in the changelog are about fixing compatibility with some proprietary crap (in FOSS) or adding AI, moving to subscription model or even more telemetry in non-free.
#assembly #foss #spreadsheet

I love a good #spreadsheet. I've used them for all sorts of things, including things as complex as double-entry bookkeeping. One of the biggest limitations I've run into is adding rows to the end of a range. For example, say I have 10 rows, and then the 11th row is the total. Then I insert another row after the first 10. Now I've got 11 rows of data, and the 12th row has a total of 1-10, but won't include row 11 in the total. Any other spreadsheets nerds have good ways to handle this situation?

Okay, I don't know if this is a #GTK thing, a #Gnome thing, a #LibreOffice thing, or a #Cinnamon thing, but I just discovered probably the most user-hostile "helpful" behaviour I've seen in a piece of #software in a long, long time.

The find-and-replace dialog in the LibreOffice #spreadsheet - I haven't checked the remainder of the apps - has the typical buttons for "Find All", "Find Previous", "Find Next", "Replace", and "Replace All".

... and no obvious keyboard shortcuts for them. Nothing shown, no #affordances, no typical underlined or bolded letter in each button's label text. Doing a large amount of selective search&replace (don't ask #Etsy cough cough) is incredibly painful. There's *got* to be #keyboard #shortcuts, right?

Here's the #evil: the shortcut keys are not indicated *until you hold down the alt key*. Then it underlines the appropriate letter in each button's label, but those underlines disappear again when you release the alt key.

So you can study this bloody dialog box until the cows come home and never see a hint of a keyboard shortcut, even though it has them.

#$*&!^%@ Who thought this was a good idea?

Updated my annual exercise tracking sheet for this year to include a graph for me to measure progress against last year.
Turns out in 2024 I ran 888km, so this year I want to try and beat 1000km. (Or 1Mm, if you prefer)

Dragged myself out this evening to do a pretty chilly 8km round the park. It really doesn't look like much on the chart so far but it's nice to see it above zero!
I'm already thinking I'd prefer to have a separate point on the graph for each run, but feels like much too much work tbh!
#running #spreadsheet