10,749 questions
-2
votes
0
answers
83
views
Shiny range slider not updating ggplot output [closed]
I want to do a range slider that filter and zoom in on the data in the vizualization. I can see the slider in my app but it doesn´t react when I change the slider. What do i do wrong? Here is my code:
...
- 1
1
vote
1
answer
45
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 ...
- 21
1
vote
1
answer
71
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:
...
- 42.8k
3
votes
1
answer
119
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 ...
- 33
0
votes
2
answers
96
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 ...
1
vote
3
answers
90
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 ...
- 21
2
votes
4
answers
169
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
...
- 665
0
votes
1
answer
62
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 ...
- 3,152
2
votes
3
answers
115
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 ...
3
votes
1
answer
124
views
Set a dynamic range based on common values in a column
I want to give a "Timepoint" value (which I call a scanRank in the code below) to all the rows in this table based on "Subject ID".
In this example, the first subject is already ...
1
vote
3
answers
151
views
How does the Postgres daterange() function work?
This SQL:
select daterange(current_date, current_date);
Results in:
daterange
-----------
empty
(1 row)
But the daterange() function does not seem to be documented. I've looked here and there. ...
- 3,152
3
votes
1
answer
121
views
How to map a value from one range to another accurately without using floating point? [closed]
I am writing firmware for a microcontroller. (In this specific case it is a Microchip PIC, but I am looking for an answer that is equally applicable to any brand of microcontroller.)
Arduino has a map ...
- 1,856
-2
votes
1
answer
111
views
How to set a maximum range on a variable in Python
I'm very new to coding and trying to write a simple program to roll dice for the TTRPG game Daggerheart (I play solo on paper, so something to help track both Fear and Hope seemed useful). In the game ...
- 9
1
vote
2
answers
66
views
Consolidate date ranges using Teradata
I need to take a list of date ranges and consolidate them. In our existing table, sometimes the FROM_DT and TO_DT are the same and the FROM_DT in the following row is 1 day after the previous row's ...
1
vote
1
answer
99
views
Follow up to Using ActiveX Checkboxes Conditions to check or disable another Checkbox that results in Formula
So this is a follow up to a previous question. That was answered wonderfully. However now I have a problem where I added another column and have specific formulas needed depending on certain ...
- 35
0
votes
0
answers
35
views
Finding number range subject to multiple criteria in R [duplicate]
I need to find the range for the chromosome regions of my results following a number of criteria, and I'm really struggling to figure out how to do this in R. My data looks roughly similar to this:
...
2
votes
0
answers
96
views
Safari sends excessive HTTP range requests during HTML5 MOV playback
I am currently developing a web application based on React and Next.js, and I use the react-player library to play user-uploaded videos stored on AWS S3. The supported upload video formats are mp4, ...
- 81
0
votes
1
answer
66
views
VBA in Word - selecting ranges and making comments
I've been trying to figure this out, but no such luck.
Ultimately, I'm trying to create a macro that searches the Word document for each instance of String1, selects a range of text starting with that ...
- 13
1
vote
2
answers
118
views
Range() using a long string variable
I create a chart in Excel using this VBA.
myRange = "Sheet1!$A$1,Sheet1!$A$3,Sheet1!$A$8,Sheet1!$A$13,Sheet1!$A$18,Sheet1!$A$23,Sheet1!$A$28,Sheet1!$A$34,Sheet1!$A$41,Sheet1!$A$48,Sheet1!$D$1,...
- 11
0
votes
0
answers
46
views
zsh date utility gives error "ranged: Cannot apply date adjustment"
I'm writing a zsh script to work with dates and want to iterate over each day of the month.
A simplified version of what I'm doing is:
for i in range {1..31}; do
dstring=$( date -v${i}d ) ;
echo ...
- 5
0
votes
2
answers
157
views
Printing a star shape using loops in python
I was trying to write a python code that would print a star shape using loops but I just can't get the shape right. Please suggest some corrections.
This is my terminal:
This is my code:
for i in ...
0
votes
1
answer
111
views
Excel VBA Range.Find not working - no data or error returned
Good day all,
I have been trying to use the range.find method to find a string from an existing cell in a column in a different sheet in the same workbook. When I use the debugger to walk through the ...
- 65
3
votes
1
answer
70
views
Struggling to find the right data source range in VBA pivot table
New to VBA and I've been struggling to find the right data source for my Pivot table in Excel. The data source should be coming from column "B" in sheet "Monthly". Any tips on how ...
- 45
0
votes
0
answers
56
views
Python script to loop through column to select specific cell ranges and paste special transpose on next sheet
I am new to scripting and get the basic ideas of looping and the such. I want to loop through a column of a worksheet selection specific cell ranges and paste special transpose on the next sheet.
I ...
- 1
0
votes
2
answers
107
views
Excel VBA Get List of Unique Values in Column without Dynamic Range [duplicate]
I have a list of data (with a header) on a sheet called "DataSheet".
I'm looking to get a list of all unique values in Column C (ignoring the header) on DataSheet and put them vertically ...
- 1
2
votes
3
answers
88
views
Conditional Format Cells Fill based on criteria
I need to fill rows from A:D if Column A has text.
I tried a lot of codes.
I ended up recording macro. It fills only cells in Column A. How to replace "Selections" to a Range?
Columns("...
- 29
6
votes
2
answers
88
views
Why is &Range<T> not an iterator, but &mut Range<T> is?
Demo code using version rustc 1.86.0 (05f9846f8 2025-03-31)
fn main() {
let mut source = 1..3;
test(&mut source); // This is good. which means &mut Range<T> is Iterator.
...
- 891
0
votes
0
answers
10
views
loading a xml file using libSBML on Spyder - tuple index out of range problem
I am trying to use the python version of libSBMLon Spyder.I previously used Cobra to do so and it works. Now, I use the command "model = ls.SBMLReader.readSBML('model.xml')" and I get the ...
1
vote
1
answer
44
views
Finding the most common interval in a list of doubles
I am currently stuck on evaluating a list of some Doubles representing time intervals. Let's say I have an unordered list of up to 100 values fluctuating around 1: [0.897, 0.912, ... 1.214, 0.981]
I ...
- 83
1
vote
1
answer
61
views
Wrong input's selectionStart value after pressing arrow key
Here is the scenario to reproduce the problem:
Given input element has test string as a content. Focus given input element by clicking at the end of the input element
After focusing, caret is set at ...
- 2,293
1
vote
1
answer
65
views
Setting discrete ranges for specific parameters of the design vector (x) to run PSO in the Indago Python module
Has anyone worked with the Indago Python module? I couldn't find many information on it besides the official documentation (https://indago.readthedocs.io/index.html).
I'm using it to run the Particle ...
- 13
0
votes
1
answer
128
views
Replace OFFSET formula
=LAMBDA(a,
LET(Range,IF(COLUMNS(a#)>1,a#,OFFSET(a,0,0,1,14)),
Range))(Q339)
The above formula is going to be used at many places. I need to eliminate OFFSET function to improve on speed. If target ...
2
votes
1
answer
62
views
How to use an If function with a range of cells to send an email if greater than a number in excel?
I have a list of employees A3:A23 and G3:G23 who must stay current in observations (B and H). If they go above 0 in E and K (observations Due) I want to email myself their names A3:A23 and G3:G23. If ...
- 21
-4
votes
1
answer
56
views
Is there a logical reason behind the indexing used for the range() function in python [closed]
I have a very simple question:
If i run the code:
for i in range(2, 10):
print(i)
I will recieve an output of:
[2, 3, 4, 5, 6, 7, 8, 9]
I am wondering if there is any logical reason why the ...
- 95
0
votes
1
answer
87
views
Delete ranges with openpyxl and adapt the relative references in formulae in the remaining cells
With openpyxl, when I use worksheet.move_range(range, rows=12, translate=True) the range will be moved 12 rows down. The translate=True will move the relative references in formulae in the range by ...
- 11
1
vote
2
answers
86
views
Check if a sequential value in a range
I am stuck in a unique situation. I have a range:
ABCD0001 to ZZZZ9999
The above range can hold any combination of numbers in between. The individual values reset at Z (next becomes A) or 9 (next ...
- 133
5
votes
0
answers
45
views
Passing R-values to ranges with range-v3 and with std::ranges [duplicate]
The range-v3 library complains if I try to feed an r-value to the pipe operator:
#include <iostream>
#include <range/v3/view/transform.hpp>
#include <vector>
std::vector<int> ...
- 483
0
votes
1
answer
65
views
Oracle query - day / time range
Trying to figure out how to write a query where the criteria on the CONNECT_TIME column is only on FRIDAYS 9:00pm - SATURDAYS 1:00am. Everything else can be ignored.
Just not sure how to combine ...
- 853
4
votes
5
answers
194
views
Are there other ways to obtain a value from 2 ranges?
I am learning Python, and I would like to know if there are other functions, methods, or techniques to obtain a value from two ranges. I provide the only example I could came up with with my current ...
3
votes
0
answers
124
views
Why is a C++ 20 view not reevaluated after assignment? [duplicate]
I recently learned, that C++ 20 views can be assignable. Can anyone tell me, why the second v1.begin() below still points to the same element, instead of being reevaluated and thus skipped?
#include &...
- 332
5
votes
1
answer
134
views
Trouble with understanding std::views::filter -> Lazy Evaluation
auto ResultView
{
std::views::iota(1,30)
| std::views::take(20)
| std::views::filter([](int x){ return x%2!=0; })
};
std::cout<<...
- 101
0
votes
2
answers
115
views
AWS redshift range join slow
I want to identify the location (country, city, area, latitude, longitude) details of clients who visit my site based on the client IP address for my analysis.
We have IP address data with details of ...
1
vote
1
answer
86
views
My function is only copying the first line. I would like it to copy all line within a range. E.g ("I7:I24")
I am using the function copyData below within another script and it works great in the original script but for another one it is only copying the first line. I would like it to copy all line within a ...
- 13
0
votes
2
answers
184
views
C# range operator, why does this not throw an exception? (int x = someIntArray[2..2]) [closed]
int[] array = { 10, 20, 30, 40, 50 };
int[] range = array[2..2]; // gives empty array
int[] range2 = array[2..3]; // gives array with one element - 30
I understand range operators somewhat, like the ...
- 245
1
vote
1
answer
85
views
Why does range() in Python require positional arguments when called, but keyword arguments in a match statement?
All examples tested using Python 3.13.2 on Windows 10.
When calling range(), I must use positional arguments, or otherwise I get an exception.
>>> range(2, 5)
range(2, 5)
>>> range(...
- 11
-1
votes
3
answers
59
views
what is "size - 1" argument in this loop?
word = input("Enter a word: ")
print("Original String is: ", word)
size = len(word)
print("Prnting only even index chars")
for i in range(0, size - 1, 2):
print(&...
1
vote
2
answers
104
views
Creating an R function (or a loop) to count the number of samples that lie above and below a range for each column in a data frame
I have a data set with different groups and many columns with different variables. For each column I want to calculate the range of values in one group, then count how many rows have a value that is ...
- 13
0
votes
0
answers
158
views
Create a border around a range if the date in a certain cell is the same as today [duplicate]
I'm using Google Sheets. My ultimate goal is to create a border around a variable range 'B', if the date in a certain cell, within a range 'A', is the same as "today".
For example:
There ...
- 1
1
vote
1
answer
79
views
Search for 13-digit UNIX Timestamp and Add Time in Conventional Format After Each
I have a Word document that is an export of a long chat history. Each entry includes a 13-digit UNIX timestamp.
I need to convert each timestamp to conventional/readable date/time (e.g. Friday, ...
- 13
-2
votes
1
answer
76
views
Protect Previous (lower) 5 Cells
Let's hope I can describe this so it is understandable.
The following requirement affects Column I.
If the user selects cell I6 or higher and enters data into that cell ... the previous (lower) 5 ...
- 131