[libreoffice-users] java macro and multiple class methods

2013-06-13 Thread Vieri
Hi,

I have a java macro and a parcel-descriptor.xml with just one method declared:

?xml version=1.0 encoding=UTF-8?
parcel language=Java xmlns:parcel=scripting.dtd
script language=Java
locale lang=en
displayname value=CO.Java/
description
CO macro.
/description
/locale
functionname value=CO.CO_submit/
logicalname value=CO.CO_submit/
languagedepprops
prop name=classpath value=COLO.jar/
/languagedepprops
/script
/parcel

Suppose I have another class method (CO_test) I'd like to call from LO. I'd 
like to add CO.CO_test just like I declared CO.CO_submit.
How can I do this?

If I try the following:

?xml version=1.0 encoding=UTF-8?
parcel language=Java xmlns:parcel=scripting.dtd
script language=Java
locale lang=en
displayname value=CO.Java/
description
CO macro.
/description
/locale
functionname value=CO.CO_submit/
logicalname value=CO.CO_submit/
languagedepprops
prop name=classpath value=COLO.jar/
/languagedepprops
/script
script language=Java
locale lang=en
displayname value=COtest.Java/
description
CO test macro.
/description
/locale
functionname value=CO.CO_test/
logicalname value=CO.CO_test/
languagedepprops
prop name=classpath value=COLO.jar/
/languagedepprops
/script
/parcel

then I can see both methods in LO. So I can select any of the two and run them. 
However, no matter which one of the two I try to run, only the CO.CO_submit 
method will be run.

What am I doing wrong?

I haven't found a single example on the internet or in the docs where a 
parcel-descriptor defines more than one method to call.

Surely I could duplicate the jar and parcel-descriptor files and define one 
method in each of them but that seems too inefficient.

Thanks,

Vieri


-- 
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] java macro and multiple class methods

2013-06-13 Thread Vieri
Never mind... Right after posting this e-mail it started to work correctly. I 
don't know what I was doing wrong before.

Sorry for the noise.

Vieri


--- On Thu, 6/13/13, Vieri rentor...@yahoo.com wrote:

 Hi,
 
 I have a java macro and a parcel-descriptor.xml with just
 one method declared:
 
 ?xml version=1.0 encoding=UTF-8?
 parcel language=Java xmlns:parcel=scripting.dtd
     script language=Java
         locale lang=en
             displayname
 value=CO.Java/
            
 description
                 CO
 macro.
            
 /description
         /locale
         functionname
 value=CO.CO_submit/
         logicalname
 value=CO.CO_submit/
         languagedepprops
             prop
 name=classpath value=COLO.jar/
         /languagedepprops
     /script
 /parcel
 
 Suppose I have another class method (CO_test) I'd like to
 call from LO. I'd like to add CO.CO_test just like I
 declared CO.CO_submit.
 How can I do this?
 
 If I try the following:
 
 ?xml version=1.0 encoding=UTF-8?
 parcel language=Java xmlns:parcel=scripting.dtd
     script language=Java
         locale lang=en
             displayname
 value=CO.Java/
            
 description
                 CO
 macro.
            
 /description
         /locale
         functionname
 value=CO.CO_submit/
         logicalname
 value=CO.CO_submit/
         languagedepprops
             prop
 name=classpath value=COLO.jar/
         /languagedepprops
     /script
     script language=Java
         locale lang=en
             displayname
 value=COtest.Java/
            
 description
                 CO
 test macro.
            
 /description
         /locale
         functionname
 value=CO.CO_test/
         logicalname
 value=CO.CO_test/
         languagedepprops
             prop
 name=classpath value=COLO.jar/
         /languagedepprops
     /script
 /parcel
 
 then I can see both methods in LO. So I can select any of
 the two and run them. However, no matter which one of the
 two I try to run, only the CO.CO_submit method will be run.
 
 What am I doing wrong?
 
 I haven't found a single example on the internet or in the
 docs where a parcel-descriptor defines more than one method
 to call.
 
 Surely I could duplicate the jar and parcel-descriptor files
 and define one method in each of them but that seems too
 inefficient.
 
 Thanks,
 
 Vieri
 
 
 -- 
 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
 
 

-- 
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] Recent Documents List

2013-06-13 Thread Keith Bainbridge
Try this:

http://ask.libreoffice.org/en/question/941/can-i-access-a-list-of-recent-documents-longer/

Keith Bainbridge

keithrbaugro...@gmail.com

0447 667 468


On 12 June 2013 00:09, Tom Davies tomdavie...@yahoo.co.uk wrote:

 Hi :)
 Does anyone remember how to fix the list of recent documents to be longer
 than 10?  There was 1 solved thread about this and 1 unsolved.  Can anyone
 remember when the solved list happened?  Perhaps a link to the Nabble
 thread?

 Regards from
 Tom :)






 
  From: susan zarrett suezr...@gmail.com
 To: Tom Davies tomdavie...@yahoo.co.uk
 Sent: Monday, 10 June 2013, 23:28
 Subject: Re: [libreoffice-documentation] Documenta
 
 
 
 Unfortunately not, but thanks for asking.
 
 
 
 On 6/10/2013 5:45 PM, Tom Davies wrote:
 
 Hi :)
 Did you ever manage to solve this one?
 Regards from
 
 Tom :)
 
 
 
 
 
  From: Tim Lloyd tim.ll...@gmx.com
 To: susan zarrett suezr...@gmail.com
 Cc: documentat...@global.libreoffice.org; users@global.libreoffice.org
 users@global.libreoffice.org
 Sent: Thursday, 16 May 2013, 0:02
 Subject: Re: [libreoffice-documentation] Documenta
 
 
 Hi Susan and welcome to LibreOffice. There was a
   thread about this back
 in January which may be of help. I haven't tried it:
 
 https://www.libreoffice.org/get-help/nabble-mailing-list-interface/
 
 Also, I have copied this to the users list which is
   probably a better
 resource. The docs list is related to documentation of
   LO.
 
 Cheers
 
 
 On 05/16/2013 06:42 AM, susan zarrett wrote:
  Hi, I'm new to LibreOffice.  I can't figure out
   how to show a list of
  all documents and not just the 10 shown.  Please
   help.  Thanks, Susan
  Zarrett
 
 
 
 --
 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



