Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 09 Nov 2017 19:05:51 +0100paste numbers into 4 columnshttps://ask.libreoffice.org/en/question/137524/paste-numbers-into-4-columns/I want to take a column of 120 or so numbers from a spreadsheet and enter them in another spreadsheet in 4 columns.
So, the first 4 numbers would be side by side in row 1 and the second 4 numbers would be in row 2.
I have a workaround that is doable but labor intensive. I can highlight the first and 5th and 9th etc. numbers until I get to 117, and then Copy or Cut and then Paste into the new spreadsheet.
And repeat 3 more times.
I think there should be someone out there who has already figured this out.
If not, maybe I'll need to learn how to write a Macro.joeh6966Thu, 09 Nov 2017 19:05:51 +0100https://ask.libreoffice.org/en/question/137524/How do I copy and paste the formulas from multiple cells at the same time?https://ask.libreoffice.org/en/question/69597/how-do-i-copy-and-paste-the-formulas-from-multiple-cells-at-the-same-time/I have a spreadsheet with 13 pages and I want all the individual formulas from sheet 2 (labeled "Jan") cells C42:C51 to be copied to the same sells in 11 other sheets, is there a shortcut for this? I've tried copying and pasting the formulas but it always changes them and screws me up.
This is the formula I have in Jan.C41 =IF(StartHere.J72=0,"",StartHere.J72), Jan C42 has the same formula but it's referencing StartHere.J73, and so on and so forth. If I highlight Jan.C42:C51 and click copy then highlight and paste only the formulas into the next sheet, Feb.C42:51, I changes all the formulas to =IF(#REF!.J72=0,"",#REF!.J72) for C42, =IF(#REF!.J73=0,"",#REF!.J73) for C43 and so on. What am I doing wrong? Is there a way to do this without manually entering the formula into each cell in each sheet?Anov229Tue, 10 May 2016 02:04:04 +0200https://ask.libreoffice.org/en/question/69597/