[libreoffice-users] Re: Suggestions for LibreOffice

2012-01-18 Thread Pedro
Hi Help_Please

Welcome to the LibreOffice Users mailing list ;)


Help_Please wrote
> 
> Suggestion One:Include "Check for updates"  to perform online checking
> for updates to LibreOffice. At present, it appears that the only way to
> find out if there are any updates is by receiving an email; or maybe by a
> third-party application ... such as SUMo.
> 

Too late :) It's already done. It will be included in the upcoming version
3.5.0 (or you can try it in 3.5.0 Beta3
http://www.libreoffice.org/download/pre-releases/ if you don't mind
experimental builds)
BTW SUMo is good but it is a Windows only solution. LibreOffice is multi or
cross-platform ;)


Help_Please wrote
> 
> Suggestion Two:   I would like to see a "navigation" tool (short-cut) or
> whatever you call it/them, that when used will send the user to the end of
> any type document or form and to the end of the last line, data, etc.  At
> present, I have not found any such "tool" to do this.  I have to manually
> scroll down to the end of the document in order to add more data to a
> document.  This can be very time consuming particularly if there is a
> large amount of data.  This navigation tool needs to be available for all
> types of documents, forms, data sheets, whatever.
> 

Ctrl+End does this. And Ctrl+Home does the reverse (jump to the beginning.
This works in most (all?) OSes and applications.

Now that Wikipedia is back from the courageous SOPA/PIPA blackout see Text
Editing in
http://en.wikipedia.org/wiki/Table_of_keyboard_shortcuts

Enjoy LibreOffice ;)

--
View this message in context: 
http://nabble.documentfoundation.org/Suggestions-for-LibreOffice-tp3671431p3671570.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] Question about Writer - pages and page count.

2012-01-18 Thread Jay Lozier

On 01/18/2012 05:30 PM, Sylvia Schmidt wrote:

Okay, I found a way that works for me:
I'll use a single side layout, make a pdf from it and then I'll create 
a pdf with only blank pages, merge these two pdfs and rearrange the 
pages - page1 of pdf1 followed by page1 of pdf2. Or something along 
those lines - I found a few pdf-editing-tools that have some great 
capabilities.


It probably isn't an elegant solution but it works.

Thank you all for your input!

Glad we could help.


---
To Miroslaw:

Well, Germany isn't the land of milk and honey.

I'm getting my master's degree at a rather small university 
(Fachhochschule) in a very rural area because here there are only up 
to 15 people in one course - sometimes as little as fife people. At 
the bigger universities you have more than one copyshop (which is what 
we've got here and it doesn't bind books) and usually a few 'full' 
printing companies nearby.


But we have computer pools which we can access 24/7 where InDesign 
(and the rest of the Adobe Suite) is available. And I could send a DOC 
but I don't like having almost no say on how the final print looks. (I 
do not know how that would impact the price).


On 18.01.2012 16:36, Mirosław Zalewski wrote:

On 18/01/2012 at 11:52, Sylvia Schmidt  wrote:


There aren't that
many companies around here that will print and bind books as hardcovers
with only three copies. If the company wasn't recommended by my
university I probably would have chosen a different one.

On the side of main topic:
I find it quite surprising. If that printing company is recommended 
by your

university, perhaps there is some kind of agreement between company and
university, and perhaps many students print their thesis in that 
printing
company. And yet they are unprepared for continuously numbered PDFs 
that have
to be printed one-sided? I doubt that MS Word makes solving your task 
any

easier than LO Writer.

Or maybe most students send .doc file to printing company? But that 
should be

more expensive, since additional editorial work has to be done (beside
printing).

Or maybe most students prepare their thesis in Adobe InDesign (which, 
as you
say, is capable of solving your task)? I find it quite hard to 
belive, since
InDesign is really expensive software. But maybe your university has 
special
agreement with Adobe that students can download and use InDesign for 
free?


Going further with offtopic, in Poland there are many small printing 
companies
in close neighborhood of each university building. These companies 
usually
have few photocopiers, few printers and one or two computers. You can 
print
and bind your thesis in almost every of these companies, although 
only in
preset hard cover (they usually say "Master thesis" or something 
similar on
front cover and they look like [1]). So, if you would like to have 
your name
or title of your thesis on your cover, it would be harder and more 
expensive.


Here in Poland we are used to believe that Germany is land of milk 
and honey.
I find it surprising that - at least in that area - in Poland we are 
apparently
in better position than you are. Having so many printing companies 
around, no
one would care about inserting real blank pages into documents - they 
would
just go to another company, the one that has no such prerequirements 
about

documents.

[1] http://www.origo.poznan.pl/Graphics/products_76ba860c-6c47-4210-
b5ad-28198cf33cb2_1.jpg
(short link: http://bit.ly/A56Nqh )

Sorry about offtopic, I just wanted to share some of my thoughts :) .






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


[libreoffice-users] Question about Calc and Annotations

2012-01-18 Thread alex sato
Is it normal Calc to freeze some minutes when resizing the width of a
column in a blank sheet that only has a column filled with 18000 cells with
annotation??
Nothing abnormal happens here when the sheet has 18000 cell with normal
data instead annotation.
Just opening the file take long time too here.

By the way, there is no slow down or freezing when using it in MS Office
2010 (file saved in ODS format, not XLS).

I did a macro to insert annotations in 18000 cells for test purpose.

