path: root/testing/libreoffice/PKGBUILD

# $Id: PKGBUILD 127521 2011-06-15 18:45:39Z andyrtr $
# Maintainer: AndyRTR <andyrtr@archlinux.org>

pkgbase="libreoffice"
pkgname=('libreoffice' 'libreoffice-sdk' 
	#'libreoffice-extension-barcode' # 
	'libreoffice-extension-diagram'
	'libreoffice-extension-google-docs'
	'libreoffice-extension-hunart'
	#'libreoffice-extension-lightproof' # no source integration
	#'libreoffice-extension-mysql-connector' # missing libmysqlcppconn-dev configure: error: mysql_driver.h not found. install MySQL C++ Connectivity
	'libreoffice-extension-nlpsolver'
	'libreoffice-extension-ct2n'
	'libreoffice-extension-numbertext'	
	'libreoffice-extension-oooblogger'
	'libreoffice-extension-pdfimport'
	'libreoffice-extension-presenter-screen'
	'libreoffice-extension-presentation-minimizer'
	'libreoffice-extension-report-builder'
	'libreoffice-extension-scripting-beanshell'
	'libreoffice-extension-scripting-javascript'
	'libreoffice-extension-scripting-python'
	'libreoffice-extension-typo'
	'libreoffice-extension-validator'
	'libreoffice-extension-watch-window'
	'libreoffice-extension-wiki-publisher')
_LOver=3.4.1.1
pkgver=3.4.1rc1
pkgrel=1
arch=('i686' 'x86_64')
#_LO_tree="3.4"
_OFFICEUPD="340"
license=('LGPL3')
url="http://www.libreoffice.org/"
makedepends=( # makedepends
             'sane' 'perl-archive-zip' 'zip' 'unzip' 'xulrunner' 'unixodbc' 'hsqldb-java' #'boost' - we use internal one for now that has some gcc4.6 fixes.
             'apache-ant' 'gperf' 'poppler' 'kdelibs' 'gconf' 'cppunit' #'libmysqlclient'
             'beanshell'  'vigra' 'libldap' 'lucene' 'libmythes' 'junit' 'libwpg' 'imagemagick'
             'mesa' 'gstreamer0.10-base' 'java-runtime'
              #'saxon' - currently broken 
             # the depends from libreoffice main pkg
             "curl>=7.20.0" "hunspell>=1.2.8" "python2>=2.7" 'libwpd>=0.9.2' 'libwps' 'libxaw' "neon>=0.28.6"
             'pango' 'nspr' 'libjpeg' 'libxrandr' 'libgl' 'dbus-glib' "icu>=4.6" 'libxslt'
             'redland' 'libgraphite' 'hyphen' 'lpsolve' 'gcc-libs' 'sh'  'libtextcat'
             'hicolor-icon-theme' 'desktop-file-utils' 'shared-mime-info' 'gtk2' # keep gtk2 for install script
	          'ttf-dejavu') # to satisfy regression tests
	     # translate-toolkit - todo move them to extra to allow --with-system-foo builds