-- 
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: [libreoffice-users] Re: [libreoffice-users] Προτάσεις βελτίωση Libre Ofice

2013-06-13 Thread Simos Xenitellis
Thanks Tom!

I am forwarding to the us...@el.libreoffice.org mailing list and also
replying inline.


2013/6/13 Tom Davies tomdavie...@yahoo.co.uk

 Hi :)
 I used Quick Translate to try to work out what the chap said.  It's all
 Greek to me.

 Is anyone able to point him to the Greek Users List?

 Regards from
 Tom :)

 Γεια σας :)
 Η συνήθιζα Quick Μετάφραση να προσπαθήσουμε να μάθουμε τι το σκάσιμο
 είπε. Είναι όλα τα ελληνικά μου.
 Η Είναι κανείς σε θέση να επισημάνει τον στην ελληνική λίστα χρηστών;
 Regards
 από Tom :)


 Kalispera, [= hello]
 I,  Dimitio Desylas, of the Greek LoCo community for Ubuntu would like to
 help my LibreOffice to become better platform.  Reason is that I want to
 promote the free, open source software companies organizations and schools
 to ordinary users. (eg my sister)

 So I suggest to add these features. These features reason I suggest the
 following comparison libre office impress (the last stable version) with MS
 powerpoint course in Microsoft WINDOWS 7 has the H / PC where you do not
 practice the LibreOffice the I use in Ubuntu linux 12.04.02 I use home.:

 * Improved color palette: In MS office powerpoint noticed that I can add
 custom font color. How simply words can be identified and mine color values
 ​​beyond some defaults. ie I define my own values ​​in r, g, b as the font
 color and background color - fill a shape and generally where I have to
 choose color.  If he has, is good to have and the corresponding option and
 buttons that it font color and click th is for color filling.


A feature to be able to specify a custom font color.
This would require a search at the LibreOffice bugzilla in case it is
already filed.
I am not sure if LibreOffice uses the OS palette widget, which in this case
it would be an issue to enable in that palette the ability to select a
custom color.



 * Ability to select multiple images Admission: Once I Insert image from
 Impress allow me to introduce only a picture. The corresponding choice of
 MS office gives me can choose more than one insert images. In LibreOffice
 need to enter one by one while ms office I can Enter all together


A feature to multi-select images when inserting an image to a document. I
think this should be an easy-hack. If there is no bug report already on
this, a feature request should be filed first. Again, it should be an issue
of enabling the multiple-file selection for FileOpen, and adjust
LibreOffice to accept multiple images into the document.



 * standards may be stored in the closed format: When becomes a
 presentation of the standards has preset the Impress when stored in.  Pptx
 then some points such size and position of objects and presentation buttets
 alloionontai and not stored properly so that the text is in the wrong place
 and some bullets do not look good when you re open the Impress.  Which does
 not help either document sharing and either in migration in LibreOffice.


This is a request for compatibility with the presentation templates (.ppx),
which in some cases they are not rendered correctly in LibreOffice. Here
there should be a bug report (or more) on specific issues on .ppx files
which are not used properly in LibreOffice. The bug report should specify a
.ppx, and how it is used wrongly in LibreOffice.



 * Ability to save as image: At the Ms office Powerpoint noticed that I can
 select text or an object and save it as a picture thing to do a group
 picture along with other images
 and text and save it as an image thing that helps especially do logos on
 site. It would have been and this feature the LibreOffice Impress.


This is a feature request to be able to save a selection from a document,
into an image. The selection would either be a paragraph or text along with
images or other objects.
I think this could be implemented through an addon.


 Personally i do not blame Impress.  I just want the LibreOffice be worthy
 replacement for MS Office because I believe in the idea of ​​free and open
 source and I want to contribute.  If there some of them would like to tell
 me where to Impress.  Still will like if some of the above features are
 developed for future versions LibreOffice.



In all these issues, I think Dimitris can search the LibreOffice bugzilla
and try to identify existing reports. If there is no report already, a new
report can be filed for each.
Then, post the URLs for those reports to the list in order for the rest of
us to subscribe and discuss further.

