When Base first loads a long data set like yours it initially only loads a small subset of the data, usually about 40 or 50 rows of data. As you scroll down it gradually adds rows.
If you scroll down 100 rows or so and then scroll up, OO Base gets confused and displays all the rows with the same data!
To get things synchronized again simply jump to the last record (the button on the navigation bar with a right arrow and a vertical bar).
Then it will display the actual row count on the navigation bar and scrolling works correctly
I believe that annoyance has been fixed in Libre Office Base.
https://www.libreoffice.org/download/do ... breoffice/
If you are new to Open Office I suggest you try Libre Office which It is based on Open Office but is more actively maintained,
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11