Another #Excel #Spreadsheet #User #failure
https://highlandradio.com/2025/03/26/donegal-ot-waiting-lists-double-that-previous-beliefs/
"Due to an administrative error, the waiting list data previously provided to the Regional Health Forum West Members was incorrect. This occurred due to the miscalculation of the OT excel spreadsheet whereby only one tab of the excel sheet was provided rather than the full total. This has since been identified and rectified and we wish to apologise for this error."

Hello, #fediverse

Does anyone know a #spreadsheet alternative to Google Sheets that is cloud based and anyone can see with a link?

Did some light searching, but no idea what's good or not. Lol.

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

My brother needs a spreadsheet program secure enough to use for patient data.

Excel is MS and works like shit on Linux.
LibreCalc has terrible UI (so by brother says).
Google Sheet is Google and is not secure enough.

Suggestions? =)

#spreadsheet
#excel

So irritated I’m just now learning this MS Excel SUM data tip.

https://youtube.com/shorts/nTpme-FmZbQ?si=1GkHzxQbBwXGa6XB

This kind of reminds me of a time I was asked to create what was essentially a bare bones controlled drug register in a spreadsheet for a small study. It worked but only because there were different sets of eyes monitoring it and I do not recommend it as a long term solution.

https://www.theregister.com/2025/03/10/nz_health_excel_spreadsheet/

You can paint in Excel (so presumably also in LibreOffice Calc too).

I am genuinely boggled at how detailed the pictures are.

#Excel #Spreadsheet #ArtByNumbers

https://mymodernmet.com/tatsuo-horiuchi-excel-spreadsheet-paintings/

Microsoft Excel has stood the test of time to be one of the most reliable spreadsheet apps out there. These 5 underappreciated features make Excel the king of spreadsheets.

#microsoft #excel #spreadsheet
https://www.xda-developers.com/underappreciated-reasons-why-excel-is-still-the-king-of-spreadsheets/

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 (https://www.mozilla.org/en-US/about/manifesto/)?

Spreadsheet help and maybe a custom made Android app?

https://blog.taursnd.haus/display/1a041b09-7367-b370-9ea9-998211506442

My presentation to ISACA on spreadsheet risk
https://www.isaca.org/training-and-events/conferences/isaca-virtual-conference/agenda
Thursday 20 February 10:45 UTC
EMEA: 313 - Assessing And Mitigating End-user Risks In The Use Of Excel Spreadsheets For Critical Uses

Wait what: Microsoft Excel World Championship??

“Then the men sat down at desktop computers, opened their Microsoft Excel spreadsheets and began to type.”

https://www.nytimes.com/2025/01/20/us/microsoft-excel-world-championships.html?unlocked_article_code=1.qk4.t0xI.vNE_uYLnInN3&smid=nytcore-ios-share&referringSource=articleShare

2021. #bioinformatics #spreadsheet #excel #donotuseexcel

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?

Who knew the secret to surviving a spreadsheet was a tiny pop-out video in the corner? Who says you can’t work and watch at the same time?

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?

#genuary7 - Software that is not intended to create art or images. Spreadsheets have to be among the most non-artwork-related software out there. So I made a Mandelbrot and Julia fractal using LibreOffice Calc macros. The macros resize each spreadsheet cell to square, then fill in the cell background with the appropriate color. #libreoffice #spreadsheet #fractal #genuary #genuary2025

So I have been wanting to learn more about how to use Microsoft Excel so I can teach other people about some of the more advanced programming techniques (EDIT: 1-on-1 lessons on their own computer with their own licensed copies of Excel). I want to teach myself more about Excel so I was going to install it on my own computer and do some advanced tutorials. But then I really do not want to burn up all of that disk space just to run Wine and Excel.

So I got to thinking:

1. is there an older version of Microsoft Excel I could use instead?
2. The “ribbon” UI/UX asside, how far back in time (in Excel software versions) would I have to go before the formula language and cell computation engine became too different from the most recent Excel that it would not be very useful for me as a learning/teaching tool?
3. Would it take less disk space to run this in a minimal Windows NT 2000 or Windows XP instance on QEMU than it would take on Wine?