date:20120613

Hi :)
Educational institutions and students can sometimes get discounts as do some 
charitable organisations.  

I think my route would be to try to set-up the template in LibreOffice but use 
the .otp (native ODF template format) for the main original, then use that to 
Save As a .pot rather than a .potX to create one that MS Office can open and 
then use MS Office to tweak the .pot to fix any problems.  Scott has more 
experience with doing presentations tho but that is what i would do for 
spreadsheets or word-processor files.  

Regards from
Tom :)  

--- On Wed, 13/6/12, Scott  wrote:

From: Scott 
Subject: Re: [libreoffice-users] PowerPoint templates and choice of .pot vs 
.potx?
To: users@global.libreoffice.org
Date: Wednesday, 13 June, 2012, 23:14

On Wednesday June 13, 2012 1:27 pm avamk wrote:
> Hello,
> 
> My group is in the process of setting up a slideshow template, and
> unfortunately for practical reasons need to save it as a PowerPoint
> template.
> 
> My question is twofold:
> 
> (1) What are some of your experiences in opening and using PowerPoint
> templates in LibreOffice? I prefer saving in the template in a format that I
> can reasonably expect good support for in LibreOffice.

Templates created in PowerPoint, regardless of the file format, often have 
issues in LibreOffice. The most common issues I have encountered are elements 
that are misplaced on the slide and font effects that do not transfer to 
LibreOffice from PowerPoint. But the most faithful reproduction seems to occur 
when using ppt files, regardless of whether they were created from a pot or a 
potx. pptx files are not as well-supported under LibreOffice as .ppt files are. 
But that's just my experience using a couple of templates I created in 
PowerPoint 2010.

> (2) We prefer a format that is as future proof as possible (in terms of
> consistent look and format using it between different software, Micro$oft or
> otherwise). With that in mind, which of the following would be a better
> choice? Microsoft PowerPoint 97/Xp/2000/2003 Template (*.pot), Microsoft
> PowerPoint 2007/2010 XML Template (*.potx), or Office Open XML Presentation
> Template (*.potm; *.potx)?

That's a difficult question to give a blanket answer for. It will depend on 
what 
features you include in your template. You will need to ensure that the fonts 
you use are available on all systems where the templates will be used, for 
instance. Your templates will need to be tested on all the software where it 
will be used to ensure that formatting is consistent. This could be an ongoing 
process.

One thing you might consider is whether you need the presentation in any of 
those formats. PowerPoint and Libreoffice can export presentations to PDF, 
which 
can be presented with some limited transition effects in many PDF viewers. Not 
many viewers offer a presentation mode with suitable features, though. Okular 
seems to have the best presentation mode among the PDF viewers I have tested, 
and there is a Windows version of that available from kde.org.

> Our work environment consists mainly of computers running Micro$oft
> PowerPoint 2010, a couple with PowerPoint 2007, and only one with
> LibreOffice 3.5. (Unfortunately switching all to LibreOffice is not
> practical for numerous reasons that I wish weren't true, but beyond the
> scope of this email.)

You will have far fewer headaches by obtaining an Office license for the one 
machine that doesn't have it than to try to make all presentation programs 
happy with whatever format is the least common denominator, unfortunately.

-- 
Scott

-- 
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] [Writer] Help setting column width

2012-06-13 Thread Juan Navarro

Hello all

I'm having problems doing something as easy as changing the column width
in a Writer document. I'm not very good at Office software, but still I
thought this wouldn't be a problem for me... well, it is :-)

In helpful and fast bug-style report:

Summary: when changing the column's width in a given ODT document, only
one cell is adjusted, not the whole column.

Component: Writer
Version: LibreOffice v3.5.4.2 (spanish) clean install; Windows 7 SP1 64bit;
Steps to reproduce:

1) Download either of these documents:
http://europass.cedefop.europa.eu/en/documents/curriculum-vitae/templates-instructions/templates/odt.odt
http://europass.cedefop.europa.eu/es/documents/curriculum-vitae/templates-instructions/templates/odt.odt
(it is the Europass template Curriculum Vitae, english or spanish)

