Hi I was doing a simple calculation in calc, please see the attached spreadsheet, and the result is wrongly displayed. In the spreadsheet, just going to write for the second row: B2=B202-E202 C2=C202-F202 D2=B2/C2 This is the same for rows 2 to 120. B,C,E,F from 202 to 321 is the input I'm using for the calculations. Steps to reproduce: * Paste the data in rows 202 to 321 from source.txt separated by spaces. * Write the formulas in B2, C2 and D2. In this moment the formula displays OK. * Select B2, C2 and D2 and pull down to do the change, now it will bug out. * After closing and opening, all formulas will be wrong. Regards
Created attachment 122805 [details] The source with the numbers
Also, I want to add that the bug only is created when pasting data from text file. If I enter the numbers manually it works ok.
Please could you attach a sample file where to reproduce the issue.
Created attachment 122820 [details] The ods file with the bug
(In reply to m.a.riosv from comment #3) > Please could you attach a sample file where to reproduce the issue. I uploaded the ods file. I forgot to upload it when reporting the bug.
Hi David, thanks for the sample. I think I can reproduce the issue only with the option: Menu/Tools/Options/LibreOffice/OpenCL - Allow use of Software Interpreter (even when OpenCL is not availaable) is enable, but not if the 'Allow use of OpenCL' is enable also. Please could you test. Even the https://bugs.documentfoundation.org/show_bug.cgi?id=94924 is solved maybe some relation with it. Win10x64 Versión: 5.1.2.0.0+ Build ID: 8896851ddb02d043f3ebcc5b27b907369f0d6730 4; Windows 6.2; TinderBox: Win-x86@62-merge-TDF, Branch:libreoffice-5-1, Time: 2016-02-11_23:47:09
Hi I tested playing with those options and found the following. In Linux, the error happens if: * Both options are turned on. * 'Allow use of software interpreter...' is on, but 'Allow use of OpenCL' is off. The bug doesn't occur when: * Both options are off. * 'Allow use of OpenCL' is on but 'Allow use of software interpreter...' is off. So it seems to have something to do with the software interpreter. I'm running libreoffice on a Intel(R) Core(TM) i7-4600U. Regards
Update The bug is still there if I recreate the file with the options turned off. I rolled back to 5.0.5.2 and in that version the bug occurs even with the opencl option disabled.
(In reply to David Zaragoza from comment #8) > Update > > The bug is still there if I recreate the file with the options turned off. > > I rolled back to 5.0.5.2 and in that version the bug occurs even with the > opencl option disabled. Have you done a hard recalc [Ctrl+Shift+F9]?
(In reply to m.a.riosv from comment #9) > > Have you done a hard recalc [Ctrl+Shift+F9]? Yes, it did not change anything.
David - there have been a number of S/W interpreter fixes in recent times. Is there any chance you can try a recent 5.1.x build, or even a 5.2.x pre-release ? I'm struggling to reproduce the steps here - although I've seen some copy/paste/import-from-CVS related formula problems in the past too. Thanks !
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20170131
Not repro with: Version: 5.2.5.1 (x64) Build ID: 0312e1a284a7d50ca85a365c316c7abbf20a4d22 CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Locale: es-ES (es_ES); Calc: group