Description: When creating a Table Control subform, it is not possible to change the text size of the cells in the table or the size of the text in the column headings. Steps to Reproduce: 1.Follow the instructions in Getting Started with LibreOffice 6.0, Chapter 8, Getting Started with Base, through to all the steps in the section "Using the Wizard to Create a Form". 2. In the Form Editor window, in the Table Control subform near the bottom, notice the size of the text in the headings "Date", "FuelCost", etc. 3. Double-click on Table Control subform at the bottom of the Edit Form window. 4. Under the "General" tab, notice the Font setting contains the value "(Default)". 5. Attempt to change the value of the Font setting. 6. Exit the Properties: Table Control dialog. 7. Click on a column in the Table Control subform. For example click on Date. 8. Right-click on the Date column and select "Column...". 9. The Properties: Date Field dialog appears. 10. Look for a way to change the font. Actual Results: The font setting cannot be changed. In the Properties: Table Control dialog,clicking on the ellipses (...) button on the right brings up various fonts but selecting any of them has no effect. The value in the Font box remains unchanged and the appearance of the Table Control is unaffected. Plus there is no font setting at all in the Properties: Date Field dialog. Expected Results: It is expected that the appearance of the Table Control, including the font size for cell elements and the header cells, can be modified. Reproducible: Always User Profile Reset: No Additional Info: This issue appears to have been discussed in a two-year-old ask topic: https://ask.libreoffice.org/en/question/93797/database-subform-font-problem/ The answer suggests that selecting the column properties is the solution but I was unable to find any setting in the column properties that can change the text size. Some of the comments in the ask topic suggest that this is an old bug but I could not find an existing open bug while searching this database. I would not be upset at all if this bug ends up being a duplicate! Version: 6.2.0.3 Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62 CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3; Locale: en-CA (en_CA.UTF-8); UI-Language: en-US Calc: threaded OS: Ubuntu 18.04LTS
To be clear, the user can change the font size in a table control, which changes the font for every cell, what can not be changed (from the GUI) is the font in a particular column, row, or cell. That has always been the case. It may be appropriate to open an RFE for that added functionality however.
Created attachment 150262 [details] example with font size changed So I've attached an example form with 4 table controls on it. The font was increased in size for only the 1st table control and as you see it has changed. There are bugs here also however: only the font family and size can be changed, italics and bold, etc have no effect. the control property editor will still display (default) in the font property slot even if a custom setting is being used. Only the data rows will pick up the changed font, the column headers will not.
@Drew : I seem to recall that there are already a few reports about at least similar issues to this (font colour, for example)
I'm sorry. I did not go so far as to see if the font change for the whole Table Control had any effect - I was only looking at the font size of the column headings. I have confirmed that, yes, the cell contents are affected by the font setting for the whole table control; however, I was also confused by the fact that the Font setting displayed in the Properties: Table Control dialog remained "(Default)" rather than being updated with the new font setting shown after pressing the ellipses (...) button. I still believe that the inability to change the size of the text in the column headings of the Table Control is a problem (that's the actual problem that motivated me to open this bug) so I have changed the bug summary to more accurately describe the issue. I am wondering if the other issue I observed (i.e. the displayed font setting remaining "Default" in the table control properties dialog) might be dealt with in a separate bug. To me, this field in the Dialog should be updated with the value selected after pressing the ellipses (...) button. I would be happy to do this if nobody objects.
(In reply to Allan Macdonald from comment #4) >I would be happy to do this if nobody objects. I meant open a new bug about this
Bump: As I suggested in comment #4, my original posting was not accurate and I have modified the bug summary. I feel that the newer summary wording describes a bug, not an enhancement. Since I have not heard anything from others, I will go ahead and change the severity to normal.
(In reply to Drew Jensen from comment #2) Tested with : Version: 6.2.1.2 Build ID: 7bcb35dc3024a62dea0caee87020152d1ee96e71 Threads CPU : 4; OS : Mac OS X 10.14.3; UI Render : par défaut; VCL: osx; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded > > only the font family and size can be changed, italics and bold, etc have no > effect. Reproduced and confirmed > > the control property editor will still display (default) in the font > property slot even if a custom setting is being used. > No repro for me, I see the name and point size of the selected font under "Font" in the "Control > Properties". > Only the data rows will pick up the changed font, the column headers will > not. Reproduced and confirmed
Confirming Allan's initial report.
Dear Allan Macdonald, 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://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
With LO 7.4.2.3, changing the font property of the Table Control: - correctly changes the font (and size, color, font effects, etc.) of the data in the rows; - correctly updates the "(default)" selection to the chosen fontname and size - has no effect of table headings I could not find any way to individually format each column, nor any indication that it ought to be possible. If I understand the different comments and OPs own rewrite of the bug report summary, and assuming my observations are valid for other users, this is now "just" an RFE for adding a mechanism that allows changing the font (and font effects, etc.) of headings in Table Controls, entirely dropping the idea of per-column configuration. Version: 7.4.2.3 (x64) / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: pt-PT (pt_PT); UI: en-US Calc: threaded
Dear Allan Macdonald, 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
This bug can be reproduced in the following version: Version: 24.8.2.1 (X86_64) / LibreOffice Community Build ID: 480(Build:1) CPU threads: 24; OS: Linux 6.2; UI render: default; VCL: gtk3 Locale: en-CA (en_CA.UTF-8); UI: en-US Ubuntu package version: 4:24.8.2-0ubuntu0.22.04.1~lo1 Calc: threaded