Sub Add18KAnnotations
dim p as integer
p=0
dim m(3) as string
m(0)="ABCDEFGHIJKLMNOPQRSTUVWXYZ"
m(1)="0123456789 0123456789"
m(2)="abcdefghijklmnopqrstuvwxyz"
m(3)="0123456789 0123456789"
dim s as object
dim n as object
dim y as integer
dim c as object
dim a as object
s = thisComponent.sheets(0)
n = s.getAnnotations()
for y=0 to 18000
   c=s.getCellByPosition(2,y)
   a=c.CellAddress
   n.insertNew(a,"-""m(p))
   p=p+1
   if p=4 then p=0
next y
End Sub


Thanks

Alex Mitsio Sato

-- 
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: Impress: Import text from file dynamically

2012-01-18 Thread Calvin Kim
Try this link. It's an old post but it seems working with Windows 
version of OO.o.

Although, I can't verify it as I'm using LO version 3.4.4 with Ubuntu.

http://www.oooforum.org/forum/viewtopic.phtml?t=38643

cK


--
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: Batch for extracting lines into new files in CALC

2012-01-18 Thread Calvin Kim


On 01/18/2012 03:08 PM, Andreas Säger wrote:

Am 18.01.2012 18:13, Andreas Säger wrote:


Connect a registered Base document to the spreadsheet. A connection to
an indexed dBase copy might be more performant.
Create a parameter query: SELECT * FROM "Table" WHERE "Column"= :p


Use the parameter query for testing if you get the wanted records for 
a given number :p.
Store the following Basic code somewhere in the global library 
container (aka "My Macros").
Modify the 6 constants on top of the code. Registered name of the 
database, table name, column name, first ID to substitute, last ID to 
substitute and the target path.
The code works without further modifications but with any type of 
database such as address books, csv, spreadsheets, dBase, MySQL, 
HSQLDB, MS Access, MS servers, Oracle servers, anything connectable 
with a Base document.



Sub Import2xls
Const cDataSource = "Chargen"
Const cTableName = "MAT"
Const cColumnName ="ID"
Const cStartID = 405
Const cEndID = 407
Const cPath = "/tmp/"

Dim addr as new com.sun.star.table.CellRangeAddress
sQuery = "SELECT * FROM """& cTableName &"""WHERE """& cColumnName 
&"""="

' print squery
Dim xlsprop as new com.sun.star.beans.PropertyValue
xlsprop.Name = "FilterName"
xlsprop.Value = "MS Excel 97"

for i = cStartID to cEndID
doc = 
StarDesktop.loadComponentFromURL("private:factory/scalc","_blank", 0, 
Array() )

dbx = doc.DatabaseRanges
dbx.addNewByName("Import2xls", addr)
dbr = dbx.getByName("Import2xls")
dsc() = dbr.getImportDescriptor()
for each prop in dsc()
if prop.Name = "SourceType" then prop.Value = 
com.sun.star.sheet.DataImportMode.SQL

if prop.Name = "SourceObject" then prop.Value = sQuery & i
if prop.Name = "DatabaseName" then prop.Value = cDataSource
next
dbr.ReferredCells.doImport(dsc())
doc.storeAsURL(convertToURL(cPath & format(i, 
String(len(cEndID),"0")) &".xls"), Array(xlsprop))

doc.close(True)
next
End Sub





Nice. Thank you for the tip. I shall remember it for next round.
Keep the good 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



Re: [libreoffice-users] Question about Writer - pages and page count.

2012-01-18 Thread Tom Davies
Hi :)
I guess that does explain why some books have Chapter headings taking up a 
complete page on their own with the back of that page empty and the contents of 
the chapter appearing on the next facing page.  Rather than just having all the 
empty pages at the end they space the chapters out to gain gravitas.  
Regards from
Tom :)

--- On Wed, 18/1/12, Sylvia Schmidt  wrote:

From: Sylvia Schmidt 
Subject: Re: [libreoffice-users] Question about Writer - pages and page count.
To: users@global.libreoffice.org
Date: Wednesday, 18 January, 2012, 22:30

Okay, I found a way that works for me:
I'll use a single side layout, make a pdf from it and then I'll create a pdf 
with only blank pages, merge these two pdfs and rearrange the pages - page1 of 
pdf1 followed by page1 of pdf2. Or something along those lines - I found a few 
pdf-editing-tools that have some great capabilities.

It probably isn't an elegant solution but it works.

Thank you all for your input!

---
To Miroslaw:

Well, Germany isn't the land of milk and honey.

I'm getting my master's degree at a rather small university (Fachhochschule) in 
a very rural area because here there are only up to 15 people in one course - 
sometimes as little as fife people. At the bigger universities you have more 
than one copyshop (which is what we've got here and it doesn't bind books) and 
usually a few 'full' printing companies nearby.

But we have computer pools which we can access 24/7 where InDesign (and the 
rest of the Adobe Suite) is available. And I could send a DOC but I don't like 
having almost no say on how the final print looks. (I do not know how that 
would impact the price).

On 18.01.2012 16:36, Mirosław Zalewski wrote:
> On 18/01/2012 at 11:52, Sylvia Schmidt  wrote:
> 
>> There aren't that
>> many companies around here that will print and bind books as hardcovers
>> with only three copies. If the company wasn't recommended by my
>> university I probably would have chosen a different one.
> On the side of main topic:
> I find it quite surprising. If that printing company is recommended by your
> university, perhaps there is some kind of agreement between company and
> university, and perhaps many students print their thesis in that printing
> company. And yet they are unprepared for continuously numbered PDFs that have
> to be printed one-sided? I doubt that MS Word makes solving your task any
> easier than LO Writer.
> 
> Or maybe most students send .doc file to printing company? But that should be
> more expensive, since additional editorial work has to be done (beside
> printing).
> 
> Or maybe most students prepare their thesis in Adobe InDesign (which, as you
> say, is capable of solving your task)? I find it quite hard to belive, since
> InDesign is really expensive software. But maybe your university has special
> agreement with Adobe that students can download and use InDesign for free?
> 
> Going further with offtopic, in Poland there are many small printing companies
> in close neighborhood of each university building. These companies usually
> have few photocopiers, few printers and one or two computers. You can print
> and bind your thesis in almost every of these companies, although only in
> preset hard cover (they usually say "Master thesis" or something similar on
> front cover and they look like [1]). So, if you would like to have your name
> or title of your thesis on your cover, it would be harder and more expensive.
> 
> Here in Poland we are used to believe that Germany is land of milk and honey.
> I find it surprising that - at least in that area - in Poland we are 
> apparently
> in better position than you are. Having so many printing companies around, no
> one would care about inserting real blank pages into documents - they would
> just go to another company, the one that has no such prerequirements about
> documents.
> 
> [1] http://www.origo.poznan.pl/Graphics/products_76ba860c-6c47-4210-
> b5ad-28198cf33cb2_1.jpg
> (short link: http://bit.ly/A56Nqh )
> 
> Sorry about offtopic, I just wanted to share some of my thoughts :) .


-- 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] Question about Writer - pages and page count.

2012-01-18 Thread Tom Davies
Hi :)
In England we have a saying 
"The grass is always greener on the other side" 
as it's usually easier to spot the flaws in whatever is closest to you.  It's 
not always true of course.  I think it goes well with the idea that before 
criticising someone you should "walk a mile in their shoes".  
Regards from
Tom :)


--- On Wed, 18/1/12, Sylvia Schmidt  wrote:

From: Sylvia Schmidt 
Subject: Re: [libreoffice-users] Question about Writer - pages and page count.
To: users@global.libreoffice.org
Date: Wednesday, 18 January, 2012, 22:30

Okay, I found a way that works for me:
I'll use a single side layout, make a pdf from it and then I'll create a pdf 
with only blank pages, merge these two pdfs and rearrange the pages - page1 of 
pdf1 followed by page1 of pdf2. Or something along those lines - I found a few 
pdf-editing-tools that have some great capabilities.

It probably isn't an elegant solution but it works.

Thank you all for your input!

---
To Miroslaw:

Well, Germany isn't the land of milk and honey.

I'm getting my master's degree at a rather small university (Fachhochschule) in 
a very rural area because here there are only up to 15 people in one course - 
sometimes as little as fife people. At the bigger universities you have more 
than one copyshop (which is what we've got here and it doesn't bind books) and 
usually a few 'full' printing companies nearby.

But we have computer pools which we can access 24/7 where InDesign (and the 
rest of the Adobe Suite) is available. And I could send a DOC but I don't like 
having almost no say on how the final print looks. (I do not know how that 
would impact the price).

On 18.01.2012 16:36, Mirosław Zalewski wrote:
> On 18/01/2012 at 11:52, Sylvia Schmidt  wrote:
> 
>> There aren't that
>> many companies around here that will print and bind books as hardcovers
>> with only three copies. If the company wasn't recommended by my
>> university I probably would have chosen a different one.
> On the side of main topic:
> I find it quite surprising. If that printing company is recommended by your
> university, perhaps there is some kind of agreement between company and
> university, and perhaps many students print their thesis in that printing
> company. And yet they are unprepared for continuously numbered PDFs that have
> to be printed one-sided? I doubt that MS Word makes solving your task any
> easier than LO Writer.
> 
> Or maybe most students send .doc file to printing company? But that should be
> more expensive, since additional editorial work has to be done (beside
> printing).
> 
> Or maybe most students prepare their thesis in Adobe InDesign (which, as you
> say, is capable of solving your task)? I find it quite hard to belive, since
> InDesign is really expensive software. But maybe your university has special
> agreement with Adobe that students can download and use InDesign for free?
> 
> Going further with offtopic, in Poland there are many small printing companies
> in close neighborhood of each university building. These companies usually
> have few photocopiers, few printers and one or two computers. You can print
> and bind your thesis in almost every of these companies, although only in
> preset hard cover (they usually say "Master thesis" or something similar on
> front cover and they look like [1]). So, if you would like to have your name
> or title of your thesis on your cover, it would be harder and more expensive.
> 
> Here in Poland we are used to believe that Germany is land of milk and honey.
> I find it surprising that - at least in that area - in Poland we are 
> apparently
> in better position than you are. Having so many printing companies around, no
> one would care about inserting real blank pages into documents - they would
> just go to another company, the one that has no such prerequirements about
> documents.
> 
> [1] http://www.origo.poznan.pl/Graphics/products_76ba860c-6c47-4210-
> b5ad-28198cf33cb2_1.jpg
> (short link: http://bit.ly/A56Nqh )
> 
> Sorry about offtopic, I just wanted to share some of my thoughts :) .


-- 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] Question about Writer - pages and page count.

2012-01-18 Thread Tom Davies
Hi :)
So they are printing to A3 rather than A4.  Those numbers are rather familiar!  
16, 32, 64.  They turn up all over the place :)
Regards from
Tom :)

--- On Wed, 18/1/12, webmaster for Kracked Press Productions 
 wrote:

From: webmaster for Kracked Press Productions 
Subject: Re: [libreoffice-users] Question about Writer - pages and page count.
To: users@global.libreoffice.org
Date: Wednesday, 18 January, 2012, 21:44

On 01/18/2012 05:52 AM, Sylvia Schmidt wrote:
> Okay, from the top: Yes, I'm using linux -> Ubuntu 11.10.
> 
> I've talked to the printing company and they said it should be "real" blank 
> pages as the backs. I do not know why exactly, it has something to do with 
> the binding and the 4 pages printout used. (There aren't that many companies 
> around here that will print and bind books as hardcovers with only three 
> copies. If the company wasn't recommended by my university I probably would 
> have chosen a different one.)
> 
> I even know how to get that using Indesign, but Indesign is a real pain as a 
> 'writing tool'. So I thought I'd try something else... I didn't even think of 
> changing the finished pdf, but that's a great idea! I'll look into your 
> suggestions. Thank you for that.
> 
> 

They print a 4 pages on each side of the sheet of paper and use the equipment 
to fold, cut, and bind them to make the physical document/book/etc.  Modern 
hardcover novels, using the large print companies, end up printing 16 pages per 
side of a sheet-block on a web-press.  Then these sheets are printed on each 
side [32 page faces at a time] then take these folded groups and have a machine 
merge each 32-page group together to make the 400 - 1000 page hardcover, and 
even mass-paperback books.  This is a standard printing method, instead of 
printing a single 2 sided page at a time.  It is easier to bind the 32-page 
group than the single double-sided pages as well.  Easier for printing and cost 
less in the long run.

That is why the blank pages; to fill the rest of the large size, multi-page, 
sheets.  They want the author to do this, not their people.  They do not want 
to edit your PDF file.  Print-on-demand companies, like Lulu.com are do the 
same, but to a lesser degree.



-- 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] Question about Writer - pages and page count.

2012-01-18 Thread Sylvia Schmidt

Okay, I found a way that works for me:
I'll use a single side layout, make a pdf from it and then I'll create a 
pdf with only blank pages, merge these two pdfs and rearrange the pages 
- page1 of pdf1 followed by page1 of pdf2. Or something along those 
lines - I found a few pdf-editing-tools that have some great capabilities.


It probably isn't an elegant solution but it works.

Thank you all for your input!

---
To Miroslaw:

Well, Germany isn't the land of milk and honey.

I'm getting my master's degree at a rather small university 
(Fachhochschule) in a very rural area because here there are only up to 
15 people in one course - sometimes as little as fife people. At the 
bigger universities you have more than one copyshop (which is what we've 
got here and it doesn't bind books) and usually a few 'full' printing 
companies nearby.


But we have computer pools which we can access 24/7 where InDesign (and 
the rest of the Adobe Suite) is available. And I could send a DOC but I 
don't like having almost no say on how the final print looks. (I do not 
know how that would impact the price).


On 18.01.2012 16:36, Mirosław Zalewski wrote:

On 18/01/2012 at 11:52, Sylvia Schmidt  wrote:


There aren't that
many companies around here that will print and bind books as hardcovers
with only three copies. If the company wasn't recommended by my
university I probably would have chosen a different one.

On the side of main topic:
I find it quite surprising. If that printing company is recommended by your
university, perhaps there is some kind of agreement between company and
university, and perhaps many students print their thesis in that printing
company. And yet they are unprepared for continuously numbered PDFs that have
to be printed one-sided? I doubt that MS Word makes solving your task any
easier than LO Writer.

Or maybe most students send .doc file to printing company? But that should be
more expensive, since additional editorial work has to be done (beside
printing).

Or maybe most students prepare their thesis in Adobe InDesign (which, as you
say, is capable of solving your task)? I find it quite hard to belive, since
InDesign is really expensive software. But maybe your university has special
agreement with Adobe that students can download and use InDesign for free?

Going further with offtopic, in Poland there are many small printing companies
in close neighborhood of each university building. These companies usually
have few photocopiers, few printers and one or two computers. You can print
and bind your thesis in almost every of these companies, although only in
preset hard cover (they usually say "Master thesis" or something similar on
front cover and they look like [1]). So, if you would like to have your name
or title of your thesis on your cover, it would be harder and more expensive.

Here in Poland we are used to believe that Germany is land of milk and honey.
I find it surprising that - at least in that area - in Poland we are apparently
in better position than you are. Having so many printing companies around, no
one would care about inserting real blank pages into documents - they would
just go to another company, the one that has no such prerequirements about
documents.

[1] http://www.origo.poznan.pl/Graphics/products_76ba860c-6c47-4210-
b5ad-28198cf33cb2_1.jpg
(short link: http://bit.ly/A56Nqh )

Sorry about offtopic, I just wanted to share some of my thoughts :) .



--
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] So what's with LibO 3.5?

2012-01-18 Thread Fabian Rodriguez

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 12-01-11 03:53 AM, Onyeibo Oku wrote:
> Greetings
>
> I've been seeing libO 3.5 on this list and I'm now curious. What is in
this 3.5 that should make me peep? What changed and what does the user
stand to benefit from the changes?
>
> I like bleeding edge, there's got to be a good excuse to dive in first.
Can someone enlighten me? I use 3.4.4 at the moment.
> -
> from twohot@device.mobile :)
>

In Windows and Mac versions, there the update/notification mechanism is
back. I know a few friends & colleagues that use Windows / Mac who will
appreciate this :)

F.



- -- 
- --
Fabián Rodríguez
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: PGP/Mime available upon request
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk8XRb0ACgkQfUcTXFrypNVNgwCgjkcnzNQOTcvY54A24RhpnePd
YA4AoID7eBVILrFAgkcFRBa9s/USs2MA
=BC5X
-END PGP SIGNATURE-


-- 
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] Question about Writer - pages and page count.

2012-01-18 Thread webmaster for Kracked Press Productions

On 01/18/2012 05:52 AM, Sylvia Schmidt wrote:

Okay, from the top: Yes, I'm using linux -> Ubuntu 11.10.

I've talked to the printing company and they said it should be "real" 
blank pages as the backs. I do not know why exactly, it has something 
to do with the binding and the 4 pages printout used. (There aren't 
that many companies around here that will print and bind books as 
hardcovers with only three copies. If the company wasn't recommended 
by my university I probably would have chosen a different one.)


I even know how to get that using Indesign, but Indesign is a real 
pain as a 'writing tool'. So I thought I'd try something else... I 
didn't even think of changing the finished pdf, but that's a great 
idea! I'll look into your suggestions. Thank you for that.





They print a 4 pages on each side of the sheet of paper and use the 
equipment to fold, cut, and bind them to make the physical 
document/book/etc.  Modern hardcover novels, using the large print 
companies, end up printing 16 pages per side of a sheet-block on a 
web-press.  Then these sheets are printed on each side [32 page faces at 
a time] then take these folded groups and have a machine merge each 
32-page group together to make the 400 - 1000 page hardcover, and even 
mass-paperback books.  This is a standard printing method, instead of 
printing a single 2 sided page at a time.  It is easier to bind the 
32-page group than the single double-sided pages as well.  Easier for 
printing and cost less in the long run.


That is why the blank pages; to fill the rest of the large size, 
multi-page, sheets.  They want the author to do this, not their people.  
They do not want to edit your PDF file.  Print-on-demand companies, like 
Lulu.com are do the same, but to a lesser degree.




--
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] Question about Writer - pages and page count.

2012-01-18 Thread webmaster for Kracked Press Productions


Was the original question involving a professional service that would 
print many copies of the document and do a professional binding?  If so, 
then printing on your own printer is not an option here.


I would not want to print out 20 copies of a 300 page document [150 
sheets of paper each] on my laser printer, which is no a duplex 
printer.  I would not print out a single copy on my duplex inkjet 
printer either.


It is all about the scale of the print job and the professional looking 
binding.  That is what seems to me the issue here.  The person needs the 
blank pages at the end of his document to fit the needs of his 
Professional Printing Service.  He is not going to do the printing at 
home, where he can just add unprinted sheets to the stack of paper 
coming off his printer.


Sure, there are a lot of printers that can do two-sided printing or 
odd/even printing, but that was not the issue here.  I bought a duplex 
inkjet to save money on paper.  I would like a duplex laser printer as 
well.  But I would never use my printers to do a production run for 
large page count documents.  I would use a print-on-demand service or a 
local printing service for those "production runs".


Would you want to print off 500 double sided brochures for a LO table at 
a show yourself?  Or would you try to get a deal at a printer's place.  
Just folding them to be a tri-fold brochure, with paper creased already 
at the folding lines, is too much for me to think about.


It all comes down to the scale of printing and how professional the 
folding/binding/covers are to be.


He is needing the professional look, in my opinion, and needs the final 
PDF file to have the extra blank pages at the end of the document.  That 
was the issue, and that is what we needed to give an answer to.


Is there a way to Export-to-PDF or print-to-PDF using internal document 
controls to create the blank pages with no header or footers?  If not 
then he will have to use some external PDF editing software to "insert" 
blank pages at the end of the document.  Hopefully someone knows how to 
add/remove/change the header and footer text after a certain point in 
the document.  I remember using some word processor many years ago that 
allowed that.  Just go to page 55 and edit the footer showing on that 
page and it will be the original one on pages 1 thru 49 and the new one 
on 50 thru the next change or the end of the document.  If that type of 
thing has been removed due to document file format issues, then it needs 
to be put back in.


So does any one know how to change the footer to a different text option 
after 50 pages or so and keep the original footer for the first 50 
pages?  He needs this for the creation of a PDF file, not a paper 
version. That is the question here, and not if/how a printer can print 
his document by some two sided printing method.


On 01/18/2012 05:30 AM, Tom Davies wrote:

Hi :)
True :))  You have to do a quick test run with 1 or 2 pages just to make sure which way you have to put the paper back in just in case your printer is weird.  Also make sure that no-one else prints to 'your' printer when you are doing the "even" pages.  I have been in quite a few offices where people would delight in saving-up their print-jobs until someone tried doing something like this purely in order to create confusion and make a fuss. 
Regards from

Tom :)


--- On Wed, 18/1/12, Ian Whitfield  wrote:

From: Ian Whitfield
Subject: Re: [libreoffice-users] Question about Writer - pages and page count.
To: users@global.libreoffice.org
Date: Wednesday, 18 January, 2012, 9:49

On 01/17/2012 06:20 PM, Sylvia Schmidt wrote:

True two-sided printing requires a more expensive printer because the

paper feed is more complex. In the US the only two-sided "printers" I
have seen are larger office copier/printer combinations; most of the
desktop printers print one-sided.

Many people do not have a printer capable of true two-sided printing
because most home and office printers are designed for one-sided
printing. They print one sheet straight through and can not reverse feed
to print automatically on the reverse side. The paper feed is much
simpler, hence less expensive and should be more reliable.

Being an "ex-Printer man" for one of the large Printer Manufactures I have to 
point out the following, (which over the years I have found very few users know about).

You do _NOT_ need a more expensive Duplex Printer to produce Double-sided 
printouts!! Almost all print routines have the option to control what prints 
out in any print job. So ..

First set-up your print job to print 'Odd pages only';
Take these pages, turn them over and put them back into the paper tray;
Now set-up the print job to print 'Even pages only'.

And there you have it - A Double-sided printout from a single page printer!! 
Easy.

Ian Whitfield
Pretoria.

-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice

[libreoffice-users] Re: Batch for extracting lines into new files in CALC

2012-01-18 Thread Andreas Säger

Am 18.01.2012 18:13, Andreas Säger wrote:


Connect a registered Base document to the spreadsheet. A connection to
an indexed dBase copy might be more performant.
Create a parameter query: SELECT * FROM "Table" WHERE "Column"= :p


Use the parameter query for testing if you get the wanted records for a 
given number :p.
Store the following Basic code somewhere in the global library container 
(aka "My Macros").
Modify the 6 constants on top of the code. Registered name of the 
database, table name, column name, first ID to substitute, last ID to 
substitute and the target path.
The code works without further modifications but with any type of 
database such as address books, csv, spreadsheets, dBase, MySQL, HSQLDB, 
MS Access, MS servers, Oracle servers, anything connectable with a Base 
document.



Sub Import2xls
Const cDataSource = "Chargen"
Const cTableName = "MAT"
Const cColumnName ="ID"
Const cStartID = 405
Const cEndID = 407
Const cPath = "/tmp/"

Dim addr as new com.sun.star.table.CellRangeAddress
sQuery = "SELECT * FROM """& cTableName &"""WHERE """& cColumnName &"""="
' print squery
Dim xlsprop as new com.sun.star.beans.PropertyValue
xlsprop.Name = "FilterName"
xlsprop.Value = "MS Excel 97"

for i = cStartID to cEndID
doc = 
StarDesktop.loadComponentFromURL("private:factory/scalc","_blank", 0, Array() )
dbx = doc.DatabaseRanges
dbx.addNewByName("Import2xls", addr)
dbr = dbx.getByName("Import2xls")
dsc() = dbr.getImportDescriptor()
for each prop in dsc()
if prop.Name = "SourceType" then prop.Value = 
com.sun.star.sheet.DataImportMode.SQL
if prop.Name = "SourceObject" then prop.Value = sQuery & i
if prop.Name = "DatabaseName" then prop.Value = cDataSource
next
dbr.ReferredCells.doImport(dsc())
doc.storeAsURL(convertToURL(cPath & format(i, String(len(cEndID),"0")) 
&".xls"), Array(xlsprop))
doc.close(True)
next
End Sub




--
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: Best JRE for LibreOffice on a 64-bit system: 32 or 64 bit ?

2012-01-18 Thread NoOp
On 01/18/2012 05:54 AM, Andreas Säger wrote:
> Am 11.01.2012 20:08, Tanstaafl wrote:
>>
>> It is simply unwise to keep old/exploitable version of java on any system.
>>
> 
> There is no technical reason to do so on a Windows system. Under Linux 
> there may be a tiny fraction of users like me who face a certain 
> performance problem in Base.

Updates are typically multi-OS. Example:


Scroll down to the 'Appendix - Oracle Java SE' and read:

CVSS scores below assume that a user running a Java applet or Java Web
Start application has administrator privileges (typical on Windows).
Where the user does not run with administrator privileges (typical on
Solaris and Linux), the corresponding CVSS impact scores for
Confidentiality, Integrity, and Availability are "Partial" instead of
"Complete", and the corresponding CVSS Base score is 7.5 instead of 10
respectively.


Ditto for the October 2011 updates:


And:
http://java.com/en/download/faq/remove_olderversions.xml

Should I remove older versions of Java?
We highly recommend users remove all older versions of Java from your
system.
Keeping old and unsupported versions of Java on your system presents a
serious security risk.
Removing older versions of Java from your system ensures that Java
applications will run with the most up-to-date security and performance
improvements on your system.


Regarding performance issues, from the same web page:

Do I need older versions of Java?
The latest available version is always compatible with the older
versions. However, some Java applications (or applets) can indicate that
they are dependent on a particular version, and may not run if you do
not have that version installed. If an application or web page you
access requires an older version of Java, you should report this to the
provider/developer and request that they update the application to be
compatible with all Java versions.


So... run older versions at *your* own risk. Just please do not advise
others to do the same without sufficent warnings.







-- 
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: Impress: Import text from file dynamically

2012-01-18 Thread bullettoothtobi
The presentation should show data from our solar panels.
I think it's OK, if this data is updated once a day with every start of the
presentation.

But it would be great if automatic updates during a presentation work in
future.

Thanks for your replies!
Tobias

--
View this message in context: 
http://nabble.documentfoundation.org/Impress-Import-text-from-file-dynamically-tp3656915p3669451.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] Question about Writer - pages and page count.

2012-01-18 Thread Calvin Kim
Do not use left or right page style. They are only good when you print 
double side. They are used to differentiate odd/even pages. And if you 
use only 'right page' style, LO will insert a blank page after every 
left/right pages. And you don't want that.
For single side printing, use 'default' page style with 'First Page' 
style as optional.

cK


On 01/17/2012 05:55 PM, Sylvia Schmidt wrote:

Hey,

I'm trying to create a layout for my thesis in Writer. I know how to 
work (reasonably well) with page/paragraph styles.


My problem is this: I have to hand in my thesis with only one side of 
the page printed, the back has to be blank.


I thought I cloud cheat by only using right page styles, because Libre 
inserts a blank page when two even or odd page follow one another. But 
these blank pages change my page count. It is true that I actually 
have more pages than the written ones but it shouldn't show in my page 
number.


I tried correcting the page number - but I can't figure out how. With 
each new page the number of blank pages increases - so the fifth page 
should have the page number 3 (3 written pages plus two blank ones) 
while the ninth page should have the page number 5 (5 written pages 
plus 4 blanks).


Is there an easier way to accomplish my goal? Or does anybody have an 
idea how I can correct my page number/count?


Any hints would be appreciated! Thank you for your time!

Regards
Sylvia





--
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] Installing LO 3.4.5

2012-01-18 Thread Maurice Batey
Within a bug report I have been asked to install & try LO 3.4.5, which
I have already downloaded (+ GB-lang & help packs).

Has the install procedure changed since the following details kindly
provided for installing 3.3?:  


"Installation instructions for Mandriva are:
===
Install process:
Intallation (based on a KDE desktop Mandriva 2010.1)
===
BEFORE STARTING, UNINSTALL ALL PREVIOUS VERSIONS OF LIBREOFFICE
WITH THROUGH THE MCC AND THEN QUIT THE MCC

1. Download LibreOffice from http://www.documentfoundation.org to
your  "downloads" folder into a folder called "LibreOffice"
2. Open Dolphin
3. Browse to the "LibreOffice" folder in the "downloads" folder
4. Right-click on the LibreOffice file and choose extract archive
here
5. Once extracted double-click on folder "en-Us" and then "RPMS"
and then "desktop-integration"
6. In Dolphin do F3 (this will split screen your window)
7. Click in the right window once and click on the "UP" arrow in
 the main menu bar up-above in Dolphin
8. You will now have the left window "desktop-integration" and
right "RPMS" windows open
9. In the left window drag the
  libreoffice3.3-mandriva-menus-3.3-.noarch.rpm 
   file to the RPMS window and choose "Copy" **
10. In Dolphin do F3 and use the "UP" arrow till you are back at
 the level where you see the "licenses", "readme", "RPMS"
 folders
11. Right-click on folder RPMS and choose Action-Open Konsole
12. Konsole will now open with a $
13. In Konsole do $su  (this is super user mode)
14. Type in your root password
15. In Konsole do #rpm -Uvih *rpm
16. Wait till all the packages have installed"
---
-- 
/\/\aurice 
(Retired in Surrey, UK) Registered Linux User #487649
Linux Mandriva 2010.2 32-bit  PowerPack (i686 kernel) 
  KDE 4.5.2  Virtualbox 4.0.6   Firefox 4.0   KMail 1.13.5


-- 
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] some interesting sites to check today

2012-01-18 Thread Jay Lozier

On 01/18/2012 01:16 PM, Tom Davies wrote:

Hi :)

The Free Software Foundation
http://www.fsf.org/
http://www.gnu.org/

Wikipedia
http://en.wikipedia.org/wiki/Main_Page
any page in English.  Note that non-English pages still do work and only carry a banner. 


Creative Commons
http://creativecommons.org/
Only has a banner but at least it's showing support.

I didn't notice quite so much fuss during Egypt's problems nor New Zealand's a 
few years ago.  However i think it's good to make a stand before freedom of 
speech is banned from the internet as it appears the USA seems to want to do 
(allegedly).

Note this email is my own personal opinion and nothing to do with TDF or 
LibreOffice except that i happened to post it here.
Regards from
Tom :)

SOPA & PIPA allow for frivolous take down orders and shutting down 
entire sites (Facebook or Twitter for example) because a few pages of 
alleged infringing content. It is primarily pushed by RIAA and MPAA


--
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] Re: Change default size to insert pictures

2012-01-18 Thread Dan Lewis
On Wed, 2012-01-18 at 08:12 -0800, mnatiello wrote:
> Hi Dan,
> 
>   I suggest you create a frame that has the properties you want the
> picture to have default width and two columns. Then create an AutoText
> with these properties. If you want a frame that is 7 cm wide with only
> one column, create an AutoText with these properties. Then anytime you
> want to insert a picture select the appropriate AutoText and insert the
> picture into the frame.
> 
> Thanks, it is a "workaround" but not a solution, I would say. One has to use
> the predefined autotext to enter 
> the pictures one at a time. I still look for a way to redefine the "default
> anchor and size" with which the pictures
> are being inserted. It makes a difference if you have to enter say 100
> pictures at one shot.
>  If you don't know about a way to modify the default... should I file an
> "enhancement request?"
> Mario
> --


 AutoText is way to do repeated things as I have described. The
other way is using a macro. Have you thought about doing that? Macros
are not my area of expertise, but others on this list might be able to
help.

--Dan



-- 
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] Table of Contents in alphabetic order?

2012-01-18 Thread .


On 01/18/2012 11:14 AM, Cor Nouws wrote:
> . wrote (18-01-12 16:57)
>> I've spent over 24 hours, in the past, to get that to work with indexes
>> and it doesn't.
>
> and it's so simple ...
>
> [ ][  ]  [   ]   [   ]
> ^1  ^2
>
> place cursor in place with  ^1 below
> and click hyperlink button
> do the same with ^2
>
> OK...
>
The hyperlink button isn't available in Indexes in my situationno
matter what I do.  The hyperlink button is grayed out.  It's only
available when I work with TOC.




-- 
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] some interesting sites to check today

2012-01-18 Thread Tom Davies
Hi :)

The Free Software Foundation
http://www.fsf.org/
http://www.gnu.org/

Wikipedia
http://en.wikipedia.org/wiki/Main_Page
any page in English.  Note that non-English pages still do work and only carry 
a banner.  

Creative Commons
http://creativecommons.org/
Only has a banner but at least it's showing support.

I didn't notice quite so much fuss during Egypt's problems nor New Zealand's a 
few years ago.  However i think it's good to make a stand before freedom of 
speech is banned from the internet as it appears the USA seems to want to do 
(allegedly).

Note this email is my own personal opinion and nothing to do with TDF or 
LibreOffice except that i happened to post it here.
Regards from
Tom :)

-- 
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: Bespoke background images

2012-01-18 Thread NoOp
On 01/17/2012 03:33 AM, chasm wrote:
> I've created a bespoke bitmap that I wish to use as a tiled page background.
> How do I add it to the list of background bitmaps that come with
> LibreOffice?
...
Perhaps these will help:


[Chapter 8 - page 30]


-- 
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: Illogical installer!

2012-01-18 Thread Tanstaafl

On 2012-01-18 8:49 AM, Andreas Säger  wrote:

Am 18.01.2012 13:22, Gordon Burgess-Parker wrote:

Can anyone tell me the logic in this?
If I download the English UK version, if I select Custom install, then
ALL the language packs are disabled apart from English, yet all the
dictionaries are ENABLED and I have to go through however many
dictionaries there are and disable them one by one (unless anyone can
tell me a better way!).
Surely logic says that if all the language packs are disabled by default
other than the one for the relevant download, then all the dictionaries
should be as well?



There is no need to enable or disable anything. You can write (and spell
check) English text with Russian figures in a Chinese GUI.
GUI language, numeric default locale and default text language are
completely independent from each other. Each snippet of text, each table
cell, field, input box and what else can be used in its own language
context.


And for those of us who don't speak 2, 3 or 10 different languages, and 
only need *one*?


Gordon: it is a little easier to first disable the entire Dictionary 
category (rather than doing each language individually), then expand it 
and select only the desired language.


And I agree with your complaint, but there is something else that bugs 
me even more...


From a previous email of mine:

On 2011-08-31 12:46 PM, Tanstaafl  wrote:
> Ok, this is really nuts...
>
> Before I go open up a bug about this, can anyone tell me why, if I
> deselect all dictionaries except the one I need, who, in the Windows
> Add/Remove Programs Support Info dialog, does it insist on showing it
> with ALL languages, thus causing the support info window to be even
> wider than my 24" 1920x1080 is capable of displaying in its entirety?

and two minutes later I posted the exact same question as the OP...


--
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: Batch for extracting lines into new files in CALC

2012-01-18 Thread Andreas Säger

Am 18.01.2012 14:56, Calvin Kim wrote:

I usually convert it to .csv and extract data with PHP, but I love to
see how to do it with Calc.
cK



Manually without any coding:
Connect a registered Base document to the spreadsheet. A connection to 
an indexed dBase copy might be more performant.

Create a parameter query: SELECT * FROM "Table" WHERE "Column"= :p
Create a Calc template with an import range bound to that param query.
Bind some shorcut to command "refresh data range", say Ctrl+R
Declare the template as default template.
Switch to xls as default file format.

Ctrl+N gets a new document.
Ctrl+R prompts for parameter :p. Enter 1 and wait for the import to 
complete.

Ctrl+W closes this document prompting for the xls file name. Enter 001.

Repeat these 3 steps until you are finished.


--
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] Question about Writer - pages and page count.

2012-01-18 Thread Jay Lozier

On 01/18/2012 10:36 AM, Mirosław Zalewski wrote:

On 18/01/2012 at 11:52, Sylvia Schmidt  wrote:


There aren't that
many companies around here that will print and bind books as hardcovers
with only three copies. If the company wasn't recommended by my
university I probably would have chosen a different one.

On the side of main topic:
I find it quite surprising. If that printing company is recommended by your
university, perhaps there is some kind of agreement between company and
university, and perhaps many students print their thesis in that printing
company. And yet they are unprepared for continuously numbered PDFs that have
to be printed one-sided? I doubt that MS Word makes solving your task any
easier than LO Writer.

Or maybe most students send .doc file to printing company? But that should be
more expensive, since additional editorial work has to be done (beside
printing).

Or maybe most students prepare their thesis in Adobe InDesign (which, as you
say, is capable of solving your task)? I find it quite hard to belive, since
InDesign is really expensive software. But maybe your university has special
agreement with Adobe that students can download and use InDesign for free?

Going further with offtopic, in Poland there are many small printing companies
in close neighborhood of each university building. These companies usually
have few photocopiers, few printers and one or two computers. You can print
and bind your thesis in almost every of these companies, although only in
preset hard cover (they usually say "Master thesis" or something similar on
front cover and they look like [1]). So, if you would like to have your name
or title of your thesis on your cover, it would be harder and more expensive.

Here in Poland we are used to believe that Germany is land of milk and honey.
I find it surprising that - at least in that area - in Poland we are apparently
in better position than you are. Having so many printing companies around, no
one would care about inserting real blank pages into documents - they would
just go to another company, the one that has no such prerequirements about
documents.
Another option is to print the required copies on a laser printer 
yourself and then have them bound. You may need special archival paper.


In the very old days, I printed my thesis and had it bound separately. I 
had to get special paper and format the text according to the instructions.



[1] http://www.origo.poznan.pl/Graphics/products_76ba860c-6c47-4210-
b5ad-28198cf33cb2_1.jpg
(short link: http://bit.ly/A56Nqh )

Sorry about offtopic, I just wanted to share some of my thoughts :) .



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


[libreoffice-users] Re: Illogical installer!

2012-01-18 Thread Andreas Säger

Am 18.01.2012 17:24, John D. Herron wrote:

Andreas, I think what Gordon was trying to find out runs just opposite
to what you elaborate on.
He seems to not understand why downloading ALL Dictionaries cannot be
disabled at install time (as he apparently has no use for any) when he
choses a specific language (in his case the English UK) version of the
suite.




He asked about the logic why French dictionaries remain in a plain 
English GUI. There are hundreds of other features he will never use. Why 
make a fuzz of a few MB of unused dictionaries?
OOo 3.3 is downloadable as one language version without any extensions 
preinstalled. There might be good reasons why LibreOffice comes 
multi-lingual with some extensions preinstalled.

The unopkg command line tool can remove them.


--
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: Change default size to insert pictures

2012-01-18 Thread Mirosław Zalewski
On 18/01/2012 at 17:12, mnatiello  wrote:

>  If you don't know about a way to modify the default... should I file an
> "enhancement request?"

If it did work in the past version of OOo (as you said), you should file it as 
"regression", not "enhancement". Fortunately, regressions gets more developers 
attention than enhancements.

I think that would be valuable to check previous versions of OOo as well. Did 
it work in 3.0.0, but not in (say) 3.1? Does changelog mention it? If changed 
behavior was introduced in OOo, chances are that LO developers don't know 
anything about it. In that case, perhaps it indeed is "enhancement" and not 
"regression".

But please wait some time (I don't know, few days?) before posting it on 
bugzilla. Maybe someone will drop by and explain things a bit.
You can also ask on developers mailing list before posting on bugzilla. Maybe 
it was changed on purpose?
-- 
Best regards
Mirosław Zalewski

-- 
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: Illogical installer!

2012-01-18 Thread John D. Herron


On 01/18/2012 02:49 PM, Andreas Säger wrote:

Am 18.01.2012 13:22, Gordon Burgess-Parker wrote:

Can anyone tell me the logic in this?
If I download the English UK version, if I select Custom install, then
ALL the language packs are disabled apart from English, yet all the
dictionaries are ENABLED and I have to go through however many
dictionaries there are and disable them one by one (unless anyone can
tell me a better way!).
Surely logic says that if all the language packs are disabled by default
other than the one for the relevant download, then all the dictionaries
should be as well?



There is no need to enable or disable anything. You can write (and 
spell check) English text with Russian figures in a Chinese GUI.
GUI language, numeric default locale and default text language are 
completely independent from each other. Each snippet of text, each 
table cell, field, input box and what else can be used in its own 
language context.



Andreas, I think what Gordon was trying to find out runs just opposite 
to what you elaborate on.
He seems to not understand why downloading ALL Dictionaries cannot be 
disabled at install time (as he apparently has no use for any) when he 
choses a specific language (in his case the English UK) version of the 
suite.



--
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] Table of Contents in alphabetic order?

2012-01-18 Thread Cor Nouws

. wrote (18-01-12 16:57)

I've spent over 24 hours, in the past, to get that to work with indexes
and it doesn't.


and it's so simple ...

[ ][  ]  [   ]   [   ]
^1  ^2

place cursor in place with  ^1 below
and click hyperlink button
do the same with ^2

OK...


--
 - Cor
 - http://nl.libreoffice.org


--
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: Change default size to insert pictures

2012-01-18 Thread mnatiello
Hi Dan,


Thanks, it is a "workaround" but not a solution, I would say. One has to use
the predefined autotext to enter 
the pictures one at a time. I still look for a way to redefine the "default
anchor and size" with which the pictures
are being inserted. It makes a difference if you have to enter say 100
pictures at one shot.
 If you don't know about a way to modify the default... should I file an
"enhancement request?"
Mario


--
View this message in context: 
http://nabble.documentfoundation.org/Change-default-size-to-insert-pictures-tp3666544p3669648.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] Table of Contents in alphabetic order?

2012-01-18 Thread .
I've spent over 24 hours, in the past, to get that to work with indexes
and it doesn't.

The directions in "danilop" do not work for me.  There's probably some
way to configure Styles and Paragraphs to allow for links in indexes but
I haven't enough brains in my head (or patience) to spend any more time
on this.  Someone, not an expert, should write an simple guide on how to
do it as too many assumptions are made which aren't included in the
directions.



On 01/18/2012 10:05 AM, Jeff Prater wrote:
> Indexes support hyperlinks:
> http://danilop.wordpress.com/2008/07/06/how-to-create-a-linked-index-with-openoffice/
>
> -
> Jeff Prater
>
>
> On Tue, Jan 17, 2012 at 6:46 PM, .  wrote:
>
>>
>> On 01/17/2012 03:33 PM, Tom Davies wrote:
>>> Hi :)
>>> Can yo cheat and insert an Index at the front and then just have it
>> index the chapter headings?
>>> (Kinda following the old saying "If in doubt, cheat")
>>> Regards from
>>> Tom :)
>>>
>> Tom,
>>
>> Since I've mastered adding a TOC with hyperlinks I was hoping I could
>> create an alphabetic ordered TOC since Indexes don't support hyperlinks
>> that'll take you to a specific location within a document.
>>
>> Thanks
>>
>>
>>> --- On Tue, 17/1/12, Mirosław Zalewski  wrote:
>>>
>>> From: Mirosław Zalewski 
>>> Subject: Re: [libreoffice-users] Table of Contents in alphabetic order?
>>> To: users@global.libreoffice.org
>>> Date: Tuesday, 17 January, 2012, 20:27
>>>
>>> On 17/01/2012 at 15:36, "."  wrote:
>>>
 How can a TOC be put into alphabetic order?  (I'm not talking about an
 Index)
>>> So, are you talking about table of contents or index?
>>>
>>> ToC's are usually placed at beginning or end of book and contain list of
>>> chapters, subchapters, sections, subsections etc. with page numbers.
>> Items are
>>> ordered in the same manner they appear in book and you should not change
>> that.
>>> Indexes are usually by the end of book and contain list of alphabetically
>>> sorted keyword with page numbers (so reader can easily if and where is
>>> particular subject in the book).
>>>
>>> Either way, please read LO Writer documentation:
>>>
>> http://wiki.documentfoundation.org/images/c/c8/0212WG3-TOCsIndexesBiblios.pdf
>>> If you need any additional help, don't hesitate to ask on the list.
>>
>> --
>> 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] Question about Writer - pages and page count.

2012-01-18 Thread Mirosław Zalewski
On 18/01/2012 at 11:52, Sylvia Schmidt  wrote:

> There aren't that 
> many companies around here that will print and bind books as hardcovers 
> with only three copies. If the company wasn't recommended by my 
> university I probably would have chosen a different one.

On the side of main topic:
I find it quite surprising. If that printing company is recommended by your 
university, perhaps there is some kind of agreement between company and 
university, and perhaps many students print their thesis in that printing 
company. And yet they are unprepared for continuously numbered PDFs that have 
to be printed one-sided? I doubt that MS Word makes solving your task any 
easier than LO Writer.

Or maybe most students send .doc file to printing company? But that should be 
more expensive, since additional editorial work has to be done (beside 
printing).

Or maybe most students prepare their thesis in Adobe InDesign (which, as you 
say, is capable of solving your task)? I find it quite hard to belive, since 
InDesign is really expensive software. But maybe your university has special 
agreement with Adobe that students can download and use InDesign for free?

Going further with offtopic, in Poland there are many small printing companies 
in close neighborhood of each university building. These companies usually 
have few photocopiers, few printers and one or two computers. You can print 
and bind your thesis in almost every of these companies, although only in 
preset hard cover (they usually say "Master thesis" or something similar on 
front cover and they look like [1]). So, if you would like to have your name 
or title of your thesis on your cover, it would be harder and more expensive.

Here in Poland we are used to believe that Germany is land of milk and honey. 
I find it surprising that - at least in that area - in Poland we are apparently 
in better position than you are. Having so many printing companies around, no 
one would care about inserting real blank pages into documents - they would 
just go to another company, the one that has no such prerequirements about 
documents.

[1] http://www.origo.poznan.pl/Graphics/products_76ba860c-6c47-4210-
b5ad-28198cf33cb2_1.jpg 
(short link: http://bit.ly/A56Nqh )

Sorry about offtopic, I just wanted to share some of my thoughts :) .
-- 
Best regards
Mirosław Zalewski

-- 
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] Table of Contents in alphabetic order?

2012-01-18 Thread Jeff Prater
Indexes support hyperlinks:
http://danilop.wordpress.com/2008/07/06/how-to-create-a-linked-index-with-openoffice/

-
Jeff Prater


On Tue, Jan 17, 2012 at 6:46 PM, .  wrote:

>
>
> On 01/17/2012 03:33 PM, Tom Davies wrote:
> > Hi :)
> > Can yo cheat and insert an Index at the front and then just have it
> index the chapter headings?
> >
> > (Kinda following the old saying "If in doubt, cheat")
> > Regards from
> > Tom :)
> >
> Tom,
>
> Since I've mastered adding a TOC with hyperlinks I was hoping I could
> create an alphabetic ordered TOC since Indexes don't support hyperlinks
> that'll take you to a specific location within a document.
>
> Thanks
>
>
> >
> > --- On Tue, 17/1/12, Mirosław Zalewski  wrote:
> >
> > From: Mirosław Zalewski 
> > Subject: Re: [libreoffice-users] Table of Contents in alphabetic order?
> > To: users@global.libreoffice.org
> > Date: Tuesday, 17 January, 2012, 20:27
> >
> > On 17/01/2012 at 15:36, "."  wrote:
> >
> >> How can a TOC be put into alphabetic order?  (I'm not talking about an
> >> Index)
> > So, are you talking about table of contents or index?
> >
> > ToC's are usually placed at beginning or end of book and contain list of
> > chapters, subchapters, sections, subsections etc. with page numbers.
> Items are
> > ordered in the same manner they appear in book and you should not change
> that.
> >
> > Indexes are usually by the end of book and contain list of alphabetically
> > sorted keyword with page numbers (so reader can easily if and where is
> > particular subject in the book).
> >
> > Either way, please read LO Writer documentation:
> >
> http://wiki.documentfoundation.org/images/c/c8/0212WG3-TOCsIndexesBiblios.pdf
> >
> > If you need any additional help, don't hesitate to ask on the list.
>
>
> --
> 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] Impress: Import text from file dynamically

2012-01-18 Thread Calvin Kim

This will only give you half way of what you want.
Goto "Insert -> Object -> OLE Object"
Select 'Create from file',
Choose the file you want to link,
Make sure to check 'Link to file' checkbox.

Unfortunately, this will not update the contents automatically.
You have to goto "Edit -> Links -> Update"
And you can't even update it manually during the slideshow. You have to 
end slideshow before you can update the links.
Only DDE(Dynamic Data Exchange) from Calc can be automatically updated, 
it said.


cK

--
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: Batch for extracting lines into new files in CALC

2012-01-18 Thread Andreas Säger

Am 17.01.2012 17:23, tk5ep wrote:

Hi All,

I have a 13 lines CALC file.
I need to :
- filter the lines according a criterion
- export these lines to a new XLS file named after this criterion
- email the file

this has to be done about 500 times (criterions)

Has anybody a solution ??

Thanks for any help,

--
View this message in context: 
http://nabble.documentfoundation.org/Batch-for-extracting-lines-into-new-files-in-CALC-tp323p323.html
Sent from the Users mailing list archive at Nabble.com.



Leave behind all spreadsheets. There is no technical reason nor 
convenience factor in favour of using spreadsheets with a database dump 
of raw data.
The dBase driver of the Base component supports indexing for fast 
lookups within millions of rows.
Save as dBase in a *dedicated directory*. dBase is a database in a 
directory.

Connect a Base document to the *directory*.
Open the table for editing and add some indices on relevant fields.
Create a set of simple queries. Parameter queries are supported.
Video tutorial on something similar with a small amount of data in a 
sheet: 
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=40403&p=186845&hilit=+parameter#p186158



--
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: Best JRE for LibreOffice on a 64-bit system: 32 or 64 bit ?

2012-01-18 Thread Andreas Säger

Am 11.01.2012 20:08, Tanstaafl wrote:


It is simply unwise to keep old/exploitable version of java on any system.



There is no technical reason to do so on a Windows system. Under Linux 
there may be a tiny fraction of users like me who face a certain 
performance problem in Base.



--
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: Batch for extracting lines into new files in CALC

2012-01-18 Thread Calvin Kim
I usually convert it to .csv and extract data with PHP, but I love to 
see how to do it with Calc.

cK

--
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: Best JRE for LibreOffice on a 64-bit system: 32 or 64 bit ?

2012-01-18 Thread Andreas Säger

Am 11.01.2012 19:28, Tom Davies wrote:

The _21 is probably the best one for Office


Why?


--
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: Illogical installer!

2012-01-18 Thread Andreas Säger

Am 18.01.2012 13:22, Gordon Burgess-Parker wrote:

Can anyone tell me the logic in this?
If I download the English UK version, if I select Custom install, then
ALL the language packs are disabled apart from English, yet all the
dictionaries are ENABLED and I have to go through however many
dictionaries there are and disable them one by one (unless anyone can
tell me a better way!).
Surely logic says that if all the language packs are disabled by default
other than the one for the relevant download, then all the dictionaries
should be as well?



There is no need to enable or disable anything. You can write (and spell 
check) English text with Russian figures in a Chinese GUI.
GUI language, numeric default locale and default text language are 
completely independent from each other. Each snippet of text, each table 
cell, field, input box and what else can be used in its own language 
context.



--
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: MySQL native connector - several databases retrieved?

2012-01-18 Thread Alexander Thurgood
Le 17/01/12 17:01, fmayo a écrit :

Hi,



> Thanks for the advice, Fernand. Good to know that it works fine with MySQL.
> I tested it that way, even closing both the server and the Ubuntu session: no 
> change.
> So, as a general info to the community, when connecting Base to MariaDB thru 
> MySQL native connector (1.0.1), it seems that all 
> db's within the targeted environment are reported in Base 'Tables' zone.

If you restrict your users' rights through the Tables/Columns privilege
in mysql, are these tables still visible when you re-start LO and
re-open the ODB ?


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

2012-01-18 Thread Vitorio Furusho
Olá jorge,

Gracias

Um abraço,

*Furusho, *Vitorio*
*[image:
https://twimg0-a.akamaihd.net/profile_images/990355931/Furusho_430x430_reasonably_small.jpg]
Ativista de Software Livre, LibreOffice e ODF
ODF Alliance 
Award
Membro da Comunidade LibreOffice Brasil - CoLibre
Membro da The Document Foundation - TDF
Membro da Free Software Foundation - FSF 10174 
Membro da Associação Software Livre Brasil 
Membro da ABNT 
Free Software Furusho 
The Furusho Daily 
Twitter: @vfurusho 
Skype: vyfurusho 
Jabber: Furusho
Gtalk: broffice
E-mail: furu...@openoffice.org



2012/1/2 jorge 

> Good Morning, Happy New Year for all !
>
> >From Costa Rica ... Central America.
> --
> Atentamente,
>
> Jorge Rodríguez
>
>
> --
> 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] Illogical installer!

2012-01-18 Thread Gordon Burgess-Parker

Can anyone tell me the logic in this?
If I download the English UK version, if I select Custom install, then 
ALL the language packs are disabled apart from English, yet all the 
dictionaries are ENABLED and I have to go through however many 
dictionaries there are and disable them one by one (unless anyone can 
tell me a better way!).
Surely logic says that if all the language packs are disabled by default 
other than the one for the relevant download, then all the dictionaries 
should be as well?


--

Registered Linux User no 240308
http://gbplinuxfoss.blogspot.com/
Say No to OOXMLhttp://www.linuxjournal.com/article/9594#mpart8
I only accept odf or pdf 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] Problem

2012-01-18 Thread Gordon Burgess-Parker

On 17/01/12 16:38, Tom Davies wrote:

Hi :)
It's not great to be faced with these challenges and questions and no answers when people first write in to the list.  It's scary.  Sadly i don't think there was a way around it this time. 

Perhaps John has installed on a lower spec than is really needed for Ubuntu.  Ubuntu really needs 15Gb hard-drive, 1GHz Cpu and 1Gb Ram.  It can run in less, far less if you are an expert and do a special install but for a default and usable system it really takes about that much.  Lubuntu is better on lower spec than that or Xubuntu if you are close.  If one thing is lower but the rest higher then you can get away with it with Ubuntu but as a rule-of-thumb it's fairly accurate. 


When i was on the Ubuntu forums i often found that people had installed the Server 
Edition thinking it would be like the desktop but more powerful.  Another common issue 
would be that people had been told the the min.spec. for installing Ubuntu was barely 
usable by highly experienced Gnu&Linux experts who could swap-out bits&bobs and 
do a very non-standard install.  Another common problem was people installing inside 
Windows using the Wubi installer and often again with far too little space.  I made 
myself fairly unpopular by suggesting that the official min.spec. should be plenty for 
a usable system for a total noob, ie about 15 Gb hard-drive space, not 2Gb (or whatever 
ridiculous claim was made).  For at least 1Gb Ram and 1GHz Cpu rather than 256Mb Ram 
which is plausible only if the architecture happens to be far better than is likely.  
Almost every product makes ridiculous claims and something i initially liked about 
Ubuntu was that it didn't but
  then the year after they suddenly copied the boasting style of the rest of the corporate world. 


It's also possible that John Black is not subscribed and therefore not seeing 
these replies
Regards from
Tom :)


--- On Tue, 17/1/12, Gordon Burgess-Parker  wrote:

From: Gordon Burgess-Parker
Subject: Re: [libreoffice-users] Problem
To: users@global.libreoffice.org
Date: Tuesday, 17 January, 2012, 9:01

On 16/01/12 20:56, John Black wrote:

I just installed Libre Calc and tried to run it. Got the message: ” The
application cannot be started. [context="shared"] caught unexpected
exception!”

What did I do wrong? This is in Ubuntu that I installed yesterday.

Thank you

John


Your post makes no sense.
If you installed the latest version of Ubuntu then it already COMES with
the full Libre Office suite.
You need to tell us EXACTLY what you have and EXACTLY what you did.
(BTW, you cannot just install Calc on it's own - it's either the whole
suite or nothing).



I've just sent a copy of my mail directly to the OP. We'll see what that 
produces!


--

Registered Linux User no 240308
http://gbplinuxfoss.blogspot.com/
Say No to OOXMLhttp://www.linuxjournal.com/article/9594#mpart8
I only accept odf or pdf 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] Question about Writer - pages and page count.

2012-01-18 Thread Brad Rogers
On Wed, 18 Jan 2012 11:49:47 +0200
Ian Whitfield  wrote:

Hello Ian,

> And there you have it - A Double-sided printout from a single page 
> printer!! Easy.

In theory, you're right.  But as we all know:  In theory, theory and
practise should be the same.  In practise, they rarely are.

It all works as long as the printer *never* pulls through two sheets of
paper at a time.  Which always seemed to happen to me on sheet 2 of a
50+ sheet print run, if I didn't sit there and watch it.  Assuming I'd
put the paper back in the tray the right way round.  Although once
you've worked out which way that is, no errors should occur because of
that.

I ended up buying a printer with a duplexer to save me all that wasted
time, paper and ink.

-- 
 Regards  _
 / )   "The blindingly obvious is
/ _)radnever immediately apparent"
Life's short, don't make a mess of it
No Time To Be 21 - The Adverts

-- 
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: Best JRE for LibreOffice on a 64-bit system: 32 or 64 bit ?

2012-01-18 Thread Andreas Säger

Am 17.01.2012 09:51, Tom Davies wrote:

Where it hasn't been written-out it seems their  best version is 6_21 or on 
Windows 6u21


Why?


--
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] Question about Writer - pages and page count.

2012-01-18 Thread Sylvia Schmidt

Okay, from the top: Yes, I'm using linux -> Ubuntu 11.10.

I've talked to the printing company and they said it should be "real" 
blank pages as the backs. I do not know why exactly, it has something to 
do with the binding and the 4 pages printout used. (There aren't that 
many companies around here that will print and bind books as hardcovers 
with only three copies. If the company wasn't recommended by my 
university I probably would have chosen a different one.)


I even know how to get that using Indesign, but Indesign is a real pain 
as a 'writing tool'. So I thought I'd try something else... I didn't 
even think of changing the finished pdf, but that's a great idea! I'll 
look into your suggestions. Thank you for that.



--
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] Question about Writer - pages and page count.

2012-01-18 Thread Tom Davies
Hi :)
True :))  You have to do a quick test run with 1 or 2 pages just to make sure 
which way you have to put the paper back in just in case your printer is 
weird.  Also make sure that no-one else prints to 'your' printer when you are 
doing the "even" pages.  I have been in quite a few offices where people would 
delight in saving-up their print-jobs until someone tried doing something like 
this purely in order to create confusion and make a fuss.  
Regards from
Tom :)


--- On Wed, 18/1/12, Ian Whitfield  wrote:

From: Ian Whitfield 
Subject: Re: [libreoffice-users] Question about Writer - pages and page count.
To: users@global.libreoffice.org
Date: Wednesday, 18 January, 2012, 9:49

On 01/17/2012 06:20 PM, Sylvia Schmidt wrote:
> True two-sided printing requires a more expensive printer because the
>> paper feed is more complex. In the US the only two-sided "printers" I
>> have seen are larger office copier/printer combinations; most of the
>> desktop printers print one-sided.
>> 
>> Many people do not have a printer capable of true two-sided printing
>> because most home and office printers are designed for one-sided
>> printing. They print one sheet straight through and can not reverse feed
>> to print automatically on the reverse side. The paper feed is much
>> simpler, hence less expensive and should be more reliable.

Being an "ex-Printer man" for one of the large Printer Manufactures I have to 
point out the following, (which over the years I have found very few users know 
about).

You do _NOT_ need a more expensive Duplex Printer to produce Double-sided 
printouts!! Almost all print routines have the option to control what prints 
out in any print job. So ..

First set-up your print job to print 'Odd pages only';
Take these pages, turn them over and put them back into the paper tray;
Now set-up the print job to print 'Even pages only'.

And there you have it - A Double-sided printout from a single page printer!! 
Easy.

Ian Whitfield
Pretoria.

-- 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] Question about Writer - pages and page count.

2012-01-18 Thread Ian Whitfield

On 01/17/2012 06:20 PM, Sylvia Schmidt wrote:

True two-sided printing requires a more expensive printer because the

paper feed is more complex. In the US the only two-sided "printers" I
have seen are larger office copier/printer combinations; most of the
desktop printers print one-sided.

Many people do not have a printer capable of true two-sided printing
because most home and office printers are designed for one-sided
printing. They print one sheet straight through and can not reverse feed
to print automatically on the reverse side. The paper feed is much
simpler, hence less expensive and should be more reliable.


Being an "ex-Printer man" for one of the large Printer Manufactures I 
have to point out the following, (which over the years I have found very 
few users know about).


You do _NOT_ need a more expensive Duplex Printer to produce 
Double-sided printouts!! Almost all print routines have the option to 
control what prints out in any print job. So ..


First set-up your print job to print 'Odd pages only';
Take these pages, turn them over and put them back into the paper tray;
Now set-up the print job to print 'Even pages only'.

And there you have it - A Double-sided printout from a single page 
printer!! Easy.


Ian Whitfield
Pretoria.

--
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: Triggering reports from html files

2012-01-18 Thread blesko
Oh - that's a typo of sorts...

http://nabble.documentfoundation.org/file/n3668719/allgergybutton.png 

--
View this message in context: 
http://nabble.documentfoundation.org/Triggering-reports-from-html-files-tp3654402p3668719.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] Question about Writer - pages and page count.

2012-01-18 Thread Joep L. Blom

On 18-01-12 00:51, Jay Lozier wrote:

Sylvia,

On 01/17/2012 06:20 PM, Sylvia Schmidt wrote:




True two-sided printing requires a more expensive printer because the
paper feed is more complex. In the US the only two-sided "printers" I
have seen are larger office copier/printer combinations; most of the
desktop printers print one-sided.

Many people do not have a printer capable of true two-sided printing
because most home and office printers are designed for one-sided
printing. They print one sheet straight through and can not reverse feed
to print automatically on the reverse side. The paper feed is much
simpler, hence less expensive and should be more reliable.


Jay,
OT: I use The Samsung ML2855ND laser printer - which costs here (The 
Netherlands) ~ 150 euro -  to print sheet music double sided, which I 
think is not expensive.

Joep



--
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: Triggering reports from html files

2012-01-18 Thread Fernand Vanrie

On 18/01/2012 09:38, blesko wrote:

I edited mdlExecReport and added a function OpenAllergyReport, which is a
duplicate of OpenReport().

maybe you must rename your new function to "OpenReport"


This works when I access the macro from the toolbar - in both the DB object
and an exported .odt form (where I hoped to put the button). It's throwing
one error for line 305 (not optional??), but it still opens the report :-)

"not optional" means there is a parameter missing when calling the function


But I cannot run it from the button. I may be configuring the button
incorrectly. On the General tab, I have Action : none, then on the events
tab I have Execute Action mdlExecReport-mdlOpenAllergyReport. If not, maybe
a button isn't the way to go?
trie first to use the original button with a renamed function and i hav 
my doubt about "mdl"OpenAllergyReport because tour new function is named


"OpenAllergyReport" and not "mdlOpenAllergyReport"

greetz

Fernand



Any suggestions?

Encouraged!

Beth

--
View this message in context: 
http://nabble.documentfoundation.org/Triggering-reports-from-html-files-tp3654402p3668612.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



[libreoffice-users] Re: Triggering reports from html files

2012-01-18 Thread blesko
I edited mdlExecReport and added a function OpenAllergyReport, which is a
duplicate of OpenReport().

This works when I access the macro from the toolbar - in both the DB object
and an exported .odt form (where I hoped to put the button). It's throwing
one error for line 305 (not optional??), but it still opens the report :-)

But I cannot run it from the button. I may be configuring the button
incorrectly. On the General tab, I have Action : none, then on the events
tab I have Execute Action mdlExecReport-mdlOpenAllergyReport. If not, maybe
a button isn't the way to go? 

Any suggestions?

Encouraged!

Beth

--
View this message in context: 
http://nabble.documentfoundation.org/Triggering-reports-from-html-files-tp3654402p3668612.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