http://bugzilla.novell.com/show_bug.cgi?id=588196 http://bugzilla.novell.com/show_bug.cgi?id=588196#c0 Summary: OpenOffice.org-calc: incorrect handling of numbers in Spanish locale Classification: openSUSE Product: openSUSE 11.2 Version: Final Platform: x86-64 OS/Version: Other Status: NEW Severity: Normal Priority: P5 - None Component: OpenOffice.org AssignedTo: bnc-team-ooo@forge.provo.novell.com ReportedBy: carlos.e.r@opensuse.org QAContact: cwei@novell.com Found By: --- Blocker: --- Created an attachment (id=348334) --> (http://bugzilla.novell.com/attachment.cgi?id=348334) photo of language options dialog User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.8) Gecko/20100204 SUSE/3.5.8-0.1.1 Firefox/3.5.8 I have default document locale as Spanish, but system locale and OOo as 'US', because I prefer untranslated programs, in English (see attached photo: "Screenshot-Options - Language Settings - Languages.png") I have OOo updated from the stable OOo repo to OpenOffice_org-calc-3.2.0.7-1.1.x86_64, but I also had a variation of this bug in the default OOo that came with oS 11.2 (not reported, or at least not by me). There, formulas with numbers like "1,11" gave an error. See photographic sequence attached. First I paste into calc this sequence of numbers: 0,71 -1,13 21,99 -19,21 It is taken from a PDF copy-paste, so there are spaces. What I get is the first photo, "Screenshot-Text Import.png". In "column type" I'm not offered "numbers", but they are indeed numbers. Notice that in Spain the decimal separator is a comma. What I get is displayed in the second photo (Screenshot-Untitled 1 - OpenOffice.org Calc.png). Notice that it is imported as TEXT, when they are numbers. This doesn't happen if the locale is US, and the numbers use a dot as decimal separator. Then I edit each of the four cells, attempting to remove leading spaces. Notice that the negative numbers are now accepted as numbers, but the positive ones are not. Notice, looking at the box just below the mouse help tip, the "0,71", that there is no leading text symbol «'» which can not be removed in the usual trick to convert text to numbers or formulas. I have three alternatives (Screenshot-Untitled 1 - OpenOffice.org Calc-2.png): - If, in the A1 cell I type "0.71" on top of the existing "0.71" , it is entered as text - again. - If, on the A5 cell (empty and untouched) I type "0.71", it is entered as a number (alternative 1). - I have to edit A1 and precede with a "=" symbol (alternative 2). - If I edit A1 again and remove the "=", it is again text, not number. - If I go to "cell format" menu, it says text (@). I can click on the monetary icon to convert it to number format. The cell remains as text, but now it has a preceding "'" which can be removed and the cell converted to number (alternative 3). - I can copy-paste the A5 cell into A1. This works. In fact, the A1, A2 and A4 cells all have a preceding "=" symbol. The A5 cell is correct, the only one entered directly by typing. Reproducible: Always Steps to Reproduce: See above. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.