Bug 33152

Summary: Using dynamic names for printing areas
Product: LibreOffice Reporter: pierre-yves samyn <pierre-yves.samyn>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: jefflibo, jn, jr, mchl.rdll
Priority: medium    
Version: 3.3.0 release   
Hardware: All   
OS: All   
Whiteboard: VOTE
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 107977    
Attachments: 1st attachment
2nd attachment
3rd attachment
The attached workbook shows the use of dynamic names

Description pierre-yves samyn 2011-01-15 07:49:39 UTC
Created attachment 42074 [details]
1st attachment

Hello

"Insert> Names> Define" allows to create "names" as the Print range (1st attachment)

"Insert> Names> Define" also allow to create "names" referring to ranges of data whose references are calculated by formula (2nd attachment)

Unfortunately "Format> Print range> Edit" does not use these names calculated by formula... (3rd attachment)

If it did, it would be a tremendous asset to our favorite spreadsheet giving us print ranges truly dynamic.

The attached workbook shows the use of dynamic names 

Best regards
Pierre-Yves
Comment 1 pierre-yves samyn 2011-01-15 07:50:29 UTC
Created attachment 42075 [details]
2nd attachment
Comment 2 pierre-yves samyn 2011-01-15 07:51:06 UTC
Created attachment 42076 [details]
3rd attachment
Comment 3 pierre-yves samyn 2011-01-15 07:53:03 UTC
Created attachment 42077 [details]
The attached workbook shows the use of dynamic names
Comment 4 Björn Michaelsen 2011-12-23 11:52:58 UTC Comment hidden (obsolete)
Comment 5 pierre-yves samyn 2011-12-24 02:21:01 UTC
Hello

Still persists with Windows 7  &  LOdev 3.5.0beta2+Build ID: 62b9587-7ef74e0-7bf1c81

Regards
PYS
Comment 6 Jeff 2012-01-04 08:42:08 UTC
Hello

Still persists with Windows XPproSP3  &  LOdev 3.5.0beta2 
Version ID : 8589e48-760cc4d-f39cf3d-1b2857e-60db978

Best regards
Comment 7 Jene 2014-03-10 15:18:10 UTC
Still not corrected in version LibreOffice 4.2.1.1. running Mac OS X 10.9.2.

Best regards
Comment 8 pierre-yves samyn 2014-03-10 17:40:30 UTC
Hello

(In reply to comment #7)
> Still not corrected in version LibreOffice 4.2.1.1. running Mac OS X 10.9.2.


Please do not change version field. It should indicate the earlier version where the bug appeared, not the latest.

See https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Version

I restore 3.3.0.

Regards
Pierre-Yves