Issue 26225 - if selected range contains differently formatted cells ask user how to chnage their formatting
Summary: if selected range contains differently formatted cells ask user how to chnage...
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1RC
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Blocks: 53833
  Show dependency tree
Reported: 2004-03-08 08:11 UTC by richlv
Modified: 2013-02-07 22:35 UTC (History)
1 user (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 richlv 2004-03-08 08:11:02 UTC
evolved from issue 23349

scenario :
create new spreadsheet
format cell a1 as number, a2 as text
select row a by clicking on label
format it as number
cell a2 hasn't type changed.

as explained, this is an intended behaviour, but this results in a problem, when 
a user wants to change all cells to some specific type.

so, a suggested action :
if, for some reason, selected range contains different cell types and some of 
them would not be changed in a default behaviour, display a dialog that explains 
this situation (it maybe even has a button {details} that further describes 
cells that have questionable type and what would happen with these cells) and 
asks the user if [s]he wants to force changing of cell type for all cells or 
change it only for those cells that suggests. it also could have a 
checkbox/option that would set one of these behaviours as default so that this 
dialog doesn't show up again. this option should be easily changeable 
thereafter, of course.

although it is nice that tries to save user from mistakes, current 
behaviour is quite irritating : changes are dropped silently and there is no way 
for user to clearly see what and why didn't happen the way [s] he wanted. also, 
there is no way to change cell type for all cells (except changing it to some 
other, third type, and then to final type - but that's not exctly the easiest 
Comment 1 frank 2004-03-08 11:47:29 UTC
Hi Bettina,

one for you.

Comment 2 ace_dent 2008-05-16 02:55:35 UTC Issue Tracker - Feedback Request.

The Issue you raised has the status 'New' pending further action, but has not
been updated within the last 4 years. Please consider re-testing with one of the
latest versions of OOo, as the problem(s) may have already been addressed.
Either use the recent stable version:
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
Comment 3 bettina.haberer 2010-05-21 14:56:42 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".