Differences

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

--- libreoffice_annoyances [2022.12.05 13:03] – [Replace dates with incremented year] Steve Isenberg
+++ libreoffice_annoyances [2025.12.09 11:48] (current) – Steve Isenberg
@@ Line 1: / Line 1: @@
+~~NOCACHE~~
+//<fs x-small>This page last changed ~~LASTMOD~~ Visits: {{counter|today| time| times}} today,
+{{counter|yesterday| time| times}} yesterday, and
+{{counter|total| time| total times}}.</fs>//
 <fs xx-large>LibreOffice Annoyances</fs>
@@ Line 11: / Line 16: @@
   - 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 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.
@@ Line 29: / Line 34: @@
 Note that names can be used within formulas.
+====Copy a cell value to cells beneath it====
+You want the same value in all of the cells that matches the value in the first cell.
+  - Click the cell with the value
+  - Copy it: ⌘+C
+  - Select the range of cells below where you want it pasted (click and drag, or click first cell, then Shift+click last cell)
+  - Paste: ⌘+V