10,000 rows in DB
Col & Header rows checked
No filters on
Normal view - Row number starts @ 22,
although when I search, Rows 2 - 21 are included and found?
Can't figure out what is wrong.
Anyone help?
TNX in advance
⌡im
[Solved] Row numbering off
-
THEBookMan
- Posts: 107
- Joined: Wed Sep 30, 2015 10:03 pm
- Location: Houston, TX area
[Solved] Row numbering off
Last edited by RoryOF on Fri Jun 15, 2018 8:27 pm, edited 1 time in total.
Reason: Added [Solved] and green tick [RoryOF. Moderator]
Reason: Added [Solved] and green tick [RoryOF. Moderator]
Open Office 4.1.3 Win 10
Re: Row numbering off
Rows 2 - 21 may be Hidden. Unhide them.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
-
THEBookMan
- Posts: 107
- Joined: Wed Sep 30, 2015 10:03 pm
- Location: Houston, TX area
Re: Row numbering off
That was it.
Now how to figure out How this happened!
I don't ever use this feature, but somehow......
Thanks, Rory
⌡im
Now how to figure out How this happened!
I don't ever use this feature, but somehow......
Thanks, Rory
⌡im
Open Office 4.1.3 Win 10
Re: Row numbering off
happens when you do a lot of filtering and sorting in different places without defining database ranges.
Select your list including any header row.
Data>Define...
Give a name to the pseudo-database.
Insert new rows before you add new data.
Delete rows to remove data.
Tools>Options>Calc>General: "Expand references ..." should be turned on when mis-using a spreadsheet as a database.
Select your list including any header row.
Data>Define...
Give a name to the pseudo-database.
Insert new rows before you add new data.
Delete rows to remove data.
Tools>Options>Calc>General: "Expand references ..." should be turned on when mis-using a spreadsheet as a database.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice