Just in case I ever need it for historic reasons:
[Wayback/Archive] WinWorld: Microsoft Office 95
Because back in the days various Office products had localised VBA (at least German and French products had; I’m not sure about other languages)
Via:
Archive for the ‘Office’ Category
WinWorld: Microsoft Office 95
Posted by jpluimers on 2025/10/29
Posted in Delphi, Development, History, LifeHacker, Office, Office 95, Office Automation, Office Development, Power User, Software Development, Windows, Windows 95 | Leave a Comment »
Excel: sorting an array on 3 different columns using functions
Posted by jpluimers on 2025/09/09
Given Excel is the most popular functional language (see the video under my post “Everybody should have an obsession with Lisp-like language at least once in their life” @KevlinHenney), this post is on sorting with Excel functions.
I had an array in Excel starting at row 2 (to exclude the headings) where I had to sort on 3 different columns: C, A, B (or numerically 3, 1, 2) so [Wayback/Archive] sorting – How to multi level sort an array in excel, using formulas? I am aware about the way, using SORT button on DATA tab – Stack Overflow (thanks [Wayback/Archive] Armaan Gohil and [Wayback/Archive] Jos Woolley) didn’t fully apply but did put me on the right track as I wasn’t aware that the SORT function allows to specify multiple columns using an embedded array argument.
The functions that worked:
Share this:
Posted in Development, Excel, Functional Programming, Office, Power User, Reddit, SocialMedia, Software Development | Tagged: VALUE | Leave a Comment »
Belastingaangifte 2024 met Excel gratis downloaden | Computer Idee
Posted by jpluimers on 2025/08/30
Let op:
- deze Excel spreadsheets werken alleen correct op Windows en Engelse of Nederlandse taal-/regioinstellingen. Op MacOS en OpenOffice kan het zijn dat ze niet behoorlijk werken
- inloggen op Mijn Belastingdienst vandaag lukt vaak niet of is heel traag en dan kom je uit op [Wayback/Archive] U kunt nu niet inloggen op Mijn Belastingdienst
Mijn Belastingdienst is tijdelijk niet bereikbaar. Dit komt doordat het maximale aantal mensen is ingelogd. Wij vragen u om later terug te komen. Onze excuses voor het ongemak.
of daar na inlogpoging met de melding:
Er is een technische fout opgetreden. U bent automatisch uitgelogd.
Probeer later nog een keer in te loggen. Of bel de Belastingtelefoon 0800 – 0543.Neemt u contact op met de Belastingdienst over deze foutmelding? De volgende gegevens kunnen helpen bij het opsporen van de oorzaak:
- Foutcode: 96762438
- Tijdstip van melding: 30 augustus 2025 om 14:32
[Wayback/Archive] 483877656-3984fa77-7838-4c92-ae50-fa530cf77255.png (1070×224)
of na inloggen deze melding:
Let op!
Probleem Mijn Belastingdienst
Door een technische storing gaat het inzenden van aangiftes niet altijd goed. Bij het inzenden kan er een technische fout optreden. We werken aan een oplossing. Excuses voor het ongemak.[Wayback/Archive] 483878240-0c9e5c63-98aa-4d19-bde1-f53a56f082a3.png (810×111)
Met dank aan het commentaar van Leon onder mijn blog-post Belastingaangifte 2023 met Excel gratis downloaden | Computer Idee is hier op de valreep de versie voor aangifte 2024:
Share this:
Posted in Development, Excel, HTML, Office, Power User, Software Development, Web Development | Leave a Comment »
Office suites trick I was unaware off: you can use images as background of shapes, then distort by moving the corner points
Posted by jpluimers on 2025/05/26
Video thumbnail
The below example is in Excel, but it holds for many other drawing tools in other office suites as well (like the ones in OpenOffice and successors like LibreOffice, Apple Pages in iWork, and others from the list of office suites):
- Insert a shape
- Move the corners so it covers the area you want a screenshot in
- Modify the shape background to contain the screenshot as background
(you can exchange steps 2 and 3 if you wish, and even go for more complex shapes – including ones where you can add corner points – to better fit the area where you want the distorted screenshot to appear).
Example in (typo was indeed in the tweet) [Wayback/Archive] Excel Dictionary on X: “Are you ready for this Excel tip? Get ready to learn how to easily scew images. 🤯”: Read the rest of this entry »
Share this:
Posted in Excel, Office, Power Point, Power User, Visio, Word | Leave a Comment »
Person 1: The glass is 1/2 full; Person 2: The glass is 1/2 empty; Excel: …
Posted by jpluimers on 2025/03/24
Why everyone hates Excel data entry:
[Archive.is] Andrew R on Twitter: “Person 1: The glass is 1/2 full Person 2: The glass is 1/2 empty Excel: The glass is the 1st of February”
--jeroen
Share this:
Posted in Excel, Office, Power User | Leave a Comment »
Converting Power Point
Posted by jpluimers on 2025/01/15
I have a lot of old Power Point slide decks that I want to reuse in current presentations. By now however, I learned prepare all my presentation stuff in either Markdown or reStructuredText: far easier to publish and put under version control.
After searching, I could only find one tool that is still maintained doing a decent job doing a PowerPoint to Markdown conversion: [Wayback/Archive] GitHub – ssine/pptx2md: a pptx to markdown converter. The tools which works great, in big part of PowerPoint content being highly structured with styles like title, subtitle and various heading levels and content types.
The thing it does not document is the prerequisites, which are these:
- a
venv(which, despite having used Python quite often, but not proficient in it, still makes me nervous: one forgotten step and you pip everything in your global environment).This links helps me every time [Wayback/Archive] Install packages in a virtual environment using pip and venv – Python Packaging User Guide. From it, I created this little table:
Steps for setting up and using a Python virtual environment Step *n*x/MacOS Windows Comment 1. python3 -m venv .venvpy -m venv .venvOnly needed once 2. source .venv/bin/activate.venv\Scripts\activateSwitch to virtual environment 3. which pythonwhere pythonCheck if python is used from the virtual environment (should result in
.venv/bin/pythonon *n*x/MacOS or
.venv\Scripts\pythonon Windows)4. which pipwhere pipCheck if pip is used from the virtual environment (should result in
.venv/bin/pipon *n*x/MacOS or
.venv\Scripts\pipon Windows)5. ./.venv/bin/pptx2md</precode
.venv\bin\pptx2mdForce a module which didn’t add itself to the path when installed via pip 6. deactivatedeactivateLeave the virtual environment - missed during
pip install pptx2md(in order I discovered them):- [Wayback/Archive] numpy · PyPI: used by [Wayback/Archive] pptx2md/pptx2md/parser.py at master · ssine/pptx2md · GitHub
pip install numpy
- [Wayback/Archive] matplotlib · PyPI: used by [Wayback/Archive] pptx2md/pptx2md/columns.py at master · ssine/pptx2md · GitHub
pip install matplotlib
- [Wayback/Archive] scipy · PyPI: used by [Wayback/Archive] pptx2md/pptx2md/utils_optim.py at master · ssine/pptx2md · GitHub
pip install scipy
- [Wayback/Archive] Wand · PyPI: used by [Wayback/Archive] pptx2md/pptx2md/image.py at master · ssine/pptx2md · GitHub and also by [Wayback/Archive] pptx2md/pptx2md/parser.py at master · ssine/pptx2md · GitHub
pip install wand
- Putting the tool in the path; I had to execute it using
./.venv/bin/pptx2md
- [Wayback/Archive] numpy · PyPI: used by [Wayback/Archive] pptx2md/pptx2md/parser.py at master · ssine/pptx2md · GitHub
Future enhancements
Share this:
Posted in Development, Lightweight markup language, MarkDown, Office, Power Point, Power User, Python, Scripting, Software Development, venv | Leave a Comment »
Markdown has been the Internet’s lingua franca for documentation. Microsoft finally the documentation format with markitdown: Python tool for converting files and office documents to Markdown.
Posted by jpluimers on 2024/12/17
Finally an easier way to convert Office documents (and other formats) to markdown: [Wayback/Archive] GitHub – microsoft/markitdown: Python tool for converting files and office documents to Markdown. (after Google added a Markdown export feature to Google Docs about half a year ago, and basic Markdown formatting about 2 years ago – see below):
There are quite a few dependencies in [Wayback/Archive] markitdown/pyproject.toml at main · microsoft/markitdown · GitHub, so be prepared for that.
Supported formats (added links for clarity):
The MarkItDown library is a utility tool for converting various files to Markdown (e.g., for indexing, text analysis, etc.)It presently supports:
Google was first though:
- [Wayback/Archive] Google Workspace Updates: Compose with Markdown in Google Docs on web
- [Wayback/Archive] Google Workspace Updates: Import and export Markdown in Google Docs
There is speculation on why Microsoft introduced it just now ranging from “they need it for AI training” to “just late to the game”. I’m with the latter. Apple is even later, so if you want to convert Apple Notes to markdown, then you can use [Wayback/Archive] Import from Apple Notes – Obsidian Help.
Via various sources, including:
Share this:
Posted in CSV, Development, Excel, HTML, HTML5, JSON, Lightweight markup language, MarkDown, Office, PDF, Power Point, Power User, Software Development, Word, XML/XSD | Tagged: MarkDown, Python | Leave a Comment »
Attempting to stop Microsoft users sending ‘reactions’ to email from me by adding a postfix header
Posted by jpluimers on 2024/09/27
If you do not want Outlook kinds of clients spamming you, then add this header to your email messages above the Content-Type header (see [Wayback/Archive] The Message Content-Type in MIME)
x-ms-reactions: disallow
[Wayback/Archive] Attempting to stop Microsoft users sending ‘reactions’ to email from me by adding a postfix header
Via [Wayback/Archive] Kris: “x-ms-reactions: disallow http…” – chaos.social
x-ms-reactions: disallowEine kleine Mailserver Config verhindert, daß Outlook Volldeppen meine Mailbox mit Likes spammen.
Sehr gut.
--jeroen
Share this:
Posted in *nix, *nix-tools, Communications Development, Development, Internet protocol suite, Office, Outlook, postfix, Power User, SMTP | Leave a Comment »
Belastingaangifte 2023 met Excel gratis downloaden | Computer Idee
Posted by jpluimers on 2024/08/27
Dit jaar was ik er een paar dagen eerder bij dan vorig jaar: meer rust in mijn hoofd na de verhuizing en een betere planning gemaakt rondom de paardrijvakantie van mijn verstandelijk beperkte broer (waar we altijd zorgen daar in de buurt te zijn zodat we indien nodig snel ter plaatse kunnen handelen).
Waarom is deze blog post zo laat?
Het laat heeft er vooral mee te maken dat deze Excel sheet meestal nog een aantal wijzigingen krijgt na de normale deadline van 1 mei. Dus ik begin pas met downloaden de maand voor de echt harde deadline van 1 september.
Waarom dan toch nu de post?
Eigenlijk is dat heel simpel: vooral zodat je kunt zien hoe je aan deze informatie komt ook al wijzigen de locaties: waar vorig jaar het Excel-bestand voor de belastingaangifte nog bij Google stond, staat het deze keer bij WeTransfer.
Dit jaar zijn de linkjes her en der dus behoorlijk anders: meer dan een simpele vervanging van 2022 door 2023 in de start-link van de eerste Google Search onderaan mijn blog-post.
Let ook op (dit vergat ik vorig jaar te vermelden): dit Excel bestand werkt bij mij niet op Office voor MacOS.
Omdat Computer Idee meestal geen jaartallen in de titels van hun artikelen gebruikt, moet je handmatig de zoekresultaten van Google Search door om te zien welke relevant voor aangifte over afgelopen jaar (in dit geval 2023) is/zijn. Vandaar dat ik hieronder op een aantal plekken jaartellen heb toegevoegd:
Share this:
Posted in Development, Excel, HTML, Office, Power User, Software Development, Web Development | 2 Comments »
CrazyMyra: “After AI took his job as an online assistant, Mr Clippy was obliged to seek work in other sectors…” – beige.party
Posted by jpluimers on 2024/07/30
I love the new title-text for the 2018 “Clippy” picture at [Wayback/Archive] CrazyMyra: “After AI took his job as an online assistant, Mr Clippy was obliged to seek work in other sectors…” – beige.party
A metal toilet paper holder in a corner od a bathro,with an empty roll, that looks similar to a large paperclip
Share this:
Posted in AI and ML; Artificial Intelligence & Machine Learning, Conference Topics, Conferences, Development, Event, Fun, History, JavaScript/ECMAScript, LifeHacker, LLM, Meme, Office, Power User, Scripting, Software Development, Web Development, Windows | Leave a Comment »
The Wiert Corner - irregular stream of stuff 