Notifications
Mark all as read
Categories Users Search
Help
Q&A Code Reviews Meta
Q&A
Posts Tags
Ask Question

General Q&A about programming, scripting, software design & architecture, process, tools, testing, and more.

147 posts · Subscribe
Activity Age Score Lottery
33%
+0 −2
What formula would fetch the content of Cell B12 unless either that is blank or a space, in which case `0` should be returned instead?

1 answer  ·  last activity 26 days ago by Alexei‭

excel excel-formula
40%
+0 −1
Query to rearrange data

1 answer  ·  last activity 26 days ago by Alexei‭

google-sheets google-query-language google-sheets-formula
40%
+0 −1
Querying date time values for date only in Google Sheets

1 answer  ·  last activity 26 days ago by Alexei‭

formula google-sheets google-query-language google-sheets-formula timestamp
30%
+1 −5
Prefer sensible fractions of pi to radians

1 answer  ·  last activity 26 days ago by Alexei‭

google-sheets radians google-sheets-formula
60%
+1 −0
Create encrypted zip archive with bsdtar [closed]

0 answers  ·  last activity 27 days ago by Lundin‭

zip bsdtar
66%
+2 −0
How can I assign the result of an operation from within a function to the global environment?

2 answers  ·  last activity 28 days ago by Alexei‭

r variable-assignment global-variables
83%
+8 −0
For scripting what are the pros and cons of command line arguments versus capturing input at the start?

3 answers  ·  last activity 29 days ago by klutt‭

software-practices
66%
+2 −0
How do I track down intermittent locks in a MySQL database?

0 answers  ·  last activity 29 days ago by Alexei‭

mysql database-locking
66%
+2 −0
In MySQL, is it possible to disable triggers for only certain queries or users?

1 answer  ·  last activity 30 days ago by Alexei‭

mysql database-trigger
70%
+5 −1
Which abstraction should I choose for background services and why?

1 answer  ·  last activity about 1 month ago by Alexei‭

c# software-practices async-await .net
33%
+0 −2
Highlight rows in different sheets where corresponding columns don't match for corresponding items

1 answer  ·  last activity about 1 month ago by pnuts‭

conditional-formatting google-sheets
66%
+2 −0
Are hyphens and/or underscores valid in golang package names?

1 answer  ·  last activity about 1 month ago by Moshi‭

naming-conventions go
50%
+0 −0
How do World Wide Web interactions happen in a general level? [closed]

0 answers  ·  last activity about 1 month ago by Alexei‭

web
33%
+0 −2
Merge any two rows that have the same ID value

1 answer  ·  last activity about 1 month ago by pnuts‭

google-sheets merge
80%
+6 −0
Function call; `this` gets bound to unexpected value

2 answers  ·  last activity about 1 month ago by Alexei‭

javascript function this
76%
+11 −2
What gets allocated on the stack and the heap?

2 answers  ·  last activity about 1 month ago by Alexei‭

heap-memory memory-management stack heap
77%
+5 −0
How are integers interpreted in contexts that expect a date?

1 answer  ·  last activity about 1 month ago by Alexei‭

sql tsql sql-server
66%
+2 −0
Is an ORDER BY required when looping through MySQL records with LIMIT?

1 answer  ·  last activity about 1 month ago by Canina‭

mysql
60%
+1 −0
Xcode, SDL app showing in a single quarter of the window.

0 answers  ·  last activity about 1 month ago by .                                                .‭

xcode sdl retina
60%
+1 −0
Automatic adjustment when copying of column reference within INDIRECT function

1 answer  ·  last activity about 1 month ago by pnuts‭

google-sheets
77%
+5 −0
How does Caveat work?

0 answers  ·  last activity about 1 month ago by Alexei‭

google-fonts fonts
60%
+1 −0
How to use LazyCache library with Unity Container?

1 answer  ·  last activity about 1 month ago by Alexei‭

asp.net dependency-injection unity-container lazycache caching
75%
+4 −0
What would the pros and cons of storing the compiled CSS output of SASS in version control?

4 answers  ·  last activity about 1 month ago by ben‭

version-control sass
71%
+3 −0
How to calculate how much data is stored in a MySQL column?

1 answer  ·  last activity about 1 month ago by Alexei‭

mysql
86%
+11 −0
How should we share some content between two otherwise-independent git repositories?

3 answers  ·  last activity about 1 month ago by ntd‭

git software-practices
75%
+4 −0
Would a MySQL database run more efficiently with smaller varchar lengths?

3 answers  ·  last activity about 1 month ago by manassehkatz‭

mysql performance varchar
62%
+3 −1
What's the difference between null pointers and NULL?

2 answers  ·  last activity about 1 month ago by Lundin‭

