Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 23 Mar 2019 02:04:44 +0100Is there a way to prevent Calc from showing hidden rows and columns when copying sheets?https://ask.libreoffice.org/en/question/187946/is-there-a-way-to-prevent-calc-from-showing-hidden-rows-and-columns-when-copying-sheets/MS Office convert here and overall very impressed with how far the LibreOffice suite has come. However one issue has us very frustrated at the moment.
We have a spreadsheet that contains a dozen hidden rows and a few hidden columns, with some behind-the-scenes formulas and values that we rarely need to see. We routinely create copies of the previous period's sheet within the same workbook and make changes to the copy. When we did this in Excel the hidden rows and columns stayed hidden. However, Calc shows all the hidden rows and columns in the newly pasted sheet, requiring us to go in and tediously re-hide each of them whenever we make a copy.
We have tried messing with the Paste Special options, but to no avail. Hoping there is a workaround we haven't noticed or thought of.
If not, modifying Calc's copy-paste code to maintain hidden rows and columns would be a nice thing for the developers to work on.
Thanks!
Jeff_SSat, 23 Mar 2019 02:04:44 +0100https://ask.libreoffice.org/en/question/187946/paste 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/Fast, easy way to move all cells within a formula?https://ask.libreoffice.org/en/question/97218/fast-easy-way-to-move-all-cells-within-a-formula/I have come across a certain issue a few times now; sometimes I find myself adding additional columns to a table in calc; let's use just 1 column as an example.
In my extra column I want to include the same formula as contained within another pre-existing column.
So, the easiest way to add this information would be to copy/paste the info from the pre-existing column using the **copy/paste special** (formulas) function.
Well the problem is that when I use this function, all of the formulas apply to different cells.
**For example:** **if the extra column was added directly to the left of the pre-existing column**, then the cells detailed in the formula will all have shifted **1 cell to the left** also. Similarly, **if the extra column was added directly to the right of the pre-existing column**, then the cells detailed in the formula will all have shifted **1 cell to the right** also.
I wonder if there is a fast and easy way to move all the cells detailed within a formula at the same time, without having to retype the cell names in the formula.
I know I can double click the cell containing the formula and then drag the coloured boxes that specify which cells are used in the formula, but even this can take a fair bit of time on some of the longer formulas.
Any ideas guys?
If anyone wants me to make this question more clear, I could upload an example document.appreciatethehelpSun, 28 May 2017 23:20:54 +0200https://ask.libreoffice.org/en/question/97218/