# http://download.documentfoundation.org/mirrors/all.html
# http://wiki.documentfoundation.org/Mirrors
_mirror="http://download.documentfoundation.org/libreoffice/src"
#_mirror="http://dev-builds.libreoffice.org/pre-releases/src/"
_additional_source_url="http://hg.services.openoffice.org/binaries"
source=(${_mirror}/${pkgbase}-{artwork,base,bootstrap,calc,components,extensions,extras,filters,help,impress,libs-core,libs-extern,libs-extern-sys,libs-gui,postprocess,sdk,testing,ure,writer}-${_LOver}.tar.bz2 #,translations
	${_additional_source_url}/1f24ab1d39f4a51faf22244c94a6203f-xmlsec1-1.2.14.tar.gz
	${_additional_source_url}/35c94d2df8893241173de1d16b6034c0-swingExSrc.zip
	${_additional_source_url}/798b2ffdc8bcfe7bca2cf92b62caf685-rhino1_5R5.zip
	${_additional_source_url}/fdb27bfe2dbe2e7b57ae194d9bf36bab-SampleICC-1.3.2.tar.gz
	${_additional_source_url}/ada24d37d8d638b3d8a9985e80bc2978-source-9.0.0.7-bj.zip
	${_additional_source_url}/2a177023f9ea8ec8bd00837605c5df1b-jakarta-tomcat-5.0.30-src.tar.gz
	${_additional_source_url}/a7983f859eafb2677d7ff386a023bc40-xsltml_2.1.2.zip
	${_additional_source_url}/3c219630e4302863a9a83d0efde889db-commons-logging-1.1.1-src.tar.gz
	${_additional_source_url}/2ae988b339daec234019a7066f96733e-commons-lang-2.3-src.tar.gz
	${_additional_source_url}/2c9b0f83ed5890af02c0df1c1776f39b-commons-httpclient-3.1-src.tar.gz
	${_additional_source_url}/af3c3acf618de6108d65fcdc92b492e1-commons-codec-1.3-src.tar.gz
	${_additional_source_url}/eeb2c7ddf0d302fba4bfc6e97eac9624-libbase-1.1.6.zip
	${_additional_source_url}/39bb3fcea1514f1369fcfc87542390fd-sacjava-1.3.zip
	${_additional_source_url}/3404ab6b1792ae5f16bbd603bd1e1d03-libformula-1.1.7.zip
	${_additional_source_url}/97b2d4dba862397f446b217e2b623e71-libloader-1.1.6.zip
	${_additional_source_url}/f94d9870737518e3b597f9265f4e9803-libserializer-1.1.6.zip
	${_additional_source_url}/8ce2fcd72becf06c41f7201d15373ed9-librepository-1.1.6.zip
	${_additional_source_url}/d8bd5eed178db6e2b18eeed243f85aa8-flute-1.1.6.zip
	${_additional_source_url}/3bdf40c0d199af31923e900d082ca2dd-libfonts-1.1.6.zip
	${_additional_source_url}/ace6ab49184e329db254e454a010f56d-libxml-1.1.7.zip
	${_additional_source_url}/db60e4fde8dd6d6807523deb71ee34dc-liblayout-0.2.10.zip
	${_additional_source_url}/ba2930200c9f019c2d93a8c88c651a0f-flow-engine-0.9.4.zip
	${_additional_source_url}/18f577b374d60b3c760a3a3350407632-STLport-4.5.tar.gz
	http://download.go-oo.org/src/7a0dcb3fe1e8c7229ab4fb868b7325e6-mdds_0.5.2.tar.bz2
	http://download.go-oo.org/extern/185d60944ea767075d27247c3162b3bc-unowinreg.dll
	http://download.go-oo.org/extern/b4cae0700aa1c2aef7eb7f345365e6f1-translate-toolkit-1.8.1.tar.bz2
	http://download.go-oo.org/src/451ccf439a36a568653b024534669971-ConvertTextToNumber-1.3.2.oxt
	http://download.go-oo.org/src/90401bca927835b6fbae4a707ed187c8-nlpsolver-0.9.tar.bz2
	http://download.go-oo.org/src/f02578f5218f217a9f20e9c30e119c6a-boost_1_44_0.tar.bz2
	http://ooo.itc.hu/oxygenoffice/download/libreoffice/7e7efc5d4a03126bb9ae3ae9aa2c4e87-Barcode_1.3.1.0.oxt
	http://ooo.itc.hu/oxygenoffice/download/libreoffice/41c9b65ad60af4b3255bbecdfef11736-Diagram_1.1.0.0.oxt
	http://ooo.itc.hu/oxygenoffice/download/libreoffice/451ccf439a36a568653b024534669971-ConvertTextToNumber-1.3.2.oxt
	http://ooo.itc.hu/oxygenoffice/download/libreoffice/bbdd5639ada63e3130761daaecae1a10-Validator_1.1.0.0.oxt
	http://ooo.itc.hu/oxygenoffice/download/libreoffice/23bd75552206dfcd8fd4e29137dcac84-WatchWindow_1.2.0.0.oxt
	http://ooo.itc.hu/oxygenoffice/download/libreoffice/b8cbca7b3363e6ca2d02bc0ba2b63904-numbertext_0.9.4.oxt
	http://ooo.itc.hu/oxygenoffice/download/libreoffice/b632bdd25649cc4067bcb410bae23d2b-hunart_0.3.oxt
	http://ooo.itc.hu/oxygenoffice/download/libreoffice/9d60b6cfa3ef1926848710bbcd11115b-typo_0.4.2.oxt
	http://ooo.itc.hu/oxygenoffice/download/libreoffice/dbaafd21de055e582d92d7d32fe9da13-gdocs_2.3.1.oxt
	http://ooo.itc.hu/oxygenoffice/download/libreoffice/b7b2d0e04e142f26dd96119c80757d1f-oooblogger_0.1.oxt
	buildfix_boost.diff
	buildfix_ct2n.diff
	vbahelper.visibility.patch)
