libreoffice_annoyances
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
libreoffice_annoyances [2019.12.14 06:03] – created Steve Isenberg | libreoffice_annoyances [2021.11.22 08:34] – Steve Isenberg | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | =====LibreOffice Annoyances===== | + | <fs xx-large> |
Maybe not // | Maybe not // | ||
- | ====Spreadsheet==== | + | =====Spreadsheet===== |
- | ===Replace dates with incremented year=== | + | ====Replace dates with incremented year==== |
- | Your spreadsheet has a column with dates, say 1/2/2019 and you want to replace | + | Your spreadsheet has a column with dates, say B7 has 1/2/2019 and you want to replace |
- | - Insert new column to right of dates column | + | - Insert new column to right of dates column |
- | - Apply this formula in new column next to date you want to change. | + | - Apply this formula in new column |
- Select the cell C7 and drag down to select all rows in column C that you want to replace column B's dates | - Select the cell C7 and drag down to select all rows in column C that you want to replace column B's dates | ||
- | - Control-D (pastes the formula down the column) | + | - Control-D (pastes the formula down the column). You should see the updated dates in column C. |
- Select all of the column C cells you have changed, and copy to clipboard | - Select all of the column C 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 B7 | ||
- Edit > Paste Special > Paste Special. | - Edit > Paste Special > Paste Special. | ||
+ | - You can delete column C. | ||
+ | |||
+ | ====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/ | ||
+ | |||
+ | 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 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