Bug 156645

Summary:	Random Loss of Database columns' width and currency format
Product:	LibreOffice	Reporter:	David Stewart <dlpastewart>
Component:	Base	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	robert, stephane.guillou
Priority:	medium
Version:	7.3.7.2 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=139611
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108441

Description David Stewart 2023-08-07 04:11:44 UTC

Description:
There is an intermittent problem where the DataBase tables loose their format. Column Widths and Currency format. Al the data remains. It can happen to all the database tables at once or can be random to the tables.
I run a database with 17 Tables with some tables having over 2000 records.
Sometimes a just loose the currency format and some column widths and other times I loose all the currency format and widths in all tables.
All the data remains. I have tried it under Windows and Ubuntu 22.04 but makes no difference.
Initially I thought it was related to software updates as I have been using Open Office data base since 2007. This problem seems to started several years ago.
I believe the problem could be resolved that when you create a database or edit a data base you can set the field width (minimum) and format in the edit phase which will remain set to these parameters.
When the database resets the table edit shows the loss of format for currency.
The Table has 15 Forms (entering Data) and 13 Queries (on the tables).
Size of Database is 582kB
I reinstate the widths and formats which may last a month or two or be gone next time I access the database.
I use word and spreadsheets and have not encountered a problem with them.
The original database was converted from MS Access bot saved in open office formats.
I do not loose the number of decimal points.
Just now I checked one of the tables and I had lost the column width on the first 3 columns but not the remainder, currency format was also lost on the relevant columns.
Other times I loose the Column width on all columns with the currency format.
Sometimes only several tables are initially effected.

Actual Results:
Cannot reproduce with actions It seems very random.

Expected Results:
Unable to reproduce other than closing database and restarting. Sometimes okay no change to tables the all of a sudden it reoccurs.

Reproducible: Sometimes

User Profile Reset: Yes

Additional Info:
DataBase table editor to be able to set the minimum column width and formatting only. Or if changed within the table this is reflected back in the edit of the table base and remains as set.

Comment 1 David Stewart 2023-08-22 03:33:13 UTC

I accessed the DataBase several times entering data through forms.  Tables okay for about 2 weeks the lost column width and currency format in the tables.

Comment 2 Stéphane Guillou (stragu) 2023-11-19 20:22:44 UTC

Thank you for the report, David.
Can you please:
- test with version 7.6, which will see further releases, and let us know if you can still reproduce the issue
- paste here the full version info copied from Help > About LibreOffice
- let us know which kind of database you are connected to

Thank you!

Comment 3 Robert Großkopf 2023-11-20 08:31:00 UTC

Got the same behavior here with internal Firebird. But don't know how to reproduce. Just tested 2 new created database files. First is created as HSQLDB, then migrated to Firebird. Second has been created directly to Firebird. Two of about 30 Tests will show all format has been gone. Don't know why, but it hasn't been saved while saving the file this two times.

Version: 7.6.3.1 (X86_64) / LibreOffice Community
Build ID: c4af5b1259bceea6e979e6fe2435dbee7a5a87c2
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

But most of this behavior in the past I found in LO 7.4.7.2. I'm creating databases only with this LO-Versions, because there are too many bugs in creating forms in LO since LO 7.5.

Comment 4 Stéphane Guillou (stragu) 2023-11-20 10:02:55 UTC

Thanks Robert. Let's set as new then, but it would be great if we could get the extra info from David too. And any clue with reproducing would help.