Issue 124996 - Offset function with external file, and calculate height
Summary: Offset function with external file, and calculate height
Status: CLOSED DUPLICATE of issue 117389
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 3.4.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2014-05-27 21:35 UTC by Oukcha
Modified: 2017-05-20 09:53 UTC (History)
1 user (show)

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

Attachments
OFFSET function return error 504 (171.65 KB, image/jpeg)
2014-05-27 21:35 UTC, Oukcha 		no flags Details
OFFSET with external reference work fine with fixe height (58.62 KB, image/jpeg)
2014-05-27 21:36 UTC, Oukcha 		no flags Details
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 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 ***