0
The problem is in that, that when I copy selection range from LibreOffice Calc to Google Spreadsheet, the result are copied with empty rows missing. The row in the selection must have all cells empty to skip.
This behaviour did me some trouble, as the pasted data got shifted up the number rows skipped. My eye didn't catch the fact and I have got some troubles at work.
I have LibreOffice version 6. Source file is in Microsoft XLSX
format.
Could someone point me how to turn this feature off? Maybe it is a Google thing? Any advice will be appriciated.
update
Today I noticed that the copy/paste not only skips empty rows but also does skip empty columns! It is such a pain to manage.
Thanks
A dummy column with non-empty content should circumvent the issue. In the target sheet you just ignore/delete it. Cumbersome, I know. I hope you'll find a real solution. – Kamil Maciorowski – 2019-10-11T05:10:24.540
@KamilMaciorowski I do a copy/paste from pivot table. Sometimes I use
sum
as aggregate function, sometime I usecount
. In case ofsum
I can get data with nulls, so the pivot table can tune to show zeroes(hopefully). I dont know what to do in case of
count`. – Ярослав Машко – 2019-10-11T05:44:48.860