Ask Your Question
0

How to fill cells with numbers in between the numbers.

asked 2019-08-23 11:30:27 +0200

HIHIHIHIHIHd gravatar image

updated 2019-08-23 11:34:55 +0200

Hello, I want to fill multiple cells with the numbers between two numbers. For example if I have five rows that I want to fill with numbers in between 5 and 12, it would be;

5

6.75

8.5

10.25

12

I tried the [Sheet > Fill Series] thing but the final number doesn't end up being the number I entered in 'End Value'. What would be the best way to go about doing this? Thanks.

edit retag flag offensive close merge delete

Comments

1

... and your settings in the dialog were ... ? And your end result was exactly ... (which)?

E.g., when I select the 5 cells in a column, and put "Direction: Down", "Series Type: Linear", "Start value: 5", "End Value: 12", "Increment: 1.75" in the SheetFill CellsFill Series dialog, I get exactly the result you wanted...

Mike Kaganski gravatar imageMike Kaganski ( 2019-08-23 11:37:06 +0200 )edit

Hello, I can of course set the increment myself but I want Calc to do that for me because I will be using this for numbers other than just 5 and 12. Thanks.

HIHIHIHIHIHd gravatar imageHIHIHIHIHIHd ( 2019-08-23 11:49:53 +0200 )edit

So, it seems that your question is an enhancement request to allow only fill two boxes (currently you may fill just Start and Increment, and have it filled; but not Start and End, or End and Increment)... - that should be filed in another place.

Mike Kaganski gravatar imageMike Kaganski ( 2019-08-23 12:11:09 +0200 )edit

Aren't there any other ways to do it without the Sheet▸Fill Cells▸Fill Series?

HIHIHIHIHIHd gravatar imageHIHIHIHIHIHd ( 2019-08-23 12:18:44 +0200 )edit

FYI: tdf#127113 was filed.

Mike Kaganski gravatar imageMike Kaganski ( 2019-08-23 12:48:30 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2019-08-23 12:29:14 +0200

updated 2019-08-23 12:30:31 +0200

If you put 5 into A1, and 12 into A5, you may put this to A2:

=A1+($A$5-$A$1)/(ROW($A$5)-ROW($A$1))

... and drag-copy to A4.

Then you even can turn the formulas to the values, e.g. using DataCalculateFormula to Value.

edit flag offensive delete link more

Comments

I wish there was a simpler way to this without having to enter the column and row for different amounts of numbers. Thanks nonetheless.

HIHIHIHIHIHd gravatar imageHIHIHIHIHIHd ( 2019-08-23 12:50:42 +0200 )edit

That's just what I have filed tdf#127113 for - for you.

Mike Kaganski gravatar imageMike Kaganski ( 2019-08-23 12:51:54 +0200 )edit

Thank you very much.

HIHIHIHIHIHd gravatar imageHIHIHIHIHIHd ( 2019-08-23 12:53:08 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-08-23 11:30:27 +0200

Seen: 28 times

Last updated: Aug 23