Description: I use the dark theme in my Ubuntu desktop environment to avoid eye strain. When I open a table in libreoffice base for data input or editing, the background of the document is dark and the font is also dark. I have tried changing the themes, icons, personalization, etc., in Tools > Options . While those options in the Options dialogue do change the fonts and document backgrounds in places like Libreoffice Calc, they do not change the fonts and document backgrounds in libreoffice Base. There is a way to fix this problem, but you have to repeat this each time you open the Table view for editing. The fix is, in the Table edit view, on the left most portion of the window (where the green arrow is that indicates which row is active, and also which indicates primary keys with key icons), right click, click on Table Format > Font Effects, and change the default text color to automatic. Steps to Reproduce: 1. In Ubuntu with Dark Mode active Libreoffice Base, create a table and input data 2. Reopen the table to view or edit the data itself 3. The font is black and the document background is black 4. Changing Libreoffice Tools > Options options does not have an effect Actual Results: Black font on dark background Expected Results: Font should follow the Libreoffice theme Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.6.5.2 (X86_64) / LibreOffice Community Build ID: 60(Build:2) CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 4:7.6.5-0ubuntu0.23.10.1 Calc: threaded
I have no dark mode for testing, but there are 2 bugs: Format for font color of the table is for default set to "Black", not to "Automatic". And if you change this value to "automatic" it won't be saved. Main bug: Font should be set to "Automatic" by default. Open any table. Set mouse left from the field names on grey border. Right mouse click → Table Format … → Font Effects Font Color is set to "Black". Choose "Automatic" and press "OK". Close the dialog, reopen the dialog. Font Color is set to "Black". You could chose other colors without any problem, but "Automatic" wont be saved at all. Could reproduce this bug for all versions I have installed. Set it to the oldest version I have tested but think it is inherited from OOo.
(In reply to Robert Großkopf from comment #1) > I have no dark mode for testing, but there are 2 bugs: > Format for font color of the table is for default set to "Black", not to > "Automatic". And if you change this value to "automatic" it won't be saved. > > Main bug: Font should be set to "Automatic" by default. > > Open any table. > Set mouse left from the field names on grey border. > Right mouse click → Table Format … → Font Effects > Font Color is set to "Black". > Choose "Automatic" and press "OK". > Close the dialog, reopen the dialog. > Font Color is set to "Black". > > You could chose other colors without any problem, but "Automatic" wont be > saved at all. > > Could reproduce this bug for all versions I have installed. Set it to the > oldest version I have tested but think it is inherited from OOo. That sounds correct. I should also add that the dark mode issue also affects the SQL edit view. SQL text has customized font colors that vary depending on the nature of the sequel. With a dark background, much of the SQL is illegible. For example, the word "SELECT" is dark blue, and on a dark themed background, the dark blue cannot be distinguished.
(In reply to contact from comment #2) > (In reply to Robert Großkopf from comment #1) > > I have no dark mode for testing, but there are 2 bugs: > > Format for font color of the table is for default set to "Black", not to > > "Automatic". And if you change this value to "automatic" it won't be saved. > > > > Main bug: Font should be set to "Automatic" by default. > > > > Open any table. > > Set mouse left from the field names on grey border. > > Right mouse click → Table Format … → Font Effects > > Font Color is set to "Black". > > Choose "Automatic" and press "OK". > > Close the dialog, reopen the dialog. > > Font Color is set to "Black". > > > > You could chose other colors without any problem, but "Automatic" wont be > > saved at all. > > > > Could reproduce this bug for all versions I have installed. Set it to the > > oldest version I have tested but think it is inherited from OOo. > > That sounds correct. > > I should also add that the dark mode issue also affects the SQL edit view. > SQL text has customized font colors that vary depending on the nature of the > sequel. With a dark background, much of the SQL is illegible. For example, > the word "SELECT" is dark blue, and on a dark themed background, the dark > blue cannot be distinguished. I was able to do an ad-hoc fix by going to Tools > Options > LibreOffice > Application Colors > SQL Syntax Highlighting and setting everything to white. That should solve most of the issues.