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
libreoffice_annoyances [2021.11.22 08:33] – [Spreadsheet] Steve Isenberglibreoffice_annoyances [2022.12.05 13:05] (current) – [Replace dates with incremented year] Steve Isenberg
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, 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 column to right of dates column (new and blank column C+  - Insert new (temporary) column to right of dates column (it's a new and blank column B
-  - Apply this formula in new column next to the first date you want to change.  Say column row has 1/2/2019.  Put this formula in column row 7: <code>=DATE(year(B7)+1,month(B7),day)B7))</code> +  - Apply this here formula in new column next to the first date you want to change.  Say column row has 1/2/2019.  Put this formula in column row 4: <code>=DATE(year(A4)+1,month(A4),day(A4))</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 B4 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 this new column B.  
-  - 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 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 delete column C.+  - You can now safely delete this column B.
  
 ====Give a Cell a Name and Use It Elsewhere==== ====Give a Cell a Name and Use It Elsewhere====
libreoffice_annoyances.1637598838.txt.gz · Last modified: 2021.12.22 11:33 (external edit)