Apache OpenOffice (AOO) Bugzilla – Issue 99118
automatic type recognition doesn't work when pasting from Calc
Last modified: 2017-05-20 10:28:49 UTC
- open the attached spreadsheet document - mark the range A1:B6 - Edit / Copy - open a database document of your choice - select "Tables" on the left hand side - Edit / Paste => the "Copy table" wizard opens - on the first page, press "Next" - on the second page, move all fields to the right hand side list box, and press "Next" - on the third page, press the "Auto" button This is expected to automatically determine the fields types for all columns. However, both the "Date" and the "Value" column still have the "Text [ VARCHAR ]" type. Given that in the source document, "Date" is explicitly formatted as date, and also contains only date values, where "Value" is formatted as Number, and contains only numbers, I would say this is not the expected result.
Created attachment 60090 [details] document to reproduce the bug case
Fixed in cws dba32b
fs->msc: please verify in CWS dba32b
going to submit a follow-up issue because copying the date values does not succeed. As far as the very original bug is concerned, it's fixed - "Auto" does what it's expected to do.
submitted issue 102479 for the failure to copy the "Date" column data.