Issue 24374 - Cell formatted as TEXT converted to NUMBER format fails
Summary: Cell formatted as TEXT converted to NUMBER format fails
Status: CLOSED WONT_FIX
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC5
Hardware: PC Windows 98
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
: 105040 (view as issue list)
Depends on:
Blocks: 5658
  Show dependency tree
 
Reported: 2004-01-14 03:21 UTC by gillesleonard
Modified: 2009-09-14 14:59 UTC (History)
2 users (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 gillesleonard 2004-01-14 03:21:48 UTC 
Hi,

Fail scenario:
On an empty cell formatted as TEXT, enter a number, say [311.25].
Then convert the sell format to NUMBER. 
The failure is that the cell now contains ['311.25] instead of [311.25] and of 
course won't participate in any calculations.
If this was intended, this is a major annoyance. This is not the way StarOffice 
nor MS Office treats this issue. And you often open a sheet and start entering 
numbers not caring about the format and then start adjusting the format as you 
go.

Kind regards,

Gilles Leonard

P.S.: Thanks for the great work, this product rocks !
Comment 1 frank 2004-01-14 14:42:26 UTC 
Hi,

I've checked the behaviour of Excel and SO and found out, that SO works like OOo
and Excel do it in a different way but the results are the same. The content of
such cells is in all three cases Text and not a number. The main difference is
just that Excel does not display the leading apostrophe and calcula6tes with
these text values.

To get rid of the apostrohe just use Find & Replace search for '.*' replace with
'&' and set regular expression under More in the Dialog.

Regarding the results of my investigation I have to close this Issue as wontfix.

Thanks for you understanding.

Frank
Comment 2 frank 2004-01-14 14:42:51 UTC 
closed wontfix
Comment 3 frank 2005-11-01 08:50:20 UTC 
*** Issue 57095 has been marked as a duplicate of this issue. ***
Comment 4 frank 2008-02-20 15:28:32 UTC 
*** Issue 57095 has been marked as a duplicate of this issue. ***
Comment 5 philhibbs 2009-05-21 13:43:51 UTC 
You have to use REGULAR EXPRESSIONS to fix this? WTF? I know what regular
expressions are, I love them, I'm just another perl hacker, but the programmer
behind me literally burst out laughing when I read out the workaround to this
issue! This is complete BS, expecting a user to use regular expressions to fix a
number formatting issue.
Comment 6 frank 2009-09-14 14:59:32 UTC 
*** Issue 105040 has been marked as a duplicate of this issue. ***