Beardy Star Stuff<p><span class="h-card" translate="no"><a href="https://fosstodon.org/@libreoffice" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>libreoffice</span></a></span> <br>Found the answer on this thread. <br>"Eventually I realised that, after copying and pasting the array formula, I should have pressed ‘Ctrl+Shift+Enter’ instead of just ‘Enter’. Talk about obscure input requirements. I don’t see why ‘Enter’ wouldn’t be sufficient."</p><p>Explanation:<br>"Array/matrix mode formulas calculate differently than in “normal” mode."</p><p>Thanks to <span class="h-card" translate="no"><a href="https://mastodon.online/@efialto" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>efialto</span></a></span> for your attempt to help me!</p><p><a href="https://social.coop/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>LibreOffice</span></a> </p><p><a href="https://ask.libreoffice.org/t/copy-formula-not-working/24756" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">ask.libreoffice.org/t/copy-for</span><span class="invisible">mula-not-working/24756</span></a></p>