[libreoffice-users] Re: database

[Alexander Thurgood]

Le 20/04/12 23:01, Tom Davies a écrit :

Hi Tom,

 The 3.5.x branch prefers java 1.7 and apparently that preference has been 
 back-ported to 3.4.5 and also gone into the 3.4.6.  For a Mac it's quite 
 important to remove java 6_29 or was it 6_30 asap.  
 Regards from
 Tom :)

Please do not recommend people to start messing with their Java
installations on Mac unless there is a known specific problem. Apple has
released several Java general/security updates recently for OSX versions
prior to Lion, i.e. for Leopard (10.5) and Snow Leopard (10.6), I
haven't checked recently on my Tiger (10.4) box (naughty me) to see
whether that has also been the case.

The current Java version on my Snow Leopard machine (10.6.8) is :
java version 1.6.0_31
Java(TM) SE Runtime Environment (build 1.6.0_31-b04-415-10M3635)
Java HotSpot(TM) 64-Bit Server VM (build 20.6-b01-415, mixed mode)

This works with LO, pretty good as far as I can tell.


Alex


-- 
For unsubscribe instructions e-mail to: users+h...@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: database

[Alexander Thurgood]

Le 20/04/12 22:07, Elizabeth Lawrence a écrit :

Hi again Elizabeth,

 I'm using Mac OS X 10.5.8.  I am trying to start a new database and

OK, I have Mac OSX 10.6.8, Snow Leopard. For me, the basic LibreOffice
Base functionality works (within the confines of known issues, bugs, etc).

Can you open a Terminal (in your Utilities folder of the Applications
folder) and type in :

java -version

press enter

and then post the output in your response. That would tell us which
version of Java you have installed in your system. It might be important.


 trying to click on use Wizard to create table.  It doesn't click
 properly and the suggestion of creating a table using the Wizard
 vanishes.   I have to confess I haven't used Libreoffice before, but my
 Boss suggested it for a database and showed me how to start off.  I have
 used a database before but I really can't get on with this at the


Here's a step by step test you can do :
1) Start LibreOffice

2)(a) Choose File  New  Database from the dropdown File menu,

OR

2)(b) from the Start Center, click on the Database icon

3) The Database creation wizard should appear.
4) Choose Create a Database.
5) Click on Next.

6) The following screen allows you to choose what you want to do after
the new database has been saved, leave the default settings for the time
being - what happens here is that an empty (it does in fact contain
certain configuration data, but that is hidden from the user) ODB
database container file is created which contains no tables


7) Accept the default settings as mentioned in point 6 and click on Finish.

8) The wizard now asks you for a name to be given to the database file
you are about to register and a location on the hard disk at which to
save it.

9) Enter a name and then press Save.

10) The main window of your newly saved database file should now appear.
By default, it should contain 4 icons in a column to the left of the
window, the first icon is named Tables. These icons are clickable and
give you access to the various main functions of the database
application in relation to your database file.

11) Since Tables should be selected by default, in the split window that
occupies most of the space, you should have an empty space in the lower
pane, and three entries in the upper pane. The three entries are as
follows :

Create Table in Design View...
Use Wizard to Create Table...
Create View...

12) Click on Create Table in Design View...


Let us know what happens next.



Alex







-- 
For unsubscribe instructions e-mail to: users+h...@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: database

[Larry Gusaas]

On 2012-04-20 2:22 PM  Steve Edmonds wrote:
My mac tried to update my java the other day to V7 (1.7), I stopped it..  I think there were 
issues with this version and LO. Possibly someone can advise the state of compatibility with 
the different LO versions and Java. 


The update is to Java for Mac OS X 10.6 update 7 ( Installs as JRE 1.6.0_31). 
This IS NOT JRE 1.7.

It is imperative to update to this version as there is a serious security vulnerability in JRE 
1.6.0_29.


--
_

Larry I. Gusaas
Moose Jaw, Saskatchewan Canada
Website:http://larry-gusaas.com
An artist is never ahead of his time but most people are far behind theirs. - 
Edgard Varese



--
For unsubscribe instructions e-mail to: users+h...@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: database

[Larry Gusaas]

On 2012-04-20 3:01 PM  Tom Davies wrote:
The 3.5.x branch prefers java 1.7 and apparently that preference has been back-ported to 3.4.5 and also gone into the 3.4.6.  For a Mac it's quite important to remove java 6_29 or was it 6_30 asap. 
Regards from


JRE 1.7 has not been released for Macs. The latest for OS X version 10.6 (Snow Leopard) is JRE 
1.6.0_31. It works well with AOO 3.4 and LO 3.5.


Please don't give Mac advice when you don't know what you are talking about.

--
_

Larry I. Gusaas
Moose Jaw, Saskatchewan Canada
Website: http://larry-gusaas.com
An artist is never ahead of his time but most people are far behind theirs. - 
Edgard Varese



--
For unsubscribe instructions e-mail to: users+h...@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] Impress issue - Number of pages in PDF or printed handouts

[Guillaume Pomerleau]

Hello all,

I am a user of LibreOffice 3.5.2.2 under Ubuntu 10.04 (but soon moving to 12.04 
:) )
I'm writing to make a suggestion for Impress, more precisely in the Printing 
and PDF exporting options.

Background:
It is currently possible to export an .ODP to .PDF (single slide). Under the 
Print option, it is also possible to print to a file (.PDF) with multiple 
slides per page (Handouts). 
Also under the print option, when selecting other information to print, I 
have the 3 following Contents choices: adding the Slide name, the Date and 
Hidden pages. (see Impress Documentation, Chapter 10 Printing, E-mailing, 
Exporting, and Saving Slide Shows, page 7)

Suggestion:
What I would like to suggest is to add in this Contents menu the choice Page 
number, so that I could add the page number on my Handout. (see Impress 
Documentation, Chapter 10 Printing, E-mailing, Exporting, and Saving Slide 
Shows, page 7)
For example, I have a Handout of 2 numbered slides on one .PDF page (with Print 
to file option), but I cannot add the page number via Impress. 

Additional suggestion:
Furthermore, when converting directly to .PDF (either with the Save as PDF, the 
Export to PDF or the PDF button of the Standard menu bar), it would be nice to 
add the option of a Handout there, with the same Contents menu, i.e. add the 
page number to the handout.

I hope everything was clear since French is my first language ;)

Thank you very much guys,

Guillaume Pomerleau
  
-- 
For unsubscribe instructions e-mail to: users+h...@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] drawing

[W . B . B van den Bos]

Dear sir or madam,
I have a problemen with drawing.
Step 1. I make a printscreen for test perpose.
Step 2. I imput the printscreen in libre drawing.

But i cannot cut certain sections with the points selection tool in the import 
screenshot.
Than the screenshot is selected and when i press cut, the hole screenshot it 
gone.
How can I edit insert images or screenshots?

 

 

With kind regards from,

 

Ben v/d Bos

 

 
  
-- 
For unsubscribe instructions e-mail to: users+h...@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] how to insert enumerated comments.

[Uwe Brauer]

Hello 


Ms word 2003 inserts comments which are automatically
numbered. I cannot find a similar feature in libreoffice
(3.4) nor can I find a extension which does this.

Does anybody know about it?

Thanks 

Uwe Brauer 

BTW when I open a word document with such comments the
numbers are *not* displayed (RTF or 2003 doc binary format).


-- 
For unsubscribe instructions e-mail to: users+h...@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] Input Needed for more LibreOffice Stories

[Bruce Byfield]

Hi, Everyone:

Some of you may have seen my recent article 12 Ways LibreOffice Writer Tops MS 
Word. Since the article was Slashdotted, I've been asked by my editor at 
Datamation to write several followups.

In the interests of fairness, I thought I'd do a flipflop and talk about where 
LibreOffice lags behind MS Office. I also thought (although I have my own 
ideas) 
that I'd ask for input from other users. At this point, I'm not sure if I'll 
discuss the office suites as a whole, or just the word processors, so any and 
all comments will be welcome.

