Bug 93289 - Error when using match()
Summary: Error when using match()
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.0.0.alpha0+ Master
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-08-09 01:13 UTC by Yousuf Philips (jay) (retired)
Modified: 2015-08-09 15:30 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 Yousuf Philips (jay) (retired) 2015-08-09 01:13:50 UTC 
Was reading 5.0 comments and a user brought up the issue that =match(b:b,"ghacks",0) gives an error and wanted to check if this is something known. Enabling Excel A1 syntax wasnt able to fix this issue.

http://www.ghacks.net/2015/08/05/libreoffice-5-0-is-available/#comment-3512905
Comment 1 m_a_riosv 2015-08-09 15:30:10 UTC 
Sorry but I don't understand this report from you.

Perhaps written the formula properly it could work.

=MATCH("ghacks";B:B;0)

at least it works for me.