To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80371
------- Additional comments from [EMAIL PROTECTED] Mon Aug 6 21:54:44 +0000 2007 ------- This seems to be very similar to the problem in 62797. I am, however, definitely using version 2.2.1. After a certain amount of frustration, I have managed to track down a further condition necessary for the bug to manifest itself: If the date information is formatted as a date in the spreadsheet (ie. the 'number format' is 'yyyy-mm-dd'), the import error does -not- seem to occur. If the date is formatted as an integer (ie. number format '0'), then the date imports as the date +2 days. The problem turned up in my case because the spreadsheet version of my data contains various formatting elements (eg. the header cells are a different colour) which are undesirable to import into the Base database. I had developed a habit, then, of first cutting and pasting the data into a blank spreadsheet using 'paste special' with the 'Formats' box unchecked, then recopying this data to import it into the database. This meant that my import was not messed up by cell colours, but it had the subsidiary effect of getting rid of the 'date' number format, as you noticed, and triggering the import problem. It seems intuitive to me, as an end user, that a given integer in the data would always represent the same date, regardless of the way in which it is formatted. Given that the data type has to be explicitly declared when it is imported to Base, the behaviour I would expect would be that the formatting of the spreadsheet would play no role. I have no idea whether this assumption is correct, but it seems so natural to me that I think that this might be a sign of an interface problem, even if the software itself is not making a true 'mistake' along the lines of issue 62797 (which it might be). Might there be some way of making the importation of date data format independent? I will shortly upload a copy of Coding_5.06.ods with the dates formatted as 'yyyy-mm-dd'. Please note that, if my researches are correct, data from this file should -not- import incorrectly into Base. Thanks, so much, for all your help. If I can provide any further help, please don't hesitate to ask. --------------------------------------------------------------------- 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]