Then follow ONE of these paths A or B:
A) Right click in any cell of the first column (eg. right click over
"Telephone(s)").
> Contextual menu > "Column" > "Width..." > Set some width (eg. some
smaller value).

B) Left click above the first column, to select the full column.
> Menu "Table" > "Autoadjust" > "Column width..." > Set some width (eg.
some smaller value).

Results:
Path A changes the width only for the cell in which I click.
Path B changes the width only for the first cell of the column.

I'm very confused, could someone please point me in the right direction?
Thanks

--
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] PowerPoint templates and choice of .pot vs .potx?

2012-06-13 Thread Scott

On Wednesday June 13, 2012 1:27 pm avamk wrote:
> Hello,
> 
> My group is in the process of setting up a slideshow template, and
> unfortunately for practical reasons need to save it as a PowerPoint
> template.
> 
> My question is twofold:
> 
> (1) What are some of your experiences in opening and using PowerPoint
> templates in LibreOffice? I prefer saving in the template in a format that I
> can reasonably expect good support for in LibreOffice.

Templates created in PowerPoint, regardless of the file format, often have 
issues in LibreOffice. The most common issues I have encountered are elements 
that are misplaced on the slide and font effects that do not transfer to 
LibreOffice from PowerPoint. But the most faithful reproduction seems to occur 
when using ppt files, regardless of whether they were created from a pot or a 
potx. pptx files are not as well-supported under LibreOffice as .ppt files are. 
But that's just my experience using a couple of templates I created in 
PowerPoint 2010.

> (2) We prefer a format that is as future proof as possible (in terms of
> consistent look and format using it between different software, Micro$oft or
> otherwise). With that in mind, which of the following would be a better
> choice? Microsoft PowerPoint 97/Xp/2000/2003 Template (*.pot), Microsoft
> PowerPoint 2007/2010 XML Template (*.potx), or Office Open XML Presentation
> Template (*.potm; *.potx)?

That's a difficult question to give a blanket answer for. It will depend on 
what 
features you include in your template. You will need to ensure that the fonts 
you use are available on all systems where the templates will be used, for 
instance. Your templates will need to be tested on all the software where it 
will be used to ensure that formatting is consistent. This could be an ongoing 
process.

One thing you might consider is whether you need the presentation in any of 
those formats. PowerPoint and Libreoffice can export presentations to PDF, 
which 
can be presented with some limited transition effects in many PDF viewers. Not 
many viewers offer a presentation mode with suitable features, though. Okular 
seems to have the best presentation mode among the PDF viewers I have tested, 
and there is a Windows version of that available from kde.org.

> Our work environment consists mainly of computers running Micro$oft
> PowerPoint 2010, a couple with PowerPoint 2007, and only one with
> LibreOffice 3.5. (Unfortunately switching all to LibreOffice is not
> practical for numerous reasons that I wish weren't true, but beyond the
> scope of this email.)

You will have far fewer headaches by obtaining an Office license for the one 
machine that doesn't have it than to try to make all presentation programs 
happy with whatever format is the least common denominator, unfortunately.

-- 
Scott

-- 
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] PowerPoint templates and choice of .pot vs .potx?

2012-06-13 Thread avamk

Hello,

My group is in the process of setting up a slideshow template, and
unfortunately for practical reasons need to save it as a PowerPoint
template.

My question is twofold:

(1) What are some of your experiences in opening and using PowerPoint
templates in LibreOffice? I prefer saving in the template in a format that I
can reasonably expect good support for in LibreOffice.

(2) We prefer a format that is as future proof as possible (in terms of
consistent look and format using it between different software, Micro$oft or
otherwise). With that in mind, which of the following would be a better
choice? Microsoft PowerPoint 97/Xp/2000/2003 Template (*.pot), Microsoft
PowerPoint 2007/2010 XML Template (*.potx), or Office Open XML Presentation
Template (*.potm; *.potx)?

