Archive for the ‘Office’ Category
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 »
Posted in Excel, Office, Power Point, Power User, Visio, Word | Leave a Comment »
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 .venv |
py -m venv .venv |
Only needed once |
| 2. |
source .venv/bin/activate |
.venv\Scripts\activate |
Switch to virtual environment |
| 3. |
which python |
where python |
Check if python is used from the virtual environment (should result in
.venv/bin/python on *n*x/MacOS or
.venv\Scripts\python on Windows) |
| 4. |
which pip |
where pip |
Check if pip is used from the virtual environment (should result in
.venv/bin/pip on *n*x/MacOS or
.venv\Scripts\pip on Windows) |
| 5. |
./.venv/bin/pptx2md</precode
|
.venv\bin\pptx2md |
Force a module which didn’t add itself to the path when installed via pip |
| 6. |
deactivate |
deactivate |
Leave the virtual environment |
- missed during
pip install pptx2md (in order I discovered them):
Future enhancements
Read the rest of this entry »
Posted in Development, Lightweight markup language, MarkDown, Office, Power Point, Power User, Python, Scripting, Software Development, venv | Leave a Comment »
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:
- PDF (.pdf)
- PowerPoint (.pptx)
- Word (.docx)
- Excel (.xlsx)
- Images (EXIF metadata, and OCR)
- Audio (EXIF metadata, and speech transcription)
- HTML (special handling of Wikipedia, etc.)
- Various other text-based formats (csv, json, xml, etc.)
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:
Read the rest of this entry »
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 »
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:
Read the rest of this entry »
Posted in Development, Excel, HTML, Office, Power User, Software Development, Web Development | 2 Comments »
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
Read the rest of this entry »
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 »
Posted by jpluimers on 2024/06/12
Posted in AI and ML; Artificial Intelligence & Machine Learning, Development, Excel, LLM, Office, Power User, Software Development | Comments Off on GitHub – dabochen/spreadsheet-is-all-you-need: A nanoGPT pipeline packed in a spreadsheet
Posted by jpluimers on 2024/05/13
I tried archiving the page 210mm x 99mm Blank Label Template – Microsoft Word – EU30032 and the template http://templates.uk.onlinelabels.com/TemplateFile/eu30032-template/EU30032.doc, but that fails because that site refuses to be archived in the WayBack machine and Archive.is.
So here is a local copy of [WayBack] eu30032.doc.
Related (not tried yet):
- [WayBack] Labels A4, 210 x 99 mm, white, permanent adhesion
| Ref. no. |
4664 |
| Format |
210 x 99 mm |
| Content |
300 labels / 100 sheets |
| Colour |
white |
| Printer type |
Laser, Copy, Ink |
| Adhesive characteristics |
permanent |
| Shape of corners |
square |
| Material |
paper, matt |
| Environment |
PEFC-certified |
| EAN |
4008705046640 |
| PEFC certificate |
[WayBack] Download now |
| Printing template / Processing information |
[WayBack] Download now |
- [WayBack] Printing Template for Labels – 210 mm x 99 mm – 3 Rectangle Labels per A4 Sheet (Word/PDF) | Template For Labels
|
|
There are 3 Rectangle Labels per page with each label being 210 mm wide and 99 mm high.There is a 0 mm gap between the label rows and 0 mm gap between the label columns to determine whether you can create your design with bleed or not. Whilst producing the design, due to printing restrictions on digital presses, you must consider that there is a 0 mm margin on both top and bottom of the sheet, and 0 mm margin on left and right hand side of the sheet.
Please read your printer manual carefully as each printer has a printing tolerance of up to 2 mm. You must accommodate this tolerance by producing your design with enough bleed and/or leave enough gap between the label contents and the label cut line. |
–jeroen
Posted in LifeHacker, Office, Power User, Word | Leave a Comment »
Word Template
PDF Template
The Wiert Corner - irregular stream of stuff 