https://bugs.documentfoundation.org/show_bug.cgi?id=156645
Bug ID: 156645
Summary: Random Loss of Database Formats
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
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.
--
You are receiving this mail because:
You are the assignee for the bug.