c null null-pointer null-pointer-constant
75%
+4 −0
Multiple string concatenation in Excel

2 answers  ·  last activity about 1 month ago by Alexei‭

excel string string-concatenation
40%
+0 −1
In a pivot table display date, time and value for each maximum daily value

1 answer  ·  last activity about 1 month ago by pnuts‭

libreoffice-calc pivot
33%
+0 −2
Delete specific cells with shift cells up

1 answer  ·  last activity about 1 month ago by pnuts‭

excel delete
71%
+3 −0
Error: 18456, Severity: 14, State: 5; SSMS > Network sever from PC

1 answer  ·  last activity about 1 month ago by Alexei‭

sql sql-server sql-server-2014
77%
+5 −0
Is there a naming convention for table aliases?

1 answer  ·  last activity about 1 month ago by Alexei‭

sql naming-conventions
75%
+4 −0
What is a standard definition (or a CS theory based formal definition) for Escaping?

1 answer  ·  last activity about 1 month ago by Alexei‭

string escaping
66%
+2 −0
pod 0.1.0-dev not accepted for required version 0.1.0 (without -dev suffix)

0 answers  ·  last activity about 1 month ago by Someone‭

cocoapods ios flutter semver
40%
+0 −1
Count the number of occurrences in a text string

1 answer  ·  last activity about 1 month ago by Alexei‭

excel string libreoffice-calc google-sheets openoffice-calc
60%
+1 −0
How to pivot text?

2 answers  ·  last activity about 1 month ago by Sigma‭

google-sheets text pivot google-query-language
71%
+3 −0
How can I generate documentation from comments in SQL DDL?

0 answers  ·  last activity about 1 month ago by Monica Cellio‭

sql documentation tools
81%
+11 −1
Why would excluding records by creating a temporary table of their primary keys be faster than simply excluding by value?

2 answers  ·  last activity about 1 month ago by Alexei‭

mysql sql notin query-performance
40%
+0 −1
Delete rows that contain a specified string

1 answer  ·  last activity about 1 month ago by pnuts‭

string libreoffice-calc rows-affected delete
50%
+0 −0
Merge a pair of columns where in each row one is blank, without a formula

1 answer  ·  last activity about 1 month ago by pnuts‭

excel merge
40%
+0 −1
LibreOffice Calc formula returns Err:539

1 answer  ·  last activity about 1 month ago by pnuts‭

libreoffice-calc array-formula separators
75%
+4 −0
How do I get IIS UrlRewrite to handle CSS-delivered woff files appropriately?

0 answers  ·  last activity about 1 month ago by Alexei‭

iis url-rewriting woff
60%
+1 −0
Trigger Conditional Formatting by Check Box

1 answer  ·  last activity about 1 month ago by pnuts‭

conditional-formatting openoffice-calc checkbox
71%
+3 −0
Handling JSON files in Rust without manually creating mapping classes

1 answer  ·  last activity about 1 month ago by r~~‭

rust json
66%
+2 −0
How do I configure Jenkins to strip the leading “origin/” in git branch parameter?

1 answer  ·  last activity about 1 month ago by Monica Cellio‭

regex git jenkins
60%
+1 −0
What is the rationale of having Cascade as a DeleteAction in EntityFramework.Core?

1 answer  ·  last activity about 1 month ago by Alexei‭

entity-framework-core sql-delete referential
66%
+2 −0
Will my implementation of a Spring Boot app work after being deployed on the Internet?

1 answer  ·  last activity about 2 months ago by Moshi‭

java spring spring-boot
80%
+6 −0
Why can't we mix increment operators like i++ with other operators?

1 answer  ·  last activity about 2 months ago by Lundin‭

c undefined-behavior unspecified-behavior increment-operator sequence-points
71%
+3 −0
Path separator for Atom / JavaScript on Windows

0 answers  ·  last activity about 2 months ago by A. Donda‭

javascript atom-editor path-separator
71%
+3 −0
Implementing impersonation in an ASP.NET Core Web application

0 answers  ·  last activity about 2 months ago by Alexei‭

asp.net-core impersonation
Category RSS feed
Featured
Introducing the Codidact Foundation
UPDATE: Abilities update coming Soon™; downtime expected
Hot Posts
Q&A — Should a salt be stored in the same database as the hash?
Meta — Add link dialog should capture enter
Q&A — How much memory is allocated for a MySQL VARCHAR variable in a stored procedure?
Q&A — Search paths where all nodes are in a relationship with same node
Q&A — Jenkins failed to delete a file - why? How to prevent?

This community is part of the Codidact network. We have other communities too — take a look!

You can also join us in chat!

Want to advertise this community? Use our templates!