Libre Office base does not seem to offer font. I create this as en enhancement request, indeed this is one. But font is not only about using the prettier, which I agree might not be that important for a database. The real issue is about some languages like Chinese - just assuming here some Eastern European languages, other Asian languages, and many more will fail too. They will not display properly. Characters input is fine because I can export a table to check this, but not seeing what a table contains is a blocker. I found some "Font settings for HTML, Basic and SQL sources". I would have expected this to be what I was looking for, but it does not seem to be Base (is that Calc? if so this could perhaps be used by Base too?). "Language Settings" did not help neither - nor Internet. However i found i'm not the only one to look for this.
Hello, is it this problem http://ask.libreoffice.org/en/question/48158/asian-characters-doesnt-display-in-libreoffice-base/ ?
The user seems to have the same issue that I meet, I shall try tonight to confirm changing user interface language is a workaround
@Pierre-Yves : please give a complete description of what you consider to be the buggy behaviour, as I have no idea what you are talking about. Where can you not set the font ? Which version LibreOffice ? Did it work in previous versions, if so which ones ? Have you tried with the latest production release of LibreOffice available from the TDF download page ? Which type of database are you using ? (embedded hsqldb default, firebird, mysql, postgres, etc) ? If you are using a non-embedded db, how do you connect to it (ODBC, JDBC, other driver) ? Setting to NEEDINFO pending requested information, please set to UNCONFIRMED afterwards.
Where : i want to set font which is used to display/edit SQL tables. Once a database is opened, i double click a table to open it, and characters do not display as i want them to. Version: 4.3.6.2 Build ID: 4.3.6.2-8.fc21 (thus, Linux, Fedora 21) I don't know if the features existed on previous version. According to internet, I'd say no (see below). TDF page offers version 4.4.2 https://wiki.documentfoundation.org/ReleaseNotes/4.4 does not mention any change regarding base. Sure i can compile latest "master" from git if useful. Base is HSQLDB embedded. Link from comment 1 says "I suspect a font issue", clearly the user does not find any way to change font for libre office base. http://ask.libreoffice.org/en/question/48158/asian-characters-doesnt-display-in-libreoffice-base/ Comment in below post writes "AFAIK there are no font settings for this component, but perhaps a Base expert will comment further.". http://ask.libreoffice.org/en/question/38244/how-can-i-change-the-default-font-in-all-components-of-libreoffice-for-network-organisation-deployment/?answer=38250 Here is a character example : 观. In a table it is displayed as a square.
Just tried to change user interface to simplified Chinese. As suggested in http://ask.libreoffice.org/en/question/48158/asian-characters-doesnt-display-in-libreoffice-base/ , this solves the character display, for example 观 will display properly. But I'd rather like to be able to change font without changing the user interface, so "cannot set font" still seems the right description
Pierre-Yves : please provide us with a sample ODB file with which we can test - I am assuming that the tables of your db contain Hanzi characters ?
Created attachment 115080 [details] Sample Odb Samble ODB file with corrupted display. For example, open table "Caracteres" ('characters'), record 2. This character is actually 伦, "lun", but it will not display properly unless libre office user interface is changed to Chinese.
I did attach a sample. To clarify, I believe bug title, "Cannot set font", still makes sense ; the attachment just provides an example of bad behavior related to this "missing" feature.
@Pierre-Yves : I tested your ODB file on OSX 10.10.5 with LibreOffice Version: 5.0.2.2 Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe Locale : fr-FR (fr.UTF-8) I opened each of the tables via double-click. I can see the traditional Hanzi characters in each table - non appear to be missing or misrepresented. I am using FR locale. Do you still see the same problem in your default locale interface ? As I can not reproduce this on OSX with the latest production release of LibreOffice, then it could be a Linux specific font support issue, or perhaps the issue has been fixed for all OSes. Please test again with the most recent production release and report back here.
WFM with Version: 5.0.3.2 Build ID: 1:5.0.3~rc2-0ubuntu1~trusty2 Locale : fr-FR (fr_FR.UTF-8) Linux Mint 17.3