Bug 90074 - Add autocomplete for localized functions and list of equal Excel and LO formulas
Summary: Add autocomplete for localized functions and list of equal Excel and LO formulas
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: AutoCorrect-Complete
  Show dependency treegraph
Reported: 2015-03-17 22:01 UTC by Yan Pas
Modified: 2017-02-19 01:02 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Yan Pas 2015-03-17 22:01:29 UTC
There alread took place the discussions about translating formulas in CALC to different languages like it is made in Excel and it was denied. I suggest another kind of feature, autocomplete formulas. For example I use russian version of LO and type =СУМ and LO offers me to replace СУМ by SUM. I press enter and get the formula "=SUM". Everybody are happy: all formulas will be in English, Excel users will feel much more comfortable.
At least must be added article to help menu with the corresponding Local and English formulas like this to help menu https://wiki.openoffice.org/wiki/%D0%A1%D0%BE%D0%BE%D1%82%D0%B2%D0%B5%D1%82%D1%81%D1%82%D0%B2%D0%B8%D0%B5_%D0%BA%D0%BE%D0%BC%D0%B0%D0%BD%D0%B4_Excel_%D0%B8_OOo_Calc :)
Comment 1 m.a.riosv 2015-03-17 23:35:26 UTC
Hi Yan, thanks for reporting.

It's not clear for me about what are you talking about.

Functions are showed in the UI (user interface) language, except using an UI different than English, with the option in Menu/Tools/Options/LibreOffice calc/Formula - Formula Options, Use English functions names, marked.

Autocomplete works for me using the language selected for functions.
Comment 2 Yan Pas 2015-03-18 11:54:18 UTC
Well in russian LO even if the checkbox "Use English function names" is unchecked formulas will be still in English.

I have heard that formula translation in non-latin languages were declined for some reasons (maybe this langs use nonascii symbols). I will clarify what i have meant: autoreplacement of russian formula name to english name.
1)I begin to type in A1 cell "=ПРОИЗ"
2)Libreoffice offers to autocomplete ПРОИЗ to ПРОИЗВЕДЕНИЕ
3)ПРОИЗВЕДЕНИЕ is what I need, I heat enter and type arguments. A1 now looks like "ПРОИЗВЕДЕНИЕ(B1;B2)"
4)But LO doesn't support russian formulas so it automaticly replaces =ПРОИЗВЕДЕНИЕ(B1;B2) by =PRODUCT(B1;B2)

I think the algorithm is clear now.
Comment 3 m.a.riosv 2015-03-18 22:26:02 UTC
Sorry Yan, selecting Russian as UI language I can see the issue.

Seems a valid request, even maybe not so easy to achieve.
Comment 4 Yan Pas 2017-02-19 01:02:22 UTC
LO 5.3 ships russian f-las, works for me