Issue 104875 - [Calc] Dynamic print range with OFFSET function
Summary: [Calc] Dynamic print range with OFFSET function
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.1.1 RC2
Hardware: All All
: P3 Trivial with 10 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-08 07:13 UTC by jeffooo
Modified: 2014-03-21 13:14 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Attachments
Select dynamic print range (70.41 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-02-17 21:09 UTC, jeffooo 		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 jeffooo 2009-09-08 07:13:55 UTC 
Hi,

In Calc, create adjustable area :

Insert > Names > Define 
 - Name : MyRange
 - Assigned to : =OFFSET($A$1;0;0;COUNTA($B$1:$b$10);2)
 - (More >)Print range
- OK

To use the print area :
 - Format > Print ranges > Edit
 -> there's not MyRange in Print area (only "none", "entire sheet", "user
defined", "sélection") 

Best regards
Comment 1 jeffooo 2013-08-24 12:33:49 UTC 
Always reproduced with AOO 4.0.0, we can’t use dynamic print range.

Regards
Comment 2 Edwin Sharp 2013-12-28 18:42:50 UTC 
Please provide real life example for a possible benefit of such functionality.
Comment 3 Edwin Sharp 2014-01-12 07:32:09 UTC 
No info from author.
Comment 4 jeffooo 2014-02-17 21:08:19 UTC 
Sorry, I don't see your post.

Created attachment
Comment 5 jeffooo 2014-02-17 21:09:40 UTC 
Created attachment 82610 [details]
Select dynamic print range
Comment 6 Edwin Sharp 2014-02-18 07:16:54 UTC 
Thank you jeffooo
Comment 7 jeffooo 2014-02-18 07:40:40 UTC 
Maybe need a issue on the names obtained with the OFFSET function, because it can help to dynamic select print range, chart (https://issues.apache.org/ooo/show_bug.cgi?id=64604), data pilot...