Numbering

Discuss the spreadsheet application

Numbering

Postby Agalloch » Fri Sep 13, 2019 8:35 am

Hello. At the first i am sorry for my english. So i hope you will understand what i want.

At the first, look at the picture included in attachment.

My goal /question is, how can i get "automatic line ordering" based from number 1019001 on B column. When i press enter, it ads one more number so it goes 1019002, 1019003 ..... but only on B column

Starting B3 - 10190001

Thanks for the help.
Attachments
obr.jpg
OpenOffice 3.1 in Windows 10
Agalloch
 
Posts: 7
Joined: Mon Nov 06, 2017 10:28 am

Re: Numbering

Postby Jan_J » Fri Sep 13, 2019 10:28 am

Mark both columns as a block; then sort it with respect to B.
When you do not use block, the ordering may affect only current column; it depends on personal Calc settings.
JJ ∙ http://forum.openoffice.org/pl/
LO (6.1|6.0) ∙ AOO 4.1.5 ∙ Python (3.7|2.7) ∙ Unicode 11 ∙ LᴬTeX 2ε ∙ XML ∙ Unix tools ∙ Linux (2.6|3.x) ∙ Fedora ∙ CentOS ∙ SUSE
Jan_J
 
Posts: 143
Joined: Wed Apr 29, 2009 1:42 pm
Location: Poland

Re: Numbering

Postby Agalloch » Fri Sep 13, 2019 11:55 am

Oh yea, thats my english, i already said i am not sure you will undertand. Actually I WAS WRONG.
What i wanted to ask about, is how to get something like, when i press enter so i move to B24, it adds automaticaly next number, like 10190022. B25 > 10190023 etc. I am very sorry for previous question.
OpenOffice 3.1 in Windows 10
Agalloch
 
Posts: 7
Joined: Mon Nov 06, 2017 10:28 am

Re: Numbering

Postby RusselB » Fri Sep 13, 2019 2:21 pm

Do the entries in column B always start with 101900 with the incrementing number coming after that or did you intend to have the sequence go from 1019009 to 1019010?
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5391
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Numbering

Postby Agalloch » Mon Sep 16, 2019 7:59 am

Yes. Till the end of this year. 10190xxx (001, 002, 003, 004---)

Next year ill use another document where it starts with 1020xxx (001, 002, 003...)
OpenOffice 3.1 in Windows 10
Agalloch
 
Posts: 7
Joined: Mon Nov 06, 2017 10:28 am

Re: Numbering

Postby Zizi64 » Mon Sep 16, 2019 8:24 am

Code: Select all   Expand viewCollapse view
1019009
10190010


The difference is not +1 in this case. Your example based on some textual labelling "values", but not based on a real numeric incrementation.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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: 8210
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Numbering

Postby Agalloch » Mon Sep 16, 2019 8:27 am

Is it possible to make it like +1 ?
10190001
....
10190010
....
10190100
...
etc?
OpenOffice 3.1 in Windows 10
Agalloch
 
Posts: 7
Joined: Mon Nov 06, 2017 10:28 am

Re: Numbering

Postby Zizi64 » Mon Sep 16, 2019 8:36 am

If the first data is located in the cell B1, then copy this formula into B2:

Code: Select all   Expand viewCollapse view
=IF(ISBLANK(C2;"";B1+1)


Then copy the formula down to the last cell what will be used in the future.

The cells in the column B will be "filled automatically", when you enter the next date value in the column C.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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: 8210
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Calc

Who is online

Users browsing this forum: No registered users and 36 guests