Our work environment consists mainly of computers running Micro$oft
PowerPoint 2010, a couple with PowerPoint 2007, and only one with
LibreOffice 3.5. (Unfortunately switching all to LibreOffice is not
practical for numerous reasons that I wish weren't true, but beyond the
scope of this email.)

Thank you in advance for your time.

--
View this message in context:
http://nabble.documentfoundation.org/PowerPoint-templates-and-choice-of-pot-vs-potx-tp3989994.html
Sent from the Users mailing list archive at Nabble.com.

Re: [libreoffice-users] Re: Fwd: BLOOMING CACTI



Well, if the user does have access to a domain they can upload a file to 
via FTP or other client, then it would make sense for them to do so.  
They control where the file is located and when to remove it, after the 
thread has gone through the "help-cycle".


I can upload it to one of several domains I own, including 
libreoffice-na.us and krackedpress.com.  Then after a few days, or a few 
weeks, I just delete it from my "online folder/directory".  I have done 
this many time with this list and files I wanted to have someone look 
at.  I do not know how long a Nabble uploaded file will be held onto by 
the server/system before it is removed.



On 06/13/2012 11:43 AM, Tom wrote:

Hi :)
I think it's better to keep everything together and just upload to Nabble.
Using 3rd party sites usually means losing the attachment and that makes the
thread fairly useless if the attachment was relevant and important to the
thread.  File sizes tend to be reasonably small.
Regards from
Tom :)

--
View this message in context: 
http://nabble.documentfoundation.org/Fwd-BLOOMING-CACTI-tp3989910p3989930.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: List and Combo boxes

2012-06-13 Thread Andreas Säger

The order of row and columns in a database has no meaning. You can get 
any order of rows and columns as needed.
If the visible field is the same as the bound one use the same field for 
both columns:

SELECT "Field", "Field" FROM "Table"


--
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: Fwd: BLOOMING CACTI

2012-06-13 Thread Tom

Hi :)
I think it's better to keep everything together and just upload to Nabble. 
Using 3rd party sites usually means losing the attachment and that makes the
thread fairly useless if the attachment was relevant and important to the
thread.  File sizes tend to be reasonably small.  
Regards from
Tom :)

--
View this message in context: 
http://nabble.documentfoundation.org/Fwd-BLOOMING-CACTI-tp3989910p3989930.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] Fwd: BLOOMING CACTI

Hi :)
Yes, ODF is the generic name covering all the different formats used by the 
different modules/applications/parts of LibreOffice.  That becomes

Odt for word-processed documents because word-processing is traditionally 
mostly about formatted text
Ods for spreadsheet
Odp for presentations

Fairly consistent with each other.   
Regards from
Tom :)  

--- On Wed, 13/6/12, Dan  wrote:

From: Dan 
Subject: Re: [libreoffice-users] Fwd: BLOOMING CACTI
To: users@global.libreoffice.org
Date: Wednesday, 13 June, 2012, 16:17

Gordon wrote:
> The attached presentation--which I received from a friend--seems to run 
> better--without any setup--with PowerPoint than with Presentation. Any idea 
> why?
> 
> Gordon Broussard

     Because it makes sense? PowerPoint has its native format that it uses. 
Unless licensed by MS, no one else uses PowerPoint's native format. That means, 
PowerPoint will run the slide presentation better than other programs. They 
have only limited ability to read PP's files.
     Impress uses ODF (open document format) as its native format. Similarly, 
MS has only developed limited ability to read this format. Consequently, a 
slide show created using Impress and the ODF native format runs better on 
Impress than it would on PowerPoint.

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

-- 
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] Fwd: BLOOMING CACTI


Gordon wrote:
The attached presentation--which I received from a friend--seems to 
run better--without any setup--with PowerPoint than with Presentation. 
Any idea why?


Gordon Broussard


 Because it makes sense? PowerPoint has its native format that it 
