View original (French)

Duplicate a cell in Calc

Solved
michael6907 Posted messages 3 Status Member -  
 michael6907 -
Hello,

how to duplicate a cell in LibreOffice Calc without it being incremented. Nor changing its value.
Thank you for your help

Configuration: Windows / Firefox 63.0

6 answers

Answer 1 / 6
yclik Posted messages 69 Registration date   Status Member Last intervention   1 608
 
Hello
To copy a value, click on the handle while holding down the CTRL key
3
Answer 2 / 6
michael6907
 
Here is the big solution..
it's even simpler
Thank you.
1
Answer 3 / 6
Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
 
Hello,

provided that I have understood correctly,
when you activate a cell, in the formula bar you will see either the value contained or the formula it holds, just select the formula, then click Esc to exit creation mode and right-click on the destination cell/Paste

another method
double-click on the cell containing the formula/select the formula/Esc to exit creation mode/right-click on the destination cell/Paste

and that's how it works for all spreadsheets

See you later
Mike-31

I am responsible for what I say, not for what you understand...
0
michael6907 Posted messages 3 Status Member
 
I wasn't clear in my question. I use the handle to duplicate my cell. I'll check if your solution works.
0
Answer 4 / 6
Raymond PENTIER Posted messages 58209 Registration date   Status Contributor Last intervention   17 480
 
Hello michael.

Your question is ambiguous and open to interpretations:
  • Does your cell contain text, a numeric value, or a formula?
  • Are you duplicating your cell by copying and pasting, dragging the handle, or writing a formula?

--
Retirement is great! Especially in the Antilles...
Raymond (INSA, AFPA)
0
Answer 5 / 6
michael6907 Posted messages 3 Status Member
 
Hello Raymond.
My cell contains a numeric value.
And I am using the handle to duplicate.
0
Raymond PENTIER Posted messages 58209 Registration date   Status Contributor Last intervention   17 480
 
You are not in Excel.
So forget the handle and just copy and paste.
-1
michael6907
 
Thank you for the response.
0
Answer 6 / 6
Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
 
Re,

if you increment a formula, the cell address is automatically reconsidered. You either need to use what I explained to you earlier or set your cells to absolute reference, but there you will have to be more talkative and explain your formula because from a distance it is impossible to guess and my crystal ball is broken.
In the meantime, you can do some research on relative and absolute references to help you understand.

--
A+
Mike-31

I am responsible for what I say, not for what you understand...
0
michael6907
 
Thank you
I set my cell as an absolute reference, and I use the handle, and everything works...
Best regards
0