noextract=(185d60944ea767075d27247c3162b3bc-unowinreg.dll
	b4cae0700aa1c2aef7eb7f345365e6f1-translate-toolkit-1.8.1.tar.bz2
	7a0dcb3fe1e8c7229ab4fb868b7325e6-mdds_0.5.2.tar.bz2
	ada24d37d8d638b3d8a9985e80bc2978-source-9.0.0.7-bj.zip
	798b2ffdc8bcfe7bca2cf92b62caf685-rhino1_5R5.zip
	1f24ab1d39f4a51faf22244c94a6203f-xmlsec1-1.2.14.tar.gz
	fdb27bfe2dbe2e7b57ae194d9bf36bab-SampleICC-1.3.2.tar.gz
	35c94d2df8893241173de1d16b6034c0-swingExSrc.zip
	2a177023f9ea8ec8bd00837605c5df1b-jakarta-tomcat-5.0.30-src.tar.gz
	a7983f859eafb2677d7ff386a023bc40-xsltml_2.1.2.zip
	3c219630e4302863a9a83d0efde889db-commons-logging-1.1.1-src.tar.gz
	2ae988b339daec234019a7066f96733e-commons-lang-2.3-src.tar.gz
	2c9b0f83ed5890af02c0df1c1776f39b-commons-httpclient-3.1-src.tar.gz
	af3c3acf618de6108d65fcdc92b492e1-commons-codec-1.3-src.tar.gz
	eeb2c7ddf0d302fba4bfc6e97eac9624-libbase-1.1.6.zip
	39bb3fcea1514f1369fcfc87542390fd-sacjava-1.3.zip
	3404ab6b1792ae5f16bbd603bd1e1d03-libformula-1.1.7.zip
	97b2d4dba862397f446b217e2b623e71-libloader-1.1.6.zip
	f94d9870737518e3b597f9265f4e9803-libserializer-1.1.6.zip
	8ce2fcd72becf06c41f7201d15373ed9-librepository-1.1.6.zip
	d8bd5eed178db6e2b18eeed243f85aa8-flute-1.1.6.zip
	3bdf40c0d199af31923e900d082ca2dd-libfonts-1.1.6.zip
	ace6ab49184e329db254e454a010f56d-libxml-1.1.7.zip
	db60e4fde8dd6d6807523deb71ee34dc-liblayout-0.2.10.zip
	ba2930200c9f019c2d93a8c88c651a0f-flow-engine-0.9.4.zip
	18f577b374d60b3c760a3a3350407632-STLport-4.5.tar.gz
	7e7efc5d4a03126bb9ae3ae9aa2c4e87-Barcode_1.3.1.0.oxt
	41c9b65ad60af4b3255bbecdfef11736-Diagram_1.1.0.0.oxt
	451ccf439a36a568653b024534669971-ConvertTextToNumber-1.3.2.oxt
	bbdd5639ada63e3130761daaecae1a10-Validator_1.1.0.0.oxt
	23bd75552206dfcd8fd4e29137dcac84-WatchWindow_1.2.0.0.oxt
	b8cbca7b3363e6ca2d02bc0ba2b63904-numbertext_0.9.4.oxt
	b632bdd25649cc4067bcb410bae23d2b-hunart_0.3.oxt
	9d60b6cfa3ef1926848710bbcd11115b-typo_0.4.2.oxt
	dbaafd21de055e582d92d7d32fe9da13-gdocs_2.3.1.oxt
	b7b2d0e04e142f26dd96119c80757d1f-oooblogger_0.1.oxt
	90401bca927835b6fbae4a707ed187c8-nlpsolver-0.9.tar.bz2
	f02578f5218f217a9f20e9c30e119c6a-boost_1_44_0.tar.bz2)
