https://bugs.documentfoundation.org/show_bug.cgi?id=172224
--- Comment #7 from ady <[email protected]> --- Just for those that might read this and lack the experience or knowledge... The "number" 1,738.24 is not just a number. If in Calc you happen to have the dot (period) as group (aka "thousand") separator (delimiter), then that "number" cannot be parsed as a number. Let's assume that in Calc the relevant cell is formatted with a Locale that has the dot as decimal separator, and that you paste the number "1234.56" (without quotation marks, and please note that there is no group separator). If the relevant cell is formatted as "General" ("Standard"), then pasting that value should be parsed as a number. With other combinations, there is a chance that the value that you paste will be parsed as a number, but there will be some combinations (cell formatting, decimal separator, group separator included in the value...) that cannot be parsed as numeric value, so it might be parsed as Text. Additionally, please remember that the content of a cell is not the same as the way the value is displayed. These are 2 different things. Depending on context, pasting on the formula bar input window gives you a different result than pasting on the cell itself. Since we have no specific details, we cannot be more specific about what exactly triggers the problem in your particular case. I would guess it is just a matter of adequate configuration, rather than a bug in Calc, but I am leaving the status as WFM anyway. Someone else might rather set this as NAB or as insufficient data. I am choosing WFM for practical purposes. Generally speaking, this kind of doubts should rather be asked at <https://ask.libreoffice.org>, rather than opening a report, because you don't even know whether there is a bug or not. If other users at the ask forum site could confirm that there was/is a bug, then you are encouraged to file a bug report. Whichever the case, you probably need some "sanitized sample file" (<https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission>). Opening a report (or a topic at the ask forum) when there is no way to replicate the problem by anyone else will have limitations on how much anyone can help. -- You are receiving this mail because: You are the assignee for the bug.
