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 4,262 other subscribers

Archive for April 2nd, 2020

Hightlight active row/column in Excel without using VBA? – Stack Overflow

Posted by jpluimers on 2020/04/02

According to [WayBack] Hightlight active row/column in Excel without using VBA? – Stack Overflow: no, but you do not need much code.

On my list of things to try is to combine both answers there into one.

–jeroen

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

For my link archive: Python – Handling command-line arguments

Posted by jpluimers on 2020/04/02

The article is dense but goes way deeper than straightforward sys.argv[1:] handling: [WayBack10.6. Handling command-line arguments.

–jeroen

Posted in Development, Python, Scripting, Software Development | Leave a Comment »

Cool Delphi IDE idea: when moving a project, not just adjust absolute file paths but also search paths

Posted by jpluimers on 2020/04/02

The IDE already owns and modifies your .dproj and .dpr files (of which many users complain, but I think it is a good thing), so this is a great suggestion: [WayBack] Possibly slightly obvious but nonetheless a minor little tip to bear in mind when moving a project (.dproj/.dpr) by saving it to a new location (which I… – Walter Prins – Google+

Possibly slightly obvious but nonetheless a minor little tip to bear in mind when moving a project (.dproj/.dpr) by saving it to a new location (which I encountered this morning):

While the IDE will automatically adjust form/pas file paths for files included in the project in the .dpr for you, what it will not however do is also adjust the project “Search path” in a similar fashion, even though moving the project is guaranteed to break the project if it has project relative search paths and hence they would require adjusting.

That is to say, if you have project relative search folders specified in the “Search path” (and indeed the output folders), you will need to manually go and edit these paths in the project by hand when you change the project’s location.

(I’d argue that the IDE ought to update relative paths in the project options automatically given that it does so already for the .dpr; it would be the intuitive and graceful thing to do.)

–jeroen

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