Issue 119303 - Can not find NEW conditional functions(COUNTIFS, SUMIFS, AVERAGEIF and AVERAGEIFS) of AOO34 new
Summary: Can not find NEW conditional functions(COUNTIFS, SUMIFS, AVERAGEIF and AVERAG...
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 3.4.0 Beta (OOo)
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on: 90269 95144 101466
Blocks:
  Show dependency tree
 
Reported: 2012-05-02 03:37 UTC by ashisuto_moi
Modified: 2012-06-20 06:35 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description ashisuto_moi 2012-05-02 03:37:36 UTC 
Test Env:
Windows XP, SP3, Japanese
Apache OpenOffice.org 3.4.0
  AOO340m1(Build9590) - Rev.1327774
English:Apache_OpenOffice_incubating_3.4.0_Win_x86_install_en-US.exe
Japanese:Apache_OpenOffice_incubating_3.4.0_Win_x86_install_ja.exe


I can not find NEW conditional functions(COUNTIFS, SUMIFS, AVERAGEIF and AVERAGEIFS) which are new functions of AOO34.

Repro Steps:
1. Start Calc
2. Insert -> Function
3. I(we) can not find out each of COUNTIFS, SUMIFS, AVERAGEIF and AVERAGEIFS.

Please investigate this matter.
Thanking you for your help and looking forward to your reply.
Comment 1 ashisuto_moi 2012-05-07 03:42:27 UTC 
I read "ODF Spreadsheet supports new Conditional Functions"
in the following URL:
https://cwiki.apache.org/OOOUSERS/aoo-34-release-notes.html

So I would like to use those functions:COUNTIFS, SUMIFS, AVERAGEIF and AVERAGEIFS.

But I can not find them out in AOO3.4.

So could you please show me where there are in AOO3.4.

Regards,
Comment 2 ashisuto_moi 2012-05-14 01:08:04 UTC 
Today, I know that the statement: "ODF Spreadsheet supports new
Conditional Functions " was deleted from AOO 3.4 Release Notes
on May 12, 2012 14:29 by Andrea Pescetti.

So My question was resolved.
Thank you.
Comment 3 Terry Yang 2012-06-20 06:32:22 UTC 
Verify COUNTIFS, SUMIFS, AVERAGEIF and AVERAGEIFS. is not in the URL, suggest close this defect.