Created attachment 91430 [details] sample file Problem description: Steps to reproduce: 1. click on "formula wizard" button 2. select a forumla, e.g. SUM 3. click next 4. click in the first argument textbox, select an area in the spreadsheet using mouse-drag. 5. click OK Current behavior: Instead of =SUM(A1:A2) LO creates =SUM(#REF!.A2) which is not correct Expected behavior: =SUM(A1:A2) Operating System: Windows 7 Version: 4.2.0.1 rc Last worked in: 4.1.2.3 release
Failed to reproduce this, tested using Windows 8.1 with LibreOffice Version: 4.3.0.0.alpha0+ Build ID: 8102d45911bf3c47ce7ee15d3db89b0024c3bff8 TinderBox: Win-x86@39, Branch:master, Time: 2013-12-29_09:34:00 Kind regards, Joren
Created attachment 91432 [details] screenshot of the error
Also I deleted user profile, and reinstalled 4.2.0.1 and the problem exists. My language version is czech.
Reverted to 4.1.4.2 and it works fine, no issues.
Confirmed, tested using Windows 8.1 with LibreOffice Version: 4.2.0.1 Build ID: 7bf567613a536ded11709b952950c9e8f7181a4a So, probably fixed. But lets mark it as NEW for the moment.
Release Candidate 2 is going to be released next week (https://wiki.documentfoundation.org/ReleasePlan/4.2#4.2.0_release). You might want to retest using that version :-). Kind regards, Joren
I'll try RC2 as soon as it's released.
Just tested on RC2 (4.2.0.2 windows version, build ID cd65d6220c5694ee7012d7863bcde3455c9e3c30 ) and the problem still occurs. Will check with clean profile and update ticket.
Deleted user profile, problem still occurs in RC2. Not able to insert functions arguments with mouse drag, when using the functions wizard.
Hi, Saw this very behaviour on my Linux debug build from master today. Alex
However, it wasn't with the SUM function, but SEARCH I can't reproduce with SUM on : Version: 4.3.0.0.alpha0+ Build ID: 46cf9aed39ac50219a4e8dbcf0b16359cb3644ee Alex
Hmm, tried your sheet, could not reproduce. Alex
Tried several languages and it seems to be different in different languages. I tried English-UK, Czech, German and French Search gave an error in all of those. E.g. in French, only search. SUM (somme) was OK, matrix transposition and multiplication also. In German more errors occured then in czech and english. This is very weird. Tested on Version: 4.2.0.2 Build ID: cd65d6220c5694ee7012d7863bcde3455c9e3c30
I can confirm this bug on Version: 4.2.0.3 Build ID: c63c03decdf780d8fb80823950665b782ec9ecd0 I have attached 2 screenshots of this error. Picture "function_wizard-selecting_cell" shows argument of ABS function after selecting cell by mouse. Picture "function_wizard-after_OK" shows how argument of ABS function changes after clicking OK button.
Created attachment 92714 [details] Function wizard - selecting cell by mouse
Created attachment 92715 [details] FUnction wizard - argument of function after OK
Adding Calc devs to CC. Anyone got any ideas as to what might be happening ? Alex
Taking.
Same happens using the Sum button left of the input line.
This is due to uninitialized memory, which is the reason why some experience it and some don't. Actually all references initialized as relative suffer from it. This is a blocker for Calc.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=70abaf45eac49405aee70bbad13bcda75d8a9c15 resolved fdo#73235 initialize reference flags The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review for 4-2 at https://gerrit.libreoffice.org/7634 for 4-2-0 at
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=16d0b4020a1987accea37536defb2eb0fa7dd27f&h=libreoffice-4-2 resolved fdo#73235 initialize reference flags It will be available in LibreOffice 4.2.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
4-2-0 at https://gerrit.libreoffice.org/7635
*** Bug 72962 has been marked as a duplicate of this bug. ***
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-2-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=db8d1d0fda64092188a8b4a3e7a8dead4026a780&h=libreoffice-4-2-0 resolved fdo#73235 initialize reference flags It will be available already in LibreOffice 4.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Did a quick tests on 4.2.0.4 and it seems to be working fine :)