Issue 53596 - The number of the text and the number of the number can't conversion to each other
Summary: The number of the text and the number of the number can't conversion to each ...
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 680m122
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2005-08-22 06:56 UTC by redoffice
Modified: 2010-11-10 17:50 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 redoffice 2005-08-22 06:56:10 UTC 
Reproduce Steps：1. Select "Format->Cell" to invoke cell format editing dialog.
Expected Result：In this dialog, check each format category, all format should 
be match the locale setting
Actual Result：The number of the text and the number of the number can't 
conversion to each other
Comment 1 Matthias Basler 2005-09-03 12:41:54 UTC 
Hi redoffice,

I'm sorry but I don't understand your problem. I had a look at the cell
formatting dialog in my German version of OOo1.9.125 on WinXP SP2 and it looks
OK, including the different locale settings.

Maybe it would help if you attached a screenshot that shows the problem and/or
describe one specific example of what's wrong. Also, what locale (what language
version) are you working with?
What do you mean with "The number of the text and the number of the number can't 
conversion to each other"?
Comment 2 frank 2005-09-16 09:12:20 UTC 
Hi,

if you would change a value separated by a dot to one separated by a comma, you
can just change the locale and the separator changes automatically.

If you have a value formatted as text and will change it to a numerical value,
just format the cell as as numeric and remove the apostrophe in front of the
numbers.

This is not a bug.

Closing invalid as we got no response and as far as I understand the description
this is not an Issue.

Frank
Comment 3 frank 2005-09-16 09:12:41 UTC 
closed invalid
Comment 4 tesotitas 2010-11-10 15:42:09 UTC 
Created attachment 72977
Comment 5 Matthias Basler 2010-11-10 17:50:20 UTC 
SPAM. Please remove and do not call the above link.