|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | copy paste date from calc to base becomes text | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | Base | Reporter: | timrichardson <tim> | ||||||||||
| Component: | code | Assignee: | marc.neumann | ||||||||||
| Status: | CLOSED FIXED | QA Contact: | issues@dba <issues> | ||||||||||
| Severity: | Trivial | ||||||||||||
| Priority: | P3 | CC: | issues, rb.henschel | ||||||||||
| Version: | OOo 1.0.0 | Keywords: | oooqa | ||||||||||
| Target Milestone: | OOo 3.3 | ||||||||||||
| Hardware: | Unknown | ||||||||||||
| OS: | All | ||||||||||||
| Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||||||
| Developer Difficulty: | --- | ||||||||||||
| Attachments: |
|
||||||||||||
Such question please ask on http://user.services.openoffice.org/en/forum. Please follow the rules: http://qa.openoffice.org/ooQAReloaded/Docs/QA-Reloaded-BasicRules.html During copy wizard you can set field types. You must check you calc file if the date inserted as text. I have taken more time to try to explain what I mean. Please show me the respect to read this carefully. 1) I don't understand which rule about reporting bugs I have not followed. Sorry. I not being annoying. I'm trying to be helpful. I'm a user trying to make the software better. I really don't know what's wrong with my bug report. I've clearly reported one and only one issue which is reproducible. The only possible mistake I made is that I have reported a "wishlist" bug. Perhaps rather than making it invalid, you could make it issue type "Enhancement" I think this is a bug because ... 2) The import transforms a date type to a text type. I can't see how that is correct behaviour. 3) Going the other way, from base to calc, works. So it's not consistent. 4) During the paste data wizard, there is an "auto recognise" data type option. You tell it how many lines of data to scan, and I supposed it would then make a good guess about data type. Isn't it normal to expect this to recognise dates as dates? Competing office software suites offer the same functionality, and this is why I expected date recognition. If it doesn't do that, what is 'recognition' doing? 5) I know that you can set a data type manually. That's a workaround for this bug, in my opinion. I cannot confirm the problem. If my column in Calc is formatted as date, then it is recognized as date in the import dialog. Do you have really clicked on "Auto" to start auto detection? What kind of database do you use and which connection? For example: embedded HSQL or MySQL with ODBC or ...? Please specify your operating system. Created attachment 66398 [details]
spreadsheet with dates to import
Created attachment 66399 [details]
resulting database (HSQL)
Created attachment 66400 [details]
screenshot during import (after auto recognition button clicked)
Created attachment 66401 [details]
schema after import completed
Reproducible on a) Linux Debian/sid and latest 3.1 packages b) Vista and latest Go OpenOffice.org c) XP and latest vanilaa OpenOffice 3.1.1 Affects both HSQL and MySql databases. Attachments show how I reproduce it. 1) Open the spreadsheet 2) Make a new database 3) copy the spreadsheet 4) paste into the tables section of the database and choose to append structure and data to make a new table. 5) Even after auto-recognition, the two spreadsheet columns formatted with a date format import as text. One date is formatted using short notation, the other with ISO My locale is English-Australia. Resolve issue, mark it as duplicate of issue 20680 *** This issue has been marked as a duplicate of 20680 *** close This one is no duplicate. The problem was a variable which was initialized with a wrong value. I fixed the problem in cws dba33d and now all columns are recognized as date. And thanks for the bug docs. Fixed in cws dba33d Please verify. Thanks. You have to press Auto on the last page to get the correct types. Thanks for the fix. Now I'm very glad I went to the trouble of reporting it. I don't know how to verify until I comes to an executable I can download; probably it will get into the Debain unstable build soon. oj's statement was directed to msc, our QA engineer, whose responsibility it is to verify, not to you :) reopen because it's not fixed. a) The first and the last column is imported as DATE but the second column is imported as double where text should be added . This generate of course an error. b) why I need to click on the Auto button? I guess the wizard should always use the auto recognition. reassign back to oj reassign back to me set to fixed OK, the auto function works as expected. Was my fault. The second part which use auto recognition automatic will be fixed later. verified in CWS dba33d find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33d |
Data in a calc spreadsheet which is a properly formatted date value in a cell of format date becomes text when the paste is done to create a new table ("copy definition and data"). Shouldn't it be a date field?