Bug 145602 - Ctrl+Shift+Enter in cell C10 ( Recalculate/Recalculate Hard?) for string search and count
Summary: Ctrl+Shift+Enter in cell C10 ( Recalculate/Recalculate Hard?) for string sear...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-11-09 13:13 UTC by Maklyakov
Modified: 2022-05-03 11:11 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Ctrl+Shift+Enter in cell C10 (16.27 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-11-09 13:13 UTC, Maklyakov 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Maklyakov 2021-11-09 13:13:33 UTC 
Created attachment 176165 [details]
Ctrl+Shift+Enter in cell C10

Hello, I ran into a problem.
When you press Ctrl+Shift+Enter in cell C10, curly brackets do not fit into the array formula (if you change the size of the array). 


The file is located at the link https://www.planetaexcel.ru/forum/index.php?PAGE_NAME=message&FID=1&TID=89664&TITLE_SEO=89664-poisk-i-podschyet-yacheek_-v-kotorom-soderzhitsya-konkretnoe-slovo&MID=742788#message742788
Comment 1 V Stuart Foote 2021-11-09 16:23:33 UTC 
It is not clear what the issue is.

Test doc C10 cell holds "=SUM(--ISNUMBER(SEARCH("Кумыс",A2:A6)))", so assume the Ctrl+Shift+Enter is local specific for "Recalculate Hard"? Though simple <F9> would refresh.

But isn't the needed syntax for doing the string search here:

=(COUNTIF(A2:A28,"*Кумыс*"))

And this is NAB?

A helpful tutorial for COUNTIF usage is here:

https://www.libreofficehelp.com/count-cells-strings-numbers-countif-function-calc-example/
Comment 2 Maklyakov 2021-11-10 09:00:52 UTC 
The fact is that when you press Ctrl+ Shift+Enter, it does not enclose curly brackets in frames. In Excel, OK.
I attach a screen capture link https://disk.yandex.ru/i/y0ry6Fy3LAN3IA
Comment 3 m_a_riosv 2021-11-12 15:47:27 UTC 
In LibreOffice you need to do some change on the cell like adding a space to the end of the formula.
Comment 4 Maklyakov 2021-11-13 13:56:30 UTC 
Thanks, after adding a space, the formula started working