https://bugs.freedesktop.org/show_bug.cgi?id=50118
joaquin <narebeest...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |narebeest...@yahoo.com
--- Comment #1 from joaquin <narebeest...@yahoo.com> 2012-06-23 04:59:29 PDT ---
Same for "JAREN()" instead of "YEARS()", still there in release 3.5.4
How to reproduce:
- install LibreOffice
- install the Dutch language pack (and or other languages)
- start LibreOffice
- select "Use English function names" under "LibreOffice Calc" -> "Formula"
- create a spreadsheet and use some functions e.g.
=YEARFRAC(DATE(2002;6;3);TODAY();1)
=YEARS(DATE(2002;6;3);TODAY();0)
- save the spreadsheet
- change the "Language of" "User interface" in to "Dutch" under "Language
Settings" -> "Languages"
- restart the application
- open the saved spreadsheet
- see that the formulas now look like:
=JAAR.DEEL(DATE(2002;6;3);TODAY();1)
=JAREN(DATE(2002;6;3);TODAY();0)
So there is a mixture of English and translated function names. It does not
matter when you change the "Formula preference", the combination of "English
function names" and a different language for the UI is not showing/using 100%
of the function names in English.
Other languages tested:
Afrikaans (seems to have no translated functions, Afrikaans without "Use
English function names" gives the same result):
=YEARFRAC(DATE(2002;6;3);TODAY();1)
=YEARS(DATE(2002;6;3);TODAY();0)
German:
=BRTEILJAHRE(DATE(2002;6;3);TODAY();1)
=JAHRE(DATE(2002;6;3);TODAY();0)
Spanish:
=FRAC.AÑO(DATE(2002;6;3);TODAY();1)
=AÑOS(DATE(2002;6;3);TODAY();0)
==> seems unrelated to the default decimal separator: Afrikaans is using a ".",
zo is the combination Spanish with a regional setting of "Puerto Rico" (or any
Spanish-speaking north- or middle American country, Mexico - Panamá) instead of
Spain or any Spanish-speaking continental south American country, it still
shows años.
Does this depend on the UI translation? Can this not be implemented independent
from the selected UI? In fact, al languages should behave the same as Afrikaans
;-) (i.e. like there are no translated functions available at all).
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
