Issue 124996

Summary: Offset function with external file, and calculate height
Product: Calc Reporter: Oukcha <oukcha.fr>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CLOSED DUPLICATE QA Contact:
Severity: Normal    
Priority: P3 CC: oukcha.fr
Version: 3.4.1Keywords: regression
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.2.0-dev
Developer Difficulty: ---
Attachments:
Description Flags
OFFSET function return error 504
none
OFFSET with external reference work fine with fixe height none

Description Oukcha 2014-05-27 21:35:54 UTC 
Created attachment 83474 [details]
OFFSET function return error 504

Hi developpers,

I hope this issue is not a duplicate of https://issues.apache.org/ooo/show_bug.cgi?id=103331

If I use OFFSET function with COUNTIF (or COUNT) function to calculate range height, I have a error 504 (see attachment)

But in the wizard function, the function result of COUNTIF is OK.

If I use only COUNTIF function lonely with external reference, COUNTIF work fine ;
If I don't use COUNTIF, and input the height value in OFFSET, OFFSET work fine too.
(see attachment)

Confirmed with AOO420m1(Build:9800)  -  Rev. 1596566 2014-05-23_04:11:18 - Rev. 1597007 under Xubuntu_x64
Confirmed with cuurent version 4.1.0 under Win7 pro 64
Confirmed with AOO 3.4.1 under Win 7 pro

Work fine with OOo 2.4.2, it's a regression.

Regards
Comment 1 Oukcha 2014-05-27 21:36:47 UTC 
Created attachment 83475 [details]
OFFSET with external reference work fine with fixe height
Comment 2 Oukcha 2014-05-30 07:47:31 UTC 
Sorry, duplicate https://issues.apache.org/ooo/show_bug.cgi?id=117389

*** This issue has been marked as a duplicate of issue 117389 ***