[Bug 40015] New: Exporting budget to Exel has error
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40015 Bug ID: 40015 Summary: Exporting budget to Exel has error Change sponsored?: --- Product: Koha Version: 24.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Acquisitions Assignee: koha-bugs@lists.koha-community.org Reporter: paivi.knuutinen@joensuu.fi QA Contact: testopia@bugs.koha-community.org When you export acquisition data to Excel, and there are negative (minus) amounts in budget, Koha adds wrong symbol (') before the amount. It's not possible to count the rows that include this symbol. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40015 Päivi Knuutinen <paivi.knuutinen@joensuu.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 - low |P3 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40015 Emmi Takkinen <emmi.takkinen@koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |emmi.takkinen@koha-suomi.fi --- Comment #1 from Emmi Takkinen <emmi.takkinen@koha-suomi.fi> --- This comes from bug 37727, minus sign is considered as unsafe character and we add ' mark before them. Could we handle minus sign separately to determine if it's used in harmful context e.g. if it's added between strings or end of string or something like that? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40015 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au --- Comment #2 from David Cook <dcook@prosentient.com.au> --- This'll need some more thought. Bug 37727 is a local workaround because support for "escapeExcelFormula" wasn't added to DataTables Buttons until 3.2.0: https://github.com/DataTables/Buttons/blob/master/js/dataTables.buttons.js#L... I suppose for acquisitions tables or at least money columns that are calculated perhaps it would be possible to do a custom display. I've opened bug 40523 because there's a number of DataTables Buttons changes that we need to make to improve things... -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40015 Mathieu Saby <mathsabypro@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mathsabypro@gmail.com -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org