Issue 124996

Summary: Offset function with external file, and calculate height
Product: Calc Reporter: Oukcha <>
Component: codeAssignee: AOO issues mailing list <issues>
Severity: Normal    
Priority: P3 CC:
Version: 3.4.1Keywords: regression
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.2.0-dev
Developer Difficulty: ---
Description Flags
OFFSET function return error 504
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

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.

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

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