https://bugs.freedesktop.org/show_bug.cgi?id=69547
Priority: medium
Bug ID: 69547
Assignee: [email protected]
Summary: EDITING: Parameter entry in AVERAGEIF and AVERAGEIFS
functions
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.1.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 86098
--> https://bugs.freedesktop.org/attachment.cgi?id=86098&action=edit
Odt document containing screenshots illustrating the problem and giving more
information.
Problem description: These two functions will only accept a numerical value as
a criteria value, and it has to be entered within double quotes.
Steps to reproduce:
1. Open an instance of Calc.
2. Open the Function Wizard
3. Select either of the two functions indicated.
4. Enter a valid range containing numerical date into the first parameter.
5. The criteria value is only accepted in the function if inserted within
double quotes, else an error results.
Current behavior:Only numeric values in quotes is accepted.
Expected behavior: Any valid data item should be accepted.
Operating System: Windows XP
Version: 4.1.1.2 release
--
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