Simos






 
  From: Δεσύλλας Δημήτριος ddesyl...@yahoo.gr
 To: users@global.libreoffice.org
 Sent: Wednesday, 12 June 2013, 19:04
 Subject: [libreoffice-users] Προτάσεις βελτίωση Libre Ofice
 
 
 Καλισπέρα,
 Με λένε  Δημήτιο Δεσυλα  είμαι μέλος της ελληνικής κοινότητας ubuntu και
 θα ήθελα να βοηθήσω το libre ofice ώστε να γίνει καλύτερη πλατφόρμα.
 Λόγο ότι θέλω να προωθήσω το ελεύθερο, ανοικτό λογισμικό σε εταιρείες
 οργανισμούς σχολεία αλλά και σε απλούς χρήστες. (πχ. 

Re: [libreoffice-users] A function doesn't work on cell whihc is a link to another cell

2013-06-13 Thread Michael Wu
Hi Pál,

Please check to see whether the problem can be fixed if you use 
Shift + Ctrl + F9  to recalculate all formulas in the file2.

Good luck and regards from

   
Michael

csanyipal 提到:
 Hi, 

 Grade_CellBehavior.ods
 http://nabble.documentfoundation.org/file/n4061013/Grade_CellBehavior.ods  

 In the uploaded Calc file 'Grade_CellBehavior.ods' the column AE and BH are
 just simple cells with number values.

 The Sheet '1.'  in this file is a sheet from another, bigger Calc file (
 called here 'file1' ) in which I have such sheets for every pupil.

 I have also a Calc file 'file2' in which I have too such columns, as AE and
 BH, but cells in these columns are not just cells with number values, but
 links for 'file1'.

 So, in the school I fill out the cells in the 'file1' file, come home, copy
 the 'file1' into approppriate directory, open the 'file2' Calc file and get
 the values into it from 'file1' automatically.

 I hope this is cleare so far. 

 As one can see in 'Grade_CellBehavior.ods' when one change the value '3' in
 AE6 to value '2' then the value in AD6 changes automatically to value !?.
 This shows me that that a teacher closed the grade for that Subject badly.

 But this doesn't work in the 'file2', because eg. the value in AE6 is not
 just a number, but a value that we get is a link from 'file1'.

 I hope this is clear. 

 How can I solve this to works in the 'file2' too?



 -
 Best Regards from
 Pál
 --
 View this message in context: 
 http://nabble.documentfoundation.org/A-function-doesn-t-work-on-cell-whihc-is-a-link-to-another-cell-tp4061013.html
 Sent from the Users mailing list archive at Nabble.com.



-- 
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] Showing cell contents as text in calc. (Not evaluating the formula the text represents)

2013-06-13 Thread david_lynch

 On 12/06/2013 22:44, Steve Edmonds wrote:

Hi.
I want to enter {=MMULT(MINVERSE(A14:R31),S14:S31)} in a cell and to 
display this as the text {=MMULT(MINVERSE(A14:R31),S14:S31)} 
(without the  quotes). Formatting the cell as text doesn't help. I 
thought once you could prepend with a ' to define the characters 
following as left aligned text but not show the '. This does not seem 
to work any more, there must be a simple solution I am missing.

Cheers, steve

If you put {=MMULT(MINVERSE(A14:R31),S14:S31)} in, say, A1. A2 with 
=FORMULA(A1), will display

{=MMULT(MINVERSE(A14:R31),S14:S31)} in A2.

David Lynch

--
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



[Solved] Re: [libreoffice-users] java macro and multiple class methods

2013-06-13 Thread Tom Davies
Hi :)
Congrats.  No need to apologise fro the noise/traffic!  Congrats on solving the 
puzzle :)
Congrats and regards from 

Tom :)  







 From: Vieri rentor...@yahoo.com
To: users@global.libreoffice.org 
Sent: Thursday, 13 June 2013, 7:27
Subject: Re: [libreoffice-users] java macro and multiple class methods
 

Never mind... Right after posting this e-mail it started to work correctly. I 
don't know what I was doing wrong before.

Sorry for the noise.

Vieri


--- On Thu, 6/13/13, Vieri rentor...@yahoo.com wrote:

 Hi,
 
 I have a java macro and a parcel-descriptor.xml with just
 one method declared:
 
 ?xml version=1.0 encoding=UTF-8?
 parcel language=Java xmlns:parcel=scripting.dtd
     script language=Java
         locale lang=en
             displayname
 value=CO.Java/
            
 description
                 CO
 macro.
            
 /description
         /locale
         functionname
 value=CO.CO_submit/
         logicalname
 value=CO.CO_submit/
         languagedepprops
             prop
 name=classpath value=COLO.jar/
         /languagedepprops
     /script
 /parcel
 
 Suppose I have another class method (CO_test) I'd like to
 call from LO. I'd like to add CO.CO_test just like I
 declared CO.CO_submit.
 How can I do this?
 
 If I try the following:
 
 ?xml version=1.0 encoding=UTF-8?
 parcel language=Java xmlns:parcel=scripting.dtd
     script language=Java
         locale lang=en
             displayname
 value=CO.Java/
            
 description
                 CO
 macro.
            
 /description
         /locale
         functionname
 value=CO.CO_submit/
         logicalname
 value=CO.CO_submit/
         languagedepprops
             prop
 name=classpath value=COLO.jar/
         /languagedepprops
     /script
     script language=Java
         locale lang=en
             displayname
 value=COtest.Java/
            
 description
                 CO
 test macro.
            
 /description
         /locale
         functionname
 value=CO.CO_test/
         logicalname
 value=CO.CO_test/
         languagedepprops
             prop
 name=classpath value=COLO.jar/
         /languagedepprops
     /script
 /parcel
 
 then I can see both methods in LO. So I can select any of
 the two and run them. However, no matter which one of the
 two I try to run, only the CO.CO_submit method will be run.
 
 What am I doing wrong?
 
 I haven't found a single example on the internet or in the
 docs where a parcel-descriptor defines more than one method
 to call.
 
 Surely I could duplicate the jar and parcel-descriptor files
 and define one method in each of them but that seems too
 inefficient.
 
 Thanks,
 
 Vieri
 
 
 -- 
 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
 
 