uses. Unless licensed by MS, no one else uses PowerPoint's native 
format. That means, PowerPoint will run the slide presentation better 
than other programs. They have only limited ability to read PP's files.
 Impress uses ODF (open document format) as its native format. 
Similarly, MS has only developed limited ability to read this format. 
Consequently, a slide show created using Impress and the ODF native 
format runs better on Impress than it would on PowerPoint.


--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] Fwd: BLOOMING CACTI



I still think you should upload the attachments to a file-sharing system 
or your own domain FTP/sharing account.


That way TDF/LO does not have to have your file uploaded to a server 
they are using/paying-for/etc..


I even have my dictionary extension on my domain and use the "external 
hosting" option so LO does not need to use its disc space to store my 
contributions to LO.


Now if you do not have any account on any online service where you can 
store your files to share with people on the lists, then using Nabble 
might be your only option.  I have not used Nabble, and uploaded a file 
there before, so I cannot tell you how easy it is to upload a file to 
that system.


http://www.libreoffice.org/get-help/  list 
http://www.libreoffice.org/get-help/nabble-mailing-list-interface/  as 
the link to LO's Nabble starting page.  You will need to register to the 
system to post threads there.


On 06/13/2012 10:51 AM, Tom Davies wrote:

Hi :)
Translating non-native formats doesn't always go 100% perfectly.  If the presentation had been created in Impress (either OpenOffice or LibreOffice) then it would work better.  If you tried the presentation in a different version of MS Office, say in 2010 if created in 2007 then you would run into similar problems. 

Oddly if you tweak it in Impress and then save back in PowerPoint formats then it tends to work in whichever version of MS Office you are using.  It's best to stick with the native Odp format instead of .ppt or .pptX as the Odp format is used by more programs (KOffice/Caligra, IBM Lotus, google-docs and on and on). 

Errr attachments don't get through to the list but you could use the Nabble interface and upload things to Nabble so that we could all see them. 
Regards from

Tom :)


--- On Wed, 13/6/12, Gordon  wrote:

From: Gordon
Subject: [libreoffice-users] Fwd: BLOOMING CACTI
To: users@global.libreoffice.org
Date: Wednesday, 13 June, 2012, 15:37





The attached presentation--which I received from a friend--seems to run 
better--without any setup--with PowerPoint than with Presentation. Any idea why?

Gordon Broussard











--
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: List and Combo boxes


Alexander Thurgood wrote:

Le 12/06/12 21:08, Dan a écrit :

Hi Dan,


  To populate a list or combo box, I have been using single field
tables. Seems like it should be possible to use a single table for more
than one list or combo box. (The SQL statement for selecting a field for

I'm not sure I understand you correctly :

- do you want Table1.field1 and Table1.field2 to populate respectively
two separate list/combo boxes in your form ?

- or Table1.field1 to populate two separate list/combo boxes,
potentially displaying 2 different values (one for each combo/list box)
from the possible list of entries ?


Alex
Your right, I was talking about two different tables and was not 
clear at all.
 What I do now: for list boxes I create single field tables (the 
field is the primary key and uses VARCHAR as the field type. I have a 
database I use for my budget that contains three similar tables for 
three list boxes. (Budget level 1, Budget level 2, and Budget level 3)
 What I was thinking was to create one table (call it Budget) for 
the three list boxes containing three data fields: Budget 1, Budget 2, 
and Budget 3. With this I would create a fourth field (ID) as the 
primary key with AutoValue set to Yes. Budget 1 is for Budget level 1, etc.
 Probably, the SQL mentioned by Andreas may be all that is 
necessary with this structure. If so, would this also mean that values 
shown in the list Box for Budget level 1 will also appear in reports 
containing Budget level 1. (In the past in a form I have had Budget 
level 1 values coming from Budget 1 of the Budget table while in a 
report, the Budget level 1 values came from ID. I was probably not using 
SQL for this then.)
 Is there a particular order for the fields of the Budget table? 
Perhaps ID should be the first field followed by Budget 1, Budget 2, 
Budget 3?


--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] Fwd: BLOOMING CACTI

Hi :)
Translating non-native formats doesn't always go 100% perfectly.  If the 
presentation had been created in Impress (either OpenOffice or LibreOffice) 
then it would work better.  If you tried the presentation in a different 
version of MS Office, say in 2010 if created in 2007 then you would run into 
similar problems.  

