Description: Hello, this is a long lasting nuisance of Base when PostgreSQL databases are used, with somewhat different behaviour from version to version. Whenever some format is applied to a column, either dates, percentages or other numeric fields, under some circumnstances the formatting get lost after saving, closing and reopening the Base file. Since version 7 the behaviour seem to have become somewhat stable, in the sense that any previous formatting get lost on save for any table which is not currently open. I.e. apply some formatting to table A, then save and close the file, open again, apply some formatting to table B without opening table A, save and close again, reopen, formatting on table B is retained, formatting on table A get lost most of the times. With previous versions the behaviour was somewhat erratic, with some versions seldom losing any formatting and others loosing almost everything on every save. Don't remeber exactly which version was better and which one was worse, but I'm sure there have been some which had almost no problems. Hope it helps, and thanks for this excellent software. Steps to Reproduce: 1. Create a Base file connected to a PostgreSQL DB with at least two tables, let's say A and B, with columns which could be formatted (date or numeric columns for example) 2. Open table A and apply some formatting to a column 3. Save while table A is open then close the file 4. Open the file again 5. Open table B without opening table A and apply some formatting 6. Save while table B is open and close the file 7. Open the file again 8. Open table A and you will see that the preciously applied formatting get lost most of the times Actual Results: Applied formatting get lost. Expected Results: Applied formatting is retained between subsequent saves. Reproducible: Sometimes User Profile Reset: No Additional Info: Version: 7.0.1.2 (x64) Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452 CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: it-IT (it_IT); Interfaccia utente: it-IT Calc: threaded I never checked if this happens also on Linux. Could do it if needed. Didn't try to reset the UserProfile, but over the years this problem happened on at least three different computers and even after few reinstalls, so I doubt it could be a UserProfile issue.
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,
Dear Denis Sbragion, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Dear QA Team, I can confirm this bug is still present with the following version: Version: 25.8.1.1 (X86_64) Build ID: 54047653041915e595ad4e45cccea684809c77b5 CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: it-IT (it_IT); UI: it-IT Calc: CL threaded I will check as soon as possible also with the latest one (25.8.3) and may be also with OOo era versions and Linux again. Hope it helps. Bye, Denis Sbragion
Confirmed with: Version: 25.8.3.2 (X86_64) Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: it-IT (it_IT); UI: it-IT Calc: CL threaded Under Debian Bookworm there's this version: Version: 7.4.7.2 / LibreOffice Community Build ID: 40(Build:2) CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Debian package version: 4:7.4.7-1+deb12u9 Calc: threaded Don't know if I'm doing something wrong, but it doesn't let me change columns formats. Right clicking on the column headers show no context menu at all, so I haven't been able to test. Testing with older versions will take some time.
Could confirm the buggy behavior with Version: 25.8.3.2 (X86_64) Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded Changed format, saved Base-file. Opened the table again - format is there. Closed the Base file, closed LO, reopened LO and reopend Base file: Format has been gone in the table. Note: Changed width of the column also - has been saved right.