The "To Keep Up" Wiki

A collection of information we find useful

User Tools

Site Tools


libreoffice_annoyances

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
libreoffice_annoyances [2019.12.14 06:06] Steve Isenberglibreoffice_annoyances [2021.12.22 10:51] – external edit 127.0.0.1
Line 1: Line 1:
-=====LibreOffice Annoyances=====+<fs xx-large>LibreOffice Annoyances</fs> 
 Maybe not //annoyances// but ways of getting things done. Maybe not //annoyances// but ways of getting things done.
-====Spreadsheet==== +=====Spreadsheet===== 
-===Replace dates with incremented year=== +====Replace dates with incremented year==== 
-Your spreadsheet has a column with dates, say B7 has 1/2/2019 and you want to replace the dates in the rest of the column with the next year, e.g., 2020.   +Your spreadsheet has a column with dates, say A7 has 1/2/2019 and you want to replace the dates in the rest of the column with the next year, e.g., 2020.   
-  - Insert new column to right of dates column (new and blank column C+  - Insert new (temporary) column to right of dates column (new and blank column B
-  - Apply this formula in new column next to the first date you want to change.  Say column row 7 has 1/2/2019.  Put this formula in column row 7: <code>=DATE(year(B7)+1,month(B7),day)B7))</code> +  - Apply this formula in new column next to the first date you want to change.  Say column row 7 has 1/2/2019.  Put this formula in column row 7: <code>=DATE(year(A7)+1,month(A7),day(A7))</code> 
-  - Select the cell C7 and drag down to select all rows in column that you want to replace column B's dates+  - Select the cell B7 and drag down to select all rows in column that you want to use to replace column A's dates
   - Control-D (pastes the formula down the column). You should see the updated dates in column C.    - Control-D (pastes the formula down the column). You should see the updated dates in column C. 
-  - Select all of the column cells you have changed, and copy to clipboard +  - Select all of the column cells you have changed, and copy to clipboard 
-  - Put cursor in first date you want to change, that is, in cell B7+  - Put cursor in first date you want to change, that is, in cell A7
   - Edit > Paste Special > Paste Special.  Make sure All is not checked and Formula is not checked.  Paste.  OK the overwrite.    - Edit > Paste Special > Paste Special.  Make sure All is not checked and Formula is not checked.  Paste.  OK the overwrite. 
-  - You can delete column C.+  - You can now safely delete this column B. 
 + 
 +====Give a Cell a Name and Use It Elsewhere==== 
 +It's easier to name a cell so that (a) references make sense and (b) you can move the cell but retain the reference.\\ //for example referencing payment totals when adding/deleting rows/columns around them.// 
 + 
 +How to name a cell 
 +  * Select the cell 
 +  * Upper-left corner, see the letter-number (e.g., D23) of the cell. Type the name you want in this spot (e.g., CCjan) 
 +  * Repeat as needed 
 +Alternatively you can select the cell, Sheet > Named Ranges and Expressions > Define  
 + 
 +How to use a named cell 
 +  * Select the cell to reference the name 
 +  * Type = and start to type the cell name (e.g, C j a) 
 +  * When the desired name is the only choice, press enter. 
 + 
 +Note that names can be used within formulas. 
 + 
libreoffice_annoyances.txt · Last modified: 2022.12.05 13:05 by Steve Isenberg