Ask Your Question

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...) [closed]

asked 2014-10-31 03:36:34 +0200

farmskis gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-05 19:03:56.649818

2 Answers

Sort by » oldest newest most voted

answered 2014-10-31 04:07:59 +0200

ObrienDave gravatar image

format cells using the fraction format

a1 = .125

a2 = a1 +.125

copy as needed to subsequent cells

edit flag offensive delete link more

answered 2014-10-31 07:30:23 +0200

ROSt52 gravatar image

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.

edit flag offensive delete link more


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

karolus gravatar imagekarolus ( 2014-10-31 10:02:52 +0200 )edit

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 gravatar imagehorst ( 2014-11-01 22:17:26 +0200 )edit

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

ROSt52 gravatar imageROSt52 ( 2014-11-03 10:56:41 +0200 )edit

Easy to create the table for the numbers is of the digital analogues and now to catalogues of the conditions and knowledge. It the page you want help to asking the questions like that in the college paper help with intension of the beneath and functions of the more explicit.

merujeq gravatar imagemerujeq ( 2018-07-17 08:48:55 +0200 )edit

Question Tools

1 follower


Asked: 2014-10-31 03:36:34 +0200

Seen: 11,186 times

Last updated: Oct 31 '14