Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 627452 - dev-libs/libxlsxwriter - is a C library for creating Excel XLSX files
Summary: dev-libs/libxlsxwriter - is a C library for creating Excel XLSX files
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: All Linux
: Normal normal with 2 votes (vote)
Assignee: Efe İzbudak
URL: https://libxlsxwriter.github.io/
Whiteboard:
Keywords: EBUILD
: 661514 (view as bug list)
Depends on:
Blocks: 680938
  Show dependency tree
 
Reported: 2017-08-10 11:01 UTC by Petric Frank
Modified: 2022-08-29 22:39 UTC (History)
7 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments
ebuild for version 0.7.2 (libxlsxwriter-0.7.2.ebuild,777 bytes, text/plain)
2017-08-10 11:01 UTC, Petric Frank
Details
Remove bundled minizip from CMakeLists.txt (CMakeLists-remove-minizip.patch,826 bytes, patch)
2017-08-10 11:02 UTC, Petric Frank
Details | Diff
Point to system wide minizip includes (packager.h-system-minizip.patch,315 bytes, patch)
2017-08-10 11:03 UTC, Petric Frank
Details | Diff
Remove bundled minizip from CMakeLists.txt (CMakeLists-remove-minizip.patch,697 bytes, patch)
2017-08-10 11:07 UTC, Petric Frank
Details | Diff
ebuild for version 0.7.2 (libxlsxwriter-0.7.2.ebuild,785 bytes, text/plain)
2017-08-10 12:08 UTC, Petric Frank
Details
libxlsxwriter 0.7.3 (libxlsxwriter-0.7.3.ebuild,635 bytes, text/plain)
2017-08-13 14:47 UTC, Petric Frank
Details
ebuild for version 0.7.5 (libxlsxwriter-0.7.5.ebuild,638 bytes, text/plain)
2017-10-07 15:13 UTC, Petric Frank
Details
ebuild for version 0.7.7 (libxlsxwriter-0.7.7.ebuild,794 bytes, text/plain)
2018-05-30 16:32 UTC, Petric Frank
Details
patch enables conversion from comma to decimal point (libxlsxwriter-0.7.7-double-function.patch,2.08 KB, patch)
2018-05-30 16:36 UTC, Petric Frank
Details | Diff
ebuild for version 0.8.5 (libxlsxwriter-0.8.5.ebuild,731 bytes, text/plain)
2019-02-19 22:27 UTC, Jon Hood
Details
ebuild for version 0.8.5 (libxlsxwriter-0.8.5.ebuild,706 bytes, text/plain)
2019-02-19 22:32 UTC, Jon Hood
Details
ebuild for version 0.8.5 (libxlsxwriter-0.8.5.ebuild,723 bytes, text/plain)
2019-02-19 22:40 UTC, Jon Hood
Details
ebuild for version 0.8.7 (libxlsxwriter-0.8.7.ebuild,723 bytes, text/plain)
2019-08-16 17:32 UTC, Jon Hood
Details
ebuild for version 0.8.7 (libxlsxwriter-0.8.7.ebuild,1.09 KB, text/plain)
2019-09-19 12:54 UTC, Petric Frank
Details
Patch to CMakeLists.txt file to pass USE_DOUBLE_FUNCTION at cmake call (libxlsxwriter-0.8.7-double-function.patch,846 bytes, patch)
2019-09-19 13:06 UTC, Petric Frank
Details | Diff
ebuild for version 0.8.8 (libxlsxwriter-0.8.8.ebuild,1.11 KB, text/plain)
2019-11-25 20:08 UTC, Jon Hood
Details
ebuild for dev-libs/libxlsxwriter-0.9.3 (libxlsxwriter-0.9.3.ebuild,1.11 KB, text/plain)
2020-01-15 18:58 UTC, Jon Hood
Details
libxlsxwriter double function patch (libxlsxwriter-0.9.3-double-function.patch,855 bytes, text/plain)
2020-01-15 18:58 UTC, Jon Hood
Details
ebuild for dev-libs/libxlsxwriter-0.9.5 (libxlsxwriter-0.9.5.ebuild,1.11 KB, text/plain)
2020-07-06 19:37 UTC, Jon Hood
Details
updated double function patch (libxlsxwriter-1.0.6-double-function.patch,858 bytes, patch)
2021-06-01 06:45 UTC, Jon Hood
Details | Diff
ebuild for dev-libs/libxlsxwriter-1.0.6 (libxlsxwriter-1.0.6.ebuild,1.17 KB, text/plain)
2021-06-01 06:46 UTC, Jon Hood
Details
ebuild for dev-libs/libxlsxwriter-1.0.8 (libxlsxwriter-1.0.8.ebuild,1.17 KB, text/plain)
2021-07-03 14:43 UTC, Jon Hood
Details
ebuild for dev-libs/libxlsxwriter-1.1.1 (libxlsxwriter-1.1.1.ebuild,1.16 KB, text/plain)
2021-07-18 22:19 UTC, Jon Hood
Details
ebuild for dev-libs/libxlsxwriter-1.1.4 (libxlsxwriter-1.1.4.ebuild,1.14 KB, text/plain)
2022-04-08 20:36 UTC, Jon Hood
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Petric Frank 2017-08-10 11:01:52 UTC
Created attachment 488486 [details]
ebuild for version 0.7.2

