Stack Overflow
Stack Overflow

Questions tagged [paste]

The paste tag is to be used for issues relating to the paste portion of copy/paste operations.

Cut and paste and copy and paste offer user-interface paradigms for transferring text, data, files or objects from a source to a destination. The paste operation performs the copy to destination, whereas the source is often a clipboard. Often, hotkeys are employed to provide the paste functionality.

2546 questions
0
votes
1 answer

Advanced paste in excel using same cell ID

I have 2 separate spreadsheets which I would like to perform an advanced paste function on. The tables contain ~4000 records relating to a Value 1 and date. We would like to query dates in the last year with value over 100. We want to use the excel…
Supernovaaa
  • 25
  • 2
  • 9
0
votes
1 answer

TinyMCE editor and Base64

I'm using the TinyMCE editor for my React application. When I cut and paste the data into the editor, the data is in Base64 format. Now the data is also storing as Base64 which is a long string consuming more space and also when I retrieve the data…
T vara prasad
  • 16
0
votes
0 answers

Is there a way to copy a cell in which a formula is made using concatenate formula and run the same in another sheet?

I am using excel 2016. I use Macros to automate the process since it is repetitive. One step includes a situation where there are multiple cell ranges coming up. Since each time the cell references change i put a concatenate formula to add "average"…
Pranav Sathyan
  • 1
  • 1
0
votes
2 answers

What is the best way to "Cut & Paste" the contents of one array into another array in JavaScript?

I've been using all of these methods to accomplish this, but I don't know which one is best practice from a professional standpoint. Am I missing a very obvious way to do this? One that everybody ...except me... uses on a daily basis? EDIT: arr1 has…
ivanle0
  • 1
  • 1
0
votes
0 answers

Simple html COPY and PASTE problem - copies button also

Sorry for the hastiness of this post I'm in a rush. I have coed below that just functions in an HTML file. It copies fine but when I paste it pastes the copy button with it. If you go to this link and earase all the css that mimics the problem Im…
Russell Hertel
  • 121
  • 3
  • 14
0
votes
1 answer

How to add vbs to paste as values?

i cant seem to get my code to paste as values, it keeps bugging out when i try changing paste to paste values original code Sub copyData() Sheets("Master - DO NOT TOUCH").Select LR = Cells.Find("*", SearchOrder:=xlByRows,…
ifwa
  • 15
  • 4
0
votes
0 answers

How to paste \ to a string in R?

I'm want to add \ to a string in R like this: paste("23", "\%", sep = "") Such that the string reads: "23\%" But I get the error: Error: '\%' is an unrecognized escape in character string starting ""\%" Any idea on to correct this? Thank you!
Sharif Amlani
  • 1,138
  • 1
  • 11
  • 25
0
votes
1 answer

Copying a Pandas Dataframe onto an existing Excel sheet

I know this has already been potentially answered elsewhere but I use the answers to tailor my issue. I have manage to merge two dataframes to look like the following: |Store number| Week 14 | Week 15 | Week 16 | …
H Card
  • 31
  • 4
0
votes
3 answers

Copying all data from a table in one tab into another tab in the same workbook based on 2 input boxes which will define a date range

i have tried many sites and am really struggling as i cant seem to understand the VBA code tab1 = data from C8:Rx? ... the data will continously grow so table will get bigger all the time Column C in tab1 contains dates 21/05/2021 I want to be able…
ifwa
  • 15
  • 4
0
votes
1 answer

Why is Excel VBA changing the date format of my pasted text?

I've recorded a macro of myself that seems to do something different when I re-run it compared to when I recorded it. My macro involves pasting a table of data into a sheet, with the table including some date and time cells. They're in the format…
Elis
  • 39
  • 1
  • 6
0
votes
1 answer

Why does Tkinter kill ability to highlight text?

I'm running ubuntu11.04, and python3 with tkinter. I've yet to check on a windows config, but whenever I have a mainloop() running and a root window open with tkinter, I can't highlight text in text edit/ gui manager stuff. It doesn't leave me…
Ponml
  • 2,917
  • 5
  • 20
  • 17
0
votes
0 answers

Combining rows of lists (or long strings) by group in R

I've got a dataframe df with research areas and journal identifiers (ISSN). Each ISSN appears several times in the dataframe and the corresponding Fields may present the same sequence of keywords, overlapping ones or totally different ones e.g. for…
Cris Urdiales
  • 13
  • 4
0
votes
1 answer

Copy/Paste not working when just one row of data filtered

I have a pivot table that I filter by "location". I then need to copy/paste from that filtered pivot table to a sheet that is named the same name as the current "location" filtered. This works perfectly fine so long as there ends up being more than…
mandeanda
  • 1
0
votes
2 answers

Create a string with special character in R

I have an issue creating a string with a special character. I have asked a similar question and I have also read answers to similar questions about my problem but I am not able to find the solution. I want to create a string character with a special…
Sss
  • 427
  • 2
  • 8
0
votes
2 answers

Why does the Range method Select work the first time but not the second

Sub History1() ' ' History Macro ' ' Dim sDate As String Application.ScreenUpdating = False sDate = Sheets("Summary").Range("P1").Value If Not WorksheetExists(sDate) Then Sheets.Add.Name = sDate End If …
Greg
  • 43
  • 3
1 2 3
…
99 100