-- 
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



-- 
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] packaging a Java macro class in an extension (.oxt)

2013-06-13 Thread Vieri
Hi,

I'm trying to deploy macros within a custom oxt extension.
I successfully deployed a Basic library by doing the following:

in META-INF\manifest.xml I added:

 manifest:file-entry manifest:full-path=CO_SaveDoc/ 
manifest:media-type=application/vnd.sun.star.basic-library/
 
 manifest:file-entry manifest:full-path=CO_SaveDoc/COSaveDoc.xcu 
manifest:media-type=application/vnd.sun.star.configuration-data/
 
 manifest:file-entry manifest:full-path=CO_SaveDoc/COSaveDoc.xcs 
manifest:media-type=application/vnd.sun.star.configuration-schema/


The CO_SaveDoc subdir contains several xba files as well as the script.xlb 
and dialog.xlb files.

If I install my custom oxt extension, I can see all my custom Basic macros 
within LO.

However, I'm failing to add my custom Java macros.

in META-INF\manifest.xml I added:

 manifest:file-entry 
manifest:full-path=CO_SaveDoc_Java/parcel-descriptor.xml 
manifest:media-type=text/xml/

 manifest:file-entry manifest:full-path=CO_SaveDoc_Java/COj1.jar 
manifest:media-type=application/vnd.sun.star.uno-component;type=Java/


and the CO_SaveDoc_Java subdir contains both files of which 
parcel-descriptor.xml has the following:

parcel language=Java xmlns:parcel=scripting.dtd
script language=Java
locale lang=en
displayname value=COj1.CO/
description
CO macro.
/description
/locale
functionname value=CO.COSaveDoc/
logicalname value=CO.COSaveDoc/
languagedepprops
prop name=classpath value=CO_SaveDoc_Java/COj1.jar/
/languagedepprops
/script
/parcel

If I zip that all up and try to install it as an .oxt then I get the following 
error:


%PROGRAMFILES%\LibreOffice 4.0\programunopkg add --shared 
Z:\LibreOffice\extensions\CO_SaveDoc-1.0.0.oxt

ERROR: An error occurred while enabling: COj1.jar
   Cause: com.sun.star.registry.CannotRegisterImplementationException: 
Cannot determine registration class!

unopkg failed.


I don't know what the above message means and how to fix it.

I then tried this instead of the above in META-INF\manifest.xml:

 manifest:file-entry 
manifest:full-path=CO_SaveDoc_Java/parcel-descriptor.xml 
manifest:media-type=text/xml/
 manifest:file-entry manifest:full-path=CO_SaveDoc_Java/COj1.jar 
manifest:media-type=application/vnd.sun.star.uno-typelibrary;type=Java/

and I don't get any errors while installing the oxt extension. However, if I 
open LO I can't find my Java macro library.

What could I be doing wrong?

I'm trying to follow several guides on the web, among others, this one:
http://wiki.openoffice.org/wiki/Documentation/DevGuide/Extensions/File_Format#Uno_Jar_Components

Does anyone know of an extension out there (http://extensions.libreoffice.org) 
that I could download that actually has Java macros?

Thanks,

Vieri


-- 
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] LO 4.1.0-beta

2013-06-13 Thread Heinrich Stoellinger

Hello,
I tried to install LO 4.1-beta2. There is no desktop-integration directory in
LibreOfficeDev_4.1.0.0.beta2_Linux_x86_deb/DEBS. Is this as intended? I cannot
start 4.1-beta2 after installing it.
Regards
H. Stoellinger

--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
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] Showing cell contents as text in calc. (Not evaluating the formula the text represents)

2013-06-13 Thread Brian Barker

At 11:32 13/06/2013 +0100, David Lynch wrote:

 On 12/06/2013 22:44, Steve Edmonds wrote:
I want to enter {=MMULT(MINVERSE(A14:R31),S14:S31)} in a cell and 
to display this as the text {=MMULT(MINVERSE(A14:R31),S14:S31)} 
(without the  quotes). Formatting the cell as text doesn't help.


If you put {=MMULT(MINVERSE(A14:R31),S14:S31)} in, say, A1. A2 with 
=FORMULA(A1), will display {=MMULT(MINVERSE(A14:R31),S14:S31)} in A2.


If you put that text into A1, I don't think that is true.  The text 
itself is not a formula, so the result of the FORMULA() reference is 
#N/A.  But yes: if you enter that into A1 *as an array formula* 
(without typing the braces and using Ctrl+Shift+Enter), that is 
indeed what happens.  Then you have to remember, when you edit what 
is in A1 (as the questioner required), to use Ctrl+Shift+Enter 
instead of simple Enter each time to confirm the edit.


Brian Barker


--
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] LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-13 Thread Maurice Batey
Having installed Mageia-3 on a trial basis, I have come across an omission
in its LO 4.0.3.3 that I have been using on Mageia-2's LO 3.5.7.2, namely
'Insert: Horizontal rule'

The result is that any document prepared with 3.5.7.2 does not appear
correctly under 4.0.3.3.

I see from:

