Latest Questions

Signing in to Google Sheets from Excel Power Query

I can use the Power Query tool to import data from Google Sheets easily, if the sheet is publicly available via a link. I just choose "Data from Web" and use th

Delete specific line number(s) from a text file using sed?

I want to delete one or more specific line numbers from a file. How would I do this using sed?

a performace issue of mybatis 3.5.3

My team meet a performance issue of mybatis 3.5.3, execute a simple select from mysql which takes about 15 seconds. The result of this query is a List, and the

How do I start an animation for a certain time?

I have the main loop of the program looped using requestAnimationFrame As for example after the character crashed, disable the collision for him for 3 seconds a

Hive retrieving meta data too slow

Situation : I am aiming to retrieve location info for a list of hive external tables. For one table the easiest way is just using show create table table_name b

How can I make a table in flutter where I can see the prices of items for different stores side by side?

I have the following class and list: Class: class ProductPrice { final int productPriceId; final String establishment; final String product; final doubl

How to calculate dynamic height of UIViewControllerRepresentable

I am working on a SwiftUI project, I need to display MarkDownContent which is coming from api. (MarkDownContent can contain text, image url, list etc..) I am us

reading pathname from undefined using react router dom 6.3.0

I am using react-router-dom 6.3.0. Below are my routes inside App component <BrowserRouter> <Routes> <Route path='/article/*' element={<

Why does the fragmentation field, in IP header, indicate the offset by bytes, and not sequentially?

Exactly what the title says. Since the offset number indicates the position of the single fragment in the overall datagram, and since they went to such lengths

Google Sheets script to send Email: If background color of cell is #00ff00, take email from next column and send mail there

This code checks if a cell from Q4 to Q20 is green. Now I want to send an email to an emailadress (which is on the same row as the the green marked cell), every

What is the scale of time complexity of this algorithm?

I have a list of list, in different length, and my algorithm runs on every element in the sub lists. What should be my time complexity? I don't know if it's oka

Identify if Socket server is running from client side

When the socket server is not running, client-side java script codes creates a connection, and then socket.onopen creates a fetal error and the javascript comp

pandas dataframe not posting correctly to excel

I've an excel sheet "Calcs" with 1 column name "old". I'm trying to add new column "new" with a fixed value of "1" to existing sheet "Calcs" and am using below

React video won't load

I'm trying to make a carousel with movies in React, and when I hover on a movie I want the trailer to start, and show some details. Everything works fine, but t

Flutter WebView file upload does not working to android app ,IOS app also ok. Anyone can help me how to solve this problem?

Here I have added my webview code in bellow. Website perfectly loaded but i couldn't camera & file chooser option to upload server. WebView( initialUrl: '',

How can I make my svg's grinder rotate using CSS animations while staying in place?

fellow Devs, I'm currently having trouble making my grinders (or whatever they're called) rotate properly in my svg. Basically I want them to rotate 360deg in p

Is it possible to make await + setTimeout + for loop work together?

I use async and for loop to test for fetch issues that might be caused by network or other issues. but testing too often It generates a request error similar to

JavaScript - Character counter for multiple textareas

I have a form on my website with several different textareas. HTML/PHP foreach ($bla as $blabla) { .... other php-code (not relevant) .... echo '<textare

Powershell: Script that was working now errors giving Get-ADUser : The server was unable to process the request due to an internal error

I had a script that was working fine. Went away for a few hours and came back and now it errors. Error Get-ADUser : The server was unable to process the request

Dynamic redirects with Gatsby

Given a Gatsby application with dynamically generated product urls on build: /product/x/ /product/x/variant1/ /product/x/variant2/ /product/y/ /product/y/varian

Python - Can't divide column values

I'm trying to divide each value of a specific column in df_rent dataframe by simply accessing each value and divide by 1000. But it's returning an error and I c

Problem in message section in orders of product prestashop 1.7

Somebody know in what phisical file in prestashop 1.7.5 (TPL) appear the message sections of product orders? i need modificate the line where show the message (

how can I search inside listView using flutter

import 'package:flutter/material.dart'; import '../app_data.dart'; import '../widgets/TopicItem.dart'; class TitleTopic extends StatefulWidget { @override Sta

POST request gets blocked on Python backend. GET request works fine

I am building a web app where the front-end is done with Flutter while the back-end is with Python. GET requests work fine while POST requests get blocked becau

Can we execute az PowerShell module commands inside of a runspace in a .net console app deployed as a webjob on Azure app service?

I've a webjob running in an azure app service that uses runspace to execute azure powershell module commands. Locally it's working fine because I can install az

How can I make the status bar / navigation bar invisible on Android, while keeping the padding at the top / bottom of the screen?

I'm trying to create an 'immersive mode' in my app, where tapping a button simply hides the status bar (and nav bar, if possible.) But I specifically don't want

How to let user choose from sample of images displayed on screen along with option to upload from device?

const [selectedFile, setSelectedFile] = useState(null); const [preview, setPreview] = useState(null); const [predictions, setPredictions] = useState([

Why my uninstalled jdk version still shows in java -version?

In my project which need jdk 1.8, but there is default openjdk 17 in my mac. So I remove it from Library/Java/JavaVirtualMachines. But when I run java -version

How to import component as a button in Nextjs?

I have this component with an internal link which is used in multiple pages when I try to import it as a button in the Nextjs application I get this result, it

File download freezes and does not finish on linux

I'm using "Node.js", "express" and "SheetJS" so that an endpoint that saves the data (from an array of objects) in an XLSX file and returns the url of the file