Steps to reproduce:
1. create formula in cell using MATCH()....
Current behavior: cell shows N/A
Expected behavior:should return row no of matched cell
I also tried OFFSET() and got same response. Have not tested anymore and only use MATCH()
Operating System: openSUSE
Last worked in: 126.96.36.199 release
What formula did you enter?
Please provide a spreadsheet test with the error.
Sorry, I should have done more testing.
The formula was working in LO 188.8.131.52 as it stood but isn't working in 4.2 because the first 4 rows are blank.
The original formula was this =MATCH(TODAY(),A1:A2000) and returns the cell ref for the last cell in the range that has today's date.
If I change it in LO 4.2 to: =MATCH(TODAY(),A5:A2000)+4 - it works as I want it.
I don't know if you would still consider this a bug.
You omitted the third parameter of the formula: "type"
as help says: "If Type = 1 or if this optional parameter is missing, it is assumed that the first column of the search array is sorted in ascending order"
Anyway I see indeed a difference between :
Build ID: 70feb7d99726f064edab4605a8ab840c50ec57a
Build ID: 1a27be92e320f97c20d581a69ef1c8b99ea9885d
Steps to reproduce:
1. Open the match.ods attached in 184.108.40.206
B1 displays 6
2. Open the match.ods attached in 220.127.116.11.beta2
B1 display #N/A even with 3rd parameter type = 1 (search array is not sorted.)
Created attachment 90480 [details]
I see another difference :
With your attachment 90480 [details] , sort in ascendant order the dates only (A5:A9) leaving blank cells before and after.
4.1.3 show 7
4.2.0 show #N/A
It seems that 4.1.3 gives the result if data are sorted even with leading blank cells.
Perhaps I should have added that my cells are always sorted in ascending order so the "type" parameter is unnecessary for my sheet.
Kohei Yoshida committed a patch related to this issue.
It has been pushed to "master":
fdo#72348: Add test to catch this.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
This one shares the same root cause with Bug 74558.
*** This bug has been marked as a duplicate of bug 74558 ***
Migrating Whiteboard tags to Keywords: (PossibleRegression)