http://ask.libreoffice.org/en/question/14922/why-is-horizontal-line-broken-in-401/

that the omission is a deliberate change rather than accidental (although it 
seems
the Help info still  thinks otherwise...).

Why on earth drop a feature that people are using?
What is the rationale?

Failing any other solution to my problem, is there any way I can copy the
3.5.7.2 'ruler' file over in to 4.0.3.3 so that the latter shows the lines 
properly?

-- 
/\/\aurice 
(Retired in Surrey, UK) Registered Linux User #487649
Linux 64-bit Mageia-2
  KDE 4.8.5  Virtualbox 4.1.14   Firefox 17.0.5   KMail 4.8.5


-- 
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] LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-13 Thread Tom Davies
Hi :)
Feel free to post a bug-report or wish-list item about it
https://wiki.documentfoundation.org/BugReport

There might already be one but you will find that out after filling in a 
suitable subject-line for the report (hopefully before it asks you to fill in 
the message part).  I suspect that if you put a clickable link to the 
feature-request/bug-report in the Ask LO thread and another in this thread 
then a lot of people might support it.  
Regards from 
Tom :)  






 From: Maurice Batey maur...@bcs.org.uk
To: users@global.libreoffice.org 
Sent: Thursday, 13 June 2013, 15:48
Subject: [libreoffice-users] LO 4.0.3.3: 'Insert: Horizontal rule' is missing
 

Having installed Mageia-3 on a trial basis, I have come across an omission
in its LO 4.0.3.3 that I have been using on Mageia-2's LO 3.5.7.2, namely
'Insert: Horizontal rule'

The result is that any document prepared with 3.5.7.2 does not appear
correctly under 4.0.3.3.

I see from:

http://ask.libreoffice.org/en/question/14922/why-is-horizontal-line-broken-in-401/

that the omission is a deliberate change rather than accidental (although it 
seems
the Help info still  thinks otherwise...).

Why on earth drop a feature that people are using?
What is the rationale?

Failing any other solution to my problem, is there any way I can copy the
3.5.7.2 'ruler' file over in to 4.0.3.3 so that the latter shows the lines 
properly?

-- 
/\/\aurice 
    (Retired in Surrey, UK)     Registered Linux User #487649
            Linux 64-bit Mageia-2
          KDE 4.8.5  Virtualbox 4.1.14   Firefox 17.0.5   KMail 4.8.5


-- 
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



-- 
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: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-13 Thread Maurice
On Thu, 13 Jun 2013 16:07:53 +0100, Tom Davies wrote:

 Feel free to post a bug-report or wish-list item about it
 https://wiki.documentfoundation.org/BugReport
 
 There might already be one

Could not see one - but there is one (53852) asking for an improvement to 
the now omitted function! (Last posting there Aug.26 2012...)

For new documents I could manage without the function, but I have an 
existing document using horizontal rules that no longer shows the lines 
correctly, so I shall raise a bug report.

I think it is poor that such a function should just be dropped for no 
apparent reason, in such an incompatible way, and with no pre-discussion 
that I'm aware of.

-- 
/\/\aurice


-- 
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: [libreoffice-users] Re: [libreoffice-users] Re: [libreoffice-users] Προτάσεις βελτίωση Libre Ofice

2013-06-13 Thread Δημήτριος Δεσύλλας

I thought I was at Greek mailing list..

Στις 13/06/2013 01:01 μμ, ο/η Simos Xenitellis έγραψε:

Thanks Tom!

I am forwarding to the us...@el.libreoffice.org mailing list and also
replying inline.


2013/6/13 Tom Davies tomdavie...@yahoo.co.uk


Hi :)
I used Quick Translate to try to work out what the chap said.  It's all
Greek to me.

Is anyone able to point him to the Greek Users List?

Regards from
Tom :)

Γεια σας :)
Η συνήθιζα Quick Μετάφραση να προσπαθήσουμε να μάθουμε τι το σκάσιμο
είπε. Είναι όλα τα ελληνικά μου.
Η Είναι κανείς σε θέση να επισημάνει τον στην ελληνική λίστα χρηστών;
Regards
από Tom :)


Kalispera, [= hello]
I,  Dimitio Desylas, of the Greek LoCo community for Ubuntu would like to
help my LibreOffice to become better platform.  Reason is that I want to
promote the free, open source software companies organizations and schools
to ordinary users. (eg my sister)

So I suggest to add these features. These features reason I suggest the
following comparison libre office impress (the last stable version) with MS
powerpoint course in Microsoft WINDOWS 7 has the H / PC where you do not
practice the LibreOffice the I use in Ubuntu linux 12.04.02 I use home.:

* Improved color palette: In MS office powerpoint noticed that I can add
custom font color. How simply words can be identified and mine color values
​​beyond some defaults. ie I define my own values ​​in r, g, b as the font
color and background color - fill a shape and generally where I have to
choose color.  If he has, is good to have and the corresponding option and
buttons that it font color and click th is for color filling.


A feature to be able to specify a custom font color.
This would require a search at the LibreOffice bugzilla in case it is
already filed.
I am not sure if LibreOffice uses the OS palette widget, which in this case
it would be an issue to enable in that palette the ability to select a
custom color.



* Ability to select multiple images Admission: Once I Insert image from
Impress allow me to introduce only a picture. The corresponding choice of
MS office gives me can choose more than one insert images. In LibreOffice
need to enter one by one while ms office I can Enter all together


