http://www.openoffice.org/issues/show_bug.cgi?id=32345
------- コメントの追加元 [EMAIL PROTECTED] 2008/05/20 10:49:57 +0000 -------
Please reopen this issue.
MS-Excel allows "=LARGE(A1:A10,{1,2,3})", OOo2.x "LARGE(A1:A10;{1;2;3})", and
looks like it works fine.
But, for example, use LARGE()/SMALL() with AVERAGE(), problem occured.
If "A1, A2, ..., A10 = 1, 2, ..., 10" and anothe cell(MS-Excel) = "
=AVERAGE(LARGE(A1:A10,{1,2,3}))", return value of AVERAGE() is 9.
(so that means (10+9+8)/3)
OOo imported avobe .xls file, AVERAGE() retunrs 10. LARGE() not works fine.
Plese look at 3 files which I attached.
#Japanese Q&A ( http://oooug.jp/faq/index.php?faq%2F4%2F1024 )
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
