https://bugs.documentfoundation.org/show_bug.cgi?id=103734
Bug ID: 103734
Summary: EDITING: VLOOKUP yield absurd amount (-1.8E+308) in
matrix formula when nothing matches
Product: LibreOffice
Version: 5.2.3.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
This is a tabletop character sheet.
The following formula is used to match character class in a preset list:
{=SI(R6 > 0, MAX(RECHERCHEH($E$2:$E$5, Classes.$C$1:$AI$48, Classes.$A12, 0)))}
Where $E$2:$E$5 are the classes the character specialize in,
Classes.$C$1:$AI$48 is the class preset list,
Classes.$A12 is the line to be crossed with classes' name.
As we use a matrix formula, MAX is used to filter the 0-4 list of numbers. Only
0's and 3's are exepected.
But when the formula matches nothing, a strange value, -1.8E+308 is yielded
instead of 0. I see no way to achieve this result.
This bug is not reproduced in Apache OOo 4.1.3 (portable version).
Steps to Reproduce:
Use a VLOOKUP in a matrix formula.
Actual Results:
-1.8E+308
Reproducible: Didn't try
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:49.0) Gecko/20100101
Firefox/49.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