Oddly if you tweak it in Impress and then save back in PowerPoint formats then 
it tends to work in whichever version of MS Office you are using.  It's best to 
stick with the native Odp format instead of .ppt or .pptX as the Odp format is 
used by more programs (KOffice/Caligra, IBM Lotus, google-docs and on and on).  

Errr attachments don't get through to the list but you could use the Nabble 
interface and upload things to Nabble so that we could all see them.  
Regards from
Tom :)


--- On Wed, 13/6/12, Gordon  wrote:

From: Gordon 
Subject: [libreoffice-users] Fwd: BLOOMING CACTI
To: users@global.libreoffice.org
Date: Wednesday, 13 June, 2012, 15:37





The attached presentation--which I received from a friend--seems to run 
better--without any setup--with PowerPoint than with Presentation. Any idea why?

Gordon Broussard








-- 



-- 



-- 



-- 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] Fwd: BLOOMING CACTI



Sorry
You cannot attach file to the list emails.

If you want to share a file, you must place it online on some place and 
give an external link.




On 06/13/2012 10:37 AM, Gordon wrote:





The attached presentation--which I received from a friend--seems to 
run better--without any setup--with PowerPoint than with Presentation. 
Any idea why?


Gordon Broussard











--
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] Fwd: BLOOMING CACTI

2012-06-13 Thread Gordon






The attached presentation--which I received from a friend--seems to run 
better--without any setup--with PowerPoint than with Presentation. Any 
idea why?


Gordon Broussard








--




--




--




--
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: List and Combo boxes

Le 12/06/12 21:08, Dan a écrit :

Hi Dan,

>  To populate a list or combo box, I have been using single field
> tables. Seems like it should be possible to use a single table for more
> than one list or combo box. (The SQL statement for selecting a field for

I'm not sure I understand you correctly :

- do you want Table1.field1 and Table1.field2 to populate respectively
two separate list/combo boxes in your form ?

- or Table1.field1 to populate two separate list/combo boxes,
potentially displaying 2 different values (one for each combo/list box)
from the possible list of entries ?


Alex


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: List and Combo boxes


Dan wrote:

Dan wrote:

Andreas Säger wrote:

Am 12.06.2012 21:08, Dan wrote:
To populate a list or combo box, I have been using single field 
tables.
Seems like it should be possible to use a single table for more 
than one

list or combo box. (The SQL statement for selecting a field for a list
or combo box is: SELECT "field name" FROM "table name".) Has anyone
tried this before? Any problems doing this?

--Dan



In a combo box you "always" want:
SELECT DISTINCT "Field" FROM "Table" ORDER BY "Field"

In a list box you "always" want:
SELECT "Field or Concatenation", "Primary Key"
FROM "Table"
ORDER BY "Field or Concatenation"
Bound field=1
Data field=The form's foreign key

[Example] Relations reflected by list boxes in forms
http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=40444 

 OK, I see I was not explicit enough. The tables I use for list 
boxes always contain only ONE field using VCHAR as the field type. 
There are no repetitions in this field, so all values entered are 
DISTINCT.

 The benefits I get from this are:

1) If I enter a new value in the field, close the table, and open it 
again; the entries have rearranged themselves alphabetically.


2) The entries always appear in alphabetically order in the list box 
after clicking the refresh tool in the form.


