[Solved] How to copy formula result from cell?

Discuss the spreadsheet application

[Solved] How to copy formula result from cell?

Postby solipsist » Sat May 17, 2008 4:06 pm

Been looking around for a way to copy the result of the formula from a set of cells. All I end up with is copying the actual formula, not the result of it. I'm trying to to get the differences from different dates in an account balance in second column so I can edit the balance at different dates and use formulas to have Calc recalculate the balances subsequent to the one edited.

Thanks.
Last edited by Hagar Delest on Tue Jun 10, 2008 2:29 pm, edited 2 times in total.
Reason: tagged the thread as solved.
solipsist
 
Posts: 2
Joined: Sat May 17, 2008 4:01 pm

Re: How to copy formula result from cell?

Postby jrkrideau » Sat May 17, 2008 4:36 pm

solipsist wrote:Been looking around for a way to copy the result of the formula from a set of cells. All I end up with is copying the actual formula, not the result of it. I'm trying to to get the differences from different dates in an account balance in second column so I can edit the balance at different dates and use formulas to have Calc recalculate the balances subsequent to the one edited.

Thanks.


Copy > Paste Special > Numbers Only
LibreOffice 6.4.3.2; Ubuntu 20.04
jrkrideau
Volunteer
 
Posts: 3788
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: How to copy formula result from cell?

Postby solipsist » Sat May 17, 2008 5:26 pm

Cool, thanks. I tried Paste Special. Must have done something wrong. :)
solipsist
 
Posts: 2
Joined: Sat May 17, 2008 4:01 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 22 guests