Copy a list of accounts and totals from a web page. Paste into Calc as unformatted text. Sum the column of numbers. Calculation is wrong. I did this numerous times. I don't know if it is me or Calc 5.0.1. Paste the html into a text editor and then copy paste into Calc and the calculations are correct.
If you use 5.1 branch, could you give a try to last 5.1.2? Also, could you give a step by step process including the website you used?
As you requested, I tried the same thing in LO 5.1.2.2. The bug does not seem to apply. The website was https://banking2.capitalone.com. I don't want to publicly post any data files. The step by step process was to open and sign into the bank website. Open a Calc sheet to receive the data. First select and copy data from website. Click on LO, then click in first cell A1. Right click and select Paste Special. Choose Unformatted Text from the two choices, Unformatted Text and HTML Formatted Text.
I don't know, if this can be said to be the fault of Calc's. Websites can add any crap they like in the HTML markup and it might mess things up. If you can't share the HTML, we will never know what the problem is. You might copy the HTML and replace any sensitive data. It could just be a couple of rows so we see the structure. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the data.
Created attachment 124827 [details] Zip file of summary html page and folder of supporting files for problem This is the html page the bank serves. Sensitive information has been "REDACTED" or set to $0.00 value. The supporting folder is images, java script files, etc.
Something is not right with LibreOffice. I have "Detect special numbers" checkbox ticked when doing a special paste, yet the amounts are not detected as Currency format type. The same happens with a simple CSV: $1,00;$2,00;juu $1,00;$2,00;juu It gives them the default format. Right-click - Format cells - Numbers to check. The same behavior is already in version 3.5 for me. Yet, the web is full of people saying Detect special numbers solved their currency import problem. You could do a mass change of the format after pasting/importing, but that always adds an apostrophe so it reads '$1,00. So you would have to get rid of that as well. Here is an extension that might help, I didn't test: http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates This needs more testers and insight.
Created attachment 132316 [details] simplified html file
* copy data from the html page. * click in first cell A1. * right click and select Paste Special. * choose Unformatted Text * "Detect special numbers" checkbox is NOT ticked RESULT: LO does not detect the numbers * copy data from the html page. * click in first cell A1. * right click and select Paste Special. * choose Unformatted Text * "Detect special numbers" checkbox IS ticked RESULT: LO detects the numbers * copy data from the html page. * click in first cell A1. * right click and select Paste Special. * choose HTML format RESULT: LO detects the numbers * copy data from the html page. * paste it in a text editor * copy the text from the text editor * click in first cell A1. * right click and select Paste * Unformatted Text is automatically detected * "Detect special numbers" checkbox IS ticked RESULT: LO detects the numbers * copy data from the html page. * paste it in a text editor * copy the text from the text editor * click in first cell A1. * right click and select Paste * Unformatted Text is automatically detected * "Detect special numbers" checkbox is NOT ticked RESULT: LO does not detect the numbers
Works as designed. The "number" is preceded with a dollar sign and contains a decimal separator. To be imported as a numeric number it has to be interpreted as English-US and "Detect special numbers" has to be checked.