Version 25.2.6.2, Arch Linux.
I just opened a spreadsheet that previously used array formulas extensively. They appear to have all been replaced by ordinary formulas and I am unable to create an array formula.
I have now looked at another spreadsheet, and there the array formulas are still present and working. I have also created a new spreadsheet with very simple array formulas, without problems. However, the sheet that provoked this post remains obdurate. If I press ctrl+shift+enter on an unchanged formula then nothing happens at all. If I make, then undo, a change, then press ctrl+shift+enter it behaves as if I had just pressed enter.
I’m fine with array formulas.
Version: 25.2.6.2 (X86_64) / LibreOffice Community
Build ID: 729c5bfe710f5eb71ed3bbde9e06a6065e9c6c5d
CPU threads: 6; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL threaded
You can upload the file and point to the problematic formula.
To introduce as array, something must be changed, add a space at the end of the formula and enter it as array.
I created a new sheet and copied the entire contents of the sheet with the failed array formulas. The copies of the former array formulas were still ordinary formulas but now the could be resaved as array formulas. After modifying a few range names to refer to the new sheet it functioned as the original had, so I deleted the original and renamed the new and the workbook now works as it did originally.
However, I still have no idea what may have caused the decay of the array formula or calc’s refusal to allow me to create array formulas in that sheet. I had not intentionally, nor, as far as I know, accidentally, altered any of the contents of that sheet in the interval between when the formulas worked and when I discovered that they did no longer. LibreOffice had, however, been updated at least once during that period.
In such cases, it’s crucial to save “unusual documents.” You can delete the contents of such a document and upload it to the forum. Experts can examine the document to determine the cause of the unusual behavior.
Check that the separators for your array formulas have not been changed in Tools > Options > LibreOffice Calc > Formula and match the ones in your sheets.