md5sums=('a21bbbc0cf9b482a78357b7b6132e799'
         'd9ccdb2b53de8e16d7bb3215b9e97d7a'
         'd3aa4a8e05f8b5c3ccf4f945b82b32a2'
         'eb03b6627f2a2240eca089c925692259'
         '190c9b25a7193b7ca98d6f6d09cd20d2'
         '45b632fb71b123b699c9e89f9db6632a'
         '19b3e65676e8e8839a4dd884a74e83e4'
         '79a955fd38d0eedca7db146c5a985041'
         '9b9b80ff14a3c6f430cc1fee4551c53e'
         'c592798d08cccfb14f6cda95eb542d7b'
         '1f98cbec964a9563b72962c943af3545'
         '01aa850fa07e4440706dcea0def5c27a'
         '9765abf75b58c5dbdf82a953af8c6de4'
         '1f07e271d64606116c84c7adbc90a324'
         '877cf0733c202936f8b918b9ad423f0d'
         '231f5a392ab78167a5a7ab7bc922a421'
         '9452301d1eee5fc3bb4758e003829075'
         '1bc390b972bbe27f513956af37e60538'
         '974b73ed0add1d6e325b9da4e3ca5c5d'
         '1f24ab1d39f4a51faf22244c94a6203f'
         '35c94d2df8893241173de1d16b6034c0'
         '798b2ffdc8bcfe7bca2cf92b62caf685'
         'fdb27bfe2dbe2e7b57ae194d9bf36bab'
         'ada24d37d8d638b3d8a9985e80bc2978'
         '2a177023f9ea8ec8bd00837605c5df1b'
         'a7983f859eafb2677d7ff386a023bc40'
         '3c219630e4302863a9a83d0efde889db'
         '2ae988b339daec234019a7066f96733e'
         '2c9b0f83ed5890af02c0df1c1776f39b'
         'af3c3acf618de6108d65fcdc92b492e1'
         'eeb2c7ddf0d302fba4bfc6e97eac9624'
         '39bb3fcea1514f1369fcfc87542390fd'
         '3404ab6b1792ae5f16bbd603bd1e1d03'
         '97b2d4dba862397f446b217e2b623e71'
         'f94d9870737518e3b597f9265f4e9803'
         '8ce2fcd72becf06c41f7201d15373ed9'
         'd8bd5eed178db6e2b18eeed243f85aa8'
         '3bdf40c0d199af31923e900d082ca2dd'
         'ace6ab49184e329db254e454a010f56d'
         'db60e4fde8dd6d6807523deb71ee34dc'
         'ba2930200c9f019c2d93a8c88c651a0f'
         '18f577b374d60b3c760a3a3350407632'
         '7a0dcb3fe1e8c7229ab4fb868b7325e6'
         '185d60944ea767075d27247c3162b3bc'
         'b4cae0700aa1c2aef7eb7f345365e6f1'
         '451ccf439a36a568653b024534669971'
         '90401bca927835b6fbae4a707ed187c8'
         'f02578f5218f217a9f20e9c30e119c6a'
         '7e7efc5d4a03126bb9ae3ae9aa2c4e87'
         '41c9b65ad60af4b3255bbecdfef11736'
         '451ccf439a36a568653b024534669971'
         'bbdd5639ada63e3130761daaecae1a10'
         '23bd75552206dfcd8fd4e29137dcac84'
         'b8cbca7b3363e6ca2d02bc0ba2b63904'
         'b632bdd25649cc4067bcb410bae23d2b'
         '9d60b6cfa3ef1926848710bbcd11115b'
         'dbaafd21de055e582d92d7d32fe9da13'
         'b7b2d0e04e142f26dd96119c80757d1f'
         'bc228237108cab7745897a9f466b6d39'
         'eee273f501ff45dc5f1365e78c6d57c0'
         '43b145db28e6c0d73578ae6fd35e510d')

