Bug Hunting Session
Bug 33152 - Using dynamic names for printing areas
Summary: Using dynamic names for printing areas
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: VOTE
Keywords:
Depends on:
Blocks: Calc-Enhancements
  Show dependency treegraph
 
Reported: 2011-01-15 07:49 UTC by pierre-yves samyn
Modified: 2017-05-26 17:29 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
1st attachment (4.02 KB, image/png)
2011-01-15 07:49 UTC, pierre-yves samyn
Details
2nd attachment (4.33 KB, image/png)
2011-01-15 07:50 UTC, pierre-yves samyn
Details
3rd attachment (3.65 KB, image/png)
2011-01-15 07:51 UTC, pierre-yves samyn
Details
The attached workbook shows the use of dynamic names (14.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-01-15 07:53 UTC, pierre-yves samyn
Details

Note You need to log in before you can comment on or make changes to this bug.
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