Created attachment 118581 [details] Numbers with extra character Copying data with numbers nn.mm into a spredsheet. OK Converting cells with numbers nn.mm to nn,mm Most cells behave OK but some rows behave ackward. Having an extra ' in front of the amounts The purpose of converting from english nn.mm to the danish nn,mm is to prepare for making eg SUM(A1:A15)/TAEL(A1:A15) Average in the danish version of Libre Office. This needs the ,-version It is necessary to manually remove the ' in the cells in question, before the calculation is functioning. There is no unambiguous behaviour with faulty numbers in certain cells, or certain rows. Immediately after the transforming from . to , there is no fault to be seen, but the calculation fails. After some searching in the faulty cells the numbers change from nn,mm to 'nn,mm and reveals the misbehaveour ! Attached you have an example of a PrintScreen. Yours Sincerely B. Reimann
How do you convert them from having . as decimal separator to , ? Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the information.
Additional info. (Sorry for the delay) About my converting from . as decimal separator to , as a separator: I marked an area, choosed "Edit", "Search and change", (In danish Soeg og erstat) "Search" . "Search all" "Change to" , "Change all" And the selected area having numbers changed to comma-numbers. Then the fault came up. Some cells got an extra ' in front of the numbers. Preventing eg. a summation. A manual correction of those numbers was necessary. I have no idea about what kind of cells or rows or number-types (%?) which might be connected to the faulty behaviour. All the original numbers were copy-pasted from a financial page with data. (Financial Times ft.com) Next time I copy-paste from that database I shall investigate the original numbers before I continue converting. But still there is a strange difference between what can be seen in a cell and the same number/image in the correction-row ahead of the spreedsheet. -as shown in the former bug-description. Boris
Why didn't you do it with Format cells - Numbers - Number - change Language from English to Danish?
This isn't a bug - it's how text is treated in LibreOffice (note that Excel has similar situations). Closing as NOTABUG. There are enhancement requests pertaining to incorporating "text to num" in LibreOffice. The situation is you have values that for whatever reason is formatted as text, when you "convert" it to a number, it adds the ' in front to show that it's text and thus functions can't be done on it like it's a number. This extension will convert for you: http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates