Apache OpenOffice (AOO) Bugzilla – Issue 12551
Stable beta 1.1 - Numbers not recognized in Calc
Last modified: 2003-09-08 16:55:29 UTC
It appears that numbers are not recognized as such in the stable beta 1.1 in the spreadsheet app. Tried entering : A1 400 B1 100 The numbers appear left justified, as if they were recognized as text. Checking in format shows them formatted as numbers. then in another cell : A1+B1 gives 0 A1-B1 gives 0 A1*B1 gives 0 A1/B1 gives #VALUE And this is a stable release ?? Linux Mandrake 9.0, OOo Beta 1.1 stable from sunsite.dk mirror
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 ...