GNOME Bugzilla – Bug 423603
Paste of numeric values no longer functions as in prior version(s)
Last modified: 2007-03-30 01:27:45 UTC
Please describe the problem: Copy text $38,115.33 from some other app, such as web page. Paste into a blank gnumeric sheet. Prior to recent upgrade of gnumeric, the value appeared in gnumeric as $38,115.33 (as one would expect). 1.7.8 now displays that as $38,115 Steps to reproduce: 1. See above (description) Copy text $38,115.33 2. Paste into cell. 3. Actual results: See above! Expected results: Would expect to see the pasted value appear as it was copied, as happened in prior versions of gnumeric. Does this happen every time? Yes Other information: Unsure what prior version is, but suspect 1.6.x or thereabouts. This may seem minor, but it's a PITA to reformat numerous spreadsheets that previously worked just fine for tracking finances, and are now unusable because they round off to nearest dollar, instead of simply taking the input the software is given.
Is the value in fact rounded or only displayed without decimals? What happens if you change the cell format to 2 decimals?
Created attachment 85430 [details] test case
Yes, it is rounded. $5.4 displays as $5, $5.5 displays as $6. Yes, one can change the format, but that then has to be done for all cells. Previously, gnumeric was clever enough to see that "$33,111.15" means show a dollar sign, include a thousands separator, and show two decimals. Understand that this problem involves working with 1.6.x spreadsheets under 1.7.8. oddly, I find that the cells which were previous filled in (with the older version), and which display values "correctly", show the format as simply "General." I am sending along a very simple spreadsheet that displays what I'm talking about. Compare the formatting of cells B5 and B6. To me, they show as identical: both fields show "General" as the format. Put your cursor on B6. Look at the number in B5, and type it in, by hand. It doesn't display the same, in spite of the fact that the cell values are equal, and the formatting is, from all indications, identical. More typically, instead of typing in a new number into B6, I copy a number from a web page and paste it in, but the copied text is still in the form $35,111.15 or similar, so I hope you get the gist. Let me know if there's anything else I can provide. Regards from Portland, Jim
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report. (The fact that Ctrl-1 did not pop up the right format was actually two different bugs.) Note: while you're waiting for the fix, you can probably just pre-format the target area with a two-decimal format.