Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 27th 06, 03:23 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 1
Default Use the Merge & Center Button with unprotected Cells - sheet prote

In Office 2003 the Merge and Center button do not function when the sheet is
protected while the unprotected cells do the same behavior, but if you move
or cut merged cells and paste to another unprotected location the merged
cells become unmerged and the target location becomes merged on an
unprotected area. This behavior is good when you need to have part of the
sheet protected and part unprotected. My suggestion for Microsoft for the
merge and center button: this feature needs to work in unprotected cells
while other parts of the sheet are protected. On Excel 2003 work in an
indirect way.

But in Excel 2007 this behavior was eliminated which is bad. When the sheet
is protected the merge and center button do not work on unprotected cells
while other parts of the sheet is protected.

I am a analytical chemist from the Food and Drug Administration and we work
with Excel Analytical Application extensively and our analyst need to have
part of the sheet protected and other unprotected in order to create
different analytical application using the USP and other company method for
food and drug analytical method.

We have done extensive research on spreadsheet analytical applications and
discover a way for our analysts to develop from a template their analytical
application which look similar to other analysts which make it easer to
verify by other analysts because all formatting properties are similar. The
merge and center button is essential when a template sheet form has protected
as well as unprotected cells. By doing this we can control better the
application development. We call this workbook files "single-user" (need 100%
verification by a second analyst each time a workbook file template is
developed) because the template in use only one time, when the analyst
complete the analytical method it personalized for that particular drug
analysis and is used only one time. The printed report is used as the
official document which can be used in a court of law. The file is save and
archived for future audits.

We also have "multi-user" applications (need validation documentation) which
can be use by more than one analyst. This type of workbook files the formulas
cells are protected while the data-entry cells are unprotected. Also these
types of workbook file are used in the pharmaceutical industries.

I have several publications (US FDA Laboratory Information Bulleting) on
this topics (single-user / multi-user). Upon request I can send them.

I hope you can understand the above situation with the merge and center
buttom. I not please give me a call, and we can discuss.

Dennis Cantellops, QAM
US FDA San Juan District
787-474-4795




----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup

  #2   Report Post  
Old September 22nd 06, 12:49 AM posted to microsoft.public.excel.setup
 
Posts: n/a
Default Use the Merge & Center Button with unprotected Cells - sheet prote

Hi Dennis,

Can you send me detailed steps that show the difference in behavior between
Excel 2007 and Excel 2003? (I'm not sure from reading your post exactly how
to reproduce the issue that you're seeing)

Cheers,
Dan
Excel Team

Note: We've only got a couple weeks to get bugs filed and fixed, so if I've
requested additional info via email, it'd be great if you can get that to us
ASAP. Please include any necessary sample files, as well as detailed repro
steps so that we can try to reproduce the problem on our side. Also - if
you're emailing me directly (definitely the most efficient at this point)
you'll want to fixup my email address to remove everything after danbatt and
before the @.



"Dennis Cantellops" wrote in
message ...
In Office 2003 the Merge and Center button do not function when the sheet
is
protected while the unprotected cells do the same behavior, but if you
move
or cut merged cells and paste to another unprotected location the merged
cells become unmerged and the target location becomes merged on an
unprotected area. This behavior is good when you need to have part of the
sheet protected and part unprotected. My suggestion for Microsoft for the
merge and center button: this feature needs to work in unprotected cells
while other parts of the sheet are protected. On Excel 2003 work in an
indirect way.

But in Excel 2007 this behavior was eliminated which is bad. When the
sheet
is protected the merge and center button do not work on unprotected cells
while other parts of the sheet is protected.

I am a analytical chemist from the Food and Drug Administration and we
work
with Excel Analytical Application extensively and our analyst need to have
part of the sheet protected and other unprotected in order to create
different analytical application using the USP and other company method
for
food and drug analytical method.

We have done extensive research on spreadsheet analytical applications and
discover a way for our analysts to develop from a template their
analytical
application which look similar to other analysts which make it easer to
verify by other analysts because all formatting properties are similar.
The
merge and center button is essential when a template sheet form has
protected
as well as unprotected cells. By doing this we can control better the
application development. We call this workbook files "single-user" (need
100%
verification by a second analyst each time a workbook file template is
developed) because the template in use only one time, when the analyst
complete the analytical method it personalized for that particular drug
analysis and is used only one time. The printed report is used as the
official document which can be used in a court of law. The file is save
and
archived for future audits.

We also have "multi-user" applications (need validation documentation)
which
can be use by more than one analyst. This type of workbook files the
formulas
cells are protected while the data-entry cells are unprotected. Also these
types of workbook file are used in the pharmaceutical industries.

I have several publications (US FDA Laboratory Information Bulleting) on
this topics (single-user / multi-user). Upon request I can send them.

I hope you can understand the above situation with the merge and center
buttom. I not please give me a call, and we can discuss.

Dennis Cantellops, QAM
US FDA San Juan District
787-474-4795




----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why "center across selection" rather than "merge" cells? What is. Michele Excel Discussion (Misc queries) 7 November 5th 08 05:36 AM
Merge and Center when sheet is protected Tory Excel Discussion (Misc queries) 2 April 25th 06 07:22 PM
Combining data from cells from several excel sheets to a new sheet Rik Excel Discussion (Misc queries) 4 February 22nd 06 10:16 AM
Difficult for me, probably basic to you onlyjohn Excel Worksheet Functions 1 February 3rd 06 06:14 PM
Merge and Center button gall Excel Discussion (Misc queries) 0 May 11th 05 02:26 AM


All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017