http://bugzilla.novell.com/show_bug.cgi?id=588196 http://bugzilla.novell.com/show_bug.cgi?id=588196#c2 --- Comment #2 from Carlos Robinson 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#c4 --- Comment #4 from Carlos Robinson 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#c6 --- Comment #6 from Kohei Yoshida 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#c7 Kohei Yoshida changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO InfoProvider| |carlos.e.r@opensuse.org --- Comment #7 from Kohei Yoshida 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#c9 Stefan Behlert changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW InfoProvider|carlos.e.r@opensuse.org | --- Comment #9 from Stefan Behlert 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#c11 Carlos Robinson changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|FIXED | --- Comment #11 from Carlos Robinson 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#c13 --- Comment #13 from Carlos Robinson 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#c15 Kohei Yoshida changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |NEEDINFO InfoProvider| |carlos.e.r@opensuse.org --- Comment #15 from Kohei Yoshida 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#c17 Carlos Robinson changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |REOPENED InfoProvider|carlos.e.r@opensuse.org | --- Comment #17 from Carlos Robinson 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.