To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93495
------- Additional comments from [EMAIL PROTECTED] Mon Sep 29 22:00:38 +0000 2008 ------- This problem is caused by two things. 1) DataPilot relies only on Calc's automatic format recognition given a date string. So, if Calc cannot recognize the given string as a date, the date value is lost at that point. IOW, this problem occurs for the same reason Calc inserts it as a string when you type "Tue, Jan 1" directly into a cell. 2) When DataPilot's results are computed, column and row's member values only carry string data. IOW, even if a member is a number or a date, the result set only stores a textural representation of that data. So, by the time the DataPilot table is constructed, we no longer have the numerical value of the number/date member. I've already tried to fix it by fixing Calc's number format parser, but that parser code is such a mess, that modifying that code would likely introduce regressions. The right fix IMO is to preserve the numerical value of column/row members during result calculation. That will probably require extending or replacing com.sun.star.sheet.MemberResult struct so that numerical values are preserved for the table output. Either way, fixing this will be non-trivial. --------------------------------------------------------------------- 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]
