Issue 104875

Summary: [Calc] Dynamic print range with OFFSET function
Product: Calc Reporter: jeffooo <jeffooo>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues, jeffooo
Version: OOo 3.1.1 RC2   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---
Description Flags
Select dynamic print range none

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...