3)   Field A has been replaced with a list box (i.e., Monday, 
Tuesday, Wednesday) in a form. (The table for this contains one field 
whose values are Monday, Tuesday, and Wednesday.) When field A 
appears in a report, the only values showing are Monday, Tuesday, and 
Wednesday.
  If I were to use a table having two fields: ID, Day (i.e., 
1,2,3 for ID & Monday, Tuesday, Wednesday for Day); the form has 
shown the Monday, Tuesday, Wednesday values while the reports show 1, 
2, 3. Obviously, more has to be included in the SQL than what I wrote 
in the beginning. But with the limiting structure of my tables for 
list boxes do not require anything more.


--Dan

 Perhaps an important point: The field used in the table for the 
list box is also the primary key. This guarantees that the field 
contains DISTINCT values.


--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] Re: List and Combo boxes


Andreas Säger wrote:

Am 12.06.2012 21:08, Dan wrote:

To populate a list or combo box, I have been using single field tables.
Seems like it should be possible to use a single table for more than one
list or combo box. (The SQL statement for selecting a field for a list
or combo box is: SELECT "field name" FROM "table name".) Has anyone
tried this before? Any problems doing this?

--Dan



In a combo box you "always" want:
SELECT DISTINCT "Field" FROM "Table" ORDER BY "Field"

In a list box you "always" want:
SELECT "Field or Concatenation", "Primary Key"
FROM "Table"
ORDER BY "Field or Concatenation"
Bound field=1
Data field=The form's foreign key

[Example] Relations reflected by list boxes in forms

http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=40444
 OK, I see I was not explicit enough. The tables I use for list 
boxes always contain only ONE field using VCHAR as the field type. There 
are no repetitions in this field, so all values entered are DISTINCT.

 The benefits I get from this are:

1) If I enter a new value in the field, close the table, and open it 
again; the entries have rearranged themselves alphabetically.


2) The entries always appear in alphabetically order in the list box 
after clicking the refresh tool in the form.


3)   Field A has been replaced with a list box (i.e., Monday, Tuesday, 
Wednesday) in a form. (The table for this contains one field whose 
values are Monday, Tuesday, and Wednesday.) When field A appears in a 
report, the only values showing are Monday, Tuesday, and Wednesday.
  If I were to use a table having two fields: ID, Day (i.e., 1,2,3 
for ID & Monday, Tuesday, Wednesday for Day); the form has shown the 
Monday, Tuesday, Wednesday values while the reports show 1, 2, 3. 
Obviously, more has to be included in the SQL than what I wrote in the 
beginning. But with the limiting structure of my tables for list boxes 
do not require anything more.


--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] creating new master template


Bala subramanian wrote:

Hello,
If i have to design a new master slide and include it to the master
templates, how can i do it in Libreoffice power point.

Bala
 A good point to start is the Getting Started with Impress chapter 
(part of the Getting started Guide) available here:

http://www.libreoffice.org/get-help/documentation/.
The Impress Guide is also available there though the Getting 
Started chapter on Impress probably would all that you would need. Look 
for a section in the table of contents on master slides.


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

[libreoffice-users] Re: List and Combo boxes

Le 13/06/12 13:50, Andreas Säger a écrit :

Hi Andreas,

> 
> A two minutes test reveals that LibO 3.6(beta) can not use the first
> field (field #0) as bound field.

Thanks for testing, I guess those changes were in cwsdb34 which didn't
make it into LO (for various reasons) :-/


> I "always" sort list box entries by the visible field so I've got to
> write a quick query anyway. If I write  or
> the other way round does not matter at all.

Agreed.

> My receipt "always" works. It gives a pointer to another table's primary
> key which can be selected by typing and picking.

Agreed.

> Contrary to a most simple SQL receipt, the list box wizard is a totally
> unproductive piece of crap. It can not even concatenate fields.

Yes, unfortunately, but it is not the only problem with concatenation
and the built-in SQL parser.



Alex



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: List and Combo boxes

2012-06-13 Thread Andreas Säger


Am 13.06.2012 09:56, Alexander Thurgood wrote:


I seem to recall having seen somewhere on the OOo dev lists that it
should now be possible to directly select Bound field=0, and still have
your sorted distinct data on the other data field, or have I muddled
things up ? This was part of the development that went into OOo3.4, but
perhaps it didn't make it into LO ?


Alex




A two minutes test reveals that LibO 3.6(beta) can not use the first 
field (field #0) as bound field.
I "always" sort list box entries by the visible field so I've got to 
write a quick query anyway. If I write  or 
the other way round does not matter at all.
My receipt "always" works. It gives a pointer to another table's primary 
key which can be selected by typing and picking.
Contrary to a most simple SQL receipt, the list box wizard is a totally 
unproductive piece of crap. It can not even concatenate fields.



--
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] a 3.5.4 DVD .iso file is now online.




North American Community DVD Project's
3.5.4 version 1 DVD .iso file is now online.

It is 4.1 GB in size and is for Windows, MacOSX, and Linux.

http://www.libreoffice.org/download/?type=box&version=3.5.4 



--
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] Draw: an odd room, place labelled furniture?

