Description: Hi folks I am a "home user" of calc / LO. In an "aerlier life i got some programming knowledge ( C ). I am german and use the german localised version of LO. SO, i might us the formula "WURZEL()" // as a translation of ROOT // to calculate any ROOT of a number. SO far so good. --------------------- A lot of "calc developers" might have some programming experiences as well and might remember ENGLISH EXPRESSIONS of a function needed. allthough the are working an a localized version (hebrew / arabic, french or what ever is thinkable. ------------- Looking for a function might be easier HAVING A SEARCH IN ENGLISH TOO /SIDE by SIDE ( english stands here for programming language experience ) IN PARALLEL to the localised versions of the function names to search for. ---------------------- FOr example: The user might look for "Wurzel()", but just remembers "SQRT()" .... Have a look to the uploadet grafics file. you will see. kind regards jk Steps to Reproduce: 1. 2. 3.eom Actual Results: eom Expected Results: eom Reproducible: Always User Profile Reset: No Additional Info: eom
Created attachment 175066 [details] description
HI again I do "state" here anyhow, that the "english funcion names" are THAT CLOSE to any known programming language, because more or less every Prog Lang is designed in ENGLISH. regards jk
Agree, the localized/translated function is not always the way a user is going to identify the desired function. Could either extend the listing (with no-translate marks for the en-US core function names); or provide the Function Wizard UI with a separate non-translated list box for selection?
Hi Karl, I agree with you that being able to see both the English and localized function names in Function Wizard is a nice enhancement. However what you may not know is that Calc already supports *using* English function names in otherwise localized UI. The option is at Tools > Options dialog, LibreOffice Calc > Formula > Formula Options > Use English function names. Once you enable this option, you can use SQRT() instead of WURZEL() (but not both) in your German localized Calc. I haven't checked how this option would affect the Function Wizard, though.
Hi folks seems i got it over! :-) best regards jk
Wouldn't bloat the functions list with non-localized variants but silently accept the English names when it's entered into a cell. Could also imagine a kind of auto correction from sqrt to wurzel, see bug 90074 for this. The English function names translates sqrt to wurzel and vice versa (but not always, see bug 135993). So it might be not too much effort.
While searching for both English and translated names in the Function Wizard might be possible, as we could have some control over which language a list entry belongs to and thus when selected may use the current (either localized or English) setting's name, entering arbitrary names in formulas is a bad idea. A translation's function may have the same name as an English function name but be a completely different function, and vice versa. For this, this bug's title/summary change is now what is not going to be implemented.
As for the function wizard I wouldn't over-engineer and return WURZEL when searching for SQRT. Switching the language on-the-fly might be an option. Putting all together I'm rather for WF.
(In reply to Heiko Tietze from comment #8) > As for the function wizard I wouldn't over-engineer and return WURZEL when > searching for SQRT. When I concurred in comment #4, I was thinking more like a disabled by default option in the Function Wizard UI, "Also show English function name", and displays "WURZEL [SQRT]" instead of "WURZEL" if enabled, while also matches searching for either "wurzel" or "sqrt". I have no idea how much work it would take to implement that, of course.
Hi folks -------- IT SEEMS to get recognition ! WHY !? It seems NOT to be THAT bad ! ------------------------------------ NOT BLOATING !!! Ist wantend !! by me !! ________________________________________ ________________________________________ Just :: // C style comment "side by side the table"// in the wizzard // ok during input to the sheets cell - might be more sopphisticated // IN THE WIZZARD ______________ ______________ JUST :: left side "english version" synchronised "right side localized version" // the SEARCH - functionality - on both // or that way _____________ _____________ NO INTERNALS seem to me !! have to be modified !! ------------- ------------- In the wizzard ONLY a " DUBBLE NECK" // of a guitar // is needed. The display window (right side where as the usage of the funcion is enhanced) should be as is is in localised application. _____________ JUst the tables of the function names parallel side by side "programmer knowledge" beside "localised" the search::: on left / on right / on both ....... regards >>>>>>>>>>>>> Search left - Search right SQRT() - Wurzel() //both synchronised in result// MAIN result in "DETAIL WINDOW displayed in localised language" >Problem to be solved was just "FINDING FUNKTION NAME" ----------------------------------------- best wishes jk
NO over engenier NO bloating ! JUST for example __ point to - look - or serch- left // if you find your "C" // LO // - language expression point to - look - or search right // if you have any idea for YOUR language A DOUBLE (synchronised) TAB SEARCH // NOT MORE ! ---------------------------------- Sorry for my pure english and "software designing ... " regards jk
Hi folks EVERY thing seem ON BOARD ! anyhow on BOARD. BAD in a BLOATED LIST:: SQRT() WURZEL() in a selection! ----------------------- GOOD in A TWO BODIES LIST: (the left displays the appropriate of the right synchron, if action is done at the right- the right displays the appropriate of the left, if // search / find / figure out // is done there as well WIZZARD :: SELECT/FIND/SEARCH(LEFT) ||||| SELECT/FIND/SEARCH(RIGHT) s ||||| w SQRT wurzel Super WHYNOT .. .. .. .. . . . . #NOW, im and the end: https://www.youtube.com/watch?v=ZeMlQEWEg2Q best wishes to all jk