https://bugs.documentfoundation.org/show_bug.cgi?id=99732
Spencer Graves <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|NOTABUG |--- Ever confirmed|0 |1 --- Comment #3 from Spencer Graves <[email protected]> --- Thanks for the review. My real problem is that when I paste a number like $1,234.56 into a cell, sometimes it is converted to numeric and sometimes it stays as character, which looks like a number and computes as a number with "+" but not "sum". Worse, I could not find an easy way to convert the text into a number. Sometimes the number starts with a single quote, like ('1234). If I see that, I can remove the single quote. Otherwise, I can't just type the number over, because the cell is now committed to text. I tried typing the number in manually without "$" and "," and found that the cell was committed to text and converted the number to text. I have to insert a new cell, carefully enter the number manually, then manually delete the cell committed to text. You are correct, that it's not a problem with "sum" -- nor with "+": If either were changed, it would break lots of spreadsheets people have used for years. Thanks, Spencer Graves -- 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
