Have to say I thought I was the only one having this problem. But after downloading the latest version I was pleased because it was working as it should for a week maybe. Careful not to open an old Libre Base file, I created an entirely new table and form. Even with closing Libre and turning off my desktop. But into the second week it went back to the same old tricks again, lost the width for each column as well as data position in the cell ( left, right, center). I have given up and am using a spreadsheet from an old version of Excell. I get the impression that Base might not be that popular or surely the knowledgeable creators would fix it.
There are not to many developers working on base… However I think you missed important lines by RobertG and Ratslinger:
So the recommended way is using forms for input. If you need a grid, there is also a grid-control to be put on the form. And there you can also re-arrange columns.
As there already is a way to reach your desired way to edit there may not be put much work into improving table-view. (I use it to check on imported data and sometimes to copy rows to spreadsheets, but for nothing else.
1 Like
If Works did everything you need, ask M$, why they do not support it…
.
The point is not Base being “newer” (I’m not so sure, as I’ve seen StarOffice first on OS/2 Warp with Adabas-Database… ), but having different concepts: For most people Works/Access “are” databases. I would describe Base as a connector to different databases, wich usually hides to Open/LibreOffice the nature of fhe file.
.
So I can query a csv-file, dBase-Table, embedded-HSQLDB, sqlite via odbc, MySQL or PostgreSQL either locally or remote on a server. As all this sources differ it limits the support you get from the connector (Base), but it also expands the possibilities you have for the Office-suite.
.
??
.
Base can access csv directly. You select connect to an existing database and set the folder with the csv-files as “the database”. The .odb will only store your connection and queries you create. The data stays in your csv.
.
Also the default hsql-embedded can attach text-tables internally for import, as described in the guide to Base (You checked the documentation on LibreOffice.org ?).
.
The mentioned way via Calc therefore is the third possibility and most connected databases have additional ways, so another option to access csv may not be the highest poriority on the list.
.
To be prepared for the future I like to have more than one option. So I use Sqlite and MariaDB with Base and LibreOffice. I can also use Tools like SqliteStudio and HeidiSQL or DBBeaver to access data and everything is available with bindings to Python, if I need to develop something on my own. So no real problem using Base - especially not, if you compare to MS-Works.