To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111475 Issue #|111475 Summary|Pasting Base records (de) to Calc (de) changes dates Component|Spreadsheet Version|OOo 3.2 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|h1onooo
------- Additional comments from [email protected] Sat May 8 11:01:23 +0000 2010 ------- I work with a German OOo 3.2 with default language set to German for all documents. I have tables and queries in a Base database with dates in DD.MM.YYYY or DD.MM.YY format. When I copy records from those tables - either selected records or complete queries/tables - and paste them to a Calc spreadsheet, the dates are interpreted as if they were in the MM.DD.YY format, even though the standard date format in the spreadsheet is DD.MM.YY, and the column is formatted DD.MM.YYYY. Example: 08.03.2010 is pasted as 03.08.2010 When using Paste Special I have two options: formatted text (RTF) or hypertext (HTML), nothing else. Pasting RTF shows the behavior above, while pasting HTML pastes the whole table regardless if I copied only selected records or not AND changes ALL dates as noted above. Pasting to Writer works as expected, date and format preserved. But Paste Special fails on both RTF and HTML with "format not available"?!? Other programs (Clipboard Viewer, Notepad, multiple editors) cannot interpret the clipboard contents and will not even offer a paste option or paste nothing. Copy&Paste between Base and the rest seems pretty tricky. Workaround: When using Drag&Drop - dragging a table or query to a spreadsheet table - preserves the dates and does no formatting. But it destroys any previous contents of the table, so be sure to use a new one. So my workflow - to get some database rows into a spreadsheet to use them for further calculations - looks like this: - open new spreadsheet - drag query/table from database into spreadsheet table - copy already selected data from the spreadsheet to the clipboard (if I need all records - if I need only a part of them and there are many records in the database table it is easier to create a new query selecting only the records wanted and drag this query) - paste to 'work spreadsheet' where formulas are already in the columns after the record data Btw: Pasting the records to Writer works as already noted. Copying then the table in the Writer document (with correct dates) and pasting them to Calc results again in changed dates. So Base and Writer both write a clipboard format that they understand correctly according to the NLS settings, but Calc fails to honor those settings. Programs outside the OOo suite cannot read this clipboard format at all. --------------------------------------------------------------------- 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]