build() {

	unset J2REDIR; unset J2SDKDIR; unset JAVA_HOME; unset CLASSPATH; unset EXTRAOPTS
	[ -z "${JAVA_HOME}" ] && . /etc/profile.d/openjdk6.sh
	[ -z "${MOZ_PLUGIN_PATH}" ] && . /etc/profile.d/mozilla-common.sh
	[ -z "${ANT_HOME}" ] && . /etc/profile.d/apache-ant.sh

	# move all LibO sources into one build directory
	mkdir ${srcdir}/build && cd ${srcdir}/build
	for i in libreoffice-{artwork,base,bootstrap,calc,components,extensions,extras,filters,help,impress,libs-core,libs-extern,libs-extern-sys,libs-gui,postprocess,sdk,testing,ure,writer}-${_LOver}; do #,translations
	  mv ${srcdir}/$i/* .
	done

	# move external sources into place
	mkdir ${srcdir}/ext_sources &&	cd ${srcdir}/ext_sources
	for source in "${noextract[@]}"; do
	  ln -s ${srcdir}/$source .
	done

	cd ${srcdir}/build

	# buildfixes & bugfixes
	patch -Np1 -i ${srcdir}/buildfix_boost.diff
	patch -Np1 -i ${srcdir}/buildfix_ct2n.diff
	patch -Np0 -i ${srcdir}/vbahelper.visibility.patch
	
	# unset C(XX)FLAGS
	# http://www.openoffice.org/issues/show_bug.cgi?id=103205
#	unset CFLAGS
#	unset CXXFLAGS

	#use the CFLAGS but remove the LibO overridden ones
	for i in $CFLAGS; do
		case "$i" in
			-O?|-pipe|-Wall|-g|-fexceptions) continue;;
		esac
        ARCH_FLAGS="$ARCH_FLAGS $i"
	done
	
	# python2 fix
	export PYTHON=python2

	# http://wiki.documentfoundation.org/Development/How_to_build/Configure_options

#	if [ "$CARCH" = "x86_64" ]; then
#	      EXTRAOPTS="--without-stlport"
#	 else 
#	      EXTRAOPTS="--with-stlport" # --without-system-boost"
#	      # # avoid problems with ixion for now
#	      sed -i '/fields-table-formula.diff/d' patches/dev300/apply || return 1
#	fi

#	autoconf -v -f

	# non-SMP test build
#	export MAKEFLAGS="-j1"
	./configure --with-build-version="${_LOver} ArchLinux build-${pkgrel}" --with-vendor="ArchLinux" \
		--with-unix-wrapper="libreoffice" \
		--with-max-jobs=${MAKEFLAGS/-j/} --with-num-cpus=${MAKEFLAGS/-j/} \
		--with-external-tar="${srcdir}/ext_sources" \
		--prefix=/usr --exec-prefix=/usr --sysconfdir=/etc \
		--with-install-dirname="${pkgbase}" --libdir=/usr/lib --mandir=/usr/share/man \
		--with-lang="" \
		--disable-verbose \
		--enable-cairo\
		--enable-crashdump \
		--enable-dbus \
		--enable-evolution2\
		--disable-graphite\
		--enable-gio\
		--disable-gnome-vfs\
		--disable-kde\
		--enable-kde4\
		--enable-ldap \
		--enable-lockdown\
		--enable-opengl \
		--enable-odk\
		--enable-opengl\
		--enable-ext-barcode \
		--enable-ext-diagram \
		--enable-ext-google-docs \
		--enable-ext-hunart \
		--disable-ext-lightproof \
		--disable-ext-mysql-connector \
		--with-system-mysql \
		--enable-ext-nlpsolver \
		--enable-ext-ct2n \
		--enable-ext-numbertext \
		--enable-ext-oooblogger \
		--enable-ext-pdfimport \
		--enable-ext-presenter-console \
		--enable-ext-presenter-minimizer \
		--enable-ext-report-builder \
		--enable-ext-scripting-beanshell \
		--enable-ext-scripting-javascript \
		--enable-ext-scripting-python \
		--enable-ext-typo \
		--enable-ext-validator \
		--enable-ext-watch-window \
		--enable-ext-wiki-publisher \
		--without-fonts\
		--without-afms\
		--without-ppds\
		--without-system-libwps\
		--without-system-mdds\
		--without-myspell-dicts \
		--with-system-dicts \
		--with-external-dict-dir=/usr/share/hunspell \
		--with-external-hyph-dir=/usr/share/hyphen \
		--with-external-thes-dir=/usr/share/mythes \
		--with-system-cppunit\
		--with-system-libwpg \
		--with-system-libwps \
		--with-system-redland\
		--without-system-saxon\
		--with-system-libtextcat \
		--with-external-libtextcat-data \
		--with-openldap\
		--with-ant-home="/usr/share/java/apache-ant"\
		--without-system-boost\
		--with-system-cairo\
		--with-system-libs\
		--with-system-mozilla\
		--with-system-mythes\
		--with-system-xrender-headers\
		--with-system-headers\
		--with-alloc=system\
		--with-system-lucene\
		--with-lucene-core-jar=/usr/share/java/lucene-core.jar\
		--with-lucene-analyzers-jar=/usr/share/java/lucene-analyzers.jar\
		$EXTRAOPTS || return 1

#--with-system-graphite --enable-graohite ?
#--with-servlet-api-jar=JARFILE 
# see http://qa.openoffice.org/issues/show_bug.cgi?id=110136
#		--with-system-saxon\
#		--with-saxon-jar=/usr/share/java/saxon/saxon9he.jar\

	touch src.downloaded
	#./download
	unset MAKEFLAGS
	./bootstrap
	make
}

#check() {
#	cd ${srcdir}/build
#	make check
#}

package_libreoffice() {

 pkgdesc="a productivity suite that is compatible with other major office suites"
 install=${pkgbase}.install
 depends=("curl>=7.20.0" "hunspell>=1.2.8" "python2>=2.7" 'libwpd>=0.9.2' 'libwps' 'libxaw' "neon>=0.28.6"
          'pango' 'nspr' 'libjpeg' 'libxrandr' 'libgl' 'dbus-glib' "icu>=4.6" 'libxslt'
          'redland' 'libgraphite' 'hyphen' 'lpsolve' 'gcc-libs' 'sh' 'libtextcat'
          'hicolor-icon-theme' 'desktop-file-utils' 'shared-mime-info' 'gtk2') # keep gtk2 for install script 
	  #'java-runtime' 
          #'saxon'
 optdepends=('java-runtime:     adds java support'
             'libcups:          adds printing support'
             'gconf:            adds additional gnome support'
             'nss:              adds support for signed files/macros'
             'pstoedit:         translates PostScript and PDF graphics into other vector formats'
             'poppler:          for shipped pdfimport extension'
             'kdelibs:          for kde integration'
             'libmythes:        for use in thesaurus'
             'hsqldb-java:      default database format for OpenOffice.org'
             'beanshell:        interactive java -- good for prototyping /macros'
             'vigra:            C++ computer vision library, usable in Basebmp'
             'libmspack:        library for Microsoft compression formats for use in FontOOo'
             'libwpg:           library for importing and converting Corel WordPerfect(tm) Graphics images'
             'libldap:          to get profiles via ldap'
             'lucene:           full-text search engine library for Java needed in the help section'
             'sane:             for scanner access'
             'unixodbc:         adds ODBC database support'
             'mesa:             for the OGLTrans extension'
             'gstreamer0.10-base: + some gstr-plugins to support multimedia content, e.g. in impress')
 backup=(etc/libreoffice/sofficerc
         etc/libreoffice/bootstraprc
         etc/libreoffice/psprint.conf)
 provides=('go-openoffice')
 conflicts=('go-openoffice')
 replaces=('go-openoffice' 'openoffice-base' )

	cd ${srcdir}/build
	make DESTDIR=${pkgdir} install
	
	# fix missing desktop integration
	install -dm755 ${pkgdir}/usr/bin
	pushd ${pkgdir}/usr/bin
	ln -vs /usr/lib/libreoffice/program/soffice ./libreoffice
	ln -vs /usr/lib/libreoffice/program/soffice ./soffice
	ln -vs /usr/lib/libreoffice/program/sbase ./lobase
	ln -vs /usr/lib/libreoffice/program/scalc ./localc
	ln -vs /usr/lib/libreoffice/program/sdraw ./lodraw
	ln -vs /usr/lib/libreoffice/program/simpress ./loimpress
	ln -vs /usr/lib/libreoffice/program/smath ./lomath
	ln -vs /usr/lib/libreoffice/program/swriter ./lowriter
	ln -vs /usr/lib/libreoffice/program/unopkg ./unopkg
	popd
	
	# move sysui desktop files into place we want to use - javafilter and qstarter, but not unneeded printeradmin
	install -dm755 ${pkgdir}/usr/share/{applications,icons,mime/packages,pixmaps}
	rm ${pkgdir}/usr/lib/libreoffice/share/xdg/printeradmin.desktop
	for i in base calc draw impress javafilter math qstart startcenter writer; do
	  cp ${pkgdir}/usr/lib/libreoffice/share/xdg/$i.desktop ${pkgdir}/usr/share/applications/libreoffice-$i.desktop
	done
	# remove version in menu entry and make it visible
	sed -i -e "s/3.4//g" ${pkgdir}/usr/share/applications/*.desktop
	sed -i -e "s/Icon=libreoffice34-/Icon=/g" ${pkgdir}/usr/share/applications/*.desktop
	sed -i -e "/NoDisplay=true/d" ${pkgdir}/usr/share/applications/libreoffice-qstart.desktop
	echo "Icon=startcenter" >> ${pkgdir}/usr/share/applications/libreoffice-qstart.desktop
	# remove unneeded .desktop files
	rm -rf ${pkgdir}/usr/lib/libreoffice/share/xdg
	
	# add missing icon files
	cp -R ${srcdir}/build/sysui/desktop/icons/{hi,lo}color ${pkgdir}/usr/share/icons/
	pushd ${pkgdir}/usr/share/pixmaps
	  for i in base calc draw impress main math printeradmin startcenter writer; do
	    ln -vs /usr/share/icons/hicolor/48x48/apps/$i.png .
	  done
	popd
	sed -i -e 's/Icon=libreoffice-/Icon=/' ${pkgdir}/usr/share/applications/*.desktop

	# add missing mimetype file
	install -m644 ${srcdir}/build/sysui/unxlng*/misc/libreoffice/openoffice.org.xml ${pkgdir}/usr/share/mime/packages/libreoffice.xml

	# put configuration files into place
	install -dm755 ${pkgdir}/etc/libreoffice
	install -m644 ${pkgdir}/usr/lib/libreoffice/program/{bootstraprc,sofficerc} ${pkgdir}/etc/libreoffice/
	install -m644 ${pkgdir}/usr/lib/libreoffice/basis3.4/share/psprint/psprint.conf ${pkgdir}/etc/libreoffice/
	# install dummy links to make them found by LibO
	cd ${pkgdir}/usr/lib/libreoffice/program/
	ln -vsf /etc/libreoffice/{bootstraprc,sofficerc} .
	cd ${pkgdir}/usr/lib/libreoffice/basis3.4/share/psprint/
	ln -vsf /etc/libreoffice/psprint.conf .
 
	#fix http://bugs.archlinux.org/task/17656
	find ${pkgdir} -perm 444 -exec ls -lh {} \;
	find ${pkgdir} -perm 444 -exec chmod 644 {} \;
	find ${pkgdir} -perm 555 -exec ls -lh {} \;
	find ${pkgdir} -perm 555 -exec chmod 755 {} \;
	
	# split out extensions
	mv ${pkgdir}/usr/lib/libreoffice/share/extensions ${srcdir}/extensions-install
	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	install -m644 ${srcdir}/extensions-install/package.txt ${pkgdir}/usr/lib/libreoffice/share/extensions/

	# move SDK to separated package
	mkdir -p ${srcdir}/sdk-install/usr/lib/libreoffice/basis3.4/sdk
	mv ${pkgdir}/usr/lib/libreoffice/basis3.4/sdk ${srcdir}/sdk-install/usr/lib/libreoffice/basis3.4/

	# cleanup gid_Module files
	mkdir ${srcdir}/splitlist
	mv -f ${pkgdir}/gid_Module* ${srcdir}/splitlist/
}

