Summary: | FILESAVE: LibreOffice Base doesn't retain column formats on file save for PostgreSQL connected databases | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Denis Sbragion <d.sbragion> |
Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | minor | CC: | robert |
Priority: | medium | ||
Version: | 7.0.1.2 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Windows (All) | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=156645 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: |
Description
Denis Sbragion
2021-01-14 15:46:49 UTC
Have tested this with OpenSUSE 15.2 64bir rpm Linux and LO 7.2.0.1. Using the direct connection here. First I had problems to create a field for a date which I could format afterwords. When I don't format the field for a date when creating the table the field seem to be recognized from Base only as a field for text. Then I created another table with a field, which could be formatted later with a currency-format. I opened table a, put in some data, changed the formatting of a field, closed the table. Same with table b. Reopened the table a and the changed formatting appears. Then I closed the database file and closed LO. Reopened LO and opened the database file. Format is the format I have chosen before. When opening the odb-file I could see: The styles are saved in the content.xml-file inside the odb-file All this is detected with Linux and direct connection. Which connection do you use? Hello Robert, thanks for your feedback. I'm using a direct connection too, i.e. no ODBC/JDBC involved. BTW I'm under Windows 7, LO version: Version: 7.1.3.2 (x64) / LibreOffice Community Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1 CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: it-IT (it_IT); UI: it-IT Calc: threaded I never tried under Linux. I'll do it as soon as possible with the same database to see what happens. I have a Debian installation, which usually is a bit lagging WRT the latest release, but it could be of help anyway. Bye, Denis Sbragion Tested right now under Debian Buster, LO Version 6.1.5.2, and I confirm that in this environment it works as expected. I want to do one further test under Windows, because so far I always opened the database from an SMB network share and never tried from a local disk. But I have to switch to Windows again, so I'll add one further comment for this test. Tested again under Windows, but with the database file on a local disk. The formatting of unopened tables get lost on save, so it isn't a matter of network share vs local disk. Feel free to contact me again if you need some further help. Bye, Denis Sbragion [Automated Action] NeedInfo-To-Unconfirmed Hello, just an update, this nuisance presists on the latest version: Version: 7.5.3.2 (X86_64) / LibreOffice Community Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: it-IT (it_IT); UI: it-IT Calc: threaded Bye, |