https://bugs.freedesktop.org/show_bug.cgi?id=47109
Rainer Bielefeld <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |LibreOffice@bielefeldundbus | |s.de Summary|[IMPORT] Link to external |'Insert external data' form |HTML file import dates well |HTML table imports US dates |but with the cell formatted |31/12/2012 with Text |as text. |FORMATTING --- Comment #6 from Rainer Bielefeld <[email protected]> 2012-09-16 07:42:52 UTC --- It seems that I can not reproduce that problem with "Server Installation of "LibreOffice 3.5.1.2 English UI/Locale [Build-ID: dc9775d-05ecbee-0851ad3-1586698-727bf66] on German WIN7 Home Premium (64bit)", 'Tools -> options -> LoadSave -> HRML Compatibility' Check Import = Use English (USA) 1. New Spreadsheet 2. Menu 'Insert -> Link To External Data' for sample document "Table with three columns, second column is date 3. In dialog "Import Options" check "Language=Automatic", "Detect Special Numbers" <ok> > HTML contents listing appears after few moments 4. Select "HTML_tables" <ok> HTML page table conetents will appear in spreadsheet after few moments To check what has been imported I formatted 3 other Columns as Number and in the cells I did a SUM of 2 vertically adjacent cells, what showed that the "dates" in the cells like "01/16/2012" were text, because the result for the SUM was "0.00" So I can confirm reporter's observations. Now we have to check whether the problem persists with latest versions. Additionally we will have to check whether there are additional strange aspects. For example when I import table from <https://wiki.documentfoundation.org/User:RBd/Workbench/Draft1> with 'Tools -> options -> LoadSave -> HRML Compatibility' Check Import = Use English (USA), it seems LibO recognizes "1/2" as date and completes it to "01/02/2012", but the formatting in the Cell is as text what a " =SUM()" test will show. I am pretty sure that this is a bug, but I will have to think about relations to "Bug 53177 - CONFIGURATION "Use 'English (USA)' locale for numbers" messes with dates and "insert link to external data"" and others. Any idea with what version this started? -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
