Created attachment 197568 [details] The document downloaded from the given URL on 2024-11-12 You can download the Ukraine Support Tracker Data document here: https://www.ifw-kiel.de/publications/ukraine-support-tracker-data-20758/ STEPS TO REPRODUCE: 1. open the attached document (or download it from above URL) 2. click on the "Aggregates by Country Group" tab 3. notice several cells display #VALUE! instead of a number as expected Libreoffice version: Version: 24.8.2.1 (X86_64) / LibreOffice Community Build ID: 480(Build:1) CPU threads: 32; OS: Linux 6.11; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 4:24.8.2-0ubuntu1 Calc: threaded
Sorry, which cells show the problem? I can't reproduce the issue, all cell has a numeric value, even after allow to update the external links. Version: 24.8.3.2 (X86_64) / LibreOffice Community Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Repro with Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 7a7ba9cbee91485a9254949d1594352b3629c070 CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded E14, E15, F14, F15, I14,I15, J14, J15 = #VALUE! . Function SUMIFS. No repro with Version: 7.3.7.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: cs-CZ Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.7 Calc: threaded
Just as a side note: This document is very slow to open in 25.2 comparing with 7.3. This document could be used to improve performance. In fact, I didn't wait to open in 25.2, too much time. Version: 7.3.7.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: ro-RO Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.7 Calc: threaded Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 315180b2a3977aadb0de3ff6d20774e87eaf9ffd CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
Sheet 'Bilateral Assistance, MAIN DATA' has many calculations that massively rely on Excel internal error types (formula expressions using the TYPE() function), for example in columns K to S, which for example in row 686 instead of some expected calculated values produce #VALUE! errors because the Calc error classification may be different from Excel so a TYPE(J686)=2 condition may not match expectations. This will probably be never fixed for all cases as Calc has a finer granularity of error values. When loaded in 7.3.7 the document is not recalculated hence displays stored values, recalculating hard with Shift+Ctrl+F9 similarly takes a very long time, and afterwards displays equally #VALUE! results. The only difference is that in newer versions recalculation may be forced on more conditions than in earlier versions. For this, classifying this bug as regression is wrong.
(In reply to BogdanB from comment #3) > Just as a side note: > This document is very slow to open in 25.2 comparing with 7.3. This document > could be used to improve performance. > > In fact, I didn't wait to open in 25.2, too much time. > See bug 163872