A feature to multi-select images when inserting an image to a document. I
think this should be an easy-hack. If there is no bug report already on
this, a feature request should be filed first. Again, it should be an issue
of enabling the multiple-file selection for FileOpen, and adjust
LibreOffice to accept multiple images into the document.



* standards may be stored in the closed format: When becomes a
presentation of the standards has preset the Impress when stored in.  Pptx
then some points such size and position of objects and presentation buttets
alloionontai and not stored properly so that the text is in the wrong place
and some bullets do not look good when you re open the Impress.  Which does
not help either document sharing and either in migration in LibreOffice.


This is a request for compatibility with the presentation templates (.ppx),
which in some cases they are not rendered correctly in LibreOffice. Here
there should be a bug report (or more) on specific issues on .ppx files
which are not used properly in LibreOffice. The bug report should specify a
.ppx, and how it is used wrongly in LibreOffice.



* Ability to save as image: At the Ms office Powerpoint noticed that I can
select text or an object and save it as a picture thing to do a group
picture along with other images
and text and save it as an image thing that helps especially do logos on
site. It would have been and this feature the LibreOffice Impress.



This is a feature request to be able to save a selection from a document,
into an image. The selection would either be a paragraph or text along with
images or other objects.
I think this could be implemented through an addon.



Personally i do not blame Impress.  I just want the LibreOffice be worthy
replacement for MS Office because I believe in the idea of ​​free and open
source and I want to contribute.  If there some of them would like to tell
me where to Impress.  Still will like if some of the above features are
developed for future versions LibreOffice.




In all these issues, I think Dimitris can search the LibreOffice bugzilla
and try to identify existing reports. If there is no report already, a new
report can be filed for each.
Then, post the URLs for those reports to the list in order for the rest of
us to subscribe and discuss further.

Simos








From: Δεσύλλας Δημήτριος ddesyl...@yahoo.gr
To: users@global.libreoffice.org
Sent: Wednesday, 12 June 2013, 19:04
Subject: [libreoffice-users] Προτάσεις βελτίωση Libre Ofice


Καλισπέρα,
Με λένε  Δημήτιο Δεσυλα  είμαι μέλος της ελληνικής κοινότητας ubuntu και
θα ήθελα να βοηθήσω το libre ofice ώστε να γίνει καλύτερη πλατφόρμα.
Λόγο ότι θέλω να προωθήσω το ελεύθερο, ανοικτό λογισμικό σε εταιρείες

[libreoffice-users] LO 4.0.4.1 crashes when running a report

2013-06-13 Thread Heinrich Stoellinger

Hello,
When trying to run a report under LO 4.0.4.1 LO crashes with the following
message:
kernel: [12362.147061] soffice.bin[28748]: segfault at 18 ip 0018 sp 
bfc62c8c
error 14 in soffice.bin[8048000+1000]
My system is Linux-Debian-Wheezy, 32-bit.
Regards
H. S.

--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
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: A function doesn't work on cell whihc is a link to another cell

2013-06-13 Thread csanyipal
Hi Michael,

I don't know why happen that, that it didn't work once, or twice some few
days back, but now it works.

Thank you for help and support!



-
Best Regards from
Pál
--
View this message in context: 
http://nabble.documentfoundation.org/A-function-doesn-t-work-on-cell-whihc-is-a-link-to-another-cell-tp4061013p4061324.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-13 Thread V Stuart Foote
Maurice,

Simply reopen issue  fdo#60858
https://bugs.freedesktop.org/show_bug.cgi?id=60858  , but you will need to
make a strong case from a UX position as to why a horizontal rule direct
style object is needed.

Also, HTML styles and direct editing still support use of HR or HR /
tagging so the horizontal rule is an more an issue of direct styling
paragraph separators.

A more precise discussion Ask LibreOffice thread  is: 
selection-of-horizontal-rule-no-longer-possible
http://ask.libreoffice.org/en/question/15930/selection-of-horizontal-rule-no-longer-possible/
  

Looking at fdo#60858, the decision to remove the direct styling looks to
have been one of code maintenance...

2012-11-23
Cédric BosdonnatRemoved horizontal rule ugly 1990 thing
Change-Id:  Ifafd8b2ffd9af90b6ac4ed2ee0ccd3c5e980731c
https://gerrit.libreoffice.org/gitweb?p=core.gita=searchh=HEADst=commits=Ifafd8b2ffd9af90b6ac4ed2ee0ccd3c5e980731c
  

But a case has to be made for UX development to reestablish--that process is
via the fdo#60858 bug and the LibreOffice   UX-Advise
http://nabble.documentfoundation.org/UX-Advise-f3619688.html   list.

Stuart







--
View this message in context: 
http://nabble.documentfoundation.org/LO-4-0-3-3-Insert-Horizontal-rule-is-missing-tp4061308p4061331.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-13 Thread V Stuart Foote
I've gone ahead and reopened the fdo#60858 bug.  

But, is it a regression or a needed enhancement?

In either case, please make your usage case for needing horizontal rule as
separators.   Should address both direct styling (i.e. from the menu) as
well as page styling (i.e. the horizontal rule applied as paragraph
separator).






--
View this message in context: 
http://nabble.documentfoundation.org/LO-4-0-3-3-Insert-Horizontal-rule-is-missing-tp4061308p4061335.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-13 Thread Maurice Batey
On Thu, 13 Jun 2013 15:32:49 +, Maurice wrote:

  I shall raise a bug report.

  Now raised, but I still don't have a bug report number.
  