2012-06-13 Thread J.A. de Vries

On 2012-06-12 22:24, Tom Davies wrote:
> Hi :)
> Not sure if Draw is the right tool to use.  
> 
> My workplace is moving soon and i have taken measurements of the oddly shaped 
> big new room at the new place.  My first thought had been to make a 2d 
> paper-'model' and then use smaller bits of paper to represent furniture to 
> test-out different layouts.  
> 
> Could Draw be used to do this instead, reasonably easily?
> Regards from
> Tom :)  
> 

Hi Tom,

I do this regularly with Draw for 2D mockups. So, yes. It can be done
quite easily with Draw.

Some tips:

- Make sure to use the right scale by adjusting the page style. Just to
remind you: you can best use a custom size for the whole page a mm or
inches as measures.

- Make good use of layers to switch between different layouts

- Group a set of lines that make up a piece of furniture. That way you
can easily shift them around

- Use the shortcut key to call the appropriate dialog (F4 for me) to
fine-tune dimensions, don't try to do that when drawing. It is more
cumbersome and less accurate.

- Make sure you begin drawing at the (0,0) coordinate. That'll make
things a lot easier.

HTH and have fun with Draw!

P.S. Draw is not the best tool for 3D mockups. You're better off with
SweetHome3D or Google Sketchup (it will run under Wine, if you are using
Linux).

Grx HdV


-- 
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] To run libreoffice arm

2012-06-13 Thread Mirosław Zalewski

On 13/06/2012 at 10:47, apple  wrote:

> hi，everyone：
>  I want to run libreoffice transplants to the arm, how can I do? thinks。

Perhaps the simplest way is to install Debian - there are already packages for 
ARM in repository.
There is official port to armel (http://www.debian.org/ports/arm/) and 
unofficial 
(it just means that it has not yet met quality criteria - you can expect some 
bugs and rough edges) port to armhf (http://wiki.debian.org/ArmHardFloatPort).

Although if you want to run LO on touchscreen device, it may be quite unusable 
because of user interface which was created with mouse and keyboard in mind.
-- 
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

[libreoffice-users] creating new master template

2012-06-13 Thread Bala subramanian

Hello,
If i have to design a new master slide and include it to the master
templates, how can i do it in Libreoffice power point.

Bala
-- 
C. Balasubramanian

-- 
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] To run libreoffice arm

Hi :)
Do you mean Arm as in a tablet, netbook or something?

I think there is a beta-testing or alpha-testing version around somewhere that 
would be well worth trying but i am not certain where it is.
Apols and regards from
Tom :) 


--- On Wed, 13/6/12, apple  wrote:

From: apple 
Subject: [libreoffice-users] To run libreoffice arm
To: users@global.libreoffice.org
Date: Wednesday, 13 June, 2012, 9:47

hi，everyone：
 I want to run libreoffice transplants to the arm, how can I do? thinks。

-- 
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] To run libreoffice arm

2012-06-13 Thread apple

hi，everyone：
 I want to run libreoffice transplants to the arm, how can I do? thinks。

-- 
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] Draw: an odd room, place labelled furniture?