This ebuild adds libxlsxwriter.

It allows to write Excel workbooks in C.
Comment 1 Petric Frank 2017-08-10 11:02:43 UTC
Created attachment 488488 [details, diff]
Remove bundled minizip from CMakeLists.txt
Comment 2 Petric Frank 2017-08-10 11:03:44 UTC
Created attachment 488490 [details, diff]
Point to system wide minizip includes
Comment 3 Petric Frank 2017-08-10 11:07:35 UTC
Created attachment 488492 [details, diff]
Remove bundled minizip from CMakeLists.txt

Fix patch - suddenly removed copyright notice
Comment 4 Petric Frank 2017-08-10 12:08:45 UTC
Created attachment 488496 [details]
ebuild for version 0.7.2

Fix License info
Comment 5 Petric Frank 2017-08-13 14:47:39 UTC
Created attachment 488776 [details]
libxlsxwriter 0.7.3

This release does no more require the patches. It have been fixed upstream.
Comment 6 Petric Frank 2017-10-07 15:13:08 UTC
Created attachment 498044 [details]
ebuild for version 0.7.5

Release 0.7.4 (skipped here):
- Fix make build system "install" target for compatibility with MacOS "brew"
installer.

New release 0.7.5 (according to web page):
- Added support for data validations and dropdown lists.
Comment 7 Petric Frank 2018-05-30 16:32:34 UTC
Created attachment 534074 [details]
ebuild for version 0.7.7

Version 0.7.7

Requires patch "...double-function..." to overcome double to string conversion (comma - dot problem). Excel always wants to get a decimal point - no comma if locale is non-english.
Comment 8 Petric Frank 2018-05-30 16:36:31 UTC
Created attachment 534076 [details, diff]
patch enables conversion from comma to decimal point

Some non-english locales convert doubles into string containing commas instead of dots (decimal points).
This patch enables a function to always have dots in decimal numbers when converted to strings.
Comment 9 Marcel Schilling 2018-12-16 17:07:42 UTC
What is preventing this from being added to the portage tree?
Is this ready for use via a local overlay?
This would allow me to add Excel support to another tool I am packaging.
Comment 10 Petric Frank 2018-12-21 00:57:21 UTC
To my knowledge at least a proxy-maintainer is required to get this package to the official tree.

Sure you can put this ebuild and the patch to your local tree - this is how i did it.

But the libxlsxwriter library is currently at version 0.8.4 with a lot of enhancements - especially to chartsheets. See also https://github.com/jmcnamara/libxlsxwriter/releases

I posted the ebuild here to let other take advantage on it. Due to time constraints i am not able to follow up the releases.

Feel free to step in.
Comment 11 Jon Hood 2019-02-19 22:27:08 UTC
Created attachment 565926 [details]
ebuild for version 0.8.5
Comment 12 Jon Hood 2019-02-19 22:32:30 UTC
Created attachment 565928 [details]
ebuild for version 0.8.5
Comment 13 Jon Hood 2019-02-19 22:40:35 UTC
Created attachment 565930 [details]
ebuild for version 0.8.5

Sorry for the spam. This one fixes the dependency issue. This bug is a duplicate of bug #661514.
Comment 14 Jon Hood 2019-08-16 17:32:40 UTC
Created attachment 587062 [details]
ebuild for version 0.8.7

Version bump to 0.8.7. No changes other than version bump.
Comment 15 Petric Frank 2019-09-19 12:54:27 UTC
Created attachment 590372 [details]
ebuild for version 0.8.7

Updated to apply a patch.

Reason: On non US locales in real number strings as decimal point a comma is used. This results in invalid Excel files.
Excel expects - independent of the locale in use - a decimal point.

See also: https://github.com/jmcnamara/libxlsxwriter/issues/64
Comment 16 Petric Frank 2019-09-19 13:06:32 UTC
Created attachment 590374 [details, diff]
Patch to CMakeLists.txt file to pass USE_DOUBLE_FUNCTION at cmake call

Add Variable USE_DOUBLE_FUNCTION to CMakeLists.txt. this allows to pass additional make option -DUSE_DOUBLE_FUNCTION.

