http://bugzilla.novell.com/show_bug.cgi?id=588196 http://bugzilla.novell.com/show_bug.cgi?id=588196#c6 --- Comment #6 from Kohei Yoshida <kyoshida@novell.com> 2010-04-16 15:36:17 UTC --- This problem consists of two parts. Part 1 is about pasting numbers from an external source into Calc, and Calc pastes them as text. Part 2 is how Calc handles cell inputs when the cell format is Text, and vise versa. Part 2 is not a bug, but is by design. What would be nice to have is an easy way to convert text numbers into real numbers (like Excel does), but as far as how Calc handles numbers when the cell format is Text, it's by design. Part 1 may already have been fixed in the latest 3.2.1 build on master. Check the separator values in the Options dialog (OpenOffice.org Calc - Formula). If one of them contains ',', then it may be conflicting with the locale specific decimal separator. Workaround is to push the Reset button in the Formula page, to reset the values appropriate for the locale. The latest build does that automatically when switching locales in the Languages page. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.