In the Function Wizard, when the character “ is typed, parenthesis and commas appear in the argument fields, delete key and backspace don’t erase and if a word is typed, is displayed backwards. Steps to reproduce: 1. Create a new spreadsheet 2. Press Ctrl + F2 or with menu Insert Function, to insert function at any cell The Function Wizard dialog displays 3. Select a function from the list, like ABS or DATEDIF, GETPIVOTDATA (preferably one with more than one argument like ACCRINT) 4. Click Next>> 5. in the argument field type “ , as if you were trying to type “Sales” the following displays: “)) 6. Typing anything else produces the displaying of more parenthesis. 7. Changing between argument fields produces more parenthesis 8. Cancel and repeat the process 9. Typing “Sales” at the first argument field produces a “saleS” backward string, the parenthesis disappear and in the Formula window below the parenthesis are still present. Typing A1 or AAA works fine, typing !, @, #, $, %, & behave normal, only when typing “, the problem is present, once typed, changing between argument fields with Tab key, produces and adds the parenthesis and commas.
Created attachment 120857 [details] Screenshoots Screenshoots of the problem with various functions
Tested Version: 5.1.0.0.alpha1+ Build ID: f6bc5b79c31225c02e9500d0ced4bd26f998f82b Threads 2; Ver: Windows 5.1; Render: default; TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-11-24_01:16:59 Locale: es-MX (es_MX)on Windows XP SP3 and Windows 10 Version: 5.1.0.0.beta1-buildfix1 Build ID: 13010a13177025f633c9b85adcb3edf6920e44e3 Threads 8; Ver: Windows 6.2; Render: default; Locale: es-MX (es_MX) on Windows XP SP3 and Windows 10
Not present on Version: 5.0.3.2 Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75 Locale: es-MX (es_MX) on Windows 10
Hi Robert, I reproduce with LO 5.1.0.0.alpha1+ Build ID: f6bc5b79c31225c02e9500d0ced4bd26f998f82b Threads 2; Ver: Windows 6.1; Render: default; TinderBox: Win-x86@39, Branch:master, Time: 2015-11-24_01:07:47 Locale: fr-FR (fr_FR) Also with LO 5.2.0.0.alpha0+ Build ID: 03c37cee476d14d1d8644ccc7ea5c69d74d9c7f9 Threads 2; Ver: Windows 6.1; Render: GL; TinderBox: Win-x86@42, Branch:master, Time: 2015-11-28_00:15:51 Locale: fr-FR (fr_FR) Not with LO 5.0.3.2 Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75 Locale : fr-FR (fr_FR) under Windows 7 Home. Notice that using editing window, " is inserted as expected and formula works. I set Status to NEW, Keywords to regression.
This seems to have begun at the below commit. Adding Cc: to Benjamin Ni ; Could you possibly take a look at this one? Thanks 18abc7c49fc637168445f32da6c936bafeb69c96 is the first bad commit commit 18abc7c49fc637168445f32da6c936bafeb69c96 Author: Norbert Thiebaud <nthiebaud@gmail.com> Date: Mon Aug 3 07:24:47 2015 -0700 source f82d89f35207fc1cfc00ad5cd914b74c55c3e3d2 source f82d89f35207fc1cfc00ad5cd914b74c55c3e3d2 author Benjamin Ni <benjaminniri@hotmail.com> 2015-07-12 14:41:55 (GMT) committer Markus Mohrhard <markus.mohrhard@googlemail.com> 2015-07-27 18:01:55 (GMT) commit f82d89f35207fc1cfc00ad5cd914b74c55c3e3d2 (patch) tdf#92546 show results for sub-expressions in formula wizard
Migrating Whiteboard tags to Keywords: (bibisected) [NinjaEdit]
Hi. Tested it with Version: 5.1.0.2 Build ID: ecd3574d51754b043f865cf5bafee286d24db7cc CPU Threads: 8; OS Version: Windows 6.2; UI Render: GL; Locale: es-MX (es_MX) On Windows 10 And is not present anymore. Fo you to confirm.
Yes, fixed. Closing the bug. Version: 5.2.0.0.alpha0+ Build ID: 0174562fa9e49bf989a571c6ccd51e558109b561 CPU Threads: 1; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@39, Branch:master, Time: 2016-01-16_00:03:18