The Wiert Corner – irregular stream of stuff

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

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

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

    Join 1,835 other subscribers

Archive for the ‘Development’ Category

Return empty cell from formula in Excel – Stack Overflow

Posted by jpluimers on 2019/11/19

I never thought you could do it, but you can: [Archive.isReturn empty cell from formula in Excel – Stack Overflow.

You have to crate:

  • a VBA function
  • a reference to a range that evaluates the function so it returns blank
  • a cell with a function that blanks the cell using the range

Convoluted, but clever!

–jeroen

 

Posted in Development, Excel, Office, Office VBA, Power User, Software Development | Leave a Comment »

Angle brackets in markdowndown needs to be escaped

Posted by jpluimers on 2019/11/19

A few days after filing <path> disappears from "Preview" rendering and also from actual rendering (at least in issues), I realised that this is by intent: Markdown allows to [WayBack] inline html which means that code like below will be all treated as such:

<path>

> <path>

*<path>*

**<path>**

> *<path>*

> **<path>**

The solution is to either escape or quote with back-ticks:

`<path>`

> `<path>`

*`<path>`*

**`<path>`**

> *`<path>`*

> **`<path>`**

Since WordPress also is based on pseudo-HTML codes, it too needs escaping.
–jeroen

 

Posted in Development, Lightweight markup language, MarkDown, Power User, Software Development | Leave a Comment »

ÜberPDF printing using a Delphi like canvas

Posted by jpluimers on 2019/11/15

For my link archive, as it has a lot of goodies in the comments, especially on how to avoid bitmaps in PDF emission: [WayBack] We took PDF to a whole new level today Load create, or editing a PDF in 2 lines of code using a simple Delphi (like) Canvas! We added a PDFPrinter and… – Joe C. Hecht – Google+

–jeroen

Posted in Delphi, Development, EPS/PostScript, PDF, Software Development | Leave a Comment »

SQL Server Downloads | Microsoft

Posted by jpluimers on 2019/11/14

[WayBack] SQL Server Downloads | Microsoft

Get started with Microsoft SQL Server downloads. Choose a SQL Server trial, edition, tool, or connector that best meets your data and workload needs.

Downloading offline installers is the same for both: run the .EXE, then choose to download off-line media.

This is much easier than subscribing to Visual Studio Dev Essentials below.

Then depending on the edition, make the choice:

Read the rest of this entry »

Posted in Database Development, Development, Software Development, SQL Server | Leave a Comment »

Great Innovators Start with Customer Struggles (Not Customer Needs)

Posted by jpluimers on 2019/11/14

Two very important quotes of a must-read article (reading of it takes ~5 minutes):

  • Teams create the most value for customers when they know the difference between customer needs and struggles
  • If we align our mental model to needs, we are missing opportunities to solve the underlying struggles in innovative ways.

Source: [Archive.isGreat Innovators Start with Customer Struggles (Not Customer Needs)

Via: [WayBack] Talking in terms of what customers need, limits options. Great Innovators Start with Customer Struggles (Not Customer Needs) – Marjan Venema – Google+

–jeroen

Read the rest of this entry »

Posted in Agile, Development, Software Development | Leave a Comment »

TTreeView: when HideSelection=True, use SetFocus() to update the current Selected state

Posted by jpluimers on 2019/11/14

Reminder to self: corner case, but sometimes useful. [WayBack] EDIT: Answered. The TTreeView.HideSelection was set to TRUE, so you needed TTreeView.SetFocus() to reflect in the UI the current state of TTreeView.sele… – Vin Colgin – Google+

–jeroen

Posted in Delphi, Development, Software Development | Leave a Comment »

Links to alternatives for Delphi REST clients

Posted by jpluimers on 2019/11/13

A few good links to a few alternatives for the built in Delphi REST client [WayBack] Hi looking for good and complete tutorial/course how to create RESTFul services with Delphi. Or if anyone use Delphi for creating RESTFul services feedb… – Gordan Paunovic – Google+

–jeroen

Posted in Communications Development, Delphi, Development, HTTP, Internet protocol suite, JSON, REST, Software Development, TCP | Leave a Comment »

MeanWell Mini Switching Power Supplies May Be Useful for Development Boards

Posted by jpluimers on 2019/11/13

Great power supplies that provide a very stable power source and are adjustable too: [WayBackMeanWell Mini Switching Power Supplies May Be Useful for Development Boards

Via: [WayBack] Tiny Meanwell switch mode power supplies that should provide a good (i.e. reliable) power source for development boards. https://www.cnx-software.com/2… – Jean-Luc Aufranc – Google+

–jeroen

Posted in Development, Hardware Development | 1 Comment »

A multi index container: TIndexedStore – Martin C Harvey’s Software Pages

Posted by jpluimers on 2019/11/13

For single-indexed containers, you can use a generic TDictionary, for instance one of these:

Reminder to self: check out if there is a generic version of [WayBackA multi index container: TIndexedStore – Martin C Harvey’s Software Pages anywhere.

Edit 20191220 (thanks Thaddy!) article moved to [WayBack] A multi index container: TIndexedStore – Martin C Harvey’s Pages.

For instance as part of:

The original library has source code in a [WayBack] zip file.

Edit 20191220 (thanks Thaddy!) download moved to [WayBack] IndexedStore.zip.

I got there via:

–jeroen

Posted in Delphi, Development, Software Development | 5 Comments »

Links to debugging COM stuff for Office Automation in Delphi

Posted by jpluimers on 2019/11/12

From a long time ago, but recently I needed them again.

Note the .NET side is much much harder Revisited from the .NET side: Why doesn’t WINWORD.EXE quit after Closing the document from Delphi? (via: Stack Overflow).

[WayBack] Why doesn’t WINWORD.EXE quit after Closing the document from Delphi? – Stack Overflow

Read the rest of this entry »

Posted in Delphi, Development, Office Automation, Software Development | 2 Comments »