[Bug 588196] New: OpenOffice.org-calc: incorrect handling of numbers in Spanish locale
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.
http://bugzilla.novell.com/show_bug.cgi?id=588196 http://bugzilla.novell.com/show_bug.cgi?id=588196#c1 --- Comment #1 from Carlos Robinson <carlos.e.r@opensuse.org> 2010-03-13 21:59:57 UTC --- Created an attachment (id=348335) --> (http://bugzilla.novell.com/attachment.cgi?id=348335) First photo -- 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.
http://bugzilla.novell.com/show_bug.cgi?id=588196 http://bugzilla.novell.com/show_bug.cgi?id=588196#c2 --- Comment #2 from Carlos Robinson <carlos.e.r@opensuse.org> 2010-03-13 22:00:18 UTC --- Created an attachment (id=348336) --> (http://bugzilla.novell.com/attachment.cgi?id=348336) second photo -- 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.
http://bugzilla.novell.com/show_bug.cgi?id=588196 http://bugzilla.novell.com/show_bug.cgi?id=588196#c3 --- Comment #3 from Carlos Robinson <carlos.e.r@opensuse.org> 2010-03-13 22:00:42 UTC --- Created an attachment (id=348337) --> (http://bugzilla.novell.com/attachment.cgi?id=348337) third photo -- 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.
http://bugzilla.novell.com/show_bug.cgi?id=588196 http://bugzilla.novell.com/show_bug.cgi?id=588196#c4 --- Comment #4 from Carlos Robinson <carlos.e.r@opensuse.org> 2010-03-13 22:01:29 UTC --- Created an attachment (id=348338) --> (http://bugzilla.novell.com/attachment.cgi?id=348338) sample ods file where the photos were taken -- 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.
http://bugzilla.novell.com/show_bug.cgi?id=588196 http://bugzilla.novell.com/show_bug.cgi?id=588196#c5 Petr Mladek <pmladek@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 - None |P3 - Medium AssignedTo|bnc-team-ooo@forge.provo.no |kyoshida@novell.com |vell.com | --- Comment #5 from Petr Mladek <pmladek@novell.com> 2010-03-19 20:36:28 UTC --- Sigh, bugzilla did not send mails last weekend, so we somehow missed this bug several days. The behavior is indeed strange. Kohei, this is for you. -- 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.
http://bugzilla.novell.com/show_bug.cgi?id=588196 http://bugzilla.novell.com/show_bug.cgi?id=588196#c6 --- Comment #6 from Kohei Yoshida <kyoshida@novell.com> 2010-04-16 15:36:17 UTC --- This problem consists of two parts. Part 1 is about pasting numbers from an external source into Calc, and Calc pastes them as text. Part 2 is how Calc handles cell inputs when the cell format is Text, and vise versa. Part 2 is not a bug, but is by design. What would be nice to have is an easy way to convert text numbers into real numbers (like Excel does), but as far as how Calc handles numbers when the cell format is Text, it's by design. Part 1 may already have been fixed in the latest 3.2.1 build on master. Check the separator values in the Options dialog (OpenOffice.org Calc - Formula). If one of them contains ',', then it may be conflicting with the locale specific decimal separator. Workaround is to push the Reset button in the Formula page, to reset the values appropriate for the locale. The latest build does that automatically when switching locales in the Languages page. -- 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.
http://bugzilla.novell.com/show_bug.cgi?id=588196 http://bugzilla.novell.com/show_bug.cgi?id=588196#c Kohei Yoshida <kyoshida@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- QAContact|cwei@novell.com |yfjiang@novell.com -- 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.
http://bugzilla.novell.com/show_bug.cgi?id=588196 http://bugzilla.novell.com/show_bug.cgi?id=588196#c7 Kohei Yoshida <kyoshida@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO InfoProvider| |carlos.e.r@opensuse.org --- Comment #7 from Kohei Yoshida <kyoshida@novell.com> 2010-04-16 15:37:48 UTC --- Please check the latest 3.2.1 build (if you are willing) to see how it's working over there. Thanks! -- 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.
http://bugzilla.novell.com/show_bug.cgi?id=588196 http://bugzilla.novell.com/show_bug.cgi?id=588196#c8 --- Comment #8 from Carlos Robinson <carlos.e.r@opensuse.org> 2010-04-18 13:21:34 UTC --- I'm in the process of testing this. My first step was making sure I could reproduce the problem before attempting to upgrade OOo... and I got a surprise: If I paste the reported sequence: 0,71 -1,13 21,99 -19,21 directly from the browser, oocalc gets it right! It appears to work as well from acrobat, but it fails if I paste from Evince. I only get the text import dialog if I paste from evince. About the upgrade. Unfortunately, there is no update available in the Stable OOo repo, so upgrading is out of the question, I need it for production. Notice that the behavior is different if you use a locale that has commas or dots as decimal separators. About resetting the formula separator, yes, that's something I discovered yesterday by accident. When changing locale to Spanish I got the warning about resetting the formula separator, if the change is done while oocalc is opened. IIRC, it does not happen if done from oowrite. Mmm... I just managed to crash OOocalc while writing this. It is a 100% cpu on one core. Had to kill it. No info to report about it, AFAIK. -- 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.
http://bugzilla.novell.com/show_bug.cgi?id=588196 http://bugzilla.novell.com/show_bug.cgi?id=588196#c9 Stefan Behlert <behlert@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW InfoProvider|carlos.e.r@opensuse.org | --- Comment #9 from Stefan Behlert <behlert@novell.com> 2010-07-21 13:26:18 UTC ---
From above comment, can we close this bug as fixed?
-- 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.
https://bugzilla.novell.com/show_bug.cgi?id=588196 https://bugzilla.novell.com/show_bug.cgi?id=588196#c10 Kohei Yoshida <kyoshida@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED --- Comment #10 from Kohei Yoshida <kyoshida@novell.com> 2010-09-27 13:28:13 UTC --- Let's call this fixed. Feel free to reopen this if there still is issues. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=588196 https://bugzilla.novell.com/show_bug.cgi?id=588196#c11 Carlos Robinson <carlos.e.r@opensuse.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|FIXED | --- Comment #11 from Carlos Robinson <carlos.e.r@opensuse.org> 2010-10-14 23:41:21 UTC --- Er... Unfortunately, the problem remains. This is a different install in the same machine, with 11.2, and OpenOffice_org-calc-3.2.1.6-1.1.x86_64 - that is the latest stable version available for 11.2. I have generated a test PDF that reproduces the problem (the original is receipt - private data). I test importing a column of numbers, and if the source is xpdf or evince, the numbers are imported as text into calc, and as numbers if the source is acroread or okular. In all cases I'm getting the import dialog (doesn't happen with all the pdfs I tried). cer@Telcontar:~> locale LANG=en_US.UTF-8 LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME=en_DK.UTF-8 LC_COLLATE=POSIX LC_MONETARY=es_ES@euro LC_MESSAGES="en_US.UTF-8" LC_PAPER=es_ES@euro LC_NAME=es_ES@euro LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE=es_ES@euro LC_MEASUREMENT=es_ES@euro LC_IDENTIFICATION="en_US.UTF-8" LC_ALL= In Calc, the user interface is the same as locale (above), default language for documents is Spanish -> which means that the decimal separator is a comma. Versions: xpdf-poppler-3.02-4.6.1.x86_64 evince-2.28.2-0.1.3.x86_64 acroread-9.4-0.1.1.i586 okular-4.3.5-0.3.1.x86_64 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=588196 https://bugzilla.novell.com/show_bug.cgi?id=588196#c12 --- Comment #12 from Carlos Robinson <carlos.e.r@opensuse.org> 2010-10-14 23:43:30 UTC --- Created an attachment (id=395079) --> (http://bugzilla.novell.com/attachment.cgi?id=395079) OOo writer file used to generate the test PDF Second round of tests - I will attach an OOo-writer document used to generate the PDF, the PDF, and the OOo-calc sheet with the importing done. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=588196 https://bugzilla.novell.com/show_bug.cgi?id=588196#c13 --- Comment #13 from Carlos Robinson <carlos.e.r@opensuse.org> 2010-10-14 23:44:22 UTC --- Created an attachment (id=395080) --> (http://bugzilla.novell.com/attachment.cgi?id=395080) Generated PDF from the OOo writer file -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=588196 https://bugzilla.novell.com/show_bug.cgi?id=588196#c14 --- Comment #14 from Carlos Robinson <carlos.e.r@opensuse.org> 2010-10-14 23:45:49 UTC --- Created an attachment (id=395081) --> (http://bugzilla.novell.com/attachment.cgi?id=395081) OOo calc sheet with the importing already done -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=588196 https://bugzilla.novell.com/show_bug.cgi?id=588196#c15 Kohei Yoshida <kyoshida@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |NEEDINFO InfoProvider| |carlos.e.r@opensuse.org --- Comment #15 from Kohei Yoshida <kyoshida@novell.com> 2011-01-11 16:27:01 UTC --- If you get a chance, try testing 3.3 (of LibreOffice). I have fixed several numbering fixes during csv import and pasting of text data. RC3 should be out the door soon. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=588196 https://bugzilla.novell.com/show_bug.cgi?id=588196#c16 --- Comment #16 from Carlos Robinson <carlos.e.r@opensuse.org> 2011-01-28 00:17:45 UTC --- I will attempt to install factory somewhere. I can't risk installing L.O. in my working installs: for me OO is a must-work software, not for play. Time permitting, which currently is scarce. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=588196 https://bugzilla.novell.com/show_bug.cgi?id=588196#c17 Carlos Robinson <carlos.e.r@opensuse.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |REOPENED InfoProvider|carlos.e.r@opensuse.org | --- Comment #17 from Carlos Robinson <carlos.e.r@opensuse.org> 2011-02-23 01:44:40 UTC --- Ok, I just tested with LO in 11.4 RC-1 (3.3.0) I opened the .ods file of #14 in LO, and the .pdf of #13. I attempted pasting the column of numbers into LO. At first attempt, I got a dialog import window (like the CSV import), and the numbers were imported as text - failure. I tried again, and I noticed that the dialog said it was using for language the default English; so I changed that to Spanish, and pasted - success, I got numbers. I looked at the option menu, and saw that the default language (locale) was English (even if the document has Spanish as language), so I changed that to Spanish - this changes the decimal separator to a comma. I attempted the paste again, and this time the dialog was showing the correct locale as Spanish, and the import succeeded, I got numbers. So yes, the issue seems solved. It is the first time I try LibreOffice. It is 2:39 AM and I'm sleepy, thus prone to mistakes; but still I think it looks good. (I double checked in 11.2, to see if the locale setting was correct: it was. No mistake, the behaviour in OO 3.2.1 is buggy) -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=588196 https://bugzilla.novell.com/show_bug.cgi?id=588196#c18 Kohei Yoshida <kyoshida@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution| |WORKSFORME --- Comment #18 from Kohei Yoshida <kyoshida@suse.com> 2013-02-01 20:06:13 UTC --- I just tested this again just to be sure, and I can verify that Calc pastes numbers as numbers, both from the web browser and from evince. I've used LibreOffice 4.0. I'll close this bug. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
participants (1)
-
bugzilla_noreply＠novell.com