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
Archive for the ‘Development’ Category
Hightlight active row/column in Excel without using VBA? – Stack Overflow
Posted by jpluimers on 2020/04/02
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: [WayBack] 10.6. Handling command-line arguments.
–jeroen
Share this:
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
Share this:
Posted in Delphi, Development, Software Development | Leave a Comment »
Forde’s Tenth Rule, or, “How I Learned to Stop Worrying and ❤ the State Machine”
Posted by jpluimers on 2020/04/01
It is important to look beyond your own comfort zone to see what other languages can support: [WayBack] Forde’s Tenth Rule, or, “How I Learned to Stop Worrying and ❤ the State Machine”.
The article is about implementing finite state machines in JavaScript with as little usage of string literals as possible.
Via: [WayBack] How I Learned to Stop Worrying and Love the State Machine – Adrian Marius Popa – Google+
–jeroen
Share this:
Posted in Development, JavaScript/ECMAScript, Scripting, Software Development | Leave a Comment »
Version Control in Visual Studio Code: view Git output window
Posted by jpluimers on 2020/03/31
Since the Git output by default is not shown, here is how to enable it:
[WayBack] Version Control in Visual Studio Code: Git output window
You can always peek under the hood to see the Git commands we are using. This is helpful if something strange is happening or if you are just curious. :)
To open the Git output window, run View > Output and select Git from the dropdown.
Or shorter on MacOS:
- Press
Cmd–Shift–P - Type
show git output - Press enter
–jeroen
Share this:
Posted in .NET, Development, DVCS - Distributed Version Control, git, Software Development, Source Code Management, Visual Studio and tools, vscode Visual Studio Code | Leave a Comment »
Excel formula: SUMIFS with multiple criteria and OR logic | Exceljet
Posted by jpluimers on 2020/03/31
As I need this one day:
To sum based on multiple criteria using OR logic, you can use the SUMIFS function with an array constant. In the example shown, the formula in H6 is:
Source: [WayBack] Excel formula: SUMIFS with multiple criteria and OR logic | Exceljet
–jeroen
Share this:
Posted in Development, Excel, Office, Office 2011 for Mac, Office 2013, Office 2016, Power User, Software Development | Leave a Comment »
Printing all DNS records using DNSPython in Python 3 · GitHub
Posted by jpluimers on 2020/03/31
Cool example, which requires dnspython and might need an update of the DNS record type list (maybe dnspython has that list built in?):
[WayBack] Printing all DNS records using DNSPython in Python 3 · GitHub
–jeroen
Share this:
Posted in Development, Python, Scripting, Software Development | Leave a Comment »
7 Practical Tips for Cheating at Design – Refactoring UI – Medium
Posted by jpluimers on 2020/03/30
Improving your designs with tactics instead of talent: weight and colour. But be careful with the variation in meanings of colours for different cultures and mind about colour-blind people. Also ensure information workers can optimise your UI for information density.
Source: [WayBack] 7 Practical Tips for Cheating at Design – Refactoring UI – Medium
Via: [WayBack] 7 Practical Tips for Cheating at Design #webdev – ThisIsWhyICode – Google+
–jeroen
Share this:
Posted in Usability, User Experience (ux) | Leave a Comment »
ODCB settings in the Windows registry on 32 and 64 bit windows
Posted by jpluimers on 2020/03/27
- While 32-bit applications can run on 64-bit machines, they cannot use 64-bit ODBC drivers. A 64-bit application must use a 64-bit ODBC driver, and a 32-bit application must use a 32-bit ODBC driver.
- ODBC.INI registry paths for the various permutations:
- User DSNs for for 64-bit and 32-bit applications
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI
- System DSNs for 64-bit applications on 64-bit Windows and 32-bit applications on 32-bit Windows
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
- System DSNs for 32-bit applications on 64-bit Windows
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBC.INI
- User DSNs for for 64-bit and 32-bit applications
Via: [WayBack] Windows registry on 32 and 64 bit windows, which also explains ODBCINST.INI to define drivers.
–jeroen
Share this:
Posted in Database Development, Development, ODBC, Power User, Windows | Leave a Comment »
MacOS: starting Visual Studio Code from the finder
Posted by jpluimers on 2020/03/26
On MacOS, a long standing wish from many developers has been to open a folder with Visual Studio Code: [WayBack] Mac OS X :: “Open Folder With” VS Code · Issue #1223 · Microsoft/vscode · GitHub.
There are many reasons for wanting this, and other tools can do this too (like Terminal, TextWrangler, Source Tree, Beyond Compare), so I was a bit surprised Visual Studio Code does not have it by default.
After initially being closed, the issue has been open for a while, so I started digging a bit for solutions that are easy to configure or install.
- Based on Automator:
- [WayBack] Add a command to Finder services in Mac OSX to open a folder in VS Code · GitHub
- [WayBack] Create Customize Shortcut in Mac’s Right Click Menu [Guide] – Hongkiat
- [WayBack] Open folder in Visual Studio Code from the Finder
- [WayBack] macos – OSX: how to add a right click option in folder to open the folder with an application like VS Code? – Ask Different
- Based on AppleScript: [WayBack] GitHub – hamxiaoz/open-folder-with-vs-code: A Finder toolbar icon to open current selected file/folder with Visual Studio Code
- Objective C (based on the .m file extension) [WayBack] GitHub – sozercan/OpenInCode: macOS Finder toolbar app to open current folder in Visual Studio Code
The last one is currently on the top of my list, so I copied and installation instructions, and added a few screenshots to explain the already included video below.
Share this:
Posted in .NET, Development, Software Development, Visual Studio and tools, vscode Visual Studio Code | Leave a Comment »
The Wiert Corner - irregular stream of stuff 