Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »
Q&A

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

42%
+1 −2
How to add to the value of one cell an amount that depends upon the range of a different cell?

A user of Web Applications asked how to: +1 when the value is &gt;=5, +2 when the value is &gt;=10, +3 when the value is &gt;=15, +4 when the value is &gt;=20, +5 when the value is &gt;=25...

1 answer  ·  posted 2y ago by pnuts‭  ·  last activity 2y ago by Alexei‭

50%
+0 −0
How to calculate the Hamming weight of a binary string?

A presently unanswered question on Stack Overflow asks: Does there exist a popcount function in libreoffice calc? and clarifies that "I often use BASE(A1;2;8) to show a number in binary".

1 answer  ·  posted 2y ago by pnuts‭  ·  last activity 2y ago by Alexei‭

57%
+2 −1
Combine the first character of a cell with another cell

A Q on Stack Exchange from a very long time ago included: I have first names in one column and second names in another, I want to create a third column that contains the first character from the...

1 answer  ·  posted 2y ago by pnuts‭  ·  last activity 2y ago by Alexei‭

50%
+2 −2
Conditionally format a pair of columns

A user of Web Applications asked "How should I fix the formula?" with reference to: =IF($K4&lt;2,$K4) applied as a Conditional Formatting [CF] formula to J4:J8, where the desired (green fill) form...

1 answer  ·  posted 2y ago by pnuts‭  ·  last activity 2y ago by Alexei‭

50%
+1 −1
Count the number of occurrences in a text string

The question about LibreOffice Calc - Number of occurrences in text string from Binz Nakama at Stack Overflow interested me because of one of the comments posted there: OK, I think this would requ...

1 answer  ·  posted 2y ago by pnuts‭  ·  last activity 2y ago by Alexei‭

80%
+6 −0
Multiple string concatenation in Excel

In Excel I would like to concatenate several strings into one. I could type and fill in the blanks CONCATENATE(A1, A2, ....) but it is a lot of work This would be cool, but it does not work CONCATE...

2 answers  ·  posted 2y ago by James Jenkins‭  ·  last activity 2y ago by Alexei‭

50%
+0 −0
Merge a pair of columns where in each row one is blank, without a formula

A Q on Stack Overflow asks how to merge two columns where each row has only one populated cell. The example was from (on the left) to (on the right): a|b a 0| ...

0 answers  ·  posted 2y ago by pnuts‭  ·  last activity 2y ago by pnuts‭

50%
+0 −0
Copy a sparse matrix with removal of blanks

A user of Web Applications gave the following as an example: https://docs.google.com/spreadsheets/d/1nPTBFXaIgpruPgNoWFSBUL2yKaibjeNJNExhnHVr8LE/edit#gid=0 and asked: How do I read a long ro...

0 answers  ·  posted 2y ago by pnuts‭  ·  last activity 2y ago by pnuts‭

50%
+0 −0
Loss of precision when concatenating an exchange rate with a string

In response to a Q on Web Applications [WA] the asker self-answered with: =CONCATENATE("@ £/€ rate: ",text(J21,"0.00000")) The issue was that, with "in a cell J21 I have a set value 1.10000":. ...

0 answers  ·  posted 2y ago by pnuts‭  ·  last activity 2y ago by pnuts‭

50%
+0 −0
A Conditional Formatting formula rule expected to apply to all cells is only affecting some

A very recently asked Q on Web Applications has no answer yet (and, in my opinion, is so badly written may not receive an answer at all promptly). However it does seem (in my interpretation) to rai...

0 answers  ·  posted 2y ago by pnuts‭  ·  last activity 2y ago by pnuts‭

66%
+2 −0
Highlight the maximum value per row across multiple columns

An as yet unanswered OpenOffice Calc - Highlighting the higest value in multiple columns posted by Rui on Super User from early this year asked whether a condition was possible to: fill with a c...

0 answers  ·  posted 2y ago by pnuts‭  ·  last activity 2y ago by pnuts‭

50%
+0 −0
Summing values formatted for a different locale

A couple of year ago a user of Super User reported difficulties with summing values purporting to be Euros imported to LibreOffice Calc in CSV format. In the Q the user does not mention the locale...

0 answers  ·  posted 2y ago by pnuts‭  ·  last activity 2y ago by pnuts‭

50%
+0 −0
TRUE/FALSE flags for alternating colouring by group

