https://bugs.freedesktop.org/show_bug.cgi?id=59309
Priority: medium
Bug ID: 59309
Assignee: [email protected]
Summary: One cell containing text in a string of addends causes
calc to return #VALUE!.
Severity: major
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 3.5.7.2 release
Component: Spreadsheet
Product: LibreOffice
Attached spreadsheet shows simple addition in cell F25 to fail and return
#VALUE! when one of the terms contains text. The same happens with subtraction.
Note, by contrast, that the function SUM is able to tolerate text-containing
cells in its parameter list. Possibly noteworthy is the fact that functions
such as MIN, MAX, AVERAGE, &c, also all tolerate text-containing cells in their
parameter lists.
LO 3.5.7.2; Build ID: 3215f89-f603614-ab984f2-7348103-1225a5b.
OO calc 3.3.0 behaves in the same manner.
--
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
