To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75196
------- Additional comments from [EMAIL PROTECTED] Wed Mar 7 12:50:08 +0000 2007 ------- A workround for this is to 1. Create a second data sheet where each normal cell (i.e. H11) contains the formula "=Sheet1:H11" and all date cells contain the formula: =IF(NOT(ISBLANK($Sheet1.H11));$Sheet1.H11-2;"") 2. Ensure all date cells are formatted so that the 'Number' tab shows them formatted as dates. Copy and paste into the database then gives the right result. --------------------------------------------------------------------- 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]