For use in connection with conditional formatting with alternating coloured fills in OpenOffice Calc, several years ago a user of Super User was applying this Ruby script: f = File.readlines("sha...

0 answers  ·  posted 2y ago by pnuts‭  ·  last activity 2y ago by pnuts‭

60%
+1 −0
Data validation applied to tickboxes

Given ColumnA contains a Text header (A1), an allowed maximum number (A2), fifty tickboxes (A3:A62) and a formula in A63 of: =countif(A3:A62,TRUE) how can I block application of more than the a...

0 answers  ·  posted 2y ago by pnuts‭  ·  last activity 2y ago by pnuts‭

66%
+2 −0
How to manage decibel meter?

I had build an application using following source code (following the steps). package com.decibal.level; import androidx.appcompat.app.AppCompatActivity; import android.media.MediaRecorder; ...

1 answer  ·  posted 2y ago by deleted user  ·  last activity 2y ago by deleted user

75%
+4 −0
What are the risks of using iFrame as a temporary migration step for an internal web application?

Overview Our development team is currently trying to develop and migrate a Web application that is split in two: legacy: ASP.NET MVC 5, jQuery, old-style JS programming overall "next": Angular...

1 answer  ·  posted 2y ago by Alexei‭  ·  last activity 2y ago by meriton‭

71%
+8 −2
Write to same file from multiple threads

I want to write a text file from multiple threads. The file structure is line-oriented. This means writing of lines should be atomic. I am using Qt 5.15.2. Is it enough to protect a shared QTextSt...

2 answers  ·  posted 2y ago by Silicomancer‭  ·  last activity 2y ago by Ayxan Haqverdili‭

16%
+0 −8
Why most hosting providers support ticket systems allow text only (no formatting)? [closed]

Through the years I have "tasted" several website hosting companies; none of them had Markdown available in their support-ticket-systems (if all any formatting method available). Why is it? What's...

1 answer  ·  posted 2y ago by deleted user  ·  last activity 2y ago by Alexei‭

50%
+1 −1
Why are my EMA values ​​different from the ones on the website? [closed]

I wrote a program for calculating EMA, but my values ​​differ from the values ​​calculated on this site. My program: double[] x = Numbers();//array numbers int N = 5; double k = 2.0 / (N + 1...

0 answers  ·  posted 2y ago by kolaa‭  ·  closed 2y ago by Alexei‭

50%
+0 −0
When is information schema not needed and when is it indeed when migrating from one website hosting provider to another?

In some situations, could it be problematic to migrate a website's database (MySQL) from one website hosting provider to another without the information schema or with the information schema? In m...

0 answers  ·  posted 2y ago by deleted user  ·  edited 2y ago by deleted user

50%
+3 −3
What is a typeless programming language?

I have read that several programming languages, listed below are considered "typeless": Forth Brainfuck B MUMPS BLISS Lucid BCPL I have shared this data with a programmer who clued that...

1 answer  ·  posted 2y ago by deleted user  ·  last activity 2y ago by deleted user

62%
+3 −1
Is this a known design pattern: a piece of code is responsible for acting as a central proxy for data distributed in various places?

I have several classes (C_1...C_n) and their instances (I_1....I_m). I have a "Registry" R of these. There are several pieces of data (d_1...d_k) spread across various instances. This much is set ...

1 answer  ·  posted 2y ago by peey‭  ·  last activity 2y ago by Alexei‭

66%
+2 −0
Changing the font of an entire JTable column.

I know I can change the font of each cell individually by overriding getCellRenderer(row, col) in JTable but I want to be able to change the font of an entire column at once and, ideally, have the ...

0 answers  ·  posted 2y ago by cuzzo‭  ·  edited 2y ago by cuzzo‭

66%
+2 −0
How to easily support time frame grouping in queries?

I had a curiosity about how much the experienced users wait for their questions to be answered on Stack Overflow and had written a query for it: SELECT YEAR(q.CreationDate) * 100 + MONTH(q.Creatio...

0 answers  ·  posted 2y ago by Alexei‭  ·  edited 2y ago by Alexei‭

87%
+12 −0
Is strcpy dangerous and what should be used instead?

I heard rumours that the strcpy function is dangerous and shouldn't be used. Supposedly it can be exploited to create buffer overflows somehow. And indeed when I compile my C code in the admittedl...

1 answer  ·  posted 2y ago by Lundin‭  ·  last activity 2y ago by J-hen‭

66%
+2 −0
Save migration info in separate DB schema

When creating a code-first solution in dot net core using Visual Studio, you manipulate the database by changing model classes and migrating the changes. I can set the schema for tables that I cre...

1 answer  ·  posted 2y ago by mcalex‭  ·  last activity 2y ago by Alexei‭

75%
+4 −0
Pros and Cons of different tacit systems?

As a big fan of tacit/point-free programming in general, I'm looking at different tacit programming systems for inspiration (for a language I'm creating). What are the advantages and disadvantages ...

0 answers  ·  posted 2y ago by Wezl‭  ·  edited 2y ago by Wezl‭

80%
+6 −0
How does Zalgo Text work, and how can I prevent my application from accepting it?

A Zalgo Text is something like this: T̃͟͏̧̟͓̯̘͓͙͔o̤̫͋ͯͫ̂ ̥͍̫̻͚̦͖͇̌ͪ̇ͤ̑̐͋̾̕i̢͖̩͙͐͑ͬ̄̿̍̚ͅn̵̢̼̙̳̒̄ͥ̋̐v̡̟̗̹̻̜͕̲ͣ̐ͤͤ͒́oͫ͂̆͑ͩ҉͇̰͚̹̠̫͔̗k̷̭̬̭͙̹̺̯ͩ̌̾̒̋̓ͤ͛͘͠e̥͙̓̄̕ ̵̫͈ͪţ̱̺̺̑̿̉̌͛̂̇h͙̣̬̓̂͞ę̡̲̟͎͉̟͛̓̉̆̉͘ ͬ̒...

1 answer  ·  posted 2y ago by hkotsubo‭  ·  last activity 2y ago by hkotsubo‭

53%
+5 −4
What is an example for a URI which is not a URL?

Every URL is a URI but not every URI is a URL is a saying I know from long ago, but what is an example for a URI which is not a URL (whatever the user agent would be - a web browser, a *nix utility...

1 answer  ·  posted 2y ago by deleted user  ·  last activity 2y ago by Wezl‭

75%
+4 −0
Changing the font of a certain cell within a JTable

I am trying to change the font type and size in a JTable cell. Ive looked at tons of posts and while most don't produce stack traces, they don't seem to do anything either. Here is the code I curr...

1 answer  ·  posted 2y ago by cuzzo‭  ·  edited 2y ago by cuzzo‭

77%
+5 −0
How can I test my front end for accessibility to the blind?

I'd like my web front end to be accessible, including to people who use screen readers. I know the basics about labels and alt text for images, but there are some areas where I'm not sure what a s...

1 answer  ·  posted 2y ago by Monica Cellio‭  ·  last activity 2y ago by Peter Cooper Jr.‭

71%
+3 −0
Is it worth using the Java Platform Module System in application code?

Is it worth using the Java Platform Module System introduced in Java 9 to structure application code? Given that the Java Platform Module System introduced in Java 9 doesn't manage dependency versi...

0 answers  ·  posted 2y ago by meriton‭  ·  edited 2y ago by meriton‭

77%
+5 −0
Warn of implicit cast in a function's arguments with GCC?

In the C program below, I make a mistake and call the function with (ld, ld) instead of (d, ld). #include &lt;stdio.h&gt; #include &lt;limits.h&gt; void print_int_long(int n, long l){ pri...

2 answers  ·  posted 2y ago by Quasímodo‭  ·  last activity 2y ago by Lundin‭

44%
+2 −3
Why often times data compression causes data loss?

I understand data compression as making data structures nearer (if they are mere machine code without any abstract representation) or representing them in less and less abstract computer languages ...

2 answers  ·  posted 2y ago by deleted user  ·  edited 2y ago by deleted user

75%
+4 −0
How to break infinite loop in CTE

I have a parent child relation in my table, with possibly circular cases. Is it possible to break the infinite recursivity in CTE checking values of all previous rows? I would need something like t...

3 answers  ·  posted 2y ago by artaxerxe‭  ·  last activity 2y ago by Peter Taylor‭

20%
+0 −6
When an FPS game player can look down on the character shehe plays [closed]

I seek help in finding a term common in game development, particularly 3D First Person Shooter games (not at all in 2.5D games such as Doom). I understand that 3D first person shooter games can be...

0 answers  ·  posted 2y ago by deleted user  ·  closed 2y ago by Lundin‭

66%
+2 −0
How to work with current entity changes when working with @ngrx/store and @ngrx/entity?

I am fairly new to working with @ngrx pattern in Angular which is a state management pattern relying on Reactive Extensions. One of the convenient structures is @ngrx/entity which helps with manag...

0 answers  ·  posted 2y ago by Alexei‭

22%
+0 −5
Which body supervises country-specific internet associations and what designations it assigned to these? [closed]

I am trying to save my question that was deleted from "Webmasters StackExchange" for not being about "a problem in a website" which I published there anonymously ; below is a shortened, directly-in...

0 answers  ·  posted 2y ago by deleted user  ·  closed 2y ago by Alexei‭

81%
+7 −0
How can I find git branches where all branch-local commits are from specific people?

We have a bunch of dead branches in our git repository, and I'd like to clean them up. Ones that were merged (but not deleted at the time) are easy; we can see those in the branch list on Bitbucke...

2 answers  ·  posted 2y ago by Monica Cellio‭  ·  edited 2y ago by Alexei‭

75%
+4 −0
Is *nix a formal term?

How can one differentiate what is or is not a *nix operating system even if that operating system (or its core/shell/common-utilities) allegedly behaves like any "other" *nix operating system? Is ...

1 answer  ·  posted 2y ago by deleted user  ·  last activity 2y ago by r~~‭

80%
+6 −0
How to properly deal with impersonation in a Web application? (security vs. usefulness for tech support)

Context Our team has begun migrating a pretty old internal application and one aspect that got my attention is the impersonation. This is implemented as follows: only administrators are allowed...

2 answers  ·  posted 2y ago by Alexei‭  ·  last activity 2y ago by meriton‭

50%
+1 −1
yyyy/mm/dd instead expected dd/mm/yyyy format in PHP-created-HTML output

I have an HTML-PHP-CSS contact form with a date field: &lt;input type="date" name="date" id="cf_input_date"&gt;&lt;/input&gt; The default value in this field is the W3C built-in default: dd/m...

1 answer  ·  posted 2y ago by deleted user  ·  last activity 2y ago by Peter Taylor‭

60%
+1 −0
Backendly redirecting a user from a contact form webpage to a success webpage

On a CentOS Apache-MySQL-PHP environment I have a website with a simple HTML-PHP-CSS contact form; the contact form itself is working. This is how I backendly redirect a user from the contact form...

0 answers  ·  posted 2y ago by deleted user

71%
+3 −0
How to tackle database migrations failure during application initialization on production systems?

Context My ASP.NET Core application got stuck in Production with a 5xx error. By inspecting the logs, I have noticed that a database error occurred during application initialization, namely a SQL ...

1 answer  ·  posted 2y ago by Alexei‭  ·  last activity 2y ago by misha130‭

60%
+1 −0
How to enable or disable a bunch of reactive form controls?

I want to conditionally disabled or not (enabled) a bunch of reactive form controls. However, I have noticed that neither enable or disable function has a boolean parameter to nicely conditionally ...

1 answer  ·  posted 2y ago by Alexei‭  ·  last activity 2y ago by meriton‭

62%
+3 −1
PHP emails are sent when $message is a string, but not when its an array

I host my website on a CentOS-Bash, PHP and MySQL environment; my local email client is engined by Roundcube. I don't know almost anything about PHP nuances. While my web domain registration is do...

2 answers  ·  posted 2y ago by deleted user  ·  last activity 2y ago by manassehkatz‭

php
57%
+2 −1
Not obligating http:// or https:// in a url field of a contact form

I have a simple HTML-PHP-CSS contact form (no JavaScript) with an input type="url" field. Currently in 30/03/2021, the default behavior of input type="url" (by W3C design I guess) is to obligate t...

1 answer  ·  posted 2y ago by deleted user  ·  last activity 2y ago by Alexei‭

50%
+0 −0
Submitting a form via XHR/AJAX causes partial data arrival to email inbox (only HTML without input)

I have a simple HTML-PHP contact form with some CSS. I desire to prevent the default behavior of the form which leads the user into a blank PHP page after submission, and, to have the form being s...

1 answer  ·  posted 2y ago by deleted user  ·  last activity 2y ago by Alexei‭

81%
+7 −0
SQL timestamp for daylight saving day when clock goes 1 hour back.

On 25th October 2020 in Europe/Berlin clocks where set back from 03:00 AM to 02:00 AM to change from summer time (CEDT) to winter time (CET). Which means there is a 1 hour separation between 02:30...

1 answer  ·  posted 2y ago by Estela‭  ·  last activity 2y ago by hkotsubo‭

71%
+3 −0
PHP variables aren't expanded when inside HTML which is by itself inside PHP

I transfer emails from my Right To Left (RTL) contact form → to my local email box (powered by Roundcube). Emails reach my email box (inbox) just fine but I have a problem were PHP variables aren'...

1 answer  ·  posted 2y ago by deleted user  ·  last activity 2y ago by luap42‭