Insert automatic list of sequential integers

Discuss the spreadsheet application

Insert automatic list of sequential integers

Postby david7365 » Thu Jan 23, 2020 6:36 pm

I would like to insert an automatic list of sequential integers into a selected row or column. I recall that some spreadsheet programs can do this, based on an entered pattern, but I can't find any such ability in OpenOffice Calc even after lots of web searching. And could not find anything in the menu. Probably because I don't know the approved term for this feature. I also couldn't find anything in Help (it complained that I had to choose something for Java--very strange message). OO 4.1.7 on Windows 10 Home. Also wondering why Calc is so hard to use. :crazy:
david7365
 
Posts: 28
Joined: Thu Mar 22, 2012 8:59 pm

Re: Calc: Want to insert automatic list of sequential intege

Postby RoryOF » Thu Jan 23, 2020 6:50 pm

OpenOffice, being 32 bit, requires a 32 bit Java downloaded and selected in /Tools /OpenOffice /Java.

Enter your first integer in a cell, click on the cell to select it (heavy black border). In bottom right will be a small black square. Click on this and pull down as far as you want.

If you wish integers separated by a regular interval, enter the first two. Drag down to select them; the bottom cell will have the heavy border and black dot; pull that dot down and you will get the sequence.

The pull the black dot method also works across rows. Open a blank Calc file and play with this until you get familiar with it.
Apache OpenOffice 4.1.7 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31451
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Calc: Want to insert automatic list of sequential intege

Postby FJCC » Thu Jan 23, 2020 7:09 pm

There is also the menu item Edit -> Fill -> Series. You can highlight a range of cells and fill it using that menu.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7752
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Insert automatic list of sequential integers

Postby david7365 » Fri Jan 24, 2020 2:18 pm

Thank you both for your complete answers, much appreciated.

But in Help, I keep getting an error message: "The OpenOffice configuration has been changed...select the Java runtime environment..."

When I view the Java dialog box, it fills with the name of my only Java, then I click OK. I click on it but nothing happens, then click OK, But still get the error message in Help when I do a search. I would expect OpenOffice to find Java itself silently.

Also, I'm not getting email notifications of replies here. I would expect notification by default. I can't find any account settings for this.
david7365
 
Posts: 28
Joined: Thu Mar 22, 2012 8:59 pm

Re: Insert automatic list of sequential integers

Postby Zizi64 » Fri Jan 24, 2020 2:27 pm

Windows 10 Home.

Is it x32 or x64 bit version of Windows 10?
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9555
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Insert automatic list of sequential integers

Postby Villeroy » Fri Jan 24, 2020 5:25 pm

Your Windows is a 64-bit system whereas OpenOffice is 32-bit software. OpenOffice needs Java only for a few features. The help search requires Java. The help index works without, so you can find something in the F1-help without Java.

Either you download and install a 32-bit Java from https://www.java.com/de/download/manual.jsp (look for "Windows Offline") or you download https://adoptopenjdk.net/releases.html (choose Windows and x86). Then call Tools>Options>Java and select the Java which is installed in C:\Program Files (x86)\...

Or you install the successor to OpenOffice https://www.libreoffice.org/download/download/ which is availlable as 64-bit software. It hardly depends on Java and any 64-bit Java installed on the 64-bit system will do.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28573
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Insert automatic list of sequential integers

Postby Villeroy » Fri Jan 24, 2020 5:50 pm

Sequential integers can be generated by dragging down a cell with a number using the cell handle (little square at the cell's bottom-right corner).
Alternatively you can select a column with the start value on top and then Edit>Fill>Series...
Or you may use the ROW function. ROW() returns the number of the current row, ROW()-1 returns one less, ROW(A1) returns 1 because A1 is in row 1. Then drag down the formula.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28573
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 24 guests