https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39327
--- Comment #6 from Michał <[email protected]> --- > the data import feature works, but adds many clicks and is training intensive Well, for some locales it only works this way (having to use the import feature, as a standard routine), so the fact "just opening" a .csv works for others is just a coincidence, and catering to that a kind of (unfair?) favouritism. > This stays a major annoyance to librarians even after training. So then I think the proper solution to have all librarians get a seamlessly-openable sheet in office suites, with proper columns and encodings and no fiddling with settings, is to have an XLSX/Excel export option everywhere. Because CSV support in Excel is too finnicky to expect it to just work for majority of people (I wasn't even aware it ever works, since for us it only supports semicolon delimeters detection by default). I mean the datatables have "Excel" option next to "CSV", so it'd be only fair to add it to other places. And we'd avoid butchering the CSVs with "Microsoft-ism" (which again, while solving this edge case, would be bound to introduce new problems and confusion, such as for if someone concatenates the files etc.). There's already `labels/label-create-xml.pl` and it technically looks like a HTML table saved as .xml opens up properly in Excel as a lazy solution... (but that'd be incompatible with current .xml, and saving them as .xls or .xlsx works but certainly doesn't seem proper either). So I guess the most proper solution would be to use some kind of library for XLSX creation instead...? Either that or have an option called "XML for Excel", idk. But basically either of these below saved as .xml should be just picked up by Excel (I only tested with LibreOffice due to lack of Excel by hand, but found these examples around Excel on the internet): <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <html xmlns:x="urn:schemas-microsoft-com:office:excel"> <body> <table> <tr><td>author</td><td>title</td></tr> <tr><td>Val1</td><td>Val2</td></tr> <tr><td>Авиабилет</td><td>Tλληνικ</td></tr> </table> </body> </html> ==== or ==== <?xml version="1.0" encoding="UTF-8"?> <?mso-application progid="Excel.Sheet"?> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40";> <Worksheet ss:Name="labels"> <ss:Table> <ss:Row> <ss:Cell><ss:Data ss:Type="String">author</ss:Data></ss:Cell> <ss:Cell><ss:Data ss:Type="String">title</ss:Data></ss:Cell> </ss:Row> <ss:Row> <ss:Cell><ss:Data ss:Type="String">Val1</ss:Data></ss:Cell> <ss:Cell><ss:Data ss:Type="String">Val2</ss:Data></ss:Cell> </ss:Row> <ss:Row> <ss:Cell><ss:Data ss:Type="String">Авиабилет</ss:Data></ss:Cell> <ss:Cell><ss:Data ss:Type="String">Tλληνικ</ss:Data></ss:Cell> </ss:Row> </ss:Table> </Worksheet> </Workbook> -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
