Every now and then, documentation in source code requires an ASCII table. Sometimes table cells are spanning multiple rows or/and column.
TL;DR: The tools I tried did not support that, so manual labour is still needed.
Archive for the ‘Office’ Category
Generating ASCII-tables with spanning cells: manual labour still needed
Posted by jpluimers on 2026/05/28
Posted in ASCII, ASCII art / AsciiArt, Development, Documentation Development, Encoding, Excel, Fun, HTML, Office, Power User, Software Development, Web Development | Tagged: 2 | Leave a Comment »
Updating Microsoft Office on Windows from a batch file
Posted by jpluimers on 2026/04/21
This batch file works for modern Click-to-Run (sometimes called ClickToRun, Click2Run or C2R) based Office installations (note the odd lowercase microsoft shared which indeed is the actual directory name):
if exist "%CommonProgramFiles%\microsoft shared\ClickToRun\OfficeC2RClient.exe" ( "%CommonProgramFiles%\microsoft shared\ClickToRun\OfficeC2RClient.exe" /update user ) else ( echo could not find the Office Updater )
This for sure does not work for MSI based Office 2013 and lower (which are updated through Windows Update anyway). Since I only have 2021 online (Click-to-Run) installs and higher to test with: those work fine.
Share this:
Posted in Batch-Files, Development, Office, Office 2021, Office Development, Power User, Scripting, Software Development, Windows, Windows Development | Leave a Comment »
Google Sheets actually has a ton of Excel compatible functions; wish the User Experience was better though
Posted by jpluimers on 2026/04/14
I have been using Microsoft Excel since it beat the Quattro Pro limitation of rows and columns with the version 12.0, on Windows more commonly named Excel 2007 (which also introduced a fully new user experience including the vertical screen estate eating Ribbon – the main reason I like 16:10 monitors over 16:9 ones) and on Mac as Excel 2008.
It means I have like 20 years of Excel experience not just on what it can technically can do (see my Excel posts) but especially on the user experience bit.
Share this:
Posted in Development, Excel, Google, GoogleDocs, GoogleSheets, Office, Office 2007, Power User, Software Development, User Experience (ux) | Tagged: div | Leave a Comment »
Only available on Window, but sometimes useful, the Excel FILTERXML function
Posted by jpluimers on 2026/04/09
Some links on the [Wayback/Archive] FILTERXML function – Microsoft Support.
It is only available on Windows (because of the underlying XPath libraries used, I think it is MSXML), and “only” as of Excel 2013, but still can be useful.
Some links below on FILTERXML and related XPath information so I can more easily find their content back.
Notes:
FILTERXMLonly supports XPath 1.0- The quotes are huge, for one because I don’t use Excel enough to be an expert, but have enough software experience to sometimes want to use complex concepts in Excel. Having all this in one place helps me with that goal.
- You need to ensure your data is either XML in a well-formed document format, or you can translate your data to well-formed XML.
The links and quotes starting with the question that sparked my interest:
Share this:
Posted in Development, Excel, Office, Office 2013, Office 2016, Office VBA, Power User, Scripting, Software Development, Windows, XML, XML/XSD, XPath | Leave a Comment »
keyboard – Shortcut to apply header style 4 (and 5, 6…) – Ask Different
Posted by jpluimers on 2026/04/03
[Wayback/Archive] keyboard – Shortcut to apply header style 4 (and 5, 6…) – Ask Different (thanks [Wayback/Archive] bouke!):
Found it, although I did not expect the solution to be this simple. To do this, follow these steps:
- Right-click the Heading 4 style in the ribbon and choose ‘Modify’ (Or through Layout > Styles > Heading 4 > Modify
- In the left hand bottom corner, select ‘Shortcut’
- Assign shortcut ⌘⌥4
- Repeat for Heading 5, 6…
- Done!
Query: [Wayback/Archive] macos microsoft word shortcut for heading levels – Google Suche
More: [Wayback/Archive] Keyboard shortcuts in Word – Microsoft Support: MacOS
--jeroen
Share this:
Posted in Apple, Mac OS X / OS X / MacOS, Office, Office 2021, Power User | Leave a Comment »
Excel: operations involving the last occurence of a substring (with examples getting the current Worksheet, Workbook and file/directory path)
Posted by jpluimers on 2026/04/02
Last month I wrote about CELL function looks interesting but beware: language nightmares coming up….
There I mentioned both formulas from [Wayback/Archive] Get sheet name only – Excel formula | Exceljet and [Wayback/Archive] Insert the current Excel file name, path, or worksheet in a cell – Microsoft Support failing to deliver the expected results
an official Microsoft example of obtaining the Worksheet name which I suspected would not work on systems allowing ] in path names. And indeed it is true: that case fails on both MacOS and Windows in the same way.
Here you see the failures of both the ExcelJet function and the ones from Microsoft Support on two operating systems:
Share this:
Posted in Conference Topics, Conferences, Development, Event, Excel, Office, Power User, Scripting, SocialMedia, Software Development, Twitter | Leave a Comment »
CELL function looks interesting but beware: language nightmares coming up…
Posted by jpluimers on 2026/03/26
A while ago I bumped into a very promising [Wayback/Archive] CELL function – Microsoft Support which exposes all sorts of interesting information on an Excel WorkSheet cell including address and filename.
But then this “disclaimer” threw me off:
Note: Formulas that use CELL have language-specific argument values and will return errors if calculated using a different language version of Excel. For example, if you create a formula containing CELL while using the Czech version of Excel, that formula will return an error if the workbook is opened using the French version. If it is important for others to open your workbook using different language versions of Excel, consider either using alternative functions or allowing others to save local copies in which they revise the CELL arguments to match their language.
It means the CELL function is only useful if the spreadsheet containing it will only ever be used in a single language: say goodbye to portability.
That’s a real bummer as it would have simplified formulas like =ADDRESS(ROW(E7), COLUMN(E7)) into =CELL("address", E7) both resulting $E$7.
The big problem is that “consider either using alternative functions” is hardly possible as many of the functions have no alternative, for instance using the CELL function is the only way to get the name of the current worksheet (prepended by the filename) as =CELL("filename") returns Macintosh HD:Users:jeroenp:Downloads:[Workbook1.xlsx]Sheet1.
Note however:
Filename (including full path) of the file that contains reference, as text. Returns empty text (“”) if the worksheet that contains reference has not yet been saved.
The basic syntax of it is CELL(info_type, [reference]), where info_type and some of the return values being language dependent:
Share this:
Posted in Development, Excel, Office, Office Development, Power User, Software Development | Leave a Comment »
It might be time for me to upgrade to a newer Excel version because of some new notation and functions like TAKE and TRIMRANGE, or does it?
Posted by jpluimers on 2026/03/23
Over the last decades, I hardly needed to upgrade Excel. For a very long time I stayed at Excel 2003, as the ribbon interface introduced with Office 2007 (version 12) was horrible (it still is, especially since 19:10 monitors are gone and the ribbon takes too much vertical screen estate).
After that, I needed newer features so I upgraded to Excel 2013 (version 15) mainly because it ditched Multiple-document interface (MDI) and I like SDI over MDI a lot, and Office 2013 was largely compatible with Office for Mac 2011 (version 14).
Mostly recovered from my cancer treatments, I noticed that MacOS ditched 32-bit support in MacOS 11 Big Sur, which meant I could not use Office 2011 any more (it was 32-bit x86 only) so in 2022 I upgraded all my office installations to Office 2021 (up in the version 16.* range as starting with Office 2016 the major version number stayed 16.minor).
I might actually upgrade to Office 2024 (version 16.many) soon despite the major version 16, finally Excel has started sped up new development of new functions and features, of which the ones below are very interesting: they will make my largest spreadsheets a lot simpler and therefore easier to maintain:
Share this:
Posted in Excel, Office, Office 2003, Office 2011 for Mac, Office 2013, Office 2021, Power User | Leave a Comment »
WinWorld: Microsoft Office 95
Posted by jpluimers on 2025/10/29
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:
Share this:
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 »
The Wiert Corner - irregular stream of stuff 