See also: https://github.com/jmcnamara/libxlsxwriter/issues/64
Comment 17 Jon Hood 2019-11-25 20:08:43 UTC
Created attachment 597530 [details]
ebuild for version 0.8.8

Hey Petric, 0.8.8 still doesn't have your patch applied. I hope you don't mind; I attempted to apply the patch in environments that have non-english locales with this update. It feels a bit hackish to me (maybe because -DUSE_DOUBLE_FUNCTION gets passed to cmake regardless of if the patch is applied); I'm hoping you can clean it up some the same as you've done so well with the previous ebuilds.
Comment 18 Jon Hood 2020-01-15 18:58:13 UTC
Created attachment 603406 [details]
ebuild for dev-libs/libxlsxwriter-0.9.3
Comment 19 Jon Hood 2020-01-15 18:58:43 UTC
Created attachment 603408 [details]
libxlsxwriter double function patch
Comment 20 Jeroen Roovers (RETIRED) gentoo-dev 2020-02-14 09:45:29 UTC
*** Bug 661514 has been marked as a duplicate of this bug. ***
Comment 21 Jon Hood 2020-07-06 19:37:39 UTC
Created attachment 648054 [details]
ebuild for dev-libs/libxlsxwriter-0.9.5
Comment 22 tonemgub 2020-08-10 02:05:29 UTC
(In reply to Jon Hood from comment #21)
> Created attachment 648054 [details]
> ebuild for dev-libs/libxlsxwriter-0.9.5

This ebuild works also for latest dev-libs/libxlsxwriter-0.9.7, however the "minizip" USE flag is required. Building without it results in multiple build errors:  "error: expected '=', ',', ';', 'asm' or '__attribute__' before 'OF'"
Comment 23 Jon Hood 2021-06-01 06:45:07 UTC
Created attachment 712974 [details, diff]
updated double function patch
Comment 24 Jon Hood 2021-06-01 06:46:38 UTC
Created attachment 712977 [details]
ebuild for dev-libs/libxlsxwriter-1.0.6

(In reply to tonemgub from comment #22)
> This ebuild works also for latest dev-libs/libxlsxwriter-0.9.7, however the
> "minizip" USE flag is required. Building without it results in multiple
> build errors:  "error: expected '=', ',', ';', 'asm' or '__attribute__'
> before 'OF'"

I haven't been able to reproduce. Can you please attach your build log?

1.0.6 upstream version. Now supports external openssl md5 function with the optional openssl USE flag.
Comment 25 Jon Hood 2021-07-03 14:43:14 UTC
Created attachment 721259 [details]
ebuild for dev-libs/libxlsxwriter-1.0.8

Ebuild for libxlsxwriter-1.0.8; obsoletes patch
Comment 26 Jon Hood 2021-07-18 22:19:28 UTC
Created attachment 724915 [details]
ebuild for dev-libs/libxlsxwriter-1.1.1

new CMake option for 1.1.1 requires a small change to the ebuild
Comment 27 Petric Frank 2021-11-10 08:42:47 UTC
The l10.eclass have been removed from portage tree. Detection of non-english locales require a change.
Replacement by plocale.eclass (plocale_get_locales instead l10n_get_locales) seems not goind to work. I've set

  L10N="de en"
  LINGUAS="de en"

in my make.conf.

Any hints ?
Comment 28 Jon Hood 2022-04-08 20:36:37 UTC
Created attachment 769505 [details]
ebuild for dev-libs/libxlsxwriter-1.1.4

This moves to EAPI 8 to fix the aforementioned plocale issues.
Comment 29 Larry the Git Cow gentoo-dev 2022-08-29 22:38:43 UTC
The bug has been closed via the following commit(s):

https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=0ce43d3e5afed7970373db36e8791894931730f6

commit 0ce43d3e5afed7970373db36e8791894931730f6
Author:     Efe İzbudak <efe.izbudak@metu.edu.tr>
AuthorDate: 2022-06-29 14:18:55 +0000
Commit:     Sam James <sam@gentoo.org>
CommitDate: 2022-08-29 22:37:37 +0000

    dev-libs/libxlsxwriter: new package, add 1.1.4
    
    Closes: https://bugs.gentoo.org/627452
    Signed-off-by: Efe İzbudak <efe.izbudak@metu.edu.tr>
    Signed-off-by: Sam James <sam@gentoo.org>

 dev-libs/libxlsxwriter/Manifest                   |  1 +
 dev-libs/libxlsxwriter/libxlsxwriter-1.1.4.ebuild | 46 +++++++++++++++++++++++
 dev-libs/libxlsxwriter/metadata.xml               | 18 +++++++++
 3 files changed, 65 insertions(+)