https://bugs.documentfoundation.org/show_bug.cgi?id=99249
Buovjaga <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |needAdvice Status|NEEDINFO |UNCONFIRMED Ever confirmed|1 |0 --- Comment #5 from Buovjaga <[email protected]> --- 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. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
