https://bugs.freedesktop.org/show_bug.cgi?id=46773
--- Comment #13 from Eike Rathke <[email protected]> 2012-08-27 23:42:05 UTC --- (In reply to comment #4) > I was thinking that it could be because in spanish formats we use "," instead > of "." for the float values, and somehow it could lead to some error between > the files? This sounds as if the data was copied via clipboard (or how did you "import" it after the query?), in which case the textual representation seems to be treated as input and indeed 98.2 would result in text and 23.2 in date 2012-02-23 (in es-ES locale and LibO 3.5, in LibO 3.6 also that would be text). As a workaround the US-English locale should be active (Tools->Options->LanguageSettings->Locale) when copying the data to have the same separators. However, the proper procedure is to register the database in LibreOffice as data source and then in Data->PivotTable->Create select "Data source registered in LibreOffice" and after OK select the Database and Type query and the query you created. -- 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