package_libreoffice-sdk() {

 pkgdesc="Software development kit for LibreOffice"
 depends=('libreoffice' 'gcc-libs' 'sh' 'make' 'zip' 'gcc' 'java-environment')

	cd ${srcdir}/sdk-install
	cp -r * ${pkgdir}

	cd ${pkgdir}/usr/lib/libreoffice/basis3.4/sdk
	cp setsdkenv_unix setsdkenv_unix.sh && chmod 755 setsdkenv_unix{,.sh}

	# fix ArchLinux LIbreOffice installation paths	
        sed -i -e "s,@OO_SDK_NAME@,libreoffice-sdk," \
              -e "s,@OO_SDK_HOME@,/usr/lib/libreoffice/basis3.4/sdk," \
              -e "s,@OFFICE_HOME@,/usr/lib/libreoffice," \
              -e "s,@OFFICE_BASE_HOME@,/usr/lib/libreoffice," \
              -e "s,@OO_SDK_URE_HOME@,/usr/lib/libreoffice/ure," \
              -e "s,@OO_SDK_MAKE_HOME@,/usr/bin," \
              -e "s,@OO_SDK_ZIP_HOME@,/usr/bin," \
              -e "s,@OO_SDK_CPP_HOME@,/usr/bin," \
              -e "s,@OO_SDK_CC_55_OR_HIGHER@,," \
              -e "s,@OO_SDK_JAVA_HOME@,\$J2SDKDIR," \
              -e "s,@OO_SDK_OUTPUT_DIR@,\$HOME," \
              -e "s,@SDK_AUTO_DEPLOYMENT@,NO," setsdkenv_unix.{csh,sh}.in
	#fix permissions
	find examples -type f -exec chmod -x {} \;
}

