https://bugs.documentfoundation.org/show_bug.cgi?id=172224
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #3 from ady <[email protected]> --- (In reply to Motim from comment #0) > Then sometimes the pasted entry > 'jumps' to the left in the box, and it is just as a simple number, not as > currency. Select the column and define it again as currency - nothing > changes. > To correct it, I have to delete the entry, make a manual entry, then its OK. > It happens in any of the currency columns, not in the same allways. > Am I doing something wrong, or something in the program ? My guess is that what you see as a number pasted is not really a number, but a text that looks as a number. There is a chance that you are pasting a "number" that has a different decimal separator or a group separator in comparison to what the cell expects (according to its Locale format). When you find a case that causes you this kind of problem, you could try copying from the built-in calculator and pasting the value in a plain text editor (e.g. notepad). Then manually enter the number in Calc, check that it is correctly displayed as currency, and copy it, then paste the value on the plain editor too. With both values in the plain text editor, compare between them. Are both using the same decimal marker? Are both using the same group (aka thousand) separator? Since we are talking about private information, there is not much we could add to solve your problem; we could only guess. Moreover, until we could have some way to replicate the problem, we cannot consider this to be a bug report. I would suggest using a forum such as <https://ask.libreoffice.org> for this kind of questions (as this is not really a bug report at this stage), but please be aware that anyone trying to help you there will probably request some sample file too. You could "sanitize" your spreadsheet (search the wiki for how to do it) in order to minimize the possibility of sharing private information. I am setting this report as NEEDINFO, awaiting for additional details and feedback. -- You are receiving this mail because: You are the assignee for the bug.