The gist of it is that the omission* of the Horizontal Rule option has
created a problem for documents that already have such lines, i.e. it
was an *incompatible* change.

(* I see that the mission was on grounds of 'difficulty of maintenance'.
Does that mean we may see other useful facilities suddenly
disappear?!)
-- 
/\/\aurice 



-- 
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: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-13 Thread V Stuart Foote
Maurice,

Your bug was  fdo#65719 https://bugs.freedesktop.org/show_bug.cgi?id=65719  
but that has been consolidated as a duplicate of  fdo#60858
https://bugs.freedesktop.org/show_bug.cgi?id=60858  .

Please comment against fdo#60858

Stuart



--
View this message in context: 
http://nabble.documentfoundation.org/LO-4-0-3-3-Insert-Horizontal-rule-is-missing-tp4061308p4061348.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-13 Thread Maurice Batey
On Thu, 13 Jun 2013 18:45:40 +0100, I wrote:

 I still don't have a bug report number.

 https://bugs.freedesktop.org/show_bug.cgi?id=65719
 
(Marked as a duplicate of :

  https://bugs.freedesktop.org/show_bug.cgi?id=60858

-- 
/\/\aurice 



-- 
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: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-13 Thread V Stuart Foote
I have started a UX-Advise thread on design review of how Horizontal Rulers
can be reintroduced to the Writer GUI.

How-to-provide-horizontal-rule-paragraph-separators
http://nabble.documentfoundation.org/How-to-provide-horizontal-rule-paragraph-separators-tp4061353.html
  

Stuart



--
View this message in context: 
http://nabble.documentfoundation.org/LO-4-0-3-3-Insert-Horizontal-rule-is-missing-tp4061308p4061356.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Re: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-13 Thread Tom Davies
Hi :)
It would be really great if more of us could learn how to mark as duplicate 
and other triaging stuff.  Even just a few people here learnt what is in some 
of those drop-downs that would be good.  I'm completely hopeless at remembering 
that sort of thing but there is a competition coming up soon and it would be 
great if the Users List were able to walk off with some of the prizes.  It's a 
t-shirt rather than a cup or trophy for the top 10 so it's a tad more useful!

Congrats Maurice if you were the one that marked-as-duplicate!  If Stuart did 
it then many thanks again to him for all his work.  

Regards from 

Tom :)  







 From: Maurice Batey maur...@bcs.org.uk
To: users@global.libreoffice.org 
Sent: Thursday, 13 June 2013, 20:01
Subject: [libreoffice-users] Re: LO 4.0.3.3: 'Insert: Horizontal rule' is 
missing
 

On Thu, 13 Jun 2013 18:45:40 +0100, I wrote:

 I still don't have a bug report number.

https://bugs.freedesktop.org/show_bug.cgi?id=65719

(Marked as a duplicate of :

  https://bugs.freedesktop.org/show_bug.cgi?id=60858

-- 
/\/\aurice 
    


-- 
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



-- 
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] LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-13 Thread Steve Edmonds


On 2013-06-14 02:48, Maurice Batey wrote:

Having installed Mageia-3 on a trial basis, I have come across an omission
in its LO 4.0.3.3 that I have been using on Mageia-2's LO 3.5.7.2, namely
'Insert: Horizontal rule'

The result is that any document prepared with 3.5.7.2 does not appear
correctly under 4.0.3.3.
74
I see from:

http://ask.libreoffice.org/en/question/14922/why-is-horizontal-line-broken-in-401/

that the omission is a deliberate change rather than accidental (although it 
seems
the Help info still  thinks otherwise...).

Why on earth drop a feature that people are using?
What is the rationale?

Failing any other solution to my problem, is there any way I can copy the
3.5.7.2 'ruler' file over in to 4.0.3.3 so that the latter shows the lines 
properly?

For me the big issue is that MSO is flamed for poor backwards 
compatibility with and support of its own file types, will you be able 
to open those MS files 10 years down the track, and now LO are heading 
the same way. Surely if the horizontal rule is to be dropped as such 
file compatibility can be maintained by converting to a drawn line 
object, as could removing compatibility with earlier files from the LO 
binary without moving the code to an optional plugin easily accessed 
from the binary.

Steve

--
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] create custom macro within share location (program files)

2013-06-13 Thread Andrew Douglas Pitonyak
Openoffice stores individual macros in modules. Modules are stored in 
libraries, and libraries are stored in macro containers.


Three things can be macro containers, documents, your user space, and 
one that is global to OpenOffice. It sounds like you desire to add a 
macro that is global to OpenOffice. I have never done this It is not 
enabled on my Linux system, is it available to you to do from the GUI 
when you are logged in as an administrator?


I expect that the Link from Tom Davis is the best you can find, since I 
don't see an ability to set the Macro location directories in the 
configuration.


On 06/12/2013 02:26 AM, Vieri wrote:

Hi,

This is probably trivial but I'm not capable of correctly creating new custom 
macros within %PROGRAMFILES%\LibreOffice 4.0\share\basic\ (Windows 7).