Hi :)
Thanks for this idea too! :)  I have downloaded Dia onto one machine so that i 
can give it a go if i can't handle Draw.  Alex's idea also looks worth 
exploring but this was the fastest answer and is much appreciated.  

Ideally i would like to get Draw to do this so i will start with that.  If 
people can see increasing good uses for LibreOffice then they might reach for 
LO more.  It's always good to have a back-up plan and 2 back-up plans makes me 
feel safe.

Thanks Eric Johansson and Alex Thurgood :)
Many regards from
Tom :)  

--- On Tue, 12/6/12, Eric S. Johansson  wrote:

From: Eric S. Johansson 
Subject: Re: [libreoffice-users] Draw: an odd room, place labelled furniture?
To: users@global.libreoffice.org
Date: Tuesday, 12 June, 2012, 21:36

On 6/12/2012 4:24 PM, Tom Davies wrote:
> Hi :)
> Not sure if Draw is the right tool to use.
>
> My workplace is moving soon and i have taken measurements of the oddly shaped 
> big new room at the new place.  My first thought had been to make a 2d 
> paper-'model' and then use smaller bits of paper to represent furniture to 
> test-out different layouts.
>
> Could Draw be used to do this instead, reasonably easily?
> Regards from
> Tom :)
>
dia might be better

https://live.gnome.org/Dia

-- 
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] [gui-talk] FW: NVDA screen reader News: NVDA 2012.2.1 released (fwd)

2012-06-13 Thread Jude DaShiell




Jude 



-- Forwarded message --
Date: Tue, 12 Jun 2012 22:07:06
From: Humberto Avila 
Reply-To: "Discussion of the Graphical User Interface, GUI Talk Mailing List"

To: gui-t...@nfbnet.org, nf...@nfbnet.org, nfb-t...@nfbnet.org,
blind...@nfbnet.org, nab...@nfbnet.org, nfbwa...@nfbnet.org
Subject: [gui-talk] FW: NVDA screen reader News: NVDA 2012.2.1 released



-Original Message-
From: nvda-announce-boun...@lists.nvaccess.org
[mailto:nvda-announce-boun...@lists.nvaccess.org] On Behalf Of NVDA
announcement list
Sent: Tuesday, June 12, 2012 6:42 PM
To: NVDA announcement mailing list
Subject: NVDA screen reader News: NVDA 2012.2.1 released

NVDA 2012.2.1 has just been released. This release addresses several 
potential security issues (by upgrading Python to 2.7.3). Upgrading is 
recommended.

To read more or manually download, please visit:
http://www.nvda-project.org/blog/NVDA2012.2.1Released


Please consider donating to NV Access to support NVDA's continued
development:
http://www.nvaccess.org/wiki/Donate

--
This is the NVDA announcement mailing list.
To unsubscribe or edit your options, please visit:
http://lists.nvaccess.org/listinfo/nvda-announce


___
gui-talk mailing list
gui-t...@nfbnet.org
http://nfbnet.org/mailman/listinfo/gui-talk_nfbnet.org
To unsubscribe, change your list options or get your account info for gui-talk:
http://nfbnet.org/mailman/options/gui-talk_nfbnet.org/jdashiel%40shellworld.net


-- 
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: List and Combo boxes

Le 12/06/12 21:37, Andreas Säger a écrit :

Hi Andreas,


> In a combo box you "always" want:
> SELECT DISTINCT "Field" FROM "Table" ORDER BY "Field"
> 
> In a list box you "always" want:
> SELECT "Field or Concatenation", "Primary Key"
> FROM "Table"
> ORDER BY "Field or Concatenation"
> Bound field=1

I seem to recall having seen somewhere on the OOo dev lists that it
should now be possible to directly select Bound field=0, and still have
your sorted distinct data on the other data field, or have I muddled
things up ? This was part of the development that went into OOo3.4, but
perhaps it didn't make it into LO ?


Alex


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Draw: an odd room, place labelled furniture?