[Libreoffice-bugs] [Bug 139611] New: FILESAVE: LibreOffice Base doesn't retain column formats on file save for PostgreSQL connected databases

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139611

            Bug ID: 139611
           Summary: FILESAVE: LibreOffice Base doesn't retain column
                    formats on file save for PostgreSQL connected
                    databases
           Product: LibreOffice
           Version: 7.0.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: d.sbragion at neomerica.it

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210114/f40a40c7/attachment-0001.htm>