The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

    Mastodon

  • Twitter Updates

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,854 other subscribers

Archive for April 2nd, 2026

On our list of places to visit: ICC Berlin

Posted by jpluimers on 2026/04/02

This is definitely on our list to visit, despite it being permanently closed: [Wayback/Archive] ICC Berlin (de) / [Wayback/Archive] ICC Berlin (en).

Wikipedia pages:

Last year, it was open during the [Wayback/Archive] Day of the Open Monument | visitBerlin.de (the German term is Tag des offenen Denkmals “seit 1993 am zweiten Sonntag im September”).

Just like the celebration of the Mauerfall gained popularity¹, the ICC Berlin has regained popularitly, hopefully later this year, a decision will be made if/how it will be repurposed, as well as the status of the asbestos. There seems to be enough potential:

Read the rest of this entry »

Posted in Uncategorized | Tagged: , | 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:

Read the rest of this entry »

Posted in Conference Topics, Conferences, Development, Event, Excel, Office, Power User, Scripting, SocialMedia, Software Development, Twitter | Leave a Comment »