If you have any thoughts, please send them to me by noon Pacific time on 
Sunday, April 22nd.

Another article in the next month or so might include a comparison of Calc and 
Excel, so please send any comments on that topic, as well. I'd be especially 
interested in hearing from high-end users about how the two spreadsheets 
compare when doing long and complex formulae.

Thanks for any input,

-- 
Bruce Byfield, Burnaby BC 604-421-7189  (on Pacific time)
blog: https://brucebyfield.wordpress.com
website: http://members.axion.net/~bbyfield/

-- 
For unsubscribe instructions e-mail to: users+h...@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: database

[Alexander Thurgood]

Le 20/04/12 22:07, Elizabeth Lawrence a écrit :

Hi Elizabeth,

Further to my question regarding the version of Java on your system, it
would appear from this link :

http://support.apple.com/kb/HT1222

that the last update to Java for OSX 10.5 was made available on June 28,
2011 :

http://support.apple.com/kb/HT4739


which should install Java version 1.6.0_26


Alex




-- 
For unsubscribe instructions e-mail to: users+h...@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: Input Needed for more LibreOffice Stories

[Alexander Thurgood]

Le 20/04/12 21:29, Bruce Byfield a écrit :

Hi Bruce,

 If you have any thoughts, please send them to me by noon Pacific time on 
 Sunday, April 22nd.
 

Scan through the discussions on Base in this list, in comparison to
other known DB frontend solutions, and I'm pretty certain you'll be able
to find some meat for your platter.


Alex


-- 
For unsubscribe instructions e-mail to: users+h...@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: database

[Larry Gusaas]

On 2012-04-20 8:39 AM  Elizabeth Lawrence wrote:

HI,

I have downloaded libreoffice in order to use the database.  I can bring up the database but 
the one I want use wont open the wizard for tables.
I have tried to uninstall libreoffice twice but it wont go.  My blood pressure is soaring - 
please help!


Liz Lawrence


The wizards require that JRE is enabled in LibreOffice.
On the menu bar go to  LibreOffice/Preferences.
In the window that opens gor to LibreOffice/Java and check Use a Java runtime 
environment
A list of installed JRE's will appear. Check the newest one.

--
_

Larry I. Gusaas
Moose Jaw, Saskatchewan Canada
Website: http://larry-gusaas.com
An artist is never ahead of his time but most people are far behind theirs. - 
Edgard Varese



--
For unsubscribe instructions e-mail to: users+h...@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: database

[Andreas Säger]

Am 20.04.2012 16:39, Elizabeth Lawrence wrote:

HI,

I have downloaded libreoffice in order to use the database. I can bring
up the database but the one I want use wont open the wizard for tables.
I have tried to uninstall libreoffice twice but it wont go. My blood
pressure is soaring - please help!

Liz Lawrence



So you installed Base only? This can not work.


--
For unsubscribe instructions e-mail to: users+h...@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: drawing

[Alexander Thurgood]

Le 20/04/12 09:52, W.B.B van den Bos a écrit :

Hi Ben,

 I have a problemen with drawing.
 Step 1. I make a printscreen for test perpose.
 Step 2. I imput the printscreen in libre drawing.

That print screen image is a bitmap.

 
 But i cannot cut certain sections with the points selection tool in the 
 import screenshot.
 Than the screenshot is selected and when i press cut, the hole screenshot it 
 gone.

The points editing/selection tool you refer to is for editing vectorial
images, not for bitmaps.


 How can I edit insert images or screenshots?
 

You would first need to convert your image to a vectorised format.
LibreOffice has this possibility, but quite frankly, im my experience,
it is cumbersome, awkward to use, requires a lot of fiddling, and the
results aren't always what a user might reasonably expect. You would be
better off using a dedicated piece of vector drawing software that has a
competent bitmap to vector format converter.

If you want to do this in LibreOffice :

Insert your image into the Draw document
Select it with the mouse.
Right mouse button click to bring up the context menu
Choose Convert to Polygon
Play with the parameters
Click on the Preview button
Repeat until satisfied...

Once converted, right mouse button click on the image
Choose Break from the context
Play with the layers, points, etc to your hearts content.



Alex


-- 
For unsubscribe instructions e-mail to: users+h...@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] calc compliance with openformula

[e-letter]

On 20/04/2012, Regina Henschel rb.hensc...@t-online.de wrote:
 SUM( { NumberSequenceList N }+ )

 e.g. SUM(a1+b2)

 No. it would be SUM(a1;b2)


It would be better if calc returned an error, stating incorrect syntax


 In LibreOffice the behavior of the operator + and the function is not
 the same in regard of cells with no numerical content.

 Your question is to general. Please give a more concrete example, what
 you try to calculate, what your result is and what you expect the result
 should be.


The question is general because a general understanding is required!
The example concerns only integers, e.g. where a1=1 and b2=2, the
results are correct, but the question is about learning the correct
syntax so that formula entered in a calc spreadsheet will not be lost
or corrupted when the spreadsheet is opened in another odf compliant
software, e.g. gnumeric. I don't want to use a sum syntax such as
(a1+b2), which gives the correct result, but if opened in another
program, the formula is lost or gives an incorrect answer.

-- 
For unsubscribe instructions e-mail to: users+h...@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: Problems importing an OO database into LO

[Ian Whitfield]

On 20/04/2012 18:51, Alexander Thurgood wrote:

Check the permissions on your /software folder and also the permissions
on the hsqldb folder and any files in it. The jar file at least, needs
to have the executable bit set.


OK - one step at a time I guess

I checked the permissions on the three .jar files and found that the 'x' 
setting was not checked so I made them all wide-open. Now when I go to 
'Class Path' I can see them and select one.


(BTW - except for the one I put in in my 'software' folder the other two 
must have been put there by LO). I selected the one in 'software' (ver 
2.2.8 - hsqldb.jar)


As I now want to try the external-linked way of running Base I selected 
to Create a New Database'. Base opens but says .


a) I'm still using the embedded Database.
b) And I get an error box that says ...  The connection to the data 
source DB Name could not be established.
The driver class 'org.hsqldb.jdbcDriver' coud not be loaded. The 
additional driver class path is 
'vnd.sun.star.expand:$BRAND_BASE_DIR/program/classes/hsqldb.jar

vnd.sun.star.expand:$BRAND_BASE_DIR/program/classes/sdbc_hsqldb.jar'.

Some more assistance please!!!

--
Ian Sig






*/_Ian Whitfield_/*
ZS6CDX

*Pretoria, South Afric*a
*Tel* - +27 (0)12 817 2001
*Cell* -+27 (0)82 573 9142
*FAX* - +27 (0)86 651 4844
*Skype* - ianzs6cdx, also on Facebook
*SnailMail* - Box 72226, Lynnwood Ridge 0040, South Africa
/
(No trees were harmed in the production of this message, however a
large number of re-cycled electrons were temporarily inconvenienced) /

--
For unsubscribe instructions e-mail to: users+h...@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: Problems importing an OO database into LO

[Alexander Thurgood]

Le 21/04/12 10:28, Ian Whitfield a écrit :

Hi Ian,

 On 20/04/2012 18:51, Alexander Thurgood wrote:
 Check the permissions on your /software folder and also the permissions
 on the hsqldb folder and any files in it. The jar file at least, needs
 to have the executable bit set.

You only needed to check/change the permissions on this :

/home/ian/software/hsqldb-2.2.8/hsqldb/lib/hsqldb.jar

not the others ! Those other jar files you listed are the ones that come
with LO, and you shouldn't really be fiddling around with those.

 
 As I now want to try the external-linked way of running Base I selected
 to Create a New Database'. Base opens but says .
 
 a) I'm still using the embedded Database.
 b) And I get an error box that says ...  The connection to the data
 source DB Name could not be established.
 The driver class 'org.hsqldb.jdbcDriver' coud not be loaded. The
 additional driver class path is
 'vnd.sun.star.expand:$BRAND_BASE_DIR/program/classes/hsqldb.jar
 vnd.sun.star.expand:$BRAND_BASE_DIR/program/classes/sdbc_hsqldb.jar'.
 

1) Remove the links that you added to the Classpath parameter to :
/opt/libreoffice3.5/programs/classes/hsqldb.jar
/opt/libreoffice3.5/programs/classes/sdbc_hsqldb.jar

LO already knows where to find them. From what you describe as your
actions, you added them again to the classpath, and that is
possibly/probably what is causing LO to moan.

2) After removing the links to those files, restart LO.

3) Do not open your old ODB file in LO Base yet, i.e. the one you want
to migrate over to using the hsqldb2 engine.

4) Follow Andreas' instructions from point (3) onwards :

 3) Extract the database folder out of your embedded .odb.

What Andreas means here is that you should make a copy of your existing
ODB database file, then unzip the copy. Although one can work directly
on the original ODB file if you know what you are doing, it would be
better I think in this case to work on a copy of that file.


 4) Rename the files:
  properties, script, backup, data
 to:
  foo.properties, foo.script, foo.backup, foo.data
 where foo is just an arbitrary name.

This instruction should be clear, if not, please state what you don't
understand


 5) Connect a new Base document to a JDBC data source with an URL like:
 jdbc:hsqldb:file:/path/to/extracted/database/foo;default_schema=true
 (the foo refers to the same database name I used as file name prefix)

This too, seems clear to me, but if you have a question, please ask.


 6) Copy queries, forms and reports from the old embedded .odb to the new one. 

This too, seems clear to me, but again, if uncertain, please ask.



Alex


-- 
For unsubscribe instructions e-mail to: users+h...@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: Problems importing an OO database into LO

[Ian Whitfield]

On 21/04/2012 10:48, Alexander Thurgood wrote:

1) Remove the links that you added to the Classpath parameter to :
/opt/libreoffice3.5/programs/classes/hsqldb.jar
/opt/libreoffice3.5/programs/classes/sdbc_hsqldb.jar

LO already knows where to find them. From what you describe as your
actions, you added them again to the classpath, and that is
possibly/probably what is causing LO to moan.

2) After removing the links to those files, restart LO.

3) Do not open your old ODB file in LO Base yet, i.e. the one you want
to migrate over to using the hsqldb2 engine.

4) Follow Andreas' instructions from point (3) onwards :

Thanks Alex. but 'No Go' I'm afraid!!!

I ONLY added the ONE path to the class like you say but I removed it and 
re-started LO and did it again. After another re-start I STILL get the 
same error message when I try to start a new Database.


I'm working this way because Base screwed-up my original DB so badly 
(which is why I decided to make a change). The original .odb file is 
such a mess. In looking for an alternative I've been working with Kexi 
and spent days correcting and editing my table in this program. It's 
very good but I have discovered a few flaws - the main one being a TOTAL 
LACK of support


So my plan is to get Base working with the external HSQLDB2 engine, 
recreate my Table layout and then export my corrected table from Kexi in 
.csv format and import it into the new Base layout. Hope you follow me.


Thanks for the kind help.


--
For unsubscribe instructions e-mail to: users+h...@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] Want code or name of the component in Writer of LibreOffice that does doc, xls, ppt conversions to pdf

[Ankit Jain]

Hi Tom/ All,

Thanks for your reply but as I said I want to make my own tool that does the 
file conversions-doc,xls or ppt to PDF format without installing either Libre 
Office or Portable Libre Office on my machine. So I want the component or the 
code or any name of the part of the source code of Libre Office that does this 
conversion utility.
I hope my question is clear now.

Can someone provide me any kind of help on this. Even if I get some web link 
that may help me then also it's fine.

Regards,
Ankit

--- On Fri, 20/4/12, Tom Davies tomdavie...@yahoo.co.uk wrote:

From: Tom Davies tomdavie...@yahoo.co.uk
Subject: Re: [libreoffice-users] Want code or name of the component in Writer 
of LibreOffice that does doc, xls, ppt conversions to pdf
To: users@global.libreoffice.org
Date: Friday, 20 April, 2012, 8:30 PM

Hi :)
You could use LibreOffice in headless mode, ie from a command-line without 
opening LibreOffice at all.  

Java is an increasingly vulnerable pile of mess with frequent updates in order 
to overcome known threats that are out in the wild even before a version of 
java gets released.  The last 3 versions, 7.0, 7.1 and 7.2 didn't even get 
released before work started on the next one due to known threats and other 
problems.  

The LibreOffice project is trying to write-out any dependance on java in order 
to avoid forcing people to install java.  
Regards from
Tom :)



--- On Fri, 20/4/12, Ankit Jain ankit_1988ma...@yahoo.co.in wrote:

From: Ankit Jain ankit_1988ma...@yahoo.co.in
Subject: [libreoffice-users] Want code or name of the component in Writer of 
LibreOffice that does doc, xls, ppt conversions to pdf
To: users@global.libreoffice.org
Date: Friday, 20 April, 2012, 11:23

   Hi All,

I just want to explore about the filter in writer component that does the doc 
or xls to pdf conversion.If someone can give me the part of code or the filter 
that does this conversion it would be very helpful to me.Also what are the 
libraries that are involved in conversion.
Please give me some link from where I can get the complete knowledge on this.

Basically I want to develop my own tool in Java which would convert any 
word,xls or ppt kind of document to pdf format without using the direct utility 
of LibreOffice that does this conversion.

Any help on this would be greatly appreciated.

Thanks in advance.
Ankit

-- 
For unsubscribe instructions e-mail to: users+h...@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

-- 
For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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

office politics Re: [libreoffice-users] Re: database

[Tom Davies]

Hi :)
Office Politics.  It sounds to me like Elizabeth is being played and that her 
boss wants to 
1)  'prove' that LibreOffice doesn't work
2)  get her fired or demoted by 'proving' she is incompetent 


How-To 'prove' that a tool doesn't work = give it to someone that 'everyone' is 
in awe of but has never done the type of task before and never used the  tools 
for anything else.  

How-To 'prove' someone is incompetent = Step1, give them a task that could be 
made to sound easy, ie  'just' a list of customers for mail-merging.  It 
helps if no-one else in the office has done the task or that anyone that has 
done something similar also has severe self-esteem issues or is an extremely 
advanced user that found the task trivial after studying the subject at college 
for 3 years or something.  Step2, tell them what tools to use and carefully 
pick something that no-one in the office has any familiarity with so that there 
is no-one to trick into getting help from.  

I have seen this sort of thing happen quite often and fallen fould of it a 
couple of times myself.  It's not always deliberately done.  Sometimes the aim 
is to build the person up rather than being part of a campaign to destroy 
them and that would be used as an excuse if you confronted them or raised a 
complaint about them.  

Recently i began to learn that a good way to turn the tables is to delegate 
the task to someone that is likely to be able to complete the task and give 
them more support than you were given, ie point them to the users-list and 
official documentation and let them know you don't think the task is trivial at 
all but encourage them into believing you think they might be one of the few 
people you know that is up to the challenge (ie generally empower them and 
leave them to get on with it).  Perhaps set a couple of kids the challenge.  
Either way once they have set-up the structure it's easier to get the real data 
into the database, perhaps one of the touch-typists would be good to delegate 
the data-entry part of the  task to?    

Regards from
Tom :)


--- On Sat, 21/4/12, Andreas Säger ville...@t-online.de wrote:

From: Andreas Säger ville...@t-online.de
Subject: [libreoffice-users] Re: database
To: users@global.libreoffice.org
Date: Saturday, 21 April, 2012, 8:42

Am 20.04.2012 16:39, Elizabeth Lawrence wrote:
 HI,

 I have downloaded libreoffice in order to use the database. I can bring
 up the database but the one I want use wont open the wizard for tables.
 I have tried to uninstall libreoffice twice but it wont go. My blood
 pressure is soaring - please help!

 Liz Lawrence


So you installed Base only? This can not work.


-- 
For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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] calc compliance with openformula

[Jean-Francois Nifenecker]

Le 21/04/2012 10:24, e-letter a écrit :

On 20/04/2012, Regina Henschelrb.hensc...@t-online.de  wrote:

SUM( { NumberSequenceList N }+ )

e.g. SUM(a1+b2)


No. it would be SUM(a1;b2)



It would be better if calc returned an error, stating incorrect syntax



I'm afraid it is *not* incorrect syntax. Likewise, SUM(5) is correct 
syntax as well.



The question is general because a general understanding is required!
The example concerns only integers, e.g. where a1=1 and b2=2, the
results are correct, but the question is about learning the correct
syntax so that formula entered in a calc spreadsheet will not be lost
or corrupted when the spreadsheet is opened in another odf compliant
software, e.g. gnumeric. I don't want to use a sum syntax such as
(a1+b2), which gives the correct result, but if opened in another
program, the formula is lost or gives an incorrect answer.



All spreadsheet software I know of are accepting the syntax above. Of 
course, the syntax to use is preferably SUM(A1:A10), ie using a cell 
range rather than discrete cell references, but the latter can be useful 
(see 3. below).


So the following are all syntactically correct:

1. SUM(A1:A10)
- returns the sum of the numerical values within the range. Non-numeric 
values are ignored.


2. SUM(A1:A10;Z1:Z10)
- like 1, with multiple ranges.

3. SUM(A1;B2;Z15)
- returns the sum of several cells. Non-numeric values are ignored, 
opposite to what A1+B2+Z15 would return (see Regina's answer).


...and any combination of the previous.

HTH,
--
Jean-Francois Nifenecker, Bordeaux

--
For unsubscribe instructions e-mail to: users+h...@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: database

[Steve Edmonds]

Thanks for the clarification.
Steve

On 2012-04-21 19:02, Larry Gusaas wrote:

On 2012-04-20 2:22 PM  Steve Edmonds wrote:
My mac tried to update my java the other day to V7 (1.7), I stopped 
it..  I think there were issues with this version and LO. Possibly 
someone can advise the state of compatibility with the different LO 
versions and Java. 


The update is to Java for Mac OS X 10.6 update 7 ( Installs as JRE 
1.6.0_31). This IS NOT JRE 1.7.


It is imperative to update to this version as there is a serious 
security vulnerability in JRE 1.6.0_29.




--
For unsubscribe instructions e-mail to: users+h...@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: Input Needed for more LibreOffice Stories

[Tom]

Hi :)
You might find it easier to search through previous posts by using Nabble.  

Errr, well MS looks prettier on the surface and successfully makes people
feel they have to buy the newest one all the time for 'greater
interoperability'.  It easily slips into different style settings so that
bullet-points and fonts can easily switch around and look very different
throughout a document without even trying.  If using non-'American'-English
the language settings for spelling and grammar slip easily back into
American-English.  MS Office is also sexily vulnerable to malware and stable
enough that updates to reduce vulnerabilities don't appear too hastily.  

Regards from
Tom :)

--
View this message in context: 
http://nabble.documentfoundation.org/Input-Needed-for-more-LibreOffice-Stories-tp3927680p3927905.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] calc compliance with openformula

[Johnny Rosenberg]

Den 20 april 2012 15:57 skrev e-letter inp...@gmail.com:
 Readers,

 According to the specification for openformula (see:
 http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html),
 the syntax for the function 'sum' is:

 SUM( { NumberSequenceList N }+ )

 e.g. SUM(a1+b2)

”a1+a2” is NOT a Number Sequence List. ”a1;a2” is.
What happens in your example, is that a1 and a2 are first calculated
and then sent to the function SUM, which then doesn't have very much
more to do than just returning its input value. So if a1=5 and a2=7,
then SUM's argument is 12. So SUM calculates the sum of 12 in this
case, which is very unnecessary.

On the other hand, with syntax ”=SUM(a1;a2₎”, a1 and a2 are sent to
SUM, and SUM calculates and returns the sum.

 However in calc the function:

 =a1+b2

 still produces a correct result. Isn't the logical behaviour for the
 second function to return an error, for non-compliance with the
 standard.

No. ”=a1+a2” has nothing to do with the SUM function at all.

 This is being asked for learning if it is better to use the
 official syntax or accept that these short-cuts exist.

It's not a short-cut, since it has nothing to do with the SUM
function, see above.



 LO334

-- 
For unsubscribe instructions e-mail to: users+h...@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] calc compliance with openformula

[Johnny Rosenberg]

Den 20 april 2012 15:57 skrev e-letter inp...@gmail.com:
 Readers,

 According to the specification for openformula (see:
 http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html),
 the syntax for the function 'sum' is:

 SUM( { NumberSequenceList N }+ )

 e.g. SUM(a1+b2)
 However in calc the function:

 =a1+b2

 still produces a correct result. Isn't the logical behaviour for the
 second function to return an error, for non-compliance with the
 standard.

Go to the link below and read about ”Operators”. Then tell me my
”=a1+b2” is ”non-compliance with the standard”:
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1017940_715980110

This is being asked for learning if it is better to use the
 official syntax or accept that these short-cuts exist.

 LO334

 --
 For unsubscribe instructions e-mail to: users+h...@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

-- 
For unsubscribe instructions e-mail to: users+h...@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: Want code or name of the component in Writer of LibreOffice that does doc, xls, ppt conversions to pdf

[Alexander Thurgood]

Le 21/04/12 11:36, Ankit Jain a écrit :

Hi Ankit,

 
 I just want to explore about the filter in writer component that does the doc 
 or xls to pdf conversion.If someone can give me the part of code or the 
 filter that does this conversion it would be very helpful to me.Also what are 
 the libraries that are involved in conversion.
 Please give me some link from where I can get the complete knowledge on this.
 
 Basically I want to develop my own tool in Java which would convert any 
 word,xls or ppt kind of document to pdf format without using the direct 
 utility of LibreOffice that does this conversion.
 
 Any help on this would be greatly appreciated.
 


Try looking here :

http://wiki.documentfoundation.org/Development/Code_Overview#writerfilter

http://docs.libreoffice.org/writerfilter.html

http://docs.libreoffice.org/writerfilter/html/classes.html

and the corresponding places in the git master repo.

Alex


-- 
For unsubscribe instructions e-mail to: users+h...@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: Want code or name of the component in Writer of LibreOffice that does doc, xls, ppt conversions to pdf

[Ankit Jain]

Thanks a lot Alex.

I hope this will help me.

Ankit

--- On Sat, 21/4/12, Alexander Thurgood alex.thurg...@gmail.com wrote:

From: Alexander Thurgood alex.thurg...@gmail.com
Subject: [libreoffice-users] Re: Want code or name of the component in Writer 
of LibreOffice that does doc, xls, ppt conversions to pdf
To: users@global.libreoffice.org
Date: Saturday, 21 April, 2012, 4:13 PM

Le 21/04/12 11:36, Ankit Jain a écrit :

Hi Ankit,

 
 I just want to explore about the filter in writer component that does the doc 
 or xls to pdf conversion.If someone can give me the part of code or the 
 filter that does this conversion it would be very helpful to me.Also what are 
 the libraries that are involved in conversion.
 Please give me some link from where I can get the complete knowledge on this.
 
 Basically I want to develop my own tool in Java which would convert any 
 word,xls or ppt kind of document to pdf format without using the direct 
 utility of LibreOffice that does this conversion.
 
 Any help on this would be greatly appreciated.
 


Try looking here :

http://wiki.documentfoundation.org/Development/Code_Overview#writerfilter

http://docs.libreoffice.org/writerfilter.html

http://docs.libreoffice.org/writerfilter/html/classes.html

and the corresponding places in the git master repo.

Alex


-- 
For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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: database

[Tom Davies]

Hi :)
Brilliant!  Thanks Larry!  Apparently Oracle have started working on Java 7_4 
already and Java 7_3 still hasn't been released.  

The 6_29 on Mac was widely reported as helping a nearly 1% of Macs world-wide 
to get infected or compromised with some sort of malware.  That doesn't mean 
that later versions are safer, just that problems haven't been widely reported 
yet.  Windows users are familiar with dealing with infections and antivirus 
companies tend to claim that around 20% of Windows machines are infected at any 
1 time and there are thousands of viruses and trojans and such adding up to 
hundreds of thousands of threats.  Mac has 1 or 2 every few years and each time 
that gets blown-up out of all proportion by the press that wouldn't bother to 
report similar incidents on Windows.  

For Windows and GnuLinux it's fairly easy to install a JRE (Java Run-time 
Environment) 7 even though they haven't been officially released yet.  I don't 
know if it's easy to get the 7_4 yet but the 7_3 is fairly easy to get from 
Java.com.  Not so easy for Macs tho!  This is about all i got from a google 
search
http://www.vineetmanohar.com/2011/03/installing-java-7-on-mac-os-x/
NOT trivial!

Mostly LibreOffice doesn't need java at all so you can switch it off
Tools - Options - Java
just untick the box at the top.  It's only needed for some Extensions/Add-ons, 
Wizards, Base (if you use the embedded back-end or HSqlDb as an external 
back-end instead of something like Sqllite).  

Generally if you can switch it off and then see if LO grumbles about not having 
it then you are very unlikely to lose any data.  If it grumbles then you can 
just switch java on again, or reinstall it and then switch it on again.  

Personally i think the whole scaremongering thing is being hyped up waaay out 
of proportion.  Almost like a film just before it gets released.  has a major 
antivirus company recently released a new product for Mac?  Is one about to be 
released in the next couple of months?
Regards from
Tom :)


--- On Sat, 21/4/12, Steve Edmonds steve.edmo...@pt-global.com wrote:

From: Steve Edmonds steve.edmo...@pt-global.com
Subject: Re: [libreoffice-users] Re: database
To: users@global.libreoffice.org
Date: Saturday, 21 April, 2012, 11:08

Thanks for the clarification.
Steve

On 2012-04-21 19:02, Larry Gusaas wrote:
 On 2012-04-20 2:22 PM  Steve Edmonds wrote:
 My mac tried to update my java the other day to V7 (1.7), I stopped it..  I 
 think there were issues with this version and LO. Possibly someone can 
 advise the state of compatibility with the different LO versions and Java. 
 
 The update is to Java for Mac OS X 10.6 update 7 ( Installs as JRE 1.6.0_31). 
 This IS NOT JRE 1.7.
 
 It is imperative to update to this version as there is a serious security 
 vulnerability in JRE 1.6.0_29.
 

-- For unsubscribe instructions e-mail to: users+h...@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

-- 
For unsubscribe instructions e-mail to: users+h...@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] beware of the m$ subsidiary

[Tanstaafl]

On 2012-04-19 11:17 AM, Mark Stanton m...@vowleyfarm.co.uk wrote:

Replying without quoting *anything* to maintain context is just as dumb
as if not dumber than blindly quoting everything...



Sorry, having a proper email client that links replies correctly, I forget
that not everybody has that.


Bah... I hate threaded view, which my client does perfectly well, the 
biggest reason being the number of people that don't understand 
threading and constantly break them.


In a perfect world, I would probably use it, but a perfect world it ain't...

--
For unsubscribe instructions e-mail to: users+h...@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] beware of the m$ subsidiary

[Tanstaafl]

On 2012-04-20 3:56 AM, Mark Stanton m...@vowleyfarm.co.uk wrote:

Wish I could.
Nary the knowledge or the time.
Frustration abounds.


I was afraid you were going to say that :-(

Mark Stanton
One small step for mankind...

PS Nice talking to someone with a proper reader ;)


Wtf? He quoted your comment, unlike you...

Oh well, at least you don't top-post... ;)

--
For unsubscribe instructions e-mail to: users+h...@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] calc compliance with openformula

[Tom Davies]

Hi :)
If it's not standard ODF behaviour then just post a bug-report about it.  
Sometimes programs try to be more forgiving but as someone pointed out that 
might not be helpful in all cases.
Regards from
Tom :)


--- On Sat, 21/4/12, Johnny Rosenberg gurus.knu...@gmail.com wrote:

From: Johnny Rosenberg gurus.knu...@gmail.com
Subject: Re: [libreoffice-users] calc compliance with openformula
To: users@global.libreoffice.org
Date: Saturday, 21 April, 2012, 11:26

Den 20 april 2012 15:57 skrev e-letter inp...@gmail.com:
 Readers,

 According to the specification for openformula (see:
 http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html),
 the syntax for the function 'sum' is:

 SUM( { NumberSequenceList N }+ )

 e.g. SUM(a1+b2)
 However in calc the function:

 =a1+b2

 still produces a correct result. Isn't the logical behaviour for the
 second function to return an error, for non-compliance with the
 standard.

Go to the link below and read about ”Operators”. Then tell me my
”=a1+b2” is ”non-compliance with the standard”:
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1017940_715980110

This is being asked for learning if it is better to use the
 official syntax or accept that these short-cuts exist.

 LO334

 --
 For unsubscribe instructions e-mail to: users+h...@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

-- 
For unsubscribe instructions e-mail to: users+h...@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

-- 
For unsubscribe instructions e-mail to: users+h...@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] drawing

[Regina Henschel]

Hi Ben,

W.B.B van den Bos schrieb:


Dear sir or madam,
I have a problemen with drawing.
Step 1. I make a printscreen for test perpose.
Step 2. I imput the printscreen in libre drawing.

But i cannot cut certain sections with the points selection tool in the import 
screenshot.


Draw is an application for vector graphics.


Than the screenshot is selected and when i press cut, the hole screenshot it 
gone.
How can I edit insert images or screenshots?


You can crop the image to the section, but that will be rectangle. Make 
sure you have set the correct scale for the image. Select the cropped 
image. Then use File  Export. Mark 'Selection' and choose the desired 
format, likely png or jpg, and save the section as new image. Afterwards 
you can insert the new image.


Cropping itself does not really cut the parts of the picture, but only 
hides them.


Another way for several sections is this: Insert the image several times 
(which will result in 1 image stored) and crop each of it to the desired 
section.


If you want a not-rectangle section, there exists a complicate way to 
use a combined drawing object, to hide the not needed parts. But I 
recommend to use an application specialized for bitmaps.


Kind regards
Regina





--
For unsubscribe instructions e-mail to: users+h...@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] automatic highlight of document objects in navigator

[Jean-Baptiste Faure]

Le 16/04/2012 23:31, e-letter a écrit :
 Readers,
 
 In the dialogue window 'navigator', is it possible to make the object
 become highlighted as the active cursor is moved through the document?
 
 For example, a document has 2 tables, table 1 and table 2. As the
 cursor is moved (e.g using the keyboard arrows) from table 1 to table
 2, it would be helpful if the highlight colour (blue) also changes.
 
 LO334
 

Hi,

as far I know, it works only with headings when you click the Content
view icon in the navigator (2nd icon on the 2nd line).

Best regards.
JBF

-- 
Seuls des formats ouverts peuvent assurer la pérennité de vos documents.

-- 
For unsubscribe instructions e-mail to: users+h...@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] drawing

[webmaster-Kracked_P_P]

On 04/21/2012 07:18 AM, Regina Henschel wrote:

Hi Ben,


snip
If you want a not-rectangle section, there exists a complicate way to 
use a combined drawing object, to hide the not needed parts. But I 
recommend to use an application specialized for bitmaps.


Kind regards
Regina



Bitmap images - think photos
 use GIMP or other free and open source 
package.  There are a lot out there.


Vector images -  think signs and graphic artwork creation
   use Draw, or an Inkscape type of package

The people who decided what was needed, and not needed, for the TDF/LO 
office suite package did not want to reinvent the wheel if there was a 
good open source option available.


Some people asked about having an email client with OOo/AOO, and now LO, 
to replace MS Outlook.  There are many good free or open source email 
clients out there, so the efforts of the developers did not feel we 
should go and try to make one as good or better.  OOo had a good vector 
graphics drawing package, so LO continued to work with that to make 
better and better.  But a vector graphics package does not do pixel 
related drawing and image editing.  GIMP has been the standard for 
open source pixel-based image editing package, as far as I can tell.  So 
why spend manpower to create a better one for this package.


An office suite needs to deal with a word processor, a spreadsheet 
package, a presentation package, a database package.  Then there are the 
extras.  Math will deal with the creation of formula text for the 
documents, and then Draw to add the basic graphics creation package for 
signs and other vector graphics needs of a business.  The average office 
worker, or student, does not need to do photo and bitmap editing.  If 
they do, they need some very specific, and maybe high end, needs that 
take a lot of manpower to develop and text to get it working right.


To be honest, one thing I hate about Microsoft's and Adobe's mindset is 
the fact that they want to have their packages do EVERYTHING they can 
think of.  That is not a good way to make a good working, and non 
bloated package.  The figures I have seen over the years is that 90% of 
the things that MS office can do is used by less that 3 to 5 percent of 
its users.  I knew people that had been working with Word since Word 95 
and they were the expert in that business for Word.  I borrowed a Word 
reference and started to read off things that Word does and this expert 
never heard of these things and could not figure out why you would want 
to do something like that in a word processor package.


In the software industry, companies try to meet all your needs, but end 
up not doing a good job.  LibreOffice is not like that.  If you want an 
office suite package, LibreOffice does it well.  If you want a photo and 
bitmap editing package, that should not be a part of an office suite, 
and LO did not include one.  If you want an email and calendar client to 
replace Outlook [another bloated package] there are open source clients 
out there that has years of development that LO could never match with 
its limited manpower.


I do not think LO should go the route of MS and Adobe and make their 
software so bloated it takes 1 to 2 GB of drive space just to install 
it, and then not use most of what those companies thought we need, when 
90% or more did not need it.


LO seems to have become the best office suite out there in the free 
and/or open source market.  One day it will be a true 100% replacement 
to MSO for most business users.  In my opinion, it fills the needs for 
at least 80% of business users.  But it will not get there if it offered 
a bloated package that included photos editing, email and calendar 
clients, a web browser, and full HTML editing client.  There are some 
good to great free and/or open source out there that covers all not 
non-office-suite package needs.  TDF/LO took the office suite market 
away from Oracle/OOo when dropped the ball in that market.  But TDF will 
not go and make the mistake of some other companies and try to create a 
package that includes everything a computer user might want to do on 
their machine.  That is one of MSO's mistakes, so let them spend the 
money and manpower dealing with that mistake.  Let TDF/LO deal with the 
needs of the average office suite user.  It makes a better product 
that way.







--
For unsubscribe instructions e-mail to: users+h...@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: database

[Andreas Säger]

Am 20.04.2012 22:07, Elizabeth Lawrence wrote:

Hi Nick,

I'm using Mac OS X 10.5.8. I am trying to start a new database and
trying to click on use Wizard to create table. It doesn't click properly
and the suggestion of creating a table using the Wizard vanishes. I have
to confess I haven't used Libreoffice before, but my Boss suggested it
for a database and showed me how to start off. I have used a database
before but I really can't get on with this at the moment. I'm in a big
sulk at the moment and have uninstalled Libreoffice, working all weekend
so I'll have another go next week. If you can think of anything that
might get me going, I would be really grateful.

Liz
On 20 Apr 2012, at 19:08, Rev. Nick Sharp wrote:


How to create a simple, editable address list without wizard nor Java 
components:


FileNewSpreadsheet.
Put the field names in row #1 (Name, Surname, ZIP, City etc.)
Fill out the table below the header row with your actual data.

FileSave As...
Create a new directory for the file you are going to save and go to that 
directory.

Enter some file name
File Type: dBase (*.dbf)

Close the spreadsheet.
FileNewDatabase
[X] Connect to an existing database
Type: dBase
Specify the _directory_ where you dropped your dBase file.
[X] Register the database (for later use in serial letters)
Save the database (*.odb file) somewhere.
The database (*.odb) has nothing more than one table so far. Open the 
table and check if your data are alright. The database table reflects 
the contents of your *.dbf file in its dedicated directory. More *.dbf 
files in the same directory would add more tables to the database.

Close the table and its database.
# end of set up 

Start a new letter in Writer, hit F4 for the data source window, in the 
left pane of the data source window, browse your database -- Tables -- 
your table
Drag the grey column headers into your letter. This will add place 
holders for the name and address fields. Notice that you can edit the 
data in the data source window (F4) without opening the database.
When you are going to print your letter you will be prompted to print a 
serial letter. The printing dialog for a serial letter lets you select 
all the table data or only selected row(s) of the table. You can also 
print all the letters into a new Writer document instead of a paper printer.



--
For unsubscribe instructions e-mail to: users+h...@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: Problems importing an OO database into LO

[Ian Whitfield]

In addition to what I wrote a couple of hours back - I have just tried a 
couple of other things...


I linked the class path to the two files mentioned in the Error Box. LO 
accepted both of them OK AND popped-up a box warning me to re-start LO 
and then worked fine. BUT both are linked to the embedded engine!!


I tried again with the 2.2.8 version and noticed I DO NOT get the 
warning box to re-start LO. And it gives me the error box as reported.


I then moved a copy of the .jre file to the same location as the first 
two and tried again - no change!!


This leaves me wondering if the .jre file is at fault. It's new, (I 
downloaded it yesterday), and is 1.4Mb in size??


Does this sound like a problem??

--
For unsubscribe instructions e-mail to: users+h...@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: calc compliance with openformula

[Andreas Säger]

Am 20.04.2012 15:57, e-letter wrote:

Readers,

According to the specification for openformula (see:
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html),
the syntax for the function 'sum' is:

SUM( { NumberSequenceList N }+ )



Analog to a regular expression, this means: One or more element of type 
numberSequenceList





--
For unsubscribe instructions e-mail to: users+h...@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: Problems importing an OO database into LO

[Andreas Säger]

Am 21.04.2012 15:46, Ian Whitfield wrote:


This leaves me wondering if the .jre file is at fault. It's new, (I
downloaded it yesterday), and is 1.4Mb in size??



This is the md5sum of my working hsqldb-2.2.8.zip:
$ md5sum ~/download/hsqldb-2.2.8.zip
8b7668689cd208867c77f2f4d77922de  /home/andreas/download/hsqldb-2.2.8.zip



--
For unsubscribe instructions e-mail to: users+h...@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] drawing

[Tom Davies]

Hi :)
There is official documentation for LibreOffice here
http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Draw_Guide

Inkscape is more specialist vector graphics package
http://inkscape.org/

It sounds like you really need Gimp
http://www.gimp.org/

Someone said something about a replacement for MS OutLook
http://projects.gnome.org/evolution/
Evolution is good but it might be better to use a separate email client such as 
Thunderbird or something tiny, light-weight and fast such as Claws or something 
packed with features such as The Bat (not OpenSource but still quite amazing) 
and then an appropriate calendar depending on whether you need it just to 
quickly look-up the date or as a project-management tool for a major project or 
somewhere in the middle.  
Regards from
Tom :)


--- On Sat, 21/4/12, Regina Henschel rb.hensc...@t-online.de wrote:

From: Regina Henschel rb.hensc...@t-online.de
Subject: Re: [libreoffice-users] drawing
To: users@global.libreoffice.org
Date: Saturday, 21 April, 2012, 12:18

Hi Ben,

W.B.B van den Bos schrieb:
 
 Dear sir or madam,
 I have a problemen with drawing.
 Step 1. I make a printscreen for test perpose.
 Step 2. I imput the printscreen in libre drawing.
 
 But i cannot cut certain sections with the points selection tool in the 
 import screenshot.

Draw is an application for vector graphics.

 Than the screenshot is selected and when i press cut, the hole screenshot it 
 gone.
 How can I edit insert images or screenshots?

You can crop the image to the section, but that will be rectangle. Make sure 
you have set the correct scale for the image. Select the cropped image. Then 
use File  Export. Mark 'Selection' and choose the desired format, likely png 
or jpg, and save the section as new image. Afterwards you can insert the new 
image.

Cropping itself does not really cut the parts of the picture, but only hides 
them.

Another way for several sections is this: Insert the image several times (which 
will result in 1 image stored) and crop each of it to the desired section.

If you want a not-rectangle section, there exists a complicate way to use a 
combined drawing object, to hide the not needed parts. But I recommend to use 
an application specialized for bitmaps.

Kind regards
Regina





-- For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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: Problems importing an OO database into LO

[Ian Whitfield]

On 21/04/2012 16:08, Andreas Säger wrote:

Am 21.04.2012 15:46, Ian Whitfield wrote:


This leaves me wondering if the .jre file is at fault. It's new, (I
downloaded it yesterday), and is 1.4Mb in size??



This is the md5sum of my working hsqldb-2.2.8.zip:
$ md5sum ~/download/hsqldb-2.2.8.zip
8b7668689cd208867c77f2f4d77922de  /home/andreas/download/hsqldb-2.2.8.zip


My copy gives me the same Check-Sum!!

So what can be causing the problem??

--
For unsubscribe instructions e-mail to: users+h...@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] LibO/Java Issue from InfoWorld Article

[Stephen Leibowitz]

The following two forum postings for LangugeTool provide possible
insight into the problem discussed in this thread.

http://languagetool-user-forum.2306527.n4.nabble.com/Language-Tool-crashes-LibreOffice-with-Java-7-td4371013.html

http://languagetool-user-forum.2306527.n4.nabble.com/Java-7-Language-Tool-Crash-tp4346420p4346420.html;cid=1328739473560-306

For many LibO users, the Java-dependent components work with the
default settings. But if there is a problem, it is a good idea to
examine the configuration at Tools  Options  Java. The box for “Use
a Java runtime environment” should be checked. The section below that
shows the installed Java runtime environments (JRE) that were
detected, along with radio buttons to select the JRE to use. The Help
button provides documentation on this and the other Java configuration
options in LibO. After making a Java configuration change, you may
need to restart LibO before it takes effect.

-- 
For unsubscribe instructions e-mail to: users+h...@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: Problems importing an OO database into LO

[Tom Davies]

Hi :)
I almost hate to say it this late in the process but wouldn't a non-java 
back-end be better?  Java just seems to be a bit of a disaster these days, 
since Oracle took over.  Kexi uses Sqllite and there are surely other light 
back-ends that might be good to try?
Regards from
Tom :)


--- On Sat, 21/4/12, Ian Whitfield whitfi...@telkomsa.net wrote:

From: Ian Whitfield whitfi...@telkomsa.net
Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO
To: users@global.libreoffice.org
Date: Saturday, 21 April, 2012, 14:46

In addition to what I wrote a couple of hours back - I have just tried a couple 
of other things...

I linked the class path to the two files mentioned in the Error Box. LO 
accepted both of them OK AND popped-up a box warning me to re-start LO and then 
worked fine. BUT both are linked to the embedded engine!!

I tried again with the 2.2.8 version and noticed I DO NOT get the warning box 
to re-start LO. And it gives me the error box as reported.

I then moved a copy of the .jre file to the same location as the first two and 
tried again - no change!!

This leaves me wondering if the .jre file is at fault. It's new, (I downloaded 
it yesterday), and is 1.4Mb in size??

Does this sound like a problem??

-- For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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] calc compliance with openformula

[Jay Lozier]

On 04/21/2012 05:51 AM, Jean-Francois Nifenecker wrote:

Le 21/04/2012 10:24, e-letter a écrit :

On 20/04/2012, Regina Henschelrb.hensc...@t-online.de  wrote:

SUM( { NumberSequenceList N }+ )

e.g. SUM(a1+b2)


No. it would be SUM(a1;b2)



It would be better if calc returned an error, stating incorrect syntax



I'm afraid it is *not* incorrect syntax. Likewise, SUM(5) is correct 
syntax as well.



The question is general because a general understanding is required!
The example concerns only integers, e.g. where a1=1 and b2=2, the
results are correct, but the question is about learning the correct
syntax so that formula entered in a calc spreadsheet will not be lost
or corrupted when the spreadsheet is opened in another odf compliant
software, e.g. gnumeric. I don't want to use a sum syntax such as
(a1+b2), which gives the correct result, but if opened in another
program, the formula is lost or gives an incorrect answer.



All spreadsheet software I know of are accepting the syntax above. Of 
course, the syntax to use is preferably SUM(A1:A10), ie using a cell 
range rather than discrete cell references, but the latter can be 
useful (see 3. below).


So the following are all syntactically correct:

1. SUM(A1:A10)
- returns the sum of the numerical values within the range. 
Non-numeric values are ignored.


2. SUM(A1:A10;Z1:Z10)
- like 1, with multiple ranges.

3. SUM(A1;B2;Z15)
- returns the sum of several cells. Non-numeric values are ignored, 
opposite to what A1+B2+Z15 would return (see Regina's answer).


...and any combination of the previous.
I think the above syntax was developed for Lotus 123 in the early 
80's(?) and everyone else implemented the rules/syntax to be compatible 
with Lotus. By the mid 80's this syntax was standard for all spreadsheets.


The only real change from Lotus is that (using 1) is in Lotus formulas 
were enter +SUM(A1:A10) while the IMHO the more logical =SUM(A1:A10) was 
introduced later by the mid 80's.


HTH,



--
Jay Lozier
jsloz...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@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] calc compliance with openformula

[Jean-Francois Nifenecker]

Le 21/04/2012 17:48, Jay Lozier a écrit :

I think the above syntax was developed for Lotus 123 in the early
80's(?) and everyone else implemented the rules/syntax to be compatible
with Lotus. By the mid 80's this syntax was standard for all spreadsheets.

The only real change from Lotus is that (using 1) is in Lotus formulas
were enter +SUM(A1:A10) while the IMHO the more logical =SUM(A1:A10) was
introduced later by the mid 80's.


Thanks for the historical backgroud, Jay. Interesting to know.

--
Jean-Francois Nifenecker, Bordeaux

--
For unsubscribe instructions e-mail to: users+h...@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 importing an OO database into LO

[Mark Stanton]

 Copying the structure and data in one go, as offered by the import 
 wizard, never creates any auto-ID fields.

Would this be a sensible improvement to make?

Mark Stanton
One small step for mankind...



-- 
For unsubscribe instructions e-mail to: users+h...@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] Want code or name of the component in Writer of LibreOffice that does doc, xls, ppt conversions to pdf

[Tom Davies]

Hi :)
Ahhh, that does make sense now.  I hope Alex's answer was able to help
Apols and regards from
Tom :)


--- On Sat, 21/4/12, Ankit Jain ankit_1988ma...@yahoo.co.in wrote:

From: Ankit Jain ankit_1988ma...@yahoo.co.in
Subject: Re: [libreoffice-users] Want code or name of the component in Writer 
of LibreOffice that does doc, xls, ppt conversions to pdf
To: users@global.libreoffice.org, Tom Davies tomdavie...@yahoo.co.uk
Date: Saturday, 21 April, 2012, 10:36

Hi Tom/ All,

Thanks for your reply but as I said I want to make my own tool that does the 
file conversions-doc,xls or ppt to PDF format without installing either Libre 
Office or Portable Libre Office on my machine. So I want the component or the 
code or any name of the part of the source code of Libre Office that does this 
conversion utility.
I hope my question is clear now.

Can someone provide me any kind of help on this. Even if I get some web link 
that may help me then also it's fine.

Regards,
Ankit

--- On Fri, 20/4/12, Tom Davies tomdavie...@yahoo.co.uk wrote:

From: Tom Davies tomdavie...@yahoo.co.uk
Subject: Re: [libreoffice-users] Want code or name of the component in Writer 
of LibreOffice that does doc, xls, ppt conversions to pdf
To: users@global.libreoffice.org
Date: Friday, 20 April, 2012, 8:30 PM

Hi :)
You could use LibreOffice in headless mode, ie from a command-line without 
opening LibreOffice at all.  

Java is an increasingly vulnerable pile of mess with frequent updates in order 
to overcome known threats that are out in the wild even before a version of 
java gets released.  The last 3 versions, 7.0, 7.1 and 7.2 didn't even get 
released before work started on the next one due to known threats and other 
problems.  

The LibreOffice project is trying to write-out any dependance on java in order 
to avoid forcing people to install java.  
Regards from
Tom :)



--- On Fri, 20/4/12, Ankit Jain ankit_1988ma...@yahoo.co.in wrote:

From: Ankit Jain ankit_1988ma...@yahoo.co.in
Subject: [libreoffice-users] Want code or name of the component in Writer of 
LibreOffice that does doc, xls, ppt conversions to pdf
To: users@global.libreoffice.org
Date: Friday, 20 April, 2012, 11:23

   Hi All,

I just want to explore about the filter in writer component that does the doc 
or xls to pdf conversion.If someone can give me the part of code or the filter 
that does this conversion it would be very helpful to me.Also what are the 
libraries that are involved in conversion.
Please give me some link from where I can get the complete knowledge on this.

Basically I want to develop my own tool in Java which would convert any 
word,xls or ppt kind of document to pdf format without using the direct utility 
of LibreOffice that does this conversion.

Any help on this would be greatly appreciated.

Thanks in advance.
Ankit

-- 
For unsubscribe instructions e-mail to: users+h...@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

-- 
For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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: Problems importing an OO database into LO

[Andreas Säger]

Am 21.04.2012 18:58, Mark Stanton wrote:

Copying the structure and data in one go, as offered by the import
wizard, never creates any auto-ID fields.


Would this be a sensible improvement to make?

Mark Stanton
One small step for mankind...



Hello Mark,

Yes, it would be useful to have more import options that actually work 
when importing a pseudo-database (mostly spreadsheet lists) into a true 
database or into HSQLDB at least:

[X] Use first column as column name
[X] Create primary key [Name Box]
  [ ] Create primary key as auto-ID

And another exclusive  option:
[o] Use existing column list box as auto-ID
[ ] Use existing column(s) multi-select list box as primary key

When importing from a true database into another true database, these 
options should be preset according to the situation in the source table 
but still modifyable. Sometimes you want to import with no constraints 
at all.


My above statement

... never creates any auto-ID fields.


is not entirely correct. At least a copypaste between 2 HSQLDBs creates 
the integer PK as auto-ID. It creates an exact copy of the table. Some 
level of detection seems to be implemented already.
Copying from HSQLDB to H2 (a similar Java DB) does creates an integer PK 
but not as an auto-ID field.


I think it can be very hard to implement for all types of connectable 
database engines. There are UNO interfaces to detect the capabilities 
and idiosyncrasies of some database driver. May be this can be utilized, 
may be not.



--
For unsubscribe instructions e-mail to: users+h...@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] calc compliance with openformula

[MiguelAngel]

El 21/04/12 18:19, Jean-Francois Nifenecker escribió:

Le 21/04/2012 17:48, Jay Lozier a écrit :

I think the above syntax was developed for Lotus 123 in the early
80's(?) and everyone else implemented the rules/syntax to be compatible
with Lotus. By the mid 80's this syntax was standard for all
spreadsheets.

The only real change from Lotus is that (using 1) is in Lotus formulas
were enter +SUM(A1:A10) while the IMHO the more logical =SUM(A1:A10) was
introduced later by the mid 80's.


Thanks for the historical backgroud, Jay. Interesting to know.



I'm sorry but +SUM(A1:A10) doesn't work in 123, there is always needed @ 
to introduce functions in 123:

@SUM(A1:A10).

Miguel Ángel

 * Inglés - detectado
 * Inglés
 * Español
 * Gallego
 * Italiano

 * Inglés
 * Español
 * Gallego
 * Italiano

 javascript:void(0);

--
For unsubscribe instructions e-mail to: users+h...@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: [3.5.1.2/Calc/XP] Keep unique rows?

[Gilles]

Thanks Regina, but after filling the form thusly...

http://img692.imageshack.us/img692/3632/libreofficecalcremovingo.jpg

... nothing happens: Did I do something wrong?

--
View this message in context: 
http://nabble.documentfoundation.org/3-5-1-2-Calc-XP-Keep-unique-rows-tp3926479p3929010.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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: [3.5.1.2/Calc/XP] Keep unique rows?

[Regina Henschel]

Hi Gilles,

Gilles schrieb:

Thanks Regina, but after filling the form thusly...

http://img692.imageshack.us/img692/3632/libreofficecalcremovingo.jpg

... nothing happens: Did I do something wrong?


Try to chose a cell on a different sheet for the output. You can 
minimize the dialog by the button next to the input field to click on 
the target cell. Select all data. It will drop those rows, which are 
totally identical.


Or

If you do not want to copy the data, then uncheck Copy results to. 
Select only those columns which you want as criteria for double. The 
double rows are hidden. Hiding effects the whole row.


In the drop-down list of 'value' chose the item - not empty -.

Kind regards
Regina

--
For unsubscribe instructions e-mail to: users+h...@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] LibreOffice losing position between sessions - solved!

[Libre User]

Could be.  Being basically lazy, I only put a first name into the 
form.  When I edit fiction, hovering the cursor over any of my edits 
shows a tag with either Inserted: Jerry - Date and Time or 
Deleted: Jerry - Date and Time.  I just tested it by adding my last 
name to the form.  Edits done after the change show a complete name 
along with date and time. Obviously without any info in the form, the 
editing function wouldn't function correctly.


Jerry


At 07:47 AM 4/19/2012, you wrote:
Actually, Tom, it is probably so that different positions can be 
saved for different users who may be editing the same file (no way 
to tell different users apart if they haven't personalized it)...


On 2012-04-19 7:21 AM, Ron House rho...@smartchat.net.au wrote:

Thanks Tom and Jerry, it works like a charm!

Cheers
Ron

On 15/04/12 16:58, Tom Davies wrote:

Hi :)
I think it's an accident rather than a deliberate design choice.
Otherwise they would probably have put a tick-box in options somewhere
i guess. The work-around works though.
Regards from
Tom :)


--- On Sun, 15/4/12, Libre Userlibreu...@earthlink.net wrote:

From: Libre Userlibreu...@earthlink.net
Subject: Re: [libreoffice-users] LibreOffice losing position between
sessions
To: users@global.libreoffice.org
Date: Sunday, 15 April, 2012, 5:49

You need to have entered some information in the User Data section
under ToolsOptionsLibreOfficeUser Data. Only a first name is
sufficient but the form can not be completely blank.

Also check the box labeled Enable experimental (unstable) features
under ToolsOptionsLibreOfficeGeneral

Jerry

At 06:45 PM 4/14/2012, you wrote:

In openoffice, if I saved a document, when I next opened it, the
cursor was automatically positioned where it was when I left off.
This doesn't seem to be happening in libreoffice, as the cursor is
always at the top of the document, meaning one has to remember some
other way where I was up to. I can't find any option to turn this
invaluable feature back on.

Is this a design decision, an oversight, or am I missing an option
somewhere?

Cheers,
Ron




--
For unsubscribe instructions e-mail to: users+h...@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


--
For unsubscribe instructions e-mail to: users+h...@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