package_libreoffice-extension-barcode() {

 pkgdesc="This extension generates UPC-A, EAN-13, ISBN and JAN barcodes in Draw "
 #arch=('any')
 depends=('libreoffice')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/7e7efc5d4a03126bb9ae3ae9aa2c4e87-Barcode_1.3.1.0.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/Barcode
	chmod o-w -R ${pkgdir}/usr/lib/libreoffice/share/extensions/Barcode
}

package_libreoffice-extension-diagram() {

 pkgdesc="An OOo Draw and Impress extension that creates your favorite diagrams with a few clicks"
 #arch=('any')
 depends=('libreoffice')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/41c9b65ad60af4b3255bbecdfef11736-Diagram_1.1.0.0.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/diagram
}

package_libreoffice-extension-google-docs() {

 pkgdesc="Google Documents extension for LibreOffice"
 #arch=('any')
 depends=('libreoffice')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/dbaafd21de055e582d92d7d32fe9da13-gdocs_2.3.1.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/google-docs
}

package_libreoffice-extension-hunart() {

 pkgdesc="Hungarian cross-reference toolbar extension"
 #arch=('any')
 depends=('libreoffice')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/b632bdd25649cc4067bcb410bae23d2b-hunart_0.3.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/hunart
}

#package_libreoffice-extension-lightproof() {

# pkgdesc="Lightproof extension for LibreOffice"
 #arch=('any')
# depends=('libreoffice')
# groups=('libreoffice-extensions')

#	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
#	unzip -q ${srcdir}/${pkgbase}-build-${_LOver}/build/libreoffice-${_LOver}/solver/${_OFFICEUPD}/unxlng*/bin/Lightproof.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/lightproof
#}

#package_libreoffice-extension-mysql-connector() {

# pkgdesc="MySQL Connector extension for LibreOffice"
 #arch=('any')
# depends=('libreoffice')
# groups=('libreoffice-extensions')

#	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
#	unzip -q ${srcdir}/${pkgbase}-build-${_LOver}/build/libreoffice-${_LOver}/solver/${_OFFICEUPD}/unxlng*/bin/Mysql-connector.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/mysql-connector
#}

