Re: [libreoffice-users] Word documents that LO messes up
On 06/23/2015 07:06 AM, Malcolm Moore wrote: Is there anyone who is interested in documents that LO munges up. There are lots of nice words on the web site about how there are loads of test that are run to ensure compatibility but we still get a lot of documents that are unusable I was wondering if there is a place to send them so the developers can see them Ta Mal When I encounter this, I file bug reports and attach the Word documents as test case files. Doing this has resulted in a number of my reported issues getting fixed. Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Problems compiling on centos 7
CentOS 7 ftp.centos.org/7.1.1503/os/x86_64/Packages/libreoffice-headless-4.2.6.3-5.el7.x86_64.rpm at: http://rpm.pbone.net/index.php3/stat/3/srodzaj/1/search/libreoffice-headless On 6/22/2015 9:21 AM, Mårten Gustafsson wrote: I am trying to build LibreOffice to be used in headless mode. I will try installing 4.3. This might interest someone. [root@maskin1 src]# uname -a Linux maskin1.novalocal 3.10.0-123.9.3.el7.x86_64 #1 SMP Thu Nov 6 15:06:03 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux This is what I have done: [root@maskin1 ]# cd ~ [root@maskin1 ~]# yum install fontconfig [root@maskin1 ~]# yum install fontconfig-devel [root@maskin1 ~]# yum install perl-Archive-Zip [root@maskin1 ~]# yum install perl-App-cpanminus.noarch [root@maskin1 ~]# yum install perl-Template-Toolkit [root@maskin1 ~]# cpanm -i Archive::Zip [root@maskin1 ~]# yum install libxslt-devel.x86_64 [root@maskin1 ~]# yum install GConf2-devel.x86_64 [root@maskin1 ~]# yum install glew.x86_64 [root@maskin1 ~]# yum install libXt-devel.x86_64 [root@maskin1 ~]# yum install libXrender-devel.x86_64 [root@maskin1 ~]# yum install cups-devel.x86_64 [root@maskin1 ~]# yum install libXrandr-devel.x86_64 [root@maskin1 ~]# yum install dbus-glib-devel.x86_64 [root@maskin1 ~]# yum install gstreamer1.x86_64 gstreamer1-plugins-base.x86_64 gstreamer1-plugins-good.x86_64 [root@maskin1 ~]# yum install gstreamer1-devel.x86_64 gstreamer1-plugins-base-devel.x86_64 [root@maskin1 ~]# yum install gperf.x86_64 [root@maskin1 ~]# yum install mesa-libGL-devel.x86_64 [root@maskin1 ~]# yum install glew-devel.x86_64 [root@maskin1 ~]# cd /usr/local/src/ [root@maskin1 src]# wget http://download.documentfoundation.org/libreoffice/src/4.4.3/libreoffice-4.4.3.2.tar.xz [root@maskin1 src]# unxz libreoffice-4.4.3.2.tar.xz [root@maskin1 src]# tar xvf libreoffice-4.4.3.2.tar [root@maskin1 src]# cd libreoffice-4.4.3.2 [root@maskin1 libreoffice-4.4.3.2]# ./autogen.sh --without-java --with-theme=no --without-doxygen --disable-gtk [root@maskin1 libreoffice-4.4.3.2]# make [build CXX] vcl/unx/generic/gdi/salgdi3.cxx In file included from /usr/local/src/libreoffice-4.4.3.2/vcl/unx/generic/gdi/openglx11cairotextrender.cxx:16:0: /usr/local/src/libreoffice-4.4.3.2/workdir/UnpackedTarball/cairo/src/cairo-svg.h:37:5: warning: CAIRO_HAS_SVG_SURFACE is not defined [-Wundef] #if CAIRO_HAS_SVG_SURFACE ^ /usr/local/src/libreoffice-4.4.3.2/workdir/UnpackedTarball/cairo/src/cairo-svg.h:79:3: error: #error Cairo was not compiled with support for the svg backend # error Cairo was not compiled with support for the svg backend ^ [build CXX] vcl/unx/generic/gdi/salgdi.cxx make[1]: *** [/usr/local/src/libreoffice-4.4.3.2/workdir/CxxObject/vcl/unx/generic/gdi/openglx11cairotextrender.o] Error 1 make[1]: *** Waiting for unfinished jobs make: *** [build] Error 2 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Problems compiling on centos 7
This may help. How to make libreoffice headless to work on CentOS 6.3 http://diegolamonica.info/how-to-make-libreoffice-headless-to-work-on-centos-6-3/ On 6/22/2015 9:21 AM, Mårten Gustafsson wrote: I am trying to build LibreOffice to be used in headless mode. I will try installing 4.3. This might interest someone. [root@maskin1 src]# uname -a Linux maskin1.novalocal 3.10.0-123.9.3.el7.x86_64 #1 SMP Thu Nov 6 15:06:03 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux This is what I have done: [root@maskin1 ]# cd ~ [root@maskin1 ~]# yum install fontconfig [root@maskin1 ~]# yum install fontconfig-devel [root@maskin1 ~]# yum install perl-Archive-Zip [root@maskin1 ~]# yum install perl-App-cpanminus.noarch [root@maskin1 ~]# yum install perl-Template-Toolkit [root@maskin1 ~]# cpanm -i Archive::Zip [root@maskin1 ~]# yum install libxslt-devel.x86_64 [root@maskin1 ~]# yum install GConf2-devel.x86_64 [root@maskin1 ~]# yum install glew.x86_64 [root@maskin1 ~]# yum install libXt-devel.x86_64 [root@maskin1 ~]# yum install libXrender-devel.x86_64 [root@maskin1 ~]# yum install cups-devel.x86_64 [root@maskin1 ~]# yum install libXrandr-devel.x86_64 [root@maskin1 ~]# yum install dbus-glib-devel.x86_64 [root@maskin1 ~]# yum install gstreamer1.x86_64 gstreamer1-plugins-base.x86_64 gstreamer1-plugins-good.x86_64 [root@maskin1 ~]# yum install gstreamer1-devel.x86_64 gstreamer1-plugins-base-devel.x86_64 [root@maskin1 ~]# yum install gperf.x86_64 [root@maskin1 ~]# yum install mesa-libGL-devel.x86_64 [root@maskin1 ~]# yum install glew-devel.x86_64 [root@maskin1 ~]# cd /usr/local/src/ [root@maskin1 src]# wget http://download.documentfoundation.org/libreoffice/src/4.4.3/libreoffice-4.4.3.2.tar.xz [root@maskin1 src]# unxz libreoffice-4.4.3.2.tar.xz [root@maskin1 src]# tar xvf libreoffice-4.4.3.2.tar [root@maskin1 src]# cd libreoffice-4.4.3.2 [root@maskin1 libreoffice-4.4.3.2]# ./autogen.sh --without-java --with-theme=no --without-doxygen --disable-gtk [root@maskin1 libreoffice-4.4.3.2]# make [build CXX] vcl/unx/generic/gdi/salgdi3.cxx In file included from /usr/local/src/libreoffice-4.4.3.2/vcl/unx/generic/gdi/openglx11cairotextrender.cxx:16:0: /usr/local/src/libreoffice-4.4.3.2/workdir/UnpackedTarball/cairo/src/cairo-svg.h:37:5: warning: CAIRO_HAS_SVG_SURFACE is not defined [-Wundef] #if CAIRO_HAS_SVG_SURFACE ^ /usr/local/src/libreoffice-4.4.3.2/workdir/UnpackedTarball/cairo/src/cairo-svg.h:79:3: error: #error Cairo was not compiled with support for the svg backend # error Cairo was not compiled with support for the svg backend ^ [build CXX] vcl/unx/generic/gdi/salgdi.cxx make[1]: *** [/usr/local/src/libreoffice-4.4.3.2/workdir/CxxObject/vcl/unx/generic/gdi/openglx11cairotextrender.o] Error 1 make[1]: *** Waiting for unfinished jobs make: *** [build] Error 2 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Word documents that LO messes up
Is there anyone who is interested in documents that LO munges up. There are lots of nice words on the web site about how there are loads of test that are run to ensure compatibility but we still get a lot of documents that are unusable I was wondering if there is a place to send them so the developers can see them Ta Mal -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] CALC: Issue with CURRENT() function?
Hello, I need to code a set of functions in calc that would translate to something like this in a programming language: b = (a + 5) * 6 b += (25 + b - 6) % 14 This can be implemented in two ways: Way 1 which works but uses additional cells: Cell A2 contains the value of a Cell B2 = (A2+5)*6 Cell B3 = B2+MOD(25+B2-6;14) If a is equal to 25, cell B3 now contains the value 183, which is the expected result. Way 2 which does not work all the time: Cell A2 contains the value of a Cell B2 set to =(A2+5)*6+MOD(25+CURRENT()-6;14) Again, if a is equal to 25, cell B2 is now equal to 182! Additionally, setting B2 to the following formulae yields these results: =(A2+5)*6+MOD(25-6+CURRENT();14) - 190 =(A2+5)*6+MOD(CURRENT()+25-6;14) - 183 (expected result) =(A2+5)*6+MOD(-6+CURRENT()+25;14) - 193 The help indicates that CURRENT() Calculates the current value of a formula at the actual position. However, since the CURRENT() is inside the MOD() function, the value of the formula should not be influenced by the position of the function since the value of the formula should not change before the MOD() is calculated. Or is there something I am missing? Thank you for your help. I use LibreOffice Version 4.3.7.2 Build ID 4.3.7.2-6.fc21 on Fedora, with a French language pack. Best regards, Rémy Gauthier. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Libre Office - Problems Working With Hebrew
Hi Yaoz Vashdi, your problems might be caused by a mismatch between system language and document language. Find the setting Ignore system input language in Tools Options Language Settings Languages. The help says about this option, Indicates whether changes to the system input language/keyboard will be ignored. If ignored, when new text is typed that text will follow the language of the document or current paragraph, not the current system language. There exist some further settings, which you might have to set to your needs. Goto Tools Options Language Settings Complex Text Layout. The setting Load user-specific settings with the document in Tools Options LibreOffice General might influence the behavior too. Which version of Word has produced your documents? Which file format have your documents? You are using an old LibreOffice version and therefore have not got the newest improvements for the filter. You should setup a test environment with a Fresh version and test whether it has less problems with your documents. http://www.libreoffice.org/download/libreoffice-fresh/ If documents are still handled wrong, it would be nice if you can help us to improve LibreOffice. Look in our Bugtracking system and if the problem is not reported already, write a bug report and _attach an example document_. https://bugs.documentfoundation.org/ Kind regards Regina Hi All , In My organization we use Word files That written in Hebrew. We have some problems While working on those files , such as : 1. fonts Type changing in Some of the Files . 2. page direction turning from rtl to ltr . 3. text becomes gibberish . 4. Line numbering Format turns from alphabetic to numbers . We use WorkArounds that solve some of the problems but each file is different from another , So that The WorkArounds not Work Properly on Some of the Files. We Use Libre Office 4.2.4 Running On Windows 7 x86 I would Like to know if there are special settings that can be Done in Libre Office to solving those problems Sincerely, Yaoz Vashdi -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Libre Office - Problems Working With Hebrew
Hi I am afraid I don't have any answer but are there any regional settings you could share with us? Armed with this information one of the more knowledgeable members may be able to help Cheers On 22/06/15 18:05, ושדי יהעוז wrote: Hi All , In My organization we use Word files That written in Hebrew. We have some problems While working on those files , such as : 1. fonts Type changing in Some of the Files . 2. page direction turning from rtl to ltr . 3. text becomes gibberish . 4. Line numbering Format turns from alphabetic to numbers . We use WorkArounds that solve some of the problems but each file is different from another , So that The WorkArounds not Work Properly on Some of the Files. We Use Libre Office 4.2.4 Running On Windows 7 x86 I would Like to know if there are special settings that can be Done in Libre Office to solving those problems Sincerely, Yaoz Vashdi -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Libre Office - Problems Working With Hebrew
Le 22/06/2015 10:05, ושדי יהעוז a écrit : Hi Yaoz, In My organization we use Word files That written in Hebrew. We have some problems While working on those files , such as : 1. fonts Type changing in Some of the Files . 2. page direction turning from rtl to ltr . 3. text becomes gibberish . 4. Line numbering Format turns from alphabetic to numbers . Most, if not all, of these problems are probably already entered into the LibreOffice projects bugzilla. Some of the currently known bugs with Hebrew are indicated in the following link: https://bugs.documentfoundation.org/buglist.cgi?quicksearch=hebrew This should give you an idea of the state of play as it stands today. We Use Libre Office 4.2.4 Running On Windows 7 x86 I would try upgrading the version of LibreOffice you use to one that is more current - 4.2.x is already end-of-life, and 4.3.x (current stable production versions) will also soon be end-of-life. LibreOffice 4.4.x is considered the current stable version, although it still has many RTL bugs. Future LibreOffice 5.0 has been released as a release candidate. I suggest you try them out, to see which suits your needs better. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Link Paste Special in Calc
Hi All I am linking data in one Master worksheet to another Slave worksheet in the same workbook. The Master worksheet has blanks in its data. These blanks will be filled in at some future time - hence I need to be able to link those blank cells to the Slave worksheet. Libre Office Help says Copy the data, open the Paste Special dialog, tick the paste all box, and the Link box, and click OK. Doesn't work for me. What am I doing wrong? John --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted