Created attachment 122668 [details] Test file created with MSO Excel 2013 Attached ods is created with MSO Excel 2013. Excel is not ODF conform and calculates for =MODE(6; 6; 4; 2; 2) a 6 (instead of the correct 2). Hitting a formula wizard (being in cell A1) and OK does work (calculation of LibO results in 2) Hitting instead F9, CTRL F9, or CTRL SHIFT F9 or using the menu (Data -> calculate --> recalculate) does not change the recalculation of the cell A1. Version: 5.1.0.3 Build-ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737 CPU Threads: 4; OS Version: Windows 6.2; UI Render: GL; Gebietsschema: de-DE (de_DE)
ScFiltersTest::testHardRecalcODS
Hard recalc works for me. [Ctrl+Shift+F9] Win10x64 Version: 5.0.5.2 (x64) Build ID: 55b006a02d247b5f7215fc6ea0fde844b30035b3
Hard recalc works for me. [Ctrl+Shift+F9] Win10x64 Version: 5.1.1.1 (x64) Build ID: c43cb650e9c145b181321ea547d38296db70f36e CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL;
might be bug 97369, fixed for 5.2.0 and 5.1.1. ?
In my opinion, it does not matter that this function returns in this example. Both answers are not correct. The function must return two numbers: 2 and 6. It is the multimodal characteristic of the function. https://en.wikipedia.org/wiki/Mode_%28statistics%29
@tagezi http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018722_715980110 "If there are more than one values with the same largest frequency, returns the smallest value." per ODF spec our handling is correct (and MS and Apple is wrong). Yes, mathematically you are right, but that is another story. (/me will retest the behavior later with a clean profile)
(In reply to tagezi from comment #5) > In my opinion, it does not matter that this function returns in this > example. Both answers are not correct. The function must return two numbers: > 2 and 6. It is the multimodal characteristic of the function. > > https://en.wikipedia.org/wiki/Mode_%28statistics%29 You have MODE.MULT for this. @ Dennis, did you had a try with OpenCL disbled ?
@GerardF good hint. Yeah, it seems that OpenCL ist not working on my Laptop. o.O Deactivating OpenCL and recalculating results in a "2". Is there also a blacklist for OpenCL?
I cannot believe this is opencl-related, this sheet is too small for opencl to kick in; also I don't think there is an opencl implementation for MODE. Dennis: The behaviour will be different if you save this sheet as .xlsx and when you save it as .ods. In the .xlsx case, the MODE is translated to MODE.SNGL during import, and then its computation behaves like the Excel's MODE. Obviously, when you save as .ods, no translation happens, and you'll get the LibreOffice's MODE, behaving according to the spec. Can you please double-check that it really depends on an opencl setting? If it does - can you please let me know what exactly you set where in the working case, and what in the non-working case? Thank you!
Version: 5.2.0.0.alpha0+ (x64) Build-ID: 042f16a19e3d5f884759dae71264433b988df0e6 CPU-Threats: 4; BS-Version: Windows 6.19; UI-Render: GL; TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2016-03-16_10:03:38 Gebietsschema: de-DE (de_DE) i had to deactivate opencl to open calc. It simply crashed always :-( I guess my driver or my laptop intel card is not supported any more. @MMeeks: what do you need from me
OpenCL platform Name: Intel(R) OpenCL Vendor: Intel(R) Corporation OpenCL version: OpenCL 1.2 Extensions: cl_intel_dx9_media_sharing cl_khr_3d_image_writes cl_khr_byte_addressable_store cl_khr_d3d11_sharing cl_khr_depth_images cl_khr_dx9_media_sharing cl_khr_gl_sharing cl_khr_global_int32_base_atomics cl_khr_global_int32_extended_atomics cl_khr_icd cl_khr_local_int32_base_atomics cl_khr_local_int32_extended_atomics cl_khr_spir OpenCL device Name: Intel(R) HD Graphics 4400 Version: OpenCL 1.2 Vendor: Intel(R) Corporation Compute Units: 20 Driver: 10.18.15.4256 OpenCL device Name: Intel(R) Core(TM) i7-4500U CPU @ 1.80GHz Version: OpenCL 1.2 (Build 10049) Vendor: Intel(R) Corporation Compute Units: 4 Driver: 5.2.0.10049 Extensions: cl_khr_icd cl_khr_global_int32_base_atomics cl_khr_global_int32_extended_atomics cl_khr_local_int32_base_atomics cl_khr_local_int32_extended_atomics cl_khr_byte_addressable_store cl_khr_depth_images cl_khr_3d_image_writes cl_intel_exec_by_local_thread cl_khr_spir cl_khr_dx9_media_sharing cl_intel_dx9_media_sharing cl_khr_d3d11_sharing cl_khr_gl_sharing cl_khr_fp64 success
Ha, the application doesn't crash any longer when using the up to date driver OpenCL platform Name: Intel(R) OpenCL Vendor: Intel(R) Corporation OpenCL version: OpenCL 1.2 Extensions: cl_intel_dx9_media_sharing cl_khr_3d_image_writes cl_khr_byte_addressable_store cl_khr_d3d11_sharing cl_khr_depth_images cl_khr_dx9_media_sharing cl_khr_gl_sharing cl_khr_global_int32_base_atomics cl_khr_global_int32_extended_atomics cl_khr_icd cl_khr_local_int32_base_atomics cl_khr_local_int32_extended_atomics cl_khr_spir OpenCL device Name: Intel(R) HD Graphics 4400 Version: OpenCL 1.2 Vendor: Intel(R) Corporation Compute Units: 20 Driver: 20.19.15.4312 OpenCL device Name: Intel(R) Core(TM) i7-4500U CPU @ 1.80GHz Version: OpenCL 1.2 (Build 10094) Vendor: Intel(R) Corporation Compute Units: 4 Driver: 5.2.0.10094 Extensions: cl_khr_icd cl_khr_global_int32_base_atomics cl_khr_global_int32_extended_atomics cl_khr_local_int32_base_atomics cl_khr_local_int32_extended_atomics cl_khr_byte_addressable_store cl_khr_depth_images cl_khr_3d_image_writes cl_intel_exec_by_local_thread cl_khr_spir cl_khr_dx9_media_sharing cl_intel_dx9_media_sharing cl_khr_d3d11_sharing cl_khr_gl_sharing cl_khr_fp64 success moreover now the test file which is linked above does recalculate correctly. I guess NOTOURBUG ?
Interesting - we don't use the Intel hardware driver in this case, but the software / CPU driver - since Intel H/W can't do FP64. So the relevant software versions are: bad: Driver: 5.2.0.10049 good: Driver: 5.2.0.10094 I guess we can up the version requirement there and black-list older Intel S/W drivers. Kendy ?
Should I also try to test following driver versions? 20.19.15.4300 4 (3%) 10.18.15.4281 1 (1%) 10.18.15.4279 14 (10%) 10.18.15.4278 4 (3%) 10.18.15.4274 5 (4%) 10.18.15.4268 1 (1%) 10.18.15.4256 21 (16%) 10.18.15.4248 12 (9%) (taken from http://http://www.kcsoftwares.com/dumo/view.php?uid=32542457&ProductName=Intel(R) HD Graphics Family&Company=Intel&OS=10.0 a really great freeware tool to check up-to-date drivers)
Hi Dennis; I think the normal approach is to black-list the old versions - we are optimistic that newer versions (post our release) will be kept compatible by the driver vendors =)
Tomaž Vajngerl committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4dd94c6637c503b7cf6e551a8b658a688d6a79ca tdf#97887: add Intel driver 5.2.0.10049 to blacklist It will be available in 5.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.
Tomaž Vajngerl committed a patch related to this issue. It has been pushed to "libreoffice-5-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=33a4dccfa23a653b60b81e5b1882e8228f5ad5ac&h=libreoffice-5-1 tdf#97887: add Intel driver 5.2.0.10049 to blacklist It will be available in 5.1.4. 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.
Black-listed; thanks ! =)