[Solved] Row numbering off

Discuss the spreadsheet application

[Solved] Row numbering off

Postby THEBookMan » Thu Jun 14, 2018 3:04 pm

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
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]
Open Office 4.1.3 Win 10
THEBookMan
 
Posts: 57
Joined: Wed Sep 30, 2015 10:03 pm
Location: GB, WI (some sort of sport team lives around here)

Re: Row numbering off

Postby RoryOF » Thu Jun 14, 2018 3:08 pm

Rows 2 - 21 may be Hidden. Unhide them.
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 27472
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Row numbering off

Postby THEBookMan » Thu Jun 14, 2018 4:32 pm

That was it.

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
THEBookMan
 
Posts: 57
Joined: Wed Sep 30, 2015 10:03 pm
Location: GB, WI (some sort of sport team lives around here)

Re: Row numbering off

Postby Villeroy » Thu Jun 14, 2018 5:02 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 25823
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 27 guests