Description: Hello! I have a document in format ODF. When i use vpr with round brackets then i get as results '#Н/Д', without round backets if i delete them everything ok. The problem could be solve by two ways: 1) save file to xls, 2) delete round brackets, so the bug only appears with ods. I did it reproduce in libreoffice 6.4 and 7.0 Actual Results: '#Н/Д' Expected Results: vpr value Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.0.4.2 Build ID: dcf040e67528d9187c66b2379df5ea4407429775 CPU threads: 2; OS: Linux 4.19; UI render: default; VCL: kf5 Locale: ru-RU (ru_RU.UTF-8); ИП: ru-RU Calc: threaded
Created attachment 169087 [details] vpr bag
This is not a bug. In your ODS document, you have regular expressions enabled in formulas [1]. As VLOOKUP documentation tells [2]: > The search supports wildcards or regular expressions. > ... > You can switch the automatic evaluation of wildcards or regular expression > on and off in Tools - Options - LibreOffice Calc - Calculate. Brackets have special meaning in regular expressions [3]. So with regular expressions enabled, search for string "Детские продукты (Акушерство)" actually tries to find text "Детские продукты Акушерство", and would make "Акушерство" a referenceable entity (not what you obviously expect). Excel (and its formats) do not support regular expressions, thus saving in its formats would disable regular expressions in its files. But with ODS, which supports all modes fully, if you don't need regular expressions, you need to make proper settings. Note that in later versions of LibreOffice, regular expressions are not enabled by default, partially to avoid newbies making this mistake. Closing NOTABUG. [1] https://help.libreoffice.org/7.1/en-US/text/shared/optionen/01060500.html#bm_id3154419 [2] https://help.libreoffice.org/7.1/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152 [3] https://help.libreoffice.org/7.1/en-US/text/shared/01/02100001.html
Thanks a lot!