Summary: | Denote delimiter in exported report results | ||
---|---|---|---|
Product: | Koha | Reporter: | Andrew Fuerste-Henry <andrew> |
Component: | Reports | Assignee: | Bugs List <koha-bugs> |
Status: | NEW --- | QA Contact: | Testopia <testopia> |
Severity: | enhancement | ||
Priority: | P5 - low | CC: | sspohn |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: | ||
Circulation function: | |||
Attachments: | Bug 38497: Denote delimiter in report csv |
Description
Andrew Fuerste-Henry
2024-11-20 17:28:51 UTC
Created attachment 174860 [details] [review] Bug 38497: Denote delimiter in report csv To test: 1- set delimiter to something other than comma 2- run and download report as CSV, try to open in Excel, it doesn't recognize your delimiter 3- apply patch 4- repeat 2, now it does recognize your delimiter (In reply to Andrew Fuerste-Henry from comment #1) > Created attachment 174860 [details] [review] [review] > Bug 38497: Denote delimiter in report csv > > To test: > 1- set delimiter to something other than comma > 2- run and download report as CSV, try to open in Excel, it doesn't > recognize your delimiter > 3- apply patch > 4- repeat 2, now it does recognize your delimiter Proof of concept, but not setting to NSO. This "sep=" function seems to have pretty spotty implementation (Excel and LibreOffice do it, Numbers does not). And in LibreOffice you end up with a first row that just says "sep=". Additionally, what I've written here breaks if you're using / as you delimiter. That slash ends up escaping the \ of the "\n" that follows it. I had enough other misgivings that I didn't pursue a fix for this. |