Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Stable beta 1.1 - Numbers not recognized in Calc | ||
---|---|---|---|
Product: | Calc | Reporter: | alex.thurgood |
Component: | code | Assignee: | oc |
Status: | CLOSED IRREPRODUCIBLE | QA Contact: | issues@sc <issues> |
Severity: | Trivial | ||
Priority: | P3 | CC: | issues |
Version: | 644 | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Linux, all | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
alex.thurgood
2003-03-21 10:37:39 UTC
Hi, It works fine on my build of 1.1beta I would suggest that for some reason you have at one point used: Tools->Options->LanguageSettings->WritingAids and have enabled "check words with numbers" Please disable this. MySpell is a spell checker that does not recognize words with numbers in them. There seems to be some sort of bug in Calc that tries to spell check all entries and if they come back incorrect it somehow defaults them to text even though they are a number. There are two long-term solutions: 1. teach MySpell how to recognize all forms of Numbers with all of the possible punctuation, currency symbols, periods, commas, $, () etc. 2. Make Calc stop deciding to convert numbers to text just because they don't spell check as correct words. The best short term solution is not to enable check words with numbers in them. Then Calc will correctly identify 400 and 100 as numbers and stop trying to make text out of them. Please note aside from things like 1st, 2nd, etc words with numbers are generally rare and technically incorrect for most uses in proper English. Your sarcasm aside ... No, this is NOT a stable release ... Notice the word "BETA" in the name? I guess not. Kevin Issue 3820 has been fixed, online spelling errors no longer prevent the input of numbers (solution 2 from above). That fix is in the beta, I just checked it. Hi, Thanks for checking that. Yes I Just tried ooo_srx644_11beta and you are right that problem has been fixed! So I guess I can stop trying to figure out out to categorize all possible numbers and curency format's and radix and etc for MySpell (whew!) So that is not the problem ... but I can not recreate it in any way ... Can you recreate this problem on 1.1Beta? I tried changing the Cell format to change the language settings to both NONE and a Language that I can't spell check in but that did not cause any problems. I tried changing the font but that did not cause the problem. The only way I could get it to think a number was a string was to format the cells as TEXT and then it was considered TEXT but that is proper operation. Ideas anyone? Kevin Hi Kevin, They always did say to me at school that sarcasm was the lowest form of humour :-) I've noted that you have been prone to such wit in the past as well, so I'll take your comments as a fair cop. Tried your suggestion, and what do you know, "Check words with numbers" was indeed ticked in the writing aids dialog, although I don't recall having set that. So I unset it, and problem solved. I have noticed however that if you reset the option back to checking, a spellcheck is run as you type, and the number is flagged as incorrectly spelt (red underlining) for a fraction of a second. Is this linked to the workaround ? All, I might have a duff installation, there are other problems cropping up, like certain characters not showing correctly (in the formula editor). I'm going to try and reinstall, but I'll have to wait until Monday to get back to the mirrors and a fast connection. Alex Downloaded again, reinstalled. Working fine now. I'll set it to resolved. This task is fixed or worked in OOo 1.1 beta2. closed ... |