https://bugs.freedesktop.org/show_bug.cgi?id=81768
Priority: medium
Bug ID: 81768
Assignee: [email protected]
Summary: editing index match function
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 3.5.7.2 release
Component: Spreadsheet
Product: LibreOffice
Removing two of the last three characters (+1) in the formula,
INDEX($B$6:$B$66,MATCH(" Total 6500 Taxes and Licenses",$A$6:$A$66,0)+1),
seems to give you
INDEX($B$6:$B$66,MATCH(" Total 6500 Taxes and Licenses",$A$6:$A$66,0)),
and then gives an error (Err:511). When you look at the formula again you see
INDEX($B$6:$B$66,MATCH(" Total 6500 Taxes and Licenses",$A$6:$A$66,0)+):
apparently, removing +1 has only removed the 1, not the +.
Now removing the + gives a formula that works.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
