Issue 37912 - Insert Sheet removes header and footer info
Summary: Insert Sheet removes header and footer info
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 1.1.3
Hardware: PC Windows NT
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-11-25 20:53 UTC by lbridle
Modified: 2013-08-07 15:13 UTC (History)
5 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description lbridle 2004-11-25 20:53:29 UTC
When I inserted an existing sheet that also contains my special header and
footer info, this info is lost and returns to the same default info as in a new
Comment 1 frank 2004-11-26 15:31:18 UTC

this is not a bug. Informations like header and footer are stored in page
styles. Such styles can be easily assigned to a sheet by using the stylist. Such
styles are stored only with the document you've created it. If you insert a
sheet into such an file and the page style has different settings at least one
of them will be destroyed. So on insert sheet from file styles will not be inserted.

You may think about an user defined default template. Have a look at the help
system about that.

Comment 2 frank 2004-11-26 15:31:37 UTC
closed invalid
Comment 3 lbridle 2004-11-28 06:43:11 UTC

I'm surprised this issue would be declared invalid.

I was expecting that when I 'insert sheet from file' that it would actually 
"insert the sheet", i.e. the whole sheet and not just some part of it.  For me,
that would include all my data items including headers and footers. (The actual
implmentation details are irrelevant from my users perspective.)  

So, for me the current solution does not match my user requirements.  On the
presumption that my user requirements are very similar to most users ( I did ask
a few), doesn't that make this issue a valid 'bug'?  

BTW, the other spreadsheet does it the way I expect and has been for many years.  

Further, would not a solution that inserts my whole sheet be a more effective
and productive solution for users, instead of having to take extra steps to
replace the info that was dropped?  Is it not the higher quality solution and
hence the right thing to do?

I hope will reconsider this issue.



Comment 4 frank 2004-11-29 08:57:05 UTC

no it doesn't qualify it as a bug but maybe an enahncement. So I change the
Issue type and re-assign it.

Comment 5 bettina.haberer 2010-05-21 14:44:37 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".