package_libreoffice-extension-nlpsolver() {

 pkgdesc="This extension integrates into Calc and offers new Solver engines to use for optimizing nonlinear programming models"
 #arch=('any')
 depends=('libreoffice')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/build/solver/${_OFFICEUPD}/unxlng*/bin/NLPSolver.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/nlpsolver
}

package_libreoffice-extension-ct2n() {

 pkgdesc="This extension enables you to convert text-cells in Calc with numbers and dates, to real numbers and dates."
 #arch=('any')
 depends=('libreoffice')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/build/solver/${_OFFICEUPD}/unxlng*/bin/ConvertTextToNumber.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/ct2n
}

package_libreoffice-extension-numbertext() {

 pkgdesc="NUMBERTEXT/MONEYTEXT extensions"
 #arch=('any')
 depends=('libreoffice')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/b8cbca7b3363e6ca2d02bc0ba2b63904-numbertext_0.9.4.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/numbertext
}

package_libreoffice-extension-oooblogger() {

 pkgdesc="An extensions for blogging"
 #arch=('any')
 depends=('libreoffice' 'coreutils')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/b7b2d0e04e142f26dd96119c80757d1f-oooblogger_0.1.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/oooblogger
}

package_libreoffice-extension-pdfimport() {

 pkgdesc="This extension allows you to import and modify PDF documents"
 depends=('libreoffice' 'poppler')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/build/solver/${_OFFICEUPD}/unxlng*/bin/pdfimport/pdfimport.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/pdfimport
}

package_libreoffice-extension-presenter-screen() {

 pkgdesc="This extension provides more control over your slide show presentation, such as the ability to see the upcoming slide, the slide notes, and a presentation timer whereas the audience see only the current slide"
 depends=('libreoffice')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/build/solver/${_OFFICEUPD}/unxlng*/bin/presenter-screen.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/presenter-screen
}

package_libreoffice-extension-presentation-minimizer() {

 pkgdesc="This extension reduce the file size of the current presentation"
 depends=('libreoffice' 'gcc-libs')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/build/solver/${_OFFICEUPD}/unxlng*/bin/presentation-minimizer.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/presentation-minimizer
}

package_libreoffice-extension-report-builder() {

 pkgdesc="This extension creates smart-looking database reports"
 #arch=('any')
 depends=('libreoffice')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/build/solver/${_OFFICEUPD}/unxlng*/bin/report-builder.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/report-builder
}

package_libreoffice-extension-scripting-beanshell() {

 pkgdesc="LibreOffice extension - Enables support for scripts in BeanShell"
 depends=('libreoffice')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/build/solver/${_OFFICEUPD}/unxlng*/bin/script-provider-for-beanshell.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/script-provider-for-beanshell
}

package_libreoffice-extension-scripting-javascript() {

 pkgdesc="LibreOffice extension - Enables support for scripts in JavaScript"
 depends=('libreoffice')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/build/solver/${_OFFICEUPD}/unxlng*/bin/script-provider-for-javascript.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/script-provider-for-javascript
}

package_libreoffice-extension-scripting-python() {

 pkgdesc="LibreOffice extension - Enables support for scripts in Python"
 depends=('libreoffice')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/build/solver/${_OFFICEUPD}/unxlng*/bin/script-provider-for-python.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/script-provider-for-python
}

package_libreoffice-extension-typo() {

 pkgdesc="Typography toolbar extension"
 #arch=('any')
 depends=('libreoffice')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/9d60b6cfa3ef1926848710bbcd11115b-typo_0.4.2.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/typo
	chmod o+r -R ${pkgdir}/usr/lib/libreoffice/share/extensions/typo
}

package_libreoffice-extension-validator() {

 pkgdesc="Validator extension for LibreOffice"
 #arch=('any')
 depends=('libreoffice')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/bbdd5639ada63e3130761daaecae1a10-Validator_1.1.0.0.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/validator
}

package_libreoffice-extension-wiki-publisher() {

 pkgdesc="This extension enables you to create Wiki articles on MediaWiki servers without having to know the syntax of the MediaWiki markup language"
 #arch=('any')
 depends=('libreoffice')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/build/solver/${_OFFICEUPD}/unxlng*/bin/wiki-publisher.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/wiki-publisher
}

package_libreoffice-extension-watch-window() {

 pkgdesc="A OOo Calc extension to add a Watch Window, which keeps the value of the monitored cell on the screen."
 #arch=('any')
 depends=('libreoffice')
 groups=('libreoffice-extensions')

	install -dm755 ${pkgdir}/usr/lib/libreoffice/share/extensions
	unzip -q ${srcdir}/23bd75552206dfcd8fd4e29137dcac84-WatchWindow_1.2.0.0.oxt -d ${pkgdir}/usr/lib/libreoffice/share/extensions/watch-window
}