Created attachment 125382 [details] numbers paste as characters and do not "sum", giving wrong answers without warning On 2016-05-08, I posted a problem with copy of numbers that were pasted as characters and resisted being changed to numbers. I was unable to replicate it. Now I can; see the attached: Go to "www.victorianweb.org/economics/wages2.html", and copy the “Cost of Living for a senior clerk (1844)”. Then try to paste it into Calc. I could not get it to work properly. LO 5.1.2.2. looked like it worked write but gave the wrong answer using sum. LO 5.1.3.2 would not paste properly for me. Documented in two sheets in the attached.
Trying to copy the “Cost of Living for a senior clerk (1844)” http://www.victorianweb.org/economics/wages2.html using LO 5.1.2.2 and 5.1.3.2 on Mac OS X 10.11.5. I had a similar problem 2016-05-08, which I confirmed with 4.4.0.2 as well as 5.0.2.2. At that time, I could not replicate it. Now I think I can; see the attached. Thanks, Spencer Graves
I can not confirm with Version: 5.2.0.0.alpha1+ Build ID: fa9416906e615f5f19ad8524176d2ed693662769 CPU Threads: 4; OS Version: Linux 4.4; UI Render: default; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-05-24_00:05:55
Spencer: raal's result is interesting, can you confirm the problem is not in 5.2/5.3? http://dev-builds.libreoffice.org/daily/master/MacOSX-x86_64@49-TDF/current/
Created attachment 125420 [details] LO Calc file showing problems pasting a table from the web
No problem here. It is pasted in two columns. I noticed you had written about your experiences with 5.2 and 5.3 inside the document. Version: 5.1.3.2 Build ID: 644e4637d1d8544fd9f56425bd6cec110e49301b CPU Threads: 4; OS Version: Mac OS X 10.11.5; UI Render: default; Locale: en-US (en.UTF-8)
Sorry: My description was incomplete: After you get it in two columns, split the second column into pounds, shillings and pence using Data -> "Text to columns" -> Separated by other = "/". Note that some of the "numbers" are right adjusted, some left. Now "sum" the pounds column": In LO5.1.2.2, cell B34 contains "=SUM(B14:B33)". That sum in my version is 99, which is the sum of the numbers that display right adjusted. The numbers that display left adjusted are apparently recognized as characters, not numbers, and so do not enter into the sum. "+" gives a different answer: Cell E17 contains "=E16+B17": E16 contains a number. B17 contains two characters that look like a number. "+" adds them as numbers. "=SUM(B14:B33)" treats B17 as character and does NOT include it in the sum. Thanks, Spencer Graves
I tried to change B17 from characters to numbers but could not figure out how to do it. Thanks again, Spencer Graves
I could reproduce the text to columns result on OS X, but not on Linux! eVrsion: 5.3.0.0.alpha0+ Build ID: b2f994469f3e2f1fe72e9f103b840aa949ace6dd CPU Threads: 4; OS Version: Mac OS X 10.11.5; UI Render: default; TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2016-05-25_23:36:03 Locale: en-US (en.UTF-8)
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.4.1 or 5.3.6 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170901
I'm not seeing any issue in the current version. I'm able to copy the table (as long as I don't select the merged cell), and split on the "/" Note that LibreOffice first thinks some of these numbers are dates in my locale settings, but when I split them the still have the same value. It is to be expected that you have issues like this though when pasting from the web.