To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=54341 Issue #:|54341 Summary:|Save to Text CSV Inconsistencies (Errors ??) Component:|Spreadsheet Version:|680m125 Platform:|PC URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|save-export Assigned to:|spreadsheet Reported by:|sblass
------- Additional comments from [EMAIL PROTECTED] Wed Sep 7 15:49:13 -0700 2005 ------- 1. Numbers formatted to display decimal positions (e.g. #,##0.00) in Calc will lose their formatting upon file conversion to CSV. That is, 123,456.70 becomes 123456.7; 123,456.00 becomes 123,456; etc. If I have two decimal positions displayed in Calc, then I want to see the same number of decimal positions - NO TRUNCATION - in the CSV file. To combat the problem, I have to create a temporary column and use the Text function (e.g. =Text(L1;"0.00") to get a column of text that will yield the expected result. 2. Date values displayed with YYMMDD format (e.g. date 1/22/2004, displayed in Calc as 040122) will not carry through in the same format to the CSV file. Instead, using the same example, the date field gets expressed in the CSV file as 01/22/2004. --------------------------------------------------------------------- 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]
