Differences

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

--- libreoffice_annoyances [2021.12.22 10:51] – external edit 127.0.0.1
+++ libreoffice_annoyances [2022.12.05 13:05] (current) – [Replace dates with incremented year] Steve Isenberg
@@ Line 4: / Line 4: @@
 =====Spreadsheet=====
 ====Replace dates with incremented year====
-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.
+Your spreadsheet has a column with dates, starting with say A4 with 1/2/2019 and you want to replace the dates in the this and the rest of the column with the next year, e.g., 2020.
-  - Insert new (temporary) column to right of dates column (new and blank column B)
+  - Insert new (temporary) column to right of dates column (it's a new and blank column B)
-  - Apply this formula in new column B next to the first date you want to change.  Say column A row 7 has 1/2/2019.  Put this formula in column B row 7: <code>=DATE(year(A7)+1,month(A7),day(A7))</code>
+  - Apply this here formula in new column B next to the first date you want to change.  Say column A row 4 has 1/2/2019.  Put this formula in column B row 4: <code>=DATE(year(A4)+1,month(A4),day(A4))</code>
-  - Select the cell B7 and drag down to select all rows in column B that you want to use to replace column A's dates
+  - Select the cell B4 and drag down to select all rows in column B 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 this new column B.
   - Select all of the column B cells you have changed, and copy to clipboard
-  - Put cursor in first date you want to change, that is, in cell A7
+  - Put cursor in first date you want to change, that is, in cell A4
-  - 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 ''Paste all'' is **not** checked and ''Formula'' is **not** checked.  Paste.  OK the overwrite.
   - You can now safely delete this column B.