Lmst

Active row/column highlight! Yes and please. 👍📊 #libreoffice #foss #spreadsheets
https://blog.documentfoundation.org/blog/2025/05/31/libreoffice-design-team-work-in-2024-tdfs-annual-report/

=COUNTIF(A2:A10; TODAY()) works

=COUNTIF(A2:A10; >TODAY()) doesn't work

Drives me mad.
#spreadsheets

RSS With An Expiration Date: The Temporary Obsessions Feed Reader

I love RSS; I literally couldn't do my self-appointed job without it. But when it comes to temporarily monitoring topics, RSS feeds are a bit unwieldy; you have to add another layer of workflow to add/remove feeds, set up reminders for yourself, etc. All that has hitherto discouraged me from using RSS when there was a time-sensitive or current event topic to cover.

https://www.calishat.com/2025/06/11/rss-with-an-expiration-date-the-temporary-obsessions-feed-reader/

#RSS #spreadsheets #curating

I am proud of this conditional formatting formula that now highlights any significant growth.

#excel #spreadsheets #gamedev #programmer_humor #funny

I was importing books from a different website into @bookwyrm and wanted to remove a couple and my personal notes just so they didn't accidentally get published to the internet. So I edited my csv by removing those parts and somehow ruined it, spent half an hour trying to fix it. That was yesterday. I tried again today and was somewhat smarter with how I handled the csv and it is currently importing correctly!
#Bookwyrm #Fediverse #Tech #CSV #LibreOffice #LibreOfficeCalc #Spreadsheets

»#Perplexity's new tool can generate #spreadsheets, #dashboards: available on the web, iOS, and Android, and coming soon to Perplexity’s apps for Mac and Windows.« https://techcrunch.com/2025/05/29/perplexitys-new-tool-can-generate-spreadsheets-dashboards-and-more/?eicker.news #tech #media #news

New bloggage - in 2014 I tried to read some old #QuattroPro for #DOS #spreadsheets in modern software, and concluded the format was effectively obsolete.

More than ten years onward, things are looking much better now, thanks to @libreoffice. But my latest tests also highlight some gnarly issues.

https://bitsgalore.org/2025/05/28/quattro-pro-for-dos-revisited-an-obsolete-format-no-more

As a #dotnet developer, at some point, someone is going to ask you for an #Excel output from your #SQL database.

You can't escape it!

Don't worry, I got you 😁

#softwaredevelopment #data #tech #spreadsheets #coding #microsoft

https://zurl.co/qOWyt

#government #finance #spreadsheets #transparency #OpenSource

'Now, users will only have to download an Excel template, input their financial data and upload it to the online tool. The tool will convert the information using eXtensible Business Reporting Language, or XBRL, a royalty-free, open source international framework that communicates financial data on the internet.'

https://news.umich.edu/u-m-develops-free-tool-to-empower-municipalities-modernize-financial-reporting/

🧮 Welcome to 2025, where we still discover the groundbreaking news that #spreadsheets have features. 🚀 In a stunning display of #innovation, intrepid researchers have quantified the sophistication of spreadsheet software, bravely facing the subjective nature of function support and calculation exactness. 🤯 Spoiler alert: they’re all just glorified #calculators with delusions of grandeur. 📈
https://grid.is/blog/comparison-of-spreadsheet-software #research #technology #humor #HackerNews #ngated

🚨 Breaking News: #KumoRFM wants you to believe that relational data is finally getting its #AI #moment, like it's the unpopular kid suddenly invited to the cool kids’ table. 🥳 But really, it's just another #overhyped attempt to make people care about #spreadsheets with delusions of grandeur. 📊✨
https://kumo.ai/company/news/kumo-relational-foundation-model/ #DataTrends #HackerNews #ngated

Been using Airtable for a long time now, so I thought I'd finally make it official (again): I'm Airtable certified.

I love working with relational databases. For some reason, they've always "clicked" in my brain. ¯\_(ツ)_/¯

Bring me some Airtable projects and let's make your database/app/interface come to life 🤝 📥

#airtable #airtableacademy #certifiedairtablebuilder #database #databases #software #nocode #apps #appdevelopment #spreadsheets

#SpreadsheetHell #SpreadSheets are great but don't scale efficiently

Tom’s Hardware: Developer gets Linux running inside Microsoft Excel, ‘mostly for fun’. “Developer NSG650 has succeeded in his attempt to get “Linux running in Excel.” The GitHub-hosted and aptly named LinuxInExcel project was uploaded to the cloud-based developer platform earlier this week, and updated with input support just yesterday.”

https://rbfirehose.com/2025/05/03/toms-hardware-developer-gets-linux-running-inside-microsoft-excel-mostly-for-fun/

Industry studies show that 90 percent of spreadsheets containing more than 150 rows have at least one major mistake. Yet we keep using them for mission critical projects 🫠 #spreadsheets

Source: https://arstechnica.com/science/2024/01/we-keep-making-the-same-mistakes-with-spreadsheets-despite-bad-consequences/

I need to set up a private spreadsheet that is viewable and editable by an elderly relation (who uses spreadsheets all the time) and a couple of younger family members, one of whom lives interstate.

The obvious answer is Google Sheets. Is there an alternative that is usable for these people?
#spreadsheet #spreadsheets

When buggy spreadsheets accidentally make you rich 🤑 #spreadsheets

Source: https://arstechnica.com/science/2024/01/we-keep-making-the-same-mistakes-with-spreadsheets-despite-bad-consequences/

A screenshot of an ars technica article talking about costly spreadsheet shenanigans. It reads "In 2021, Crypto.com, an online provider of cryptocurrency, accidentally transferred $10.5 million (£8.3 million) instead of $100 into the account of an Australian customer due to an incorrect number being entered on a spreadsheet.

The clerk who processed the refund for the Australian customer had wrongly entered her bank account number in the refund field in a spreadsheet. It was seven months before the mistake was spotted. The recipient attempted to flee to Malaysia but was stopped at an Australian airport carrying a large amount of cash."

Ever hidden Excel rows or columns only to forget what's tucked away? 🤔 Stop playing hide-and-seek with your data! 🙈

Discover how Excel's grouping feature lets you easily collapse and expand sections. No more guessing or endless scrolling to find what you need. 👁️ Bring clarity and control back to your spreadsheets. ✨

Check out my latest video on how to effectively use this often overlooked feature of Excel: https://youtu.be/1rvnSAEynYA

#ExcelTips #DataManagement #Productivity #Spreadsheets