Re: [libreoffice-users] Word documents that LO messes up

2015-06-23 Thread Tom Williams
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

2015-06-23 Thread Paul D. Mirowsky
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

2015-06-23 Thread Paul D. Mirowsky

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

2015-06-23 Thread Malcolm Moore
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?

2015-06-23 Thread Remy Gauthier
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

2015-06-23 Thread Regina Henschel

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

2015-06-23 Thread Tim Lloyd
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

2015-06-23 Thread Alexander Thurgood
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

2015-06-23 Thread John Ruth Sparrow

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