My goal is to setup some custom macros globally for all users (location=share). I don't 
want to include the macros within location=document because I'll be deploying lots of 
docs and it would be a pain to maintain/update macros within every single odt document. 
I'd also like to avoid location=user (or location=application - I don't remember which is 
which) because I have PCs that are being used by lots of users and copying/syncing 
user macros to each user profile on every machine would be a waste of space 
and network bandwidth.
That's why I was hoping to install and update all my macros within the main LO 
application.
Another even better way would be to tell the LO application that my custom macros can be 
found on a remote server, eg. something like location=url. This way, I'd 
maintain my macros on my web/ftp/webdav/whatever server (just one single copy) and forget 
about syncing them with each and every LO client installation.

Any ideas?

Vieri




--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
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] DDE Links from calc to writer

2013-06-13 Thread Mike Shaul

Hello all,

I have created a document in writer that has DDE links to a spreadsheet 
I created in calc. It has recently been acting funny, when I change a 
value in the calc spreadsheet it used to change all the values in the 
document in writer. Now, about 80% of the writer document responds to 
the changes in calc but about 20% does not. Could this be due to having 
too many links? I have about 3400 DDE links.


I'm using:
LibreOffice 3.5.4.2
Linux mint Cinnamon

I should also say that on a scale from 1-10 on computer knowledge I'm at 
best a 5.


Thank you in advance,
-Mike


--
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: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-13 Thread Ken Springer

On 6/13/13 3:10 PM, Steve Edmonds wrote:


On 2013-06-14 02:48, Maurice Batey wrote:

Having installed Mageia-3 on a trial basis, I have come across an omission
in its LO 4.0.3.3 that I have been using on Mageia-2's LO 3.5.7.2, namely
'Insert: Horizontal rule'

The result is that any document prepared with 3.5.7.2 does not appear
correctly under 4.0.3.3.
74
I see from:

http://ask.libreoffice.org/en/question/14922/why-is-horizontal-line-broken-in-401/

that the omission is a deliberate change rather than accidental (although it 
seems
the Help info still  thinks otherwise...).

Why on earth drop a feature that people are using?
What is the rationale?

Failing any other solution to my problem, is there any way I can copy the
3.5.7.2 'ruler' file over in to 4.0.3.3 so that the latter shows the lines 
properly?


For me the big issue is that MSO is flamed for poor backwards
compatibility with and support of its own file types, will you be able
to open those MS files 10 years down the track, and now LO are heading
the same way. Surely if the horizontal rule is to be dropped as such
file compatibility can be maintained by converting to a drawn line
object, as could removing compatibility with earlier files from the LO
binary without moving the code to an optional plugin easily accessed
from the binary.
Steve


+1

So much for the big discussion earlier about how everyone should switch 
to ODT because the standard wouldn't change.LOL


This just proves, that if you want those old files, you'd better have an 
old OS and software available to read them.



--
Ken

Mac OS X 10.8.4
Firefox 20.0
Thunderbird 17.0.5
LibreOffice 4.0.3.3


--
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] LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-13 Thread Tom Davies
Hi :)
Hmm, there are many reasons for preferring non-MS.  Backwards compatibility is 
just 1 of the issues.  Current compatibility with it's own current formats is 
another.  A third is whether it's current formats work with non-MS products 
that do follow the OOXML ISO standard.  
Regards from 
Tom :)  






 From: Steve Edmonds steve.edmo...@ptglobal.com
To: maur...@bcs.org.uk 
Cc: users@global.libreoffice.org 
Sent: Thursday, 13 June 2013, 22:10
Subject: Re: [libreoffice-users] LO 4.0.3.3: 'Insert: Horizontal rule' is 
missing
 


On 2013-06-14 02:48, Maurice Batey wrote:
 Having installed Mageia-3 on a trial basis, I have come across an omission
 in its LO 4.0.3.3 that I have been using on Mageia-2's LO 3.5.7.2, namely
 'Insert: Horizontal rule'

 The result is that any document prepared with 3.5.7.2 does not appear
 correctly under 4.0.3.3.
 74
 I see from:

 http://ask.libreoffice.org/en/question/14922/why-is-horizontal-line-broken-in-401/

 that the omission is a deliberate change rather than accidental (although it 
 seems
 the Help info still  thinks otherwise...).

 Why on earth drop a feature that people are using?
 What is the rationale?

 Failing any other solution to my problem, is there any way I can copy the
 3.5.7.2 'ruler' file over in to 4.0.3.3 so that the latter shows the lines 
 properly?

For me the big issue is that MSO is flamed for poor backwards 
compatibility with and support of its own file types, will you be able 
to open those MS files 10 years down the track, and now LO are heading 
the same way. Surely if the horizontal rule is to be dropped as such 
file compatibility can be maintained by converting to a drawn line 
object, as could removing compatibility with earlier files from the LO 
binary without moving the code to an optional plugin easily accessed 
from the binary.
Steve

-- 
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



-- 
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: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-13 Thread Ken Springer

On 6/13/13 5:12 PM, Tom Davies wrote:

Hi :)
Hmm, there are many reasons for preferring non-MS.  Backwards compatibility is 
just 1 of the issues.  Current compatibility with it's own current formats is 
another.  A third is whether it's current formats work with non-MS products 
that do follow the OOXML ISO standard.
Regards from
Tom :)



Preferring MS or not, or any other format, isn't the point here.

It's accessing the old files regardless of format, which even LO appears 
to be abandoning.  You can't have it both ways, use ODT because the 
standards will remain unchanged so old files can be accessed while 
accepting a decision that prevents the accurate opening of the old files.



--
Ken

Mac OS X 10.8.4
Firefox 20.0
Thunderbird 17.0.5
LibreOffice 4.0.3.3


--
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