Apply Paste Special Arithmetic Safely in LibreOffice Calc

Paste Special can adjust numbers already in a destination instead of replacing them with the copied numbers. Use it for a deliberate one-time adjustment, not as a substitute for a live formula model. This lesson uses matched three-cell ranges, with a saved baseline and totals outside the targets.

Scope and a recoverable starting point

These instructions are for the genuinely free LibreOffice Calc desktop application, using its English standard menus. They follow Calc Guide 26.2 and online Help labeled 26.8, checked on 22 October 2026. Windows/Linux menu names are used; this is not a claim about a web edition or another spreadsheet product. Arithmetic and coordinate mappings were independently checked. Native execution, screenshots and save/reopen behavior remain untested.

Create a disposable ODS workbook with a sheet named Adjustments. Type this table into A1:E4. D3 must be genuinely empty: do not type the words “leave empty”, a space, or a formula returning empty text.

Row	A: Item	B: Baseline	C: Adjustment	D: Multiplier	E: Divisor
2	Folders	80	7	2	2
3	Binders	120	-5	leave empty	4
4	Labels	200	12	3	5

Enter separate destination constants as follows:

• F1 = Add result; F2:F4 = 80, 120, 200.
• G1 = Subtract result; G2:G4 = 80, 120, 200.
• H1 = Multiply result; H2:H4 = 80, 120, 200.
• I1 = Divide result; I2:I4 = 80, 120, 200.
• F6 = =SUM(F2:F4); G6 = =SUM(G2:G4); H6 = =SUM(H2:H4); I6 = =SUM(I2:I4).
• J2 = DO NOT CHANGE.

Each total initially equals 400. Save a baseline copy before proceeding. There are no filtered, hidden or merged rows, and no formulas inside F2:I4. Inspect the input line to confirm that these targets contain numbers, not references to B2:B4.

Set the dialog once, inspect it before every application

Copy the source range stated in each experiment, select the stated target’s first cell, and choose Edit → Paste Special → Paste Special. Keep Run immediately off. Clear Paste all; select only Numbers under the component selection. Leave Formulas, Formats and other components off. Keep As Link and Transpose off, and Shift Cells at Don’t shift. Choose the experiment’s operation and blank-cell setting before clicking OK.

These controls are documented in the Calc Guide editing chapter. Use cells copied from this workbook, not text copied directly from this article, when opening the dialog.

Compare addition and subtraction

Copy C2:C4, target F2, choose Add, with Skip empty cells enabled. Expected F2:F4: 87, 115, 212; F6: 414.

Copy C2:C4 again, target G2, choose Subtract, with Skip empty cells enabled. Expected G2:G4: 73, 125, 188; G6: 386. In particular, 120 minus -5 is 125. This is destination minus clipboard, not clipboard minus destination.

B2:B4 must still be 80, 120, 200. All four totals in row 6 must still be formulas, and J2 must retain its text. Neither source changes nor a correct grand total alone prove every row is correct: compare each item with its corresponding result.

Multiply while leaving a missing adjustment alone

Copy D2:D4, target H2, choose Multiply, and enable Skip empty cells. Expect H2:H4 = 160, 120, 600, totaling 880. The blank D3 means no multiplication is applied to H3 in this configuration.

For a controlled failure test, first undo that paste and verify H2:H4 is back to 80, 120, 200. Recopy D2:D4 and repeat Multiply into H2 with Skip empty cells off. Expect 160, 0, 600, totaling 760: the blank is treated as zero. Undo immediately, confirm the baseline, and repeat with the option enabled to restore 880.

Paste Special Help documents both blank-source cases. An actual zero is not a blank: replacing D3 with 0 would make H3 zero even when Skip empty cells is enabled. Keep D3 empty for the finished example.

Divide in the right direction

Copy E2:E4, target I2, choose Divide, with Skip empty cells enabled. Expect 40, 30, 40, totaling 110. The operation is destination divided by clipboard: 200 / 5 = 40, not 5 / 200. All three divisors are nonzero; do not use this fixture to infer treatment of zero divisors or text.

Prove that this is a one-time edit

Change C2 from 7 to 9. F2 should remain 87, not become 89: the earlier paste is not a live link. To apply the new adjustment exactly once, first restore F2:F4 to the baseline constants 80, 120, 200, then copy C2:C4 and repeat Add into F2. Expect 89, 115, 212, total 416.

Restore C2 to 7, restore F2:F4 to baseline again, then reapply Add to finish at 414. Repeating Add on already-adjusted values compounds the change. For example, applying the original 7, -5, 12 twice would produce 94, 110, 224, total 428. A second paste is not a refresh command.

Troubleshooting and final acceptance

• If the dialog lacks the component and arithmetic controls, cancel and copy the actual Calc source cells again.
• If multiplication clears a row, inspect both the source cell and Skip empty cells before retrying from the baseline. A space or ="" is outside this numeric-and-genuinely-empty fixture.
• If results move or overwrite neighbors, undo and recheck target address, three-row footprint, Transpose and Shift Cells. Reopen the baseline if undo history is uncertain.
• If the data should respond to future inputs, keep formulas in a separate report instead. See values, formats and transposed pastes for those different workflows.

Save the finished practice copy as ODS, close and reopen it, then inspect the complete columns and the totals 414, 386, 880, 110. Confirm the original baseline column, blank D3, row-6 formulas and J2. These are user acceptance checks, not claimed native test results. This lesson does not establish behavior for formula targets, mixed data types, filtered ranges or cross-format export.