10,728 questions
Advice
0
votes
13
replies
204
views
How to direct calculate the range of a float in C?
I'm doing trying to solve the exercise 2.1 of K&R 2nd. I have already calculated the range of signed/unsigned char, short, int and long, mainly because two's complement is easy to get but IEEE754 ...
- reputation score 1
Advice
0
votes
7
replies
120
views
Unable to understand certain logic in the solution
I was practicing this DSA question and my university provided a solution too, unfortunately I am unable to understand why we are taking the range(M-N+1) instead of just range(P+1).
This the Question:
...
- reputation score 1
Score of 2
1 answer
195 views
iteration over integer range doesn't work with generic type constrainted to integer
Go v1.22 added the ability to easily range from 0 to n-1:
// Prints 0, 1, 2 on separate lines.
for i := range 3 {
fmt.Println(i)
}
However, it doesn't work as expected when the expression's type ...
- reputation score 55065
Score of 0
1 answer
84 views
How to use Postgres timestamp ranges in Rust with time-rs, especially NULL and (-)infinity?
I need to use (read, write) Postgres's built-in tstzrange datatype with postgres-rs and time-rs.
postgres_range-rs is lacking an example (except for the range! macro).
This is what I have got until ...
- reputation score 3256
Score of 0
1 answer
127 views
HTML range input value off by 1
Using the code:
const input = document.querySelector("#Tester");
console.log(input);
console.log(input.value);
<input type="range" id="Tester" min="4" max="250" step="5" value="25" />
24
It ...
- reputation score 62117
Score of 0
2 answers
93 views
Removing non-underlined characters from a Word Doc range in VB.NET
I've got some text in a word document in a specific range object, and I'd like to remove any characters that are not underlined. I've tried two approaches, but they both seem to lead to different ...
- reputation score 43
Score of 2
1 answer
110 views
Storing store time of day ranges where timezone matters
I need to store some store hours that exist in different time zones and may be interacted with in different timezones through an admin portal where it will display store time and local time.
I know ...
- reputation score 23
Score of 1
1 answer
79 views
Plotly/Dash rangeselector "All" button extends x-axis into future despite no data
I'm building a time series plot using Plotly with Dash, and I'm running into a frustrating issue with the x-axis.
Python Version: 3.10.16
Plotly Version : 6.0.0
Pandas Version : 2.2.3
My setup:
The ...
- reputation score 21
Score of 2
1 answer
107 views
Add range to rangeslider in Plotly R
I would like to add an initial range to the rangeslider option in plotly r. Apparently, we could use the range argument for this based on the documentation. Here is a simple reproducible example:
...
- reputation score 43187
Score of 3
1 answer
142 views
Error getting a named range from another sheet in the same workbook
I have a workbook with multiple sheets. In the name manager, I have a range that looks like this:
Name Value Refers To
PremierPeeled ...
- reputation score 33
Score of 0
2 answers
118 views
Sheets Arrayformula: increment range size row by row
I am doing a tiny home store overview lists. At the movement sheet I want to sum ONLY the same and previous rows but never mix the results with the future row values.
As I use mostly ARRAYFORMULAs I ...
- reputation score 13
Score of 1
3 answers
108 views
If column BU contains "Tail lift required" add "TL&PT" to beginning of cell in Colum U
I am trying to add specific text to the beginning of a cell in column U based on the value of the corresponding cell in column BU.
If Column BU contains the text "TAIL LIFT REQUIRED" then ...
- reputation score 21
Score of 2
4 answers
195 views
How to union multiple ranges and show it in a listbox of a VBA form
I try to union multiple ranges, but the result is alway just two columns where it should be more.
With ActiveSheet
lastRow = .Cells(ActiveSheet.Rows.Count, "A").End(xlUp).Row
...
- reputation score 665
Score of 0
1 answer
97 views
PostgreSQL alter column type from tstzrange to daterange
Similar to this SO question, how to convert a tstzrange value to daterange (ignoring the time part) ?
alter table x alter column y type daterange using y::daterange;
Ouput:
ERROR: cannot cast type ...
- reputation score 3256
Score of 2
3 answers
122 views
How do I limit an array to a single column in VBA?
I have this code for "Data 1" that I got from an AI ChatBot. I want it to average my values in column B based on if there are duplicate values in column D, and it does this. But now I want ...
- reputation score 99