onlyoffice · Editing · Intermediate
Enter and Fill a Checked Data Series in ONLYOFFICE
Fill number and date series, repeat constants, and undo editing mistakes with explicit checks across a month boundary.
Quick answer
Use two numeric or date seeds to establish a sequence, then fill into empty cells and check every result. Use ordinary copy for repeated constants. Test a month boundary and undo mistakes before making another edit.
Version and evidence
ONLYOFFICE Desktop Editors 10.0.0 documentation baseline, English desktop interface on Windows/Linux; official help and desktop changelog checked 2026-10-19. No native application execution or screenshots were obtained. Exact installed build, OS behavior and saved-file round trips remain manual verification requirements; hosted and mobile behavior is outside scope. The steps below are a documented procedure with independently calculated checkpoints, not a native test report. Use an editable .xlsx practice copy. Do not treat the online help as proof of every older desktop build.
A fill handle is useful only when you verify the sequence it produced. Build ticket numbers and daily dates across a month boundary, contrast a series with repeated values, and recover one ordinary editing mistake before saving. No text-pattern recognition is assumed.
Prepare the practice sheet
Create fill-series-practice.xlsx with a worksheet named Schedule. Enter Ticket, Date, Units, Owner, DoubleUnits in A1:E1. Leave rows 2–7 blank initially. Keep the workbook local so the exercise does not alter shared data.
In A2 enter 1001 and in A3 enter 1002. In B2 enter =DATE(2026,1,30) and B3 =DATE(2026,1,31), then format these cells as dates. For a literal-date seed suitable for a date-series fill, copy B2:B3 and use a values-only paste back into B2:B3. Confirm the formula bar now contains date values rather than DATE formulas. This seed preparation avoids confusing copied formulas with inferred date increments.
Fill down using two seeds
On Schedule, select A2:A3 together and drag the lower-right fill handle through A7. The intended ticket series is 1001, 1002, 1003, 1004, 1005, 1006. Select B2:B3 together and drag through B7. Expected dates are January 30, January 31, February 1, February 2, February 3, February 4 of 2026.
The month boundary is the important test. February 1 must follow January 31, with no January 32 text. The official Auto Fill help describes extending numbers or dates from at least two starting values. If your date result repeats instead, inspect whether the seeds are genuine dates and use the documented Fill series choice. Do not accept a visually date-like text string as equivalent to a date value.
Check A7 and B7 directly, then inspect every intermediate row. The six ticket numbers sum to 6021. The difference =B7-B2, entered temporarily in G2, should be 5 calendar days. A correct endpoint alone does not rule out a duplicate or skipped middle value.
Make repeated values deliberately
Enter 3 in C2. Copy C2 into C3:C7, choosing ordinary copy behavior rather than a numeric series. All six entries should remain 3, total 18. In D2 enter Alex, then copy it to D3:D7. This is repetition of a literal label, not generation of names.
In E2 enter =C2*2 and copy it down through E7. Check E3 contains =C3*2 and E7 =C7*2; every result is 6, total 36. Thus identical source values can lead to identical outputs while the copied formulas still have different row references. Inspecting only the displayed sixes would miss a mistakenly fixed reference.
Edit and undo one mistake in the same session
Select C4, replace 3 with 30, and commit the edit. E4 should immediately become 60 and the units total becomes 45. Before making any other edit, use Undo once. Inspect C4 and E4: they should return to 3 and 6, restoring totals 18 and 36. If another action was made afterward, do not blindly undo several times; explicitly re-enter 3 in C4 and check the dependent formula instead.
Now make an intentional revision: select D5, edit its label from Alex to Blair, and commit. Only D5 should change. This is the final owner assignment; do not undo it. The worksheet should contain five Alex entries and one Blair entry.
Fill horizontally with an explicit step
On the same sheet, enter Checkpoints in A10 and 5 in B10. Select B10:F10, including the four empty destination cells. Use Home → Fill → Series. Choose Rows, Linear, step 5, stop 25, and confirm. B10:F10 should read 5, 10, 15, 20, 25, summing to 75. Rows means movement across columns; Columns means movement down rows. If the installed interface differs, the two-seed alternative is to enter 5 and 10 in B10:C10, then fill right through F10.
Save the completed state and reopen
Save fill-series-practice.xlsx, close it and reopen that file. Activate Schedule. Verify ticket endpoint 1006, date endpoint February 4, units total 18, doubled-units total 36, D5=Blair, and the horizontal series through 25. G2 should still show 5 if you kept the date-span check. Reopening is a persistence check for you to perform, not an already-observed test result.
Advanced case: a step other than one
Create fill-series-step-test.xlsx with Save As. On Schedule, enter 10 in H2 and 15 in H3, select H2:H3 and fill down to H6. Expected values are 10, 15, 20, 25, 30, total 100. This checks that two seeds encode a five-unit increment rather than defaulting to one. Inspect the original A:E fixture afterward; the experiment should not touch it.
Troubleshooting
If the same pair repeats, inspect the selected seed cells and the chosen copy-versus-series action. If dates are displayed as serial numbers, apply Date formatting rather than retyping ambiguous slash dates. If only one column changes, check the fill handle selection before dragging. If a destination already contains data, stop and use empty cells: fill operations can overwrite the destination. Keep recovery experiments in their own named copy, and never expect Undo to survive a close/reopen cycle.