To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68871 Issue #|68871 Summary|oo2.0.3 spreadsheet export to .csv truncates floating |point numbers Component|Spreadsheet Version|OOo 2.0.3 Platform|All URL| OS/Version|Unix, X11 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|akho
------- Additional comments from [EMAIL PROTECTED] Tue Aug 22 11:11:30 -0700 2006 ------- Hello, My OS is Linux (Fedora Core 1) and I had been using OpenOffice 1.1.5 until this week (Aug 22, 2006) when I switched to OpenOffice 2.0.3 and noticed the following feature on the oo2.0.3 Spreadsheet that was not on oo1.1.5. When I open a tab-delimited text file with floating point numbers, say, Row_u133.2 CV_WT CV_MT Symbol 29687 0.4925 0.6073 A1BG 17184 0.8158 0.4418 A2M On oo2.0.3 spreadsheet when I try to save it back into tab-delimited .csv format, the floating point numbers are truncated to resemble what appears on screen. See example below, "Row_u133.2" "CV_WT" "CV_MT" "Symbol" 29687 0.49 0.61 "A1BG" 17184 0.82 0.44 "A2M" On oo1.1.5 spreadsheet, when I try to save the original back into tab-delimited .csv format, the result was identical (ignoring " marks on non-numbers) see example below, "Row_u133.2" "CV_WT" "CV_MT" "Symbol" 29687 0.4925 0.6073 "A1BG" 17184 0.8158 0.4418 "A2M" As a data analyst, I think this new feature on oo2.0.3 that truncates the original floating point numbers to look exactly like what appears on the screen is not an improvement over oo1.1.5's handling export .csv files. I did try re-formatting the cells to text prior to CSV export which made matters worst as truncation became permanent. I will be sticking to oo.1.1.5 for the time being. In case you want to try these files out yourselves, I've put examples of the 3 files up on my website, www.chip.org/~kho/Original_Tab_Delim_Data_File.txt (original tab-delim file) www.chip.org/~kho/Original_Tab_Delim_Data_File_oo2-0-3.csv (save from oo1.1.5) www.chip.org/~kho/Original_Tab_Delim_Data_File_oo1-1-5.csv (save from oo2.0.3) Thank you in advance for looking at this, [EMAIL PROTECTED] --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
