To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83667 Issue #|83667 Summary|Auto-format erroneously converting TEXT value into DAT |E Component|Spreadsheet Version|OOo 2.3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|rjms
------- Additional comments from [EMAIL PROTECTED] Thu Nov 15 15:08:24 +0000 2007 ------- When copyijng data from the USDA database (http://www.nal.usda.gov/fnic/foodcomp/search/index.html) into CALC, there is a problem where CALC insists on auto-formatting the input and it causes an error. Sequence: Open this link (http://www.nal.usda.gov/fnic/foodcomp/search/index.html) and choose any food. Now highlight the data, and copy it into CALC. Everything works fine except in the "LIPIDS" identifiers, in the first column. Sample column from Bananas: Lipids Fatty acids, total saturated 4:0 6:0 8:0 10:0 12:0 14:0 16:0 18:0 Once that data is in the fields, it gets converted into a "time" value so that 4:0 becomes 04:00:00 AM. No attempt to change the data into 4:0 by defining the data as text data works, and even if the whole column is defined as text data, CALC still insists on auto-formatting 4:0 and similar values into time values. The manual work around is to enter '4:0. Tis is a major problem if large anounts of data are being studied. It would be better if CALC re-displayed the data as it was pasted in once the auto-formatted time value was switched back to text. A better solution would be: 1)User selects column to be used for data. 2)User selects column and the selects "Format Cells" 3)User selects "text" 4)All data pasted into a column is displayed verbatim,with no conversions. --------------------------------------------------------------------- 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]
