On my research list for Visual Studio 2017 and up: [WayBack] How to Integrate ILMerge into Visual Studio Build Process to Merge Assemblies? – Stack Overflow
–jeroen
Archive for the ‘Software Development’ Category
How to Integrate ILMerge into Visual Studio Build Process to Merge Assemblies? – Stack Overflow
Posted by jpluimers on 2020/03/19
Posted in .NET, Development, Software Development, Visual Studio and tools | Leave a Comment »
Why should I hire a software engineer if I can just copy and paste code from Stack Overflow?
Posted by jpluimers on 2020/03/19
Via [WayBack] Your cut and paste skills are in demand ##IL – Christoph Puppe – Google+:
- Answer:[Archive.is] Jessica Su’s answer “It’s still worth the money. The breakdown is: 1. Copying code from StackOverflow: $1; 2. Knowing which code to copy from StackOverflow: $100000/year”
- Question: [Archive.is] Why should I hire a software engineer if I can just copy and paste code from Stack Overflow? – Quora
–jeroen
Share this:
Posted in Development, Pingback, Software Development, Stackoverflow | Leave a Comment »
Display the relationships between formulas and cells – Excel
Posted by jpluimers on 2020/03/18
The “Formulas” tab has to buttons that help to Display the relationships between formulas and cells – Excel [WayBack]:
- Precedent cells — cells that are referred to by a formula in another cell. For example, if cell D10 contains the formula =B5, then cell B5 is a precedent to cell D10.
- Dependent cells — these cells contain formulas that refer to other cells. For example, if cell D10 contains the formula =B5, cell D10 is a dependent of cell B5.
To assist you in checking your formulas, you can use the Trace Precedents and Trace Dependentscommands to graphically display and trace the relationships between these cells and formulas with tracer arrows, as shown in this figure.
Related:
- [WayBack] vba – Is there a way to tell which cells reference a selected cell in Excel? – Super User
- [WayBack] Macro Code To Trace Dependents/Precedents – Free Excel\VBA Help Forum
- [WayBack] Solved: Splitting all addresses in a formula – Page 2
- [WayBack] Tracing Cell Precedents in VBA (Finding formulae t – Free Excel\VBA Help Forum
–jeroen
Share this:
Posted in Development, Excel, Office, Power User, Software Development | Leave a Comment »
The Delphi Geek: Data-driven Multithreading
Posted by jpluimers on 2020/03/18
Still on my reading list because it is relevant to many programming environments: [WayBack] The Delphi Geek: Data-driven Multithreading.
Related:
- [WayBack] Lockless Multi-Threading in Delphi – Chapman World
- [WayBack] julian m bucknall >> Tomes of Delphi: Algorithms and Data Structures
- [WayBack1/WayBack2] Communicating with TThread with standard Delphi RTL. – Primož Gabrijelčič – Google+
–jeroen
Share this:
Posted in Delphi, Development, Software Development | Leave a Comment »
Nick Craver – Stack Overflow: How We Do Deployment – 2016 Edition
Posted by jpluimers on 2020/03/18
It sounds long ago, but this post is still so relevant for anyone not yet bringing operations and development close together. And for those who did:
- automate the heck out of everything
- make lots of mistakes as early as possible so you can fix them before the hit any of your production sites
[WayBack] Nick Craver – Stack Overflow: How We Do Deployment – 2016 Edition
The relevance is why Nick repeated it in 2018 in a response to a @ThePracticalDev discussion right after the first Falcon Heavy deployment, and why I repeat it now.
- [WayBack] Nick Craver on Twitter: “I wrote up how we do deployment of Stack Overflow here – not selling anything, just sharing in case it helps others. #DevDiscuss…”
- [WayBack] The Practical Dev on Twitter: “Time for the #DevDiscuss Twitter chat. Tonight’s topic is DEPLOYMENT – What’s your deployment process like? – Experienced devs, how has your deployment process changed over time? – Who is typically in charge of deployment? Answer any of the above or go on a tangent.… https://t.co/Sc5uTIOTbm”
–jeroen
Share this:
Posted in Development, DevOps, Infrastructure, Software Development | Leave a Comment »
Fast-Forward »: My Lazarus External Tools (and Delphi External tools)
Posted by jpluimers on 2020/03/17
For my link archive if I want to make Explorer (for Linux caja) or console shortcuts to source or target directories: [WayBack] Fast-Forward »: My Lazarus External Tools with these XML files from [WayBack] Lazarus External Tools · GitHub:
And the Delphi equivalent from 2004: [WayBack] Fast-Forward »: My Delphi Tools, which addes “Open Source in Notepad2” and “Start Resource Explorer”.
via: [WayBack] Ondrej Kelle – Google+
–jeroen
Share this:
Posted in Delphi, Development, Lazarus, Software Development | Leave a Comment »
Working around [Fatal error] F2084 Internal errors like AV101E53EB-R0000000C-0
Posted by jpluimers on 2020/03/17
A few notes from my response to [WayBack] [Fatal error] F2084 Internal error : AV101E53EB-R0000000C-0 I’m getting this when trying to do some code completion. Any idea ? – Stéphane Wierzbicki – Google+:
This compiler related error usually made it go away for me either when it occurs during project compilation or when using code completion: Close the IDE. Delete your DCU files. Then restart the IDE.
Starting fresh gives a high chance if fixing this unless it is indeed a compiler related error in which case it returns. For that you need to trim down your code to see under which circumstances.
Reasoning (please shoot at it when things are wrong/missing):
Both the IDE code completion and the project compilation use the compiler. The DCU cache is shared between these compiler instances. The DCU cache depends on internal memory structures. Various pointer related errors (both from the IDE, compiler and 3rd party extensions) can damage this cache.
Especially weak IDE uses of the compiler are the find symbol and rename symbol functionalities. I’ve stopped using those about a decade ago.
Sometimes the F2084 (which I often mistype as F2048) is indeed an error in the compiler. Over the years, some of them have been fixed too. See my earlier articles on F2084.
–jeroen
Share this:
Posted in Conference Topics, Conferences, Delphi, Development, Event, F2084, Software Development | Leave a Comment »
bash – How to add a progress bar to a shell script? – Stack Overflow
Posted by jpluimers on 2020/03/17
From [WayBack] bash – How to add a progress bar to a shell script? – Stack Overflow (thanks Mitch Haile!):
You can implement this by overwriting a line. Use
\rto go back to the beginning of the line without writing\nto the terminal.Write
\nwhen you’re done to advance the line.Use
echo -neto:
- not print
\nand- to recognize escape sequences like
\r.Here’s a demo:
echo -ne '##### (33%)\r' sleep 1 echo -ne '############# (66%)\r' sleep 1 echo -ne '####################### (100%)\r' echo -ne '\n'
–jeroen
Share this:
Posted in *nix, *nix-tools, bash, bash, Development, Power User, Scripting, Software Development | Leave a Comment »
worksheet function – How to add or subtract to, or increment, column letters in Excel? – Super User
Posted by jpluimers on 2020/03/13
[WayBack] worksheet function – How to add or subtract to, or increment, column letters in Excel? – Super User:
Here’s the best I’ve found so far:
=SUBSTITUTE(ADDRESS(1,( COLUMN() + 1 ),4),1,"")The part in the middle marked in bold is the only part that changes. In this example, it’s taking the current column and adding1, so returningBif it’s in columnAandAAif it’s in columnZ.
It is related to the question and answer [WayBack] Formula to return just the Column Letter in excel – Super User:
FYI on your original formula you don’t actually need to call the CELL formula to get row and column you can use:
=ADDRESS(ROW(),COLUMN())Then as an extension of that you can use MID & SEARCH to find the $ and trim down the output so you are just left with the letter:
=MID(ADDRESS(ROW(),COLUMN()),SEARCH("$",ADDRESS(ROW(),COLUMN()))+1,SEARCH("$",ADDRESS(ROW(),COLUMN()),SEARCH("$",ADDRESS(ROW(),COLUMN()))+1)-2)edit You can even simplify this further:
=MID(ADDRESS(ROW(),COLUMN()),2,SEARCH("$",ADDRESS(ROW(),COLUMN()),2)-2)
And it is part of a much more elaborate answer
Share this:
Posted in Development, Excel, Office, Power User, Software Development | Leave a Comment »
0.30000000000000004.com
Posted by jpluimers on 2020/03/12
Cool! It’s about Floting Point Math. Which means that in most programming languages 0.1 + 0.2 does not equal 0.3: [WayBack] 0.30000000000000004.com
–jeroen
Share this:
Posted in Development, Software Development | Leave a Comment »
The Wiert Corner - irregular stream of stuff 