[Solved] So simple but not! copy all find results

[dogsfor555]

how to copy and paste all the find and replace results ?

ive tried almost everything and spent 2 days now yes 2 days, im exhausted, anyone can solve this very hard to do mystery?

its not working , its highlighting them but not allowing me to copy them all

the words are highlighted but they will not copy paste them all just the first few lines in the results, and i notice that the row numbers are not highlighted only the words in the cells

i have a deadline by Friday and im getting very worried

thankyou all im here waiting, listening hoping!

[FJCC]

Are you working with Calc?

[dogsfor555]

yes calc thats right calc

[FJCC]

In the attached file, I searched for the word there, using Find All. I then copied the result with Ctrl + C and pasted into C1. Is that the kind of result you are looking for?

[dogsfor555]

not exactly you see what im trying to do is use the find tool to find many rows/cells with a certain word and then be able to copy and past them into another sheet. how do i attach files here?

[dogsfor555]

see these images one attempt it says i cannot copy multiple cells/ the find results

the other image shows the word there does get highlighted in all cells but i cannot copy them all at once, it wont allwo me

as you also see (which has some thing to do with it) is the row numbers as you see are NOT highlighted i knwo that has something to do with it

[dogsfor555]

image no 2 here

[RoryOF]

I got the result you showed - all pasted items close together. No warning about multiple selections.

[dogsfor555]

please tell me the exact way / method you are using to find the words and then the exact way you are copying them button by button etc.

[FJCC]

I get the warning about not being able to handle multiple selections if the text is in more than one column. That is, if I start with just the text in column A and then search, copy and paste, it all works. If I start with the text in both columns A and C, I get the warning when I try to copy.

I don't understand why you think the row numbers should be selected. Do you want to coy entire rows?

[RoryOF]

Find and Replace, Find All
/Edit /Copy
Click at destination
/Edit /Paste.

[dogsfor555]

im sorry i must have not been clear , yes that works but how do i grab the entire rows information's of each results not just the words typed into "find"
for example any word in the row that is in the results i want to be able to copy and paste the entire row not just the cell with the word searched for

i need the entire rows information each cell

[Villeroy]

Like so many things, this works with LibreOffice but not with OpenOffice. You may not have noticed yet, but since 10 years there is a successor to OpenOffice. OpenOffice is dead man walking, a zombie project.
https://www.libreoffice.org/discover/li ... penoffice/

----------------
With OpenOffice you can do this:
Data>Filter>Autofilter
Filter the item(s) you are looking for. Non-matching rows will be hidden.
Copy the remaining visible cells to some unfiltered cell range.

[FJCC]

Find and Replace is not the right tool for copying entire rows. Please explain your goal in more detail. What range of cells do you want to copy based on what criterion. Is it really copying the entire row if any cell in the row contains a specific word? Or do you want to copy a fixed set of columns in each row where a particular column contains the specific word?

[dogsfor555]

i think it works i tested so far and its working you guys are great how do i click thankyo to you all and click answered ?

[Hagar Delest]

You can add [Solved] at the beginning of the title in your first post (top of the topic) with the *EDIT button if your issue has been fixed.
I've done that for you.

[dogsfor555]

thank you you guys are really great