Issue 23349 - cell type is not changed if first cell type matches target type
Summary: cell type is not changed if first cell type matches target type
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: frank
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-12-09 15:50 UTC by richlv
Modified: 2004-03-08 11:45 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description richlv 2003-12-09 15:50:13 UTC 
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.

also works this way if the two cells are selected by dragging cursor and it is 
not important which cell is active. also is the same for multiple cells.

solutions :
1. change cell type of all cells that are selected or
2. if this is intentional - display a dialog box that would explain situation 
and ask if type should be changed for all cells that are selected
Comment 1 srobertson 2003-12-09 22:38:19 UTC 
Confirmed on OpenOffice.org 1.1.0 built from sources, running on Gentoo Linux.
Comment 2 frank 2003-12-10 08:50:24 UTC 
Hi,

I could not reproduce under WinXP and Linux (Suse 8.2). 

Richlv what OS do you use and have you compiled OOo by yourself ?

Frank
Comment 3 richlv 2003-12-10 09:03:55 UTC 
linux slackware 9.1 + some upgrades to current;
oo.org sun's build from website
Comment 4 richlv 2003-12-10 09:09:46 UTC 
also just tested on win2k, sun's build from website, works the same way
Comment 5 frank 2003-12-10 10:27:56 UTC 
Hi,

please attach a file which shows the problem or describe exactly and step by
step what you're doing.

Thanks for your help.

Frank
Comment 6 frank 2004-03-05 19:59:14 UTC 
Hi,

as I got no document I've asked my crystal ball ;-)

If you format a1 as number and fill the cell with say 123, format a2 as text and
fill it with let's say 456, select a1:a5 and choose format cell number from the
context menu and apply this format to the range, a2 will not change from number
to text because there could be some good reasons to have such text cells as they
are, text. So this works as intended.

So I close this Issue as invalid.

Frank
Comment 7 richlv 2004-03-08 08:13:07 UTC 
ahh, i'm very sorry, somehow i missed this request for addition information.
1. the problem is, oo.org behaves this way even with empty cells;
2. this behaviour is completely silent. user finds out this only when something 
is wrong with calcualtions etc.

so, to make sure users don't get too confused i opened issue http://www.
openoffice.org/issues/show_bug.cgi?id=26225
Comment 8 frank 2004-03-08 11:45:24 UTC 
so I close this one.

Frank