File perl-Spreadsheet-WriteExcel.spec of Package perl-Spreadsheet-WriteExcel

# spec file for package perl-Spreadsheet-WriteExcel (Version 2.21)
# Copyright (c) 2008 SUSE LINUX Products GmbH, Nuernberg, Germany.
# This file and all modifications and additions to the pristine
# package are under the same license as the package itself.
# Please submit bugfixes or comments via

# norootforbuild
# usedforbuild    aaa_base acl attr audit-libs autoconf automake bash binutils brp-check-internal bzip2 coreutils cpio cpp cpp43 cracklib cvs diffutils file filesystem fillup findutils gawk gcc gcc43 gdbm gettext-runtime gettext-tools glibc glibc-devel glibc-locale gmp grep groff gzip info insserv less libacl libattr libbz2-1 libbz2-devel libdb-4_5 libgcc43 libgomp43 libltdl-3 libmpfr1 libmudflap43 libncurses5 libreadline5 libstdc++43 libtool libuuid1 libvolume_id libxcrypt libzio linux-kernel-headers login m4 make man net-tools netcfg pam pam-modules patch perl perl-Parse-RecDescent perl-base permissions popt psmisc rpm sed sysvinit tar terminfo-base texinfo timezone util-linux zlib

Name:           perl-Spreadsheet-WriteExcel
BuildRequires:  perl-Parse-RecDescent
License:        Artistic License
Group:          Development/Libraries/Perl
AutoReqProv:    on
Summary:        This Module can be Used to Create Excel Binary Files
Version:        2.21
Release:        1
Source:         Spreadsheet-WriteExcel-%{version}.tar.bz2
BuildRoot:      %{_tmppath}/%{name}-%{version}-build

Requires:       perl-Parse-RecDescent
BuildRequires:  perl(ExtUtils::MakeMaker)
%if 0%{?fedora_version}
BuildRequires:  perl-devel

The Spreadsheet::WriteExcel module can be used to create a cross-
platform Excel binary file. Multiple worksheets can be added to a
workbook and formatting can be applied to cells. Text, numbers,
formulas, hyperlinks, and images can be written to the cells.

The Excel file produced by this module is compatible with Excel 5, 95,
97, 2000, and 2002.

The module will work on the majority of Windows, UNIX, and Macintosh
platforms. Generated files are also compatible with Gnumeric and, the Linux/UNIX spreadsheet applications. The generated
files are not compatible with MS Access.

    John McNamara (

%setup -n Spreadsheet-WriteExcel-%{version} 

perl Makefile.PL
%ifnarch %arm
make test

%if 0%{?suse_version}
make DESTDIR=$RPM_BUILD_ROOT install_vendor
find $RPM_BUILD_ROOT/usr -type f -name perllocal.pod |xargs -i rm -f {}
find $RPM_BUILD_ROOT/usr -type d -depth -exec rmdir {} \; 2>/dev/null


%doc %{_mandir}/man?/*
%doc Changes INSTALL MANIFEST README doc examples charts
%if 0%{?suse_version}

* Thu May 31 2012 Holger Manthey <>
- remove perl-version require
* Sat Apr  4 2009 Holger Manthey <>
- Build for centos
* Thu Apr 03 2008
- version 2.21
  ! Fixed bug where UTF-8 strings in formulas weren't handled.
  Thanks Sergey Zhuravlev.
  ! Fixed collapse outlines compatibility with Gnumeric
  ! Made pane split optional when calling freeze_panes().
  Also renamed thaw_panes() as split_panes(). The old
  method name is still available, but deprecated.
  ! Renamed write_unicode() and write_unicode_le() methods
  to the more explicit write_utf16be_string() and
  write_utf16le_string(). The old method names are
  still available, but deprecated.
  + Added document section about rewriting Excel files.
  + Minor security fix to Format to avoid eval and
  additional fix for RT 24218.
  + Added increased compatibility with third party
  Excel reading applications such as POI.
  + Added optional compatibility_mode() to fix problems
  that can occur with Office SP3.
  + Added set_start_page() method for setting the start page
  number when printing.
  + Added autofilter() and filter_column() method and example.
  + Added embed_chart() method to allow extracted chart
  templates to be embedded in a worksheet.
  + Added the insert_image() method and proper Excel 97
  style image handling for PNG and BMP.
  Images now work with Gnumeric and OpenOffice.
  insert_bitmap() is now deprecated.
* Mon Apr 16 2007
- version 2.18
  ! Correct invalid user set_column() calls to prevent
  crashes after Excel patch KB918419 is applied.
  ! Fixed bug when writing comments longer than 8219 bytes.
  ! Fixed bug when using copy() with merged formats.
  ! Fixed bug where $@ was clobbered during garbage collection.
  ! Removed all non-ascii characters from main docs to
  avoid problems with troff and man.
  + Added autoloading of OLE::Storage_Lite, when available,
  to create workbooks larger than 7MB. It is no longer
  required to explicitly use ::Big.
  + Added handling of Unicode sheet names in formulas
* Fri Jul 14 2006
- version 2.17
  + Added set_tab_color() method and example (
  + Add set_page_view() method for Mac Excel view style
  and better default worksheet dimensions.
  + Added simulated example.
  + Added simulated Autofit example (
  ! Fixed RT #17801, incorrect close value with filehandles.
  ! Changed comment font to Excel's default of Tahoma 8.
  ! Fixed bug that stopped Charts working in 2.16.
* Wed Jan 25 2006
- converted neededforbuild to BuildRequires
* Thu Jan 12 2006
- version 2.16
- Rewrote and reinstated the write_comment() method to take
  account of the changes in the Excel 97+ comment format.
  Currently conflicts with insert_bitmap(), see docs.
- Added standard styles such as comma, percent and currency.
- Changed write_url() methods to allow numbers or formulas
  as well as strings as the optional text.
- Documented use of encoding flag in add_worksheet() to allow
  handling of UTF-16 sheet names.
- Added encoding flag to merge_range() method to allow
  handling of UTF-16 strings.
  Added example program.
- Added hide_zero() worksheet method to allow hiding of zero
  values in cells.
- Added print_across() worksheet method to allow changing of
  the default print direction.
- Added right_to_left() worksheet method to allow changing of
  the default worksheet direction in eastern versions of Excel.
- Documented the Worksheet hide() method.
- Added and example programs.
- Added tests for the internal methods used by write_comment().
* Thu Nov 24 2005
- update to version 2.15
* Tue Nov 15 2005
- no idea why this fails on ARM, but let's just blame it on
* Tue Oct 04 2005
- add norootforbuild
* Sun Jul 31 2005
- update to version 2.14
* Fri Apr 01 2005
- update to version 2.12
  * Added further Unicode support.
  * Added chart support via external templates.
  * many other fixes
* Mon Aug 09 2004
- update to version 2.03
* Thu Sep 25 2003
- initial version (0.41)