Hi, Simple open the file in LibreOffice (22 MB) I tried with Excel 2010 and LibreOffice Version: 5.1.0.0.alpha1+ (x64) Build-ID: 32d4c03cba399ada807b8ec113a3928aa9e3ff7b TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2015-11-16_23:41:46 Gebietsschema: de-AT (de_AT) Version: 5.0.3.2 (x64) Build-ID: e5f16313668ac592c1bfb310f4390624e3dbfb75-GL Gebietsschema: en-US (de_AT) also not working Version: 4.3.5.2 Build-ID: 3a87456aaa6a95c63eea1c1b3201acedf0751bd5 WORKING regression The first error is in F4 but I gueess C5:F5 is also faulty which results in the rest being wrong. I uploaded the 22 MB file here: https://app.box.com/s/usrad4nglvo7za3yg7w9d9nbxaysgbve There is a screenshot of Excel included Operations used are: "+" "*" "/" and cell reference e.g. "=D2+F2". So very basic stuff. Recalculating does not help. Tested on WIn 10
For me, F4 is the same as in the Excel screenshot: 1,8333333333 Lowering severity as it is not about a crash and doesn't seem to be affecting all users. Win 7 Pro 64-bit, Version: 5.0.3.2 (x64) Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75 Locale: fi-FI (fi_FI) Version: 5.1.0.0.alpha1+ Build ID: 66d2b72667792cb18b25805387824d636e2a455c TinderBox: Win-x86@39, Branch:master, Time: 2015-11-18_02:35:53 Locale: fi-FI (fi_FI) Ubuntu 15.10 64-bit Version: 5.0.2.2 Build ID: 00m0(Build:2) Locale: en-US (en_US.UTF-8)
I can not confirm with Version: 5.1.0.0.alpha1+ Build ID: 8bde421ccec9c10fe1382ad68485852889dd4c74; win7
As the file has circular references, I think in this case, seems, it's needed to set up the iterations about 60, but verify what is the minimum you need to get the correct result, I guess the same than in excel. Menu/Tools/Options/LIbreOffica calc/Calculate/Iterative References - Iterations.
Created attachment 120762 [details] How it looks like with LibreOffice 5
Created attachment 120763 [details] With circular reference enabled @m.a.riosv :It works with the default Excel settings. Eiter I reference a cell to the left or to the top, so I think that it is NOT recursive (everything has to be calculated in a specific order. From top to bottom and from left to right. Please keep in mind, that it works correctly with an older version of LibreOffice
Created attachment 120770 [details] Reduced sample file. @Florian, opening the file after two hard recalc I get and Err:522 ->Error:circular reference, with the third hard recalc the results seems Ok. After a lot of trials to reduce the file size, I have found that the origin of the issue is OpenCL, disabling it I think solves the issue. Attached a reduced file sample, if OpenCL enable just the cell F101 makes the difference, deleting this cell and seems it works Ok again.
I don't think it is a regression, with OpenCL active the same happens in 4.3.7 and 4.4.7
Hi, You are right. Seems to be an OpenCl related bug.
@mmeeks: This is yet another "calculating wrong with OpenCL" report. Any estimate if, how and in what time frame it can be fixed on your side? As an interim measure I suggest to default the OpenCL option to disabled in all releases.
Could reproduce in 5.0.4.2, not in 5.0.5.1 or 5.1.0.2. Resolving as FIXED.