While I love the idea of abandoning all things Microsoft, I hate Libre Office for exactly this reason. It’s not robust enough to completely shed the competing application.
I just upgraded to 7.6.1.2, and what was a working template in 7.4 will not save the table design. There’s no information about why this error occurs or how to fix it.
To which database do you connect? There is no field type Integer [Long] available for internal HSQLDB and also for internal Firebird database. Both will show Integer [INTEGER] and both will show Text [VARCHAR]. Types for database will appear in capitalized letters.
Also MariaDB won’t show this combinations with direct connection or JDBC connection.
Also PostgreSQL won’t show type [Long] with direct connection or JDBC connection. Types here will all shown lower cased.
So I couldn’t reproduce this with
Version: 7.6.1.2 (X86_64) / LibreOffice Community
Build ID: f5defcebd022c5bc36bbb79be232cb6926d8f674
CPU threads: 6; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded
If you use any external database have a look at the driver for this database. There are many databases, which are supported by JDBC connection or ODBC connection. But not all functions for these databases are available through this drivers.