Argh!!!

Classic #Microsoft fail move. Exporting an #Excel spreadsheet to CSV (for further processing later via Python scripts), I've found a niggling `\ufeff` character leading it off, which has bombed my pipelines. It looks like this zero-width, non-breaking space is used as a BOM (byte order mark) by Excel (though explicitly exporting to UTF-8).

Unfortunately the Unicode spec clearly discourages this strongly:

> The serialized order of the bytes must not depart from the order defined by the UTF-8 encoding form. Use of a BOM is neither required nor recommended for UTF-8

Why does this evil empire have to make everything unnecessarily difficult???

LibreOffice 25.2.5: stabilità migliorata con oltre 60 bug risolti

https://gomoot.com/libreoffice-25-2-5-stabilita-migliorata-con-oltre-60-bug-risolti/

Can someone suggest VBA and Python resources specifically for Excel?

I'm helping someone from the Windows world upskill. Her biggest technical skill is Excel, so we're staring with that.

I can point her towards a Byte of Python for starters, but it has nothing about Excel integration and I really want to cover that. Thanks, folks.

This week on Embedded.fm, (@stoneymonster) and (@logicalelegance) sit down with Peter Griffin to unpack some wildly creative maker hacks:

Jumperless breadboards
Using Excel 365 as a serial-port bridge (yes, you can drive servos from a spreadsheet!)
And puppy buttons

Give it a listen: https://embedded.fm/episodes/505

Transcript & show notes: https://embedded.fm/transcripts/505

Which hack will you try first? Let us know in the comments!

Hat hier jemand Erfahrung mit #openpyxl? Alles was ich damit an Excel-Dateien erstelle, fürht dazu, dass mich #Excel anmotzt und die Datei reparieren möchte. Die Inhalte sind dann zwar vollständig, aber dieser unnütze Dialog nervt doch sehr. Es tritt sogar mit dem Codebeispiel aus der Projektdoku auf. Weiß jemand einen Rat? #followerpower #fragfedi #python #boost

Chris and Elecia ( @logicalelegance ) speak with Peter Griffin to explore:

Jumperless breadboards

Excel 365 Data Streamer

Puppy buttons

Whether you’re an embedded systems veteran or a maker looking to level up, you’ll find actionable insights and unexpected use cases—like controlling a robot via Excel!

Listen now: https://embedded.fm/episodes/505

#embedded #electronics #Excel #GUI #maker #engineering #innovation #puppies

Thank you to Mouser Electronics for sponsoring the show!

So... does anyone here have any experience with using #grep on #Excel files?

Episode 505: Potato In A Number Field

Chris (@stoneymonster) and Elecia (@logicalelegance) spoke with Peter Griffin about Jumperless Breadboards, no-install GUI development, Excel, and puppies.

Listen here: https://embedded.fm/episodes/505

#CustomHouse #Excel
#DLR #London

#ElectricLightOrchestra
#LastTrainToLondon

Tonight, I'm just sorting through my latest retro downloads... mostly stuff I found on the Internet Archive.

And... "Holy cow!" This must be the earliest version of "Microsoft Office" I've ever seen! "WIN OFFICE 1.00". Everything's on 5.25inch disks and it doesn't even have a combined SETUP.EXE yet. You just pick what you want and then you're being thrown into a full-screen DOS session to go through the setup process. It features "Word 1.1", "Excel 2.0d" and "PowerPoint 2.00". This is fun!.. albeit in a strange way.

Source:
https://archive.org/details/microsoft-office-1.0-for-windows-1.0-1990-09-english-5.25-1.2-mb

Seeking #recommendations for #alternatives to #Microsoft #Excel. Ideally #FOSS but not a hard requirement. I tried #LibreOffice #Calc and #CryptPad but found their capabilities lacking. E.g., I need something comparable to Excel's tables that allows me to refer to table and column names in my formulas instead of just cell locations. It looks like #SoftMaker can, but they also integrate #ChatGPT, and I'd like to avoid my money helping destroy the #environment and oppress the #GlobalSouth.

My spirit animal.
F*ck #Excel! F*ck! F*ck! F*ck!

#Excel è uno dei prodotti informatici al tempo stesso più usati e più odiati del mondo.
La cosa notevole è che sia l'uso che l'odio vengono in buona parte dal fatto che molti lo hanno frainteso e lo usano male.
La maggioranza della gente (sia a livello professionale che privato) lo usa per creare banche dati, elenchi, liste o simili.
Ma Excel è un foglio di calcolo! Al limite un #programma per creare grafici! Non un programma per creare banche dati!
1/2

#Excel ist auch das einzige mir bekannte Programm, dass per Autoformatierung aus

> 1-2

eine Datumsangabe baut:
> 01. Feb.

Da muss man dann >'1-2< eingeben, damit das nicht passiert. Ein mal mit Qualitäts-Software arbeiten, die bitte nicht mitdenkt - bzw. nicht zu viel...

love it when my #sigma #grindset leads me to #excel at #roguelike #deck #building #games. #galvanized #epic #fyp #ass #gravy #gravours #mastodev #foss #teeth the hottest tip is the nearest, as they say! #ὖWὖ

Ich habe gerade über den gem. Verein der Kinder eine Lehrerkollegin kennen gelernt. Informatik, Administratorin, sympathisch. Hessen, berufliches Gymnasium.

- sie verbindet gerade etliche private Schüler #iPads mit dem schulischen MDM und Classroom.

- alle Schüler melden sich an den Schul-PCs mit ihrem #Microsoft-Konto an.

- es gibt ein verpflichtendes #MS365 mit OneNote Kursbüchern.

- Nein, natürlich habe sie die AGB nicht gelesen. Und auch keine Vorgaben / Einschränkungen des Bildungsministeriums. Es sei ja doch erlaubt.

- ja, das sei ja schon "etwas bedenklich", aber es sei ja ein Schulbeschluss und ihr Chef habe das "von oben" für alle verpflichtend so angeordnet. Dafür sei es ja auch praktisch, einheitlich und Standard. Und #Word, #Excel, #Powerpoint stehe schließlich im Lehrplan.

"Mit Produktname und Herstellervorgabe?"

Nein, so direkt ja nicht. Aber was denn sonst?

Ich erzähle nur von meiner nicht vorhandenen freiwilligen Einwilligung.

Jetzt sitzt sie wo anders.

So have I got this right, #Microsoft - if I insert a link into an #Excel spreadsheet cell, then A. I can change the link target but there's no way of stripping the link & also B. even if I delete the contents of the cell entirely, anything I subsequently write in it will still be formatted like a hyperlink & if I don't want non-functional & nonsensical links in my file I have to manually remove the underline & change the text color...?

I swear, MS errors feel like trolling.

#Excel: Ganze Zeile färben, wenn in einer Zelle ein bestimmtes Wort steht - pctipp.ch https://www.pctipp.ch/praxis/office/excel-ganze-zeile-faerben-in-zelle-bestimmtes-wort-steht-2803397.html #MicrosoftExcel #LibreOffice #LibreOfficeCalc