Numbering
Numbering
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.
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.
OpenOffice 3.1 in Windows 10
Re: Numbering
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.
When you do not use block, the ordering may affect only current column; it depends on personal Calc settings.
JJ ∙ https://forum.openoffice.org/pl/
LO (7.6) ∙ Python (3.11|3.10) ∙ Unicode 15 ∙ LᴬTEX 2ε ∙ XML ∙ Unix tools ∙ Linux (Rocky|CentOS)
LO (7.6) ∙ Python (3.11|3.10) ∙ Unicode 15 ∙ LᴬTEX 2ε ∙ XML ∙ Unix tools ∙ Linux (Rocky|CentOS)
Re: Numbering
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.
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
Re: Numbering
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.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
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.
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.
Re: Numbering
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...)
Next year ill use another document where it starts with 1020xxx (001, 002, 003...)
OpenOffice 3.1 in Windows 10
Re: Numbering
The difference is not +1 in this case. Your example based on some textual labelling "values", but not based on a real numeric incrementation.Code: Select all
1019009 10190010
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
Re: Numbering
Is it possible to make it like +1 ?
10190001
....
10190010
....
10190100
...
etc?
10190001
....
10190010
....
10190100
...
etc?
OpenOffice 3.1 in Windows 10
Re: Numbering
If the first data is located in the cell B1, then copy this formula into B2:
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.
Code: Select all
=IF(ISBLANK(C2;"";B1+1)
The cells in the column B will be "filled automatically", when you enter the next date value in the column C.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
Re: Numbering
Taking the request literally (and in accordance with the image showing the next number in a row where nothing was entered in column C) I would assume it cannot be done without relying on user code.
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München
Re: Numbering
Please upload your ODF type sample file here.It returns error for me.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
Re: Numbering
If reporting an error, please always give the complete error message, or (in case of a formula error like here) the error number.
In this case it surely was "Err:508" because Zizi64 had omitted a closing parenthese. His formula corrected would read
In this case it surely was "Err:508" because Zizi64 had omitted a closing parenthese. His formula corrected would read
Code: Select all
=IF(ISBLANK(C2);"";B1+1)
help (List of error codes) wrote: 508
Error: Pair missing
Missing bracket, for example, closing brackets, but no opening brackets
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München
Re: Numbering
(It seems a strange idea to me to denote the year 2019 by "1019".)Lupp wrote:If reporting an error, please always give the complete error message, or (in case of a formula error like here) the error number.
In this case it surely was "Err:508" because Zizi64 had omitted a closing parenthese. His formula corrected would readCode: Select all
=IF(ISBLANK(C2);"";B1+1)
help (List of error codes) wrote: 508
Error: Pair missing
Missing bracket, for example, closing brackets, but no opening brackets
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München
Re: Numbering
Oh yes. Sorry."Err:508" because Zizi64 had omitted a closing parenthese. His formula corrected would read
Code: Select all
=IF(ISBLANK(C2);"";B1+1)
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.