[libreoffice-users] Re: Postgresql with LibO-3.3.2 BASE

2011-04-08 Thread Alexander Thurgood
Le 07/04/11 10:37, amine amine a écrit :

Hi Amine,

I downloaded and installed the XTuple software. It sets up a postgresql
server on a Unix socket, with a default db called demo and User/PWD
admin/admin.

I then downloaded the JDBC3 driver for postgres 8.4.

Started LibO, and indicated in the Java settings (Add archive) where it
could find the driver. Shut down LibO and restarted it.


I then chose Create New DB, the DB creation wizard started. I told it to
connect to an existing database via JDBC, entered the connection and
driver parameters :

Connection
jdbc:postgresql://localhost/demo

Driver
org.postgresql.Driver


Tested the driver.


Then carried on through the wizard with the defaults, saving as
XTuple_demo.odb

When I click on the Tables icon, it asks me for the user and pwd
combination, I enter admin and admin, the connection works and
displays a list of dbs with their associated tables or views.

If I click on a table, I can edit the data in that table, update it,
create new entries, etc, and they are saved (providing I validate the
entry by either moving from one tuple to another or by clicking the
appropriate disk icon.

None of the Views are editable.

So my guess is, you are either working with Views, which do not appear
to be updateable, or Queries across multiple tables which AFAIK are also
not updateable, or you have something special else in your user rights
or table definitions that prevents the driver from changing the data via
LibO.


Alex





-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted



[libreoffice-users] I can't type after putting up a table

2011-04-08 Thread Jet Ong
Of the many tables I created in LibreOffice, a few just won't let me type
anything after the table.
I would be redirected to the next page. Please help.

Btw, I would also like to know how to caption a table and relate that to my
index of table

Thanks!
Jet

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted



[libreoffice-users] Re: Problem selecting objects

2011-04-08 Thread Linus Paulsson
Hi Ryan,

I now have:

LibreOffice 3.3.2 
OOO330m19 (Build:202)
tag libreoffice-3.3.2.2, Ubuntu package 1:3.3.2-1ubuntu2~maverick1

but the problem is still there.

Sorry for my bad english. I use a Swedish version of LO. I meant a 'one line
form field' as in:

Name: textField (that accepts input from the reader)
E-mail: textField
SUBMIT


I think you will find it under:
Show(or View) - Toolbars - Form control - Text Field

or something like that.

The same problem occurs for groups of object that i have saved in gallery,
containing these objects:
Show(or View) - Toolbars - Draw - Text
Show(or View) - Toolbars - Draw - Line
Show(or View) - Toolbars - Form control - Text Field

The problem does not occur for other images in the gallery nor for frames.

Best regards
Linus



--
View this message in context: 
http://nabble.documentfoundation.org/Problem-selecting-objects-tp2742625p2794462.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: import of postscript files

2011-04-08 Thread Joep L. Blom

On 08/04/11 05:28, NoOp wrote:



You may have already explored this, but can you use oolilypond?

http://ooolilypond.sourceforge.net/
http://extensions.services.openoffice.org/en/project/OOoLilyPondhttp://www.lilypond.org/



Gary,
No, I didn't. I looked at it but the big snag is that you must translate 
first to Lilypond format.The music I write is much too cumbersome for 
writing directly in Lilypond format (I write arrangements for 2 piano's 
and big bands) and in my book  there will be many examples.
However, I can try the route: Finale (Windows) - .mxml - Musescore 
(Linux notation program that reads .mxml and can give Lilypond output) 
- Lilypond output - oolilypond in libreoffice.
I need to use Finale as the Linux programs don't have the opportunities 
I need to write efficiently.
However, it's - as usual - a very good suggestion and I sure will 
explore it. Maybe someone will make a oomxml plugin!

Thanks,
Joep

--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] unsubscribe

2011-04-08 Thread luiz
Hi,

Unsubscribe instructions: E-mail to users+unsubscr...@libreoffice.org


regards,

Luiz


 Please take me off the list.

 Dwayne Barber
 dwa...@sasktel.net

   


-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Calc Question

2011-04-08 Thread Johnny Rosenberg
fre 2011-04-08 klockan 15:15 -0400 skrev Chris Gummo:
 My company is in the process of moving to LibreOffice from MS Office. We do
 inventory of equipment from our customers and in Excel we have a formula
 that does not allow us to scan in duplicate serial numbers. Does any one
 know of a way to do this using Calc in LibreOffice?
 
 Chris
 

I guess that could be done in several ways. What does that formula look
like in Excel?

-- 
Best regards

Johnny Rosenberg


-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] Re: import of postscript files

2011-04-08 Thread Joep L. Blom

On 08/04/11 10:40, Joep L. Blom wrote:

On 08/04/11 05:28, NoOp wrote:



You may have already explored this, but can you use oolilypond?

http://ooolilypond.sourceforge.net/
http://extensions.services.openoffice.org/en/project/OOoLilyPondhttp://www.lilypond.org/




Gary,
No, I didn't. I looked at it but the big snag is that you must translate
first to Lilypond format.The music I write is much too cumbersome for
writing directly in Lilypond format (I write arrangements for 2 piano's
and big bands) and in my book there will be many examples.
However, I can try the route: Finale (Windows) - .mxml - Musescore
(Linux notation program that reads .mxml and can give Lilypond output)
- Lilypond output - oolilypond in libreoffice.
I need to use Finale as the Linux programs don't have the opportunities
I need to write efficiently.
However, it's - as usual - a very good suggestion and I sure will
explore it. Maybe someone will make a oomxml plugin!
Thanks,
Joep

I momentarily gave up on direct import but instead explored how to 
import as a picture. I found 2 routes to convert .ps to .jpg.

The most simple is to use convert:
convert sample.ps sample.jpg.
 This gives rather small files but the resolution is not really optimal 
despite the use of several options to enhance the quality.
Another route is via gs. There a better control of the resolution can be 
achieved using:
gs -sDEVICE=jpeg -r300 -dBATCH -dNOPAUSE -sOutputFile=testpage-a4.jpg 
testpage-a4.ps
 Here r300 is the resolution (I have found that r 150 is also 
acceptable and the file is 75 % smaller), dBATCH makes that gs finishes 
automatically and dNOPAUSE makes it process all pages without prompt.
It is not exactly what I wanted but this is very usable. I publish it 
here so that it may be of some help to others.

Joep


--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] Re: I can't type after putting up a table

2011-04-08 Thread Jet Ong
Problem solved with deleting the existing table and rearranging the table.
Putting caption on tables were also done with the help of a friend

On Fri, Apr 8, 2011 at 3:21 PM, Jet Ong raulio...@gmail.com wrote:

 Of the many tables I created in LibreOffice, a few just won't let me type
 anything after the table.
 I would be redirected to the next page. Please help.

 Btw, I would also like to know how to caption a table and relate that to my
 index of table

 Thanks!
 Jet




-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: I can't type after putting up a table

2011-04-08 Thread Andy Brown

Jet Ong wrote:

Problem solved with deleting the existing table and rearranging the table.
Putting caption on tables were also done with the help of a friend

On Fri, Apr 8, 2011 at 3:21 PM, Jet Ongraulio...@gmail.com  wrote:


Of the many tables I created in LibreOffice, a few just won't let me type
anything after the table.
I would be redirected to the next page. Please help.

Btw, I would also like to know how to caption a table and relate that to my
index of table

Thanks!
Jet


Hi Jet,

Would you mind letting us in on what was found?  It would be helpful to 
others that may have a like problem.


Thanks
Andy

--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted