Issue 104875 - [Calc] Dynamic print range with OFFSET function
Summary: [Calc] Dynamic print range with OFFSET function
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:
Depends on:
Reported: 2009-09-08 07:13 UTC by jeffooo
Modified: 2014-03-21 13:14 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Select dynamic print range (70.41 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-02-17 21:09 UTC, jeffooo
no flags Details

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

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.

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 (, data pilot...