Bug 83535

Summary: In Base all window titles and only the window titles are in Spanish instead of localization option setting
Product: LibreOffice Reporter: Paul Harouff <pharouff>
Component: DatabaseAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium CC: fitojb, iplaw67, jbfaure, serval2412, timar74
Version: 4.3.0.4 release   
Hardware: x86-64 (AMD64)   
OS: All   
Whiteboard:
i915 platform: i915 features:

Description Paul Harouff 2014-09-05 16:17:06 UTC
I'm trying to create a new Base database. All of the Tools > Options > Language Settings are set to "English (USA)". 

Every time I open a table, query, form, or report window, the title of the window appears to be in Spanish, for example:

Create Table  --> PROJECT.odb: Table1 - LibreOffice Base: desen~o de tablas
Create Query  --> PROJECT.odb: Query1 - LibreOffice Base: desen~o de consulta
Create Form   --> PROJECT.odb: Form1 - LibreOffice Base: formulario de base de datos
Create Report --> PROJECT.odb: Report2 - LibreOffice Base: generador de informes de Oracle

Note: The ~ appears over the n above. I don't speak Spanish and have no idea how to type a ~ over the n in a Bugzilla form.
Comment 1 Julien Nabet 2014-09-05 21:25:57 UTC
Is it a first install or is it an upgrade?
Comment 2 Paul Harouff 2014-09-05 21:30:34 UTC
I completely uninstalled version 3 before installing version 4.
Comment 3 Julien Nabet 2014-09-05 21:32:22 UTC
For the test, could you rename your LO directory profile (see https://wiki.documentfoundation.org/UserProfile#Windows) and give it a new try?
Comment 4 Paul Harouff 2014-09-05 22:16:47 UTC
With the new LO profile folder, the behavior was the same.

I searched both the user profile and the program folders and couldn't find a file that contained any of those words. It must be compiled somewhere.
Comment 5 Julien Nabet 2014-09-06 05:17:42 UTC
Thank you for your feedback.

In this case, I'd try the raw method:
- uninstall any LO/Apache OpenOffice/old OpenOffice version, related language packs, etc.
- remove any left directories concerning these
- remove any LO profile from 3.X.X or 4.X.X version (see https://wiki.documentfoundation.org/UserProfile#Windows)
Remark: are there several user profiles on your pc? (in case you're not the only one to use it) If yes, it would be useful to remove their LO user profile too. 
- clean your Windows registry with a free tool (eg: ccleaner)
- make sure to download last LO version from official website (http://www.libreoffice.org/download/libreoffice-fresh/)
- install again

If it still doesn't work, I must recognize I'm stuck :-(
Comment 6 Jean-Baptiste Faure 2014-09-21 18:08:19 UTC
Hi Paul,

Did you download LibreOffice from http://www.libreoffice.org or from another website ?

Best regards. JBF
Comment 7 Paul Harouff 2014-09-23 15:23:55 UTC
I did a clean installation both times. I also manually searched and cleaned the registry after uninstalling to make sure there were no orphan links left behind.

I downloaded LibreOffice_4.3.0_Win_x86.msi from the libreoffice.org site.

After uninstalling and reinstalling a few times, I verified that if I select only the English (United States) user interface language pack during installation, then the Base window titles are in English. But if I select both English (United States) and Spanish user interface language packs, the Base popup window titles are always in Spanish no matter what language is selected in Tools > Options > Language Settings.

It appears that other components -- Writer, Calc, Impress, Draw, Math -- change to the selected language. Only the titles of the popup windows inside Base appear to be broken.

There is only one profile on my workstation; but I am developing this database to be used by other employees in my firm, some who speak Spanish as their native language, which is why I had also downloaded the Spanish language pack for testing.
Comment 8 Julien Nabet 2014-10-13 18:38:07 UTC
Paul: http://www.libreoffice.org/download/libreoffice-fresh/ proposes 4.3.2 version (so 2 versions containing fixes on 4.3 branch since 4.3.0). Could you give it a try?
Comment 9 Paul Harouff 2014-10-14 17:07:07 UTC
Hmm ...

Help->Check for Updates shows "LibreOffice 4.3 is up to date."

Help->About LibreOffice shows Version: 4.3.0.4 Build ID: 62ad5818884a2fc2e5780dd45466868d41009ec0

I cannot find any explanation of what the difference is between LibreOffice Fresh and LibreOffice Still, and the Development Versions page discusses release candidates for both. The release notes for both 4.3.2 and 4.2.6 are nearly word-for-word the same, except for the note about the 4.2.6 security fix recommending that users upgrade to 4.3.1, which is even more confusing since the other download option is 4.3.2.

How am I supposed to know which version is the latest stable release, and why doesn't Help->Check for Updates tell me that I don't have the latest stable release?
Comment 10 Paul Harouff 2014-10-14 18:37:56 UTC
After delete and clean install, verified that the same behavior still exists in LO Base version 4.3.2.2.
Comment 11 Julien Nabet 2014-10-14 19:54:56 UTC
Thank you for your feedback. I must recognize I'm stuck now :-(
I put it back to UNCONFIRMED since I've got no more questions.

LibreOffice Fresh (4.3 branch) contains most recent new features "and is suited for early adopters willing to leverage a larger number of innovations.

LibreOffice Still (4.2 branch) is more conservative and will only get bug fixes (no new features) because of being more tested. 4.2.7 will be the last version of 4.2 branch.

You might be interested in the release plan:
https://wiki.documentfoundation.org/ReleasePlan
Comment 12 Paul Harouff 2014-10-14 20:27:37 UTC
Okay, let's try a more detailed click by click clean installation. Maybe something I did will help you figure out how to duplicate it.

Dell Precision T3500, Windows 7 Pro SP1, 64 bit, Intel Xeon CPU W3530 @2.80GHz

1. Run LibreOffice_4.3.2_Win_x86.msi
2. Click Next
3. Select Custom
4. Under Optional Components
     a. Deselect French dictionary
     b. Keep English and Spanish dictionaries selected
     b. Select ActiveX Control
5. Under Additional user interface languages
     a. Deselect English (South Africa)
     b. Deselect English (United Kingdom)
     c. Keep English (United States) selected
     c. Select Spanish
6. Click Next
7. Uncheck Word, Excel. Check PowerPoint, Visio.
8. Click Next
9. Check Create a start link on desktop
10. Click Install
11. When prompted select Yes to allow installation
12. Click Finish


13. Run soffice.exe
14. Create a new Base Database (HSQLDB Embedded)
15. Yes, register the database
16. Check Open the database for editing
17. Click Finish
18. Name and save the database (default New Database.odb)
19. Click Create Table in Design View
20. A popup window opens with a Spanish title:
          "New Database.odb: Table1 - LibreOffice Base: diseño de tablas"
21. Close the popup window
22. Click Create Query in Design View
23. A popup window opens with a Spanish title:
          "New Database.odb: Query1 - LibreOffice Base: diseño de consulta"
24. Close the Add Table or Query popup and close the Query popup
22. Click Create Form in Design View
23. A popup window opens with a Spanish title:
          "New Database.odb: Form1 - LibreOffice Base: formulario de base de datos"
21. Close the popup window
22. Click Create Report in Design View
23. A popup window opens with a Spanish title:
          "New Database.odb: Report1 - LibreOffice Base: generador de informes de Oracle"
Comment 13 Julien Nabet 2014-10-14 20:38:38 UTC
Thank you Paul for your new feedback.

Adolfo: have you heard about this problem? Any idea (as main contact for Spanish language)?
Comment 14 Adolfo Jayme 2014-10-15 06:39:49 UTC
This is the commit that made these titles translatable (yes, the English was hardcoded before): http://cgit.freedesktop.org/libreoffice/core/commit/?id=8f44fb5ee0bd21d192820ffd359504f6d1c68a52

By giving it a quick, initial look, I can’t tell what’s wrong there; but then again, I’m not familiar with the Base code.
Comment 15 Julien Nabet 2014-10-15 17:42:25 UTC
Paul: I retested with LO Debian 4.3.2 package, I could reproduce this!

English US UI + French for Locale Settings. (but even with English US Locale Settings)
Everything is in English except Design Table/Query/Form (Report seemed ok however but perhaps it was not translated in French).

Andras: thought you might be interested in this one.
Comment 16 Alex Thurgood 2015-01-03 17:41:15 UTC
Adding self to CC if not already on

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.