To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68260 Issue #|68260 Summary|pivot table data refresh changes cells format to date Component|Spreadsheet Version|1.0.3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|chrb
------- Additional comments from [EMAIL PROTECTED] Tue Aug 8 08:01:33 -0700 2006 ------- I've tested on Windows and Linux and issue occurs on both. This is probably not an xsl import issue as the same occurs when file is saved and reloaded as .ods. To reproduce: Load the attached .xls file in oocalc Go to sheet "Received shipped" (though also happens with pivot tables in "In out report" and "Fault analysis") Right click on cell A5, click refresh Result: Cells in column C change format to Date What should happen: Try the same in MS Excel. The C column should be integer values with various counts. --------------------------------------------------------------------- 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]
