Bug 80202 - UI: Formula completion does not stop with "(" where the formula syntax has a "."
Summary: UI: Formula completion does not stop with "(" where the formula syntax has a "."
Status: RESOLVED DUPLICATE of bug 75264
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2014-06-18 21:04 UTC by Zeki Bildirici
Modified: 2014-06-19 05:52 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Calc does not care "(" and takes as "." (28.61 KB, image/jpeg)
2014-06-18 21:04 UTC, Zeki Bildirici

Note You need to log in before you can comment on or make changes to this bug.
Description Zeki Bildirici 2014-06-18 21:04:59 UTC
Created attachment 101322 [details]
Calc does not care "(" and takes as "."

Problem description: 


If the formula syntax has a "." in its name to seperate it from derivative for example lets take STDEV and STDEV.P.

If you start typing to have "STDEV", the formula suggestion and completion will change to STDEV.P when you type the open bracket"(" like:


Screenshot can better tell the issue. 

In Calc and OO.org the traditional formula seperator was "_" i think. The new functions of Excel imported to calc are using "."

In addition, we, in Turkish locale decided to use MS Excel's locale names to make it uniform to have the chance to say "Yes, the functions are same, you may use the formula sytntax you used to" to enable more migrations to Calc...

Anyway we have many formulas localized with "." and this suggestion window can mislead the users.

Also the "." is stopping the guessing if you type =STDEV. popup does not come up and syntax help is missing.

Steps to reproduce:
1. Open Calc, type =STDEV( into a cell
2. "(" char will not stop the formula guessing

1.a - Open Calc, type =STDEV. into a cell to have STDEV.P no suggestion comes (may be there is more functions as STDEV.S and P) - or lets take WEIBULL and WEIBULL.DIST if you type to =WEIBULL.D  Calc will ignore the syntax before the dot and suggest you DCOUNT function

Current behavior:
"(" is not stopping the guessing and sytnax help
"." char to be recognized

Expected behavior:
"(" to stop the guessing and give the correct formula help
"." char to be recognized
Operating System: All
Version: release
Comment 1 Winfried Donkers 2014-06-19 05:52:36 UTC

*** This bug has been marked as a duplicate of bug 75264 ***