How do I have calc create a sequence of numbers down a column in 1/8 inch increments? (Ex. 1/8, 1/4, 3/8, 1/2, 5/8, 3/4, 7/8, 1, 1 1/8...)

I am trying to create a table that counts up in 1/8 increments. I would like one value in each cell and just increase in 1/8 increments. Also I would prefer that it use 1/2 vs 4/8 on such values.

format cells using the fraction format

a1 = .125

a2 = a1 +.125

copy as needed to subsequent cells

An alternative to the simple and effective explanation of @ObrienDave is the usage of the “Fill” function in the edit menu.

  • Write in two cell beneath (or aside of) each other 0.125 and 0.250
  • Select these 2 cells
  • Open: Edit > Fill > Series
  • Now you see that Calc detects already your intention
  • Fill the end values an click OK

Note: The “Series” function only becomes visible if you have selected 2 cells. I feel that this is a bug and hope someone with knowledge on this condition leaves a comment in respect to bug or not.

I see no Sense in a “Series”-funktion with one cell as Target

You don’t have to use the Fill function. Just enter the first 2 cell, highlight them, click and hold on the little black square in the bottom right corner of the cell and pull with the mouse. It shows you the value in a little window.

@horst - thanks for this hint. Have to keep in mind!