The "To Keep Up" Wiki

A collection of information we find useful

User Tools

Site Tools

Trace:
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 [2021.11.22 08:33] – [Spreadsheet] Steve Isenberglibreoffice_annoyances [2021.11.22 08:34] – [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=====
Line 5: Line 6:
 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 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.  
   - Insert new column to right of dates column (new and blank column C)   - Insert new column to right of dates column (new and blank column C)
-  - Apply this formula in new column C next to the first date you want to change.  Say column B row 7 has 1/2/2019.  Put this formula in column C row 7: <code>=DATE(year(B7)+1,month(B7),day)B7))</code>+  - Apply this formula in new column C next to the first date you want to change.  Say column B row 7 has 1/2/2019.  Put this formula in column C row 7: <code>=DATE(year(B7)+1,month(B7),day(B7))</code>
   - 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). 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. 
libreoffice_annoyances.txt · Last modified: 2022.12.05 13:05 by Steve Isenberg