Created attachment 110622 [details] Testdatabase for formatted table - format will be deleted, when changing language settings of LO Open the database. Open the table. It contains a field for currency and another field vor Voltage, which shows "Volt". Now close the database and set Tools → Options → Language Settings → Languages → Enhance language support → Ignore system input language to "No" (False/deselect), close LO and the reopen the database. The format of the table is gone. Same when changing the language of the User-Interface. Seem the language-settings would destroy all format-settings in the table.
Have tested it a little bit more: If you change the langugae under Tools you have to do change something in the database for saving new. Only opening and closing the database wouldnt rewrite the internal content.xml. For example only open the table and change the width of a column. Then you could save base. If you reopen it in most cases the format of the field (€ and Volt) will be lost. I have had a look at the language for the format of the table. When I had a first look it has been "de" (which couldn't be chosen). When I changed the the language-settings it changed to "Standard (Deutschland)". Why is there a field for languages? Don't know if there is somebody, who need this field. So there could be added something like "none". Could be this solves the problem here.
Can't confirm with regard to Tools → Options → Language Settings → Languages → Enhance language support → Ignore system input language to "No" (False/deselec as this is not selected by default in my master build OSX 10.10.1 Version: 4.5.0.0.alpha0+ Build ID: c70d907c6bac7720338207355e41724ba1e97781 Locale: fr_
Can also not confirm after changing application language to English(USA).
Also resized a field in table, saved, shut down LO, reopened file, no difference in formatting. Either fixed in master or Linux specific ?
Setting to WFM per Alex's comment. @Robert - if you could test 4.4 beta2 and and see if you still see the issue. If so can you provide information about your distro? If you can still reproduce on 4.4 beta2 or later, please set the bug to UNCONFIRMED and provide additional steps on what we expect to see. Thanks!
Created attachment 110917 [details] Wrong language in format of table Ok, seems to be a little bit tricky. I couldn't reproduce the bug whith the document I have uploaded. I couldn't send a screenshot in English, because the language would change, what I want to show: I open a table for editing, where the format was lost during changing language. There I see "Sprache → de". This language couldn't be chosen by the formatting of the field. Could be it is the language from my system ("de" - OpenSUSE 12.3, 64bit rpm Linux, KDE). This bug has been reported from another person: http://www.libreoffice-forum.de/viewtopic.php?f=10&t=14297 (only in German ...) So I tried to reproduce and get the same error. Will test how to reproduce this for everybody.
Have tested a little bit more whith opening and closing and switching input language. Then I created new tables in the database of the first attachment. Couldn't reproduce with the new, but suddenly the old table has lost the format. I got the same error with the first database I created here. Format loss there for two tables. All the same behavior, when I open the format of the table there appears the language "de", which couldn't be chosen in the listfield for languages, but is shown there, as you could see by the attached screenshot. Have got this error with LO 4.3.5.2, OpenSUSE 12.3 64bit rpm Linux, KDE. Couldn't test LO 4.4 or 4.5, because of another bug with my configuration and KDE (black menu). I will set this back to unconfirmed and hope I will get a better way to reproduce. Could be it is as tricky as the behavior of the language-settings in Bug67615.
Hello, could confirm the bug. There seems to be a general problem with localisation settings in Base (this bug and the textvarchar bug with "0" instead of "@" in the format field), and in other applications (Writer, Calc), see these bug reports: https://www.libreoffice.org/bugzilla/show_bug.cgi?id=30821 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=41044 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=84641 This bug here does not occur always, but when a base file is saved, closed and reopened several times, the chance is about 100% that all local formats of currency and date fields are forgotten. Perhaps the bug will never be reproducable on operating systems based on the english language. But it is yet important, just look at the Manifesto of The Document Foundation: "Manifesto Our values We commit ourselves: to support the preservation of mother tongues by encouraging all peoples to translate, document, support, and promote our office productivity tools in their mother tongue" Greetings Freischreiber
Oh, and my OS is Windows 7 64bit German Version using LO 4.2.6.3...
I set this to NEW. See https://bugs.freedesktop.org/show_bug.cgi?id=87151#c8
Adding self to CC if not already on
It happens in LO English (GB) LO when Database has language English (USA). 4.3.5.2release OSX-10.9.5.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.