Description: See attached spreadsheet. Deleting a single cell in column A takes 25 seconds. Deleting the whole column A about an hour. Steps to Reproduce: Open spreadsheet, select column A, [Delete] Actual Results: As expected with a hour's delay. Expected Results: No delay. Reproducible: Always User Profile Reset: Yes Additional Info: Delay about 20 minutes in 5.4. Same results in safe mode. Version: 7.4.2.3 (x64) / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: threaded
Created attachment 183408 [details] Exhibits bug
Created attachment 183425 [details] Sample file with TEXTJOIN instead CONCAT Seems the issue is with CONCAT function in array context. Instead TEXTJOIN is very quick doing the same. Attached sample file with TEXTJOIN
On my system, the TEXTJOIN and CONCAT versions take the same time, about 61 minutes on each. Version: 7.4.2.3 (x64) / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: threaded
Maybe OpenCL makes the difference. Seems it's not active in your configuration. Menu/Tools/Options/LibreOffice/OpenCL. With TEXTJOIN instantly. Version: 7.4.2.3 (x64) / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL
I don't understand why our experience is so different. I have taken the TEXTJOIN version you loaded and enabled OpenCL on three different versions of Libreoffice on three different hardware platforms. I get slow performance always. About an hour on Version: 7.4.2.3 (x64) / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: CL About 40 minutes on Version: 5.4.7.2 (x64) Build ID: c838ef25c16710f8838b1faec480ebba495259d0 CPU threads: 4; OS: Windows 6.19; UI render: GL; Locale: en-US (en_US); Calc: CL About 1 hour 20 minutes on Version: 7.4.0.3 (x64) / LibreOffice Community Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: CL
Created attachment 183429 [details] Sample file with INDIRECT instead INDEX Sorry, I was doing something no in the right way to test. Deleting a cell with data in column A: - 20 with CONCAT. - 18 with TEXTJOIN. The issue, I don't think it's a bug, but how the formula works to get the array to analyze the word. ROW($A$1:INDEX($A:$A;LEN(A2)), is slow, I think, because all data it's iterated inside INDEX, only to force the array with the word length. ROW(INDIRECT("1:"&LEN(A2))), also force the array, but without such calculate cost.
Thanks, that worked. I'd assumed, wrongly, that using a volatile function, INDIRECT, was slower than the non-volatile, INDEX.