Ask Your Question
0

copy data from one sheet to another giving zeroes

asked 2018-03-04 04:26:12 +0100

RealGomer1 gravatar image

I'm working on an Excel 2013 spreadsheet in LO 6.02.01. I got down about 11 rows and LO decided to show "0" instead of the actual value I was copying from another sheet. The values being copied are calculated values (=sum). Why isn't LO copying the actual value?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-03-04 06:34:21 +0100

Because it copies formulas, which are the actual content of the original cells. Use Paste Special if you need to paste values.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-03-04 04:26:12 +0100

Seen: 19 times

Last updated: Mar 04 '18