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?
Because it copies formulas, which are the actual content of the original cells. Use Paste Special if you need to paste values.