Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

[Alanon SR3]

thank you Bruce.

I have the Query setup as well as the stand alone or unbound form with the
listbox in it.

I find a way to get the form to execute the Query.  In the controls window,
I am finding where actions can trigger, but it only appears to allow me to
add macros...I can't type anything in the text boxes next to the event
items.  I've also tried adding a push button hoping a wizard would come up
to build the action...no such luck.

I'd prefer not typing in all 12+ categories in the Query criterion field as
more categories will be added in the future on an as-needed basis.  Plus
some are rather longly named.

Can you or anyone assist with getting a form to execute a query?  The
"help" was more like a dictionary than a how-to.

thank you in advance,
alanon

On Aug 27, 2016 6:31 PM, "Bruce Hohl"  wrote:

> > What would I need to write as a criteria so that when the QUERY is run,
> it
> prompts the user to select from a listbox
>
> You must create a form to use the List Box control.  If you really only
> need a query you can add the choices to the query parameter name.  For
> example: SELECT "F1", "F2" FROM "Table1" WHERE "F1" =
> :enter_dog_cat_or_bird (see simple attached example).
>
> From the installed help see: Contents > Database Functionality > General
> Information > Working with Queries (Query Design / Parameter queries) and
> Working with Forms (Form Controls / List Box).
>
>
> On Sat, Aug 27, 2016 at 3:14 PM, alanon  wrote:
>
>> Hi,
>> Thank you in advance for your help!
>> I'm trying to build a query that would list the records in a database
>> where
>> the user selects from an existing list of categories.
>>
>> IE
>> there are 12 existing categories, each with a bunch of records.
>> the user wants to review just the records under the category "gas", but he
>> doesn't know that exact category name so he needs a listbox to show his
>> existing categories to select from.
>>
>> What would I need to write as a criteria so that when the query is run, it
>> prompts the user to select from a listbox so he can review the records for
>> that said category?
>>
>> Thank you.
>> Alanon
>>
>>
>>
>> --
>> View this message in context: http://nabble.documentfoundati
>> on.org/libreoffice-base-building-query-need-help-with-
>> input-parameter-development-tp4191909.html
>> Sent from the Users mailing list archive at Nabble.com.
>>
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
>> ubscribe/
>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>> List archive: http://listarchives.libreoffice.org/global/users/
>> All messages sent to this list will be publicly archived and cannot be
>> deleted
>>
>>
>

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

Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

[Bruce Hohl]

> What would I need to write as a criteria so that when the QUERY is run, it
prompts the user to select from a listbox

You must create a form to use the List Box control.  If you really only
need a query you can add the choices to the query parameter name.  For
example: SELECT "F1", "F2" FROM "Table1" WHERE "F1" =
:enter_dog_cat_or_bird (see simple attached example).

From the installed help see: Contents > Database Functionality > General
Information > Working with Queries (Query Design / Parameter queries) and
Working with Forms (Form Controls / List Box).


On Sat, Aug 27, 2016 at 3:14 PM, alanon  wrote:

> Hi,
> Thank you in advance for your help!
> I'm trying to build a query that would list the records in a database where
> the user selects from an existing list of categories.
>
> IE
> there are 12 existing categories, each with a bunch of records.
> the user wants to review just the records under the category "gas", but he
> doesn't know that exact category name so he needs a listbox to show his
> existing categories to select from.
>
> What would I need to write as a criteria so that when the query is run, it
> prompts the user to select from a listbox so he can review the records for
> that said category?
>
> Thank you.
> Alanon
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/
> libreoffice-base-building-query-need-help-with-input-
> parameter-development-tp4191909.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

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

Re: [libreoffice-users] Save button

[jorge]

Hi:

As I understand, it depends of the Theme and Icon Style that you have
installed in your LO:

Menu-> Tools-> Options-> View-> User Interface-> Theme and Icon Style

For example:

In my Ubuntu 16.04 LTS->LibreOffice 5.1.4.2-> Style Oxygen-> Icon is a
Diskete with Asterisk white with Border green.

In my Ubuntu 16.04 LTS->LibreOffice 5.1.4.2-> Style Galaxy-> Icon is a
Diskete with a little Asterisk white with Border orange.

In my Ubuntu 16.04 LTS->LibreOffice 5.1.4.2-> Style Human-> Icon is a
Hard Disk with an arrow pointing down but when something is changed in
the spreadsheet, it turns to Diskete with Asterisk white with Border
green. Then, after save, it change again to Hard Disk.

I hope this help,

Regards,

Jorge Rodríguez


El sáb, 27-08-2016 a las 15:00 -0400, Virgil Arrington escribió: 
> 
> On 8/27/2016 1:50 PM, M Henri Day wrote:
> > Om my 64-bit Linux Mint 18 system with the Cinnamon desktop, when 
> > running LO Version: 5.2.1.1, I don't observe any changes to the save 
> > button after a document has been saved.​ ​But perhaps I'm looking in 
> > the wrong place ?... Henri 
> 
> I wonder how much of this is the result of the operating system. On my 
> Windows 10 system with LO 5.1.4.2, I get a white star on a green circle 
> green starburst on the save button, which is an icon of an old floppy 
> disk on my toolbar. So, I've seen three different results as follows:
> 
> Windows 10, LO 5.1.4.2 -- White star on green circle on the floppy disk 
> save icon
> Ubuntu 16.04 LTS, Unity Desktop, LO 5.1.5.2 -- A small red dot on the 
> floppy disk save icon (the Unity floppy disk icon is more of a line 
> drawing than a full color icon)
> Ubuntu 16.04 LTS, Gnome Desktop, LO 5.1.5.2 -- A yellow starburst on the 
> floppy disk save icon
> 
> Regardless of my system setup, I'm getting a distinguishing mark on a 
> file once I've changed it from the version previously saved.
> 
> Virgil
> 

-- 
Atentamente,

Jorge Rodríguez


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

[libreoffice-users] libreoffice base: building query, need help with input parameter development

[alanon]

Hi,
Thank you in advance for your help!
I'm trying to build a query that would list the records in a database where
the user selects from an existing list of categories.

IE
there are 12 existing categories, each with a bunch of records.
the user wants to review just the records under the category "gas", but he
doesn't know that exact category name so he needs a listbox to show his
existing categories to select from.

What would I need to write as a criteria so that when the query is run, it
prompts the user to select from a listbox so he can review the records for
that said category?

Thank you.
Alanon



--
View this message in context: 
http://nabble.documentfoundation.org/libreoffice-base-building-query-need-help-with-input-parameter-development-tp4191909.html
Sent from the Users mailing list archive at Nabble.com.

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

Re: [libreoffice-users] Save button

[Virgil Arrington]

On 8/27/2016 1:50 PM, M Henri Day wrote:
Om my 64-bit Linux Mint 18 system with the Cinnamon desktop, when 
running LO Version: 5.2.1.1, I don't observe any changes to the save 
button after a document has been saved.​ ​But perhaps I'm looking in 
the wrong place ?... Henri 


I wonder how much of this is the result of the operating system. On my 
Windows 10 system with LO 5.1.4.2, I get a white star on a green circle 
green starburst on the save button, which is an icon of an old floppy 
disk on my toolbar. So, I've seen three different results as follows:


Windows 10, LO 5.1.4.2 -- White star on green circle on the floppy disk 
save icon
Ubuntu 16.04 LTS, Unity Desktop, LO 5.1.5.2 -- A small red dot on the 
floppy disk save icon (the Unity floppy disk icon is more of a line 
drawing than a full color icon)
Ubuntu 16.04 LTS, Gnome Desktop, LO 5.1.5.2 -- A yellow starburst on the 
floppy disk save icon


Regardless of my system setup, I'm getting a distinguishing mark on a 
file once I've changed it from the version previously saved.


Virgil

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

Re: [libreoffice-users] Re: Overly aggressive autoformatting issues in LibreOffice

[Virgil Arrington]

On 8/27/2016 6:42 AM, william drescher wrote:
Unless things have changed a lot since I did research, the data in the 
spreadsheet was not typed by the researcher.  It was probably typed by 
an undergraduate work-study student or, at best, a harried 
departmental secretary.


Brian, love the umbrella metaphor.

-bill



Which illustrates one of the ongoing characteristics of office suites. 
They offer many so different methods of accomplishing a task that a user 
just wanting to get work done has to first invest what seems to be an 
unreasonable effort into learning how to most effectively use his/her 
tool. And, heaven forbid if the gene researcher and department secretary 
mix and match their respective methods into the same document/spreadsheet.


I can understand why a gene researcher, or a department secretary for a 
gene researcher, might prefer to focus their energy on gene research 
rather than office suite research.


Virgil

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

Re: [libreoffice-users] Save button

[M Henri Day]

2016-08-26 23:18 GMT+02:00 Virgil Arrington :

> I should have clarified that is with the Gnome desktop. When using the
> Unity desktop, I see a small red dot on the save icon. Either way, the save
> icon changes when a change is made to a document.
>
> Virgil
>
> On 08/26/2016 03:12 PM, Virgil Arrington wrote:
>
>> On my system, Ubuntu 16.04 and LO 5.1.5.2, the save button doesn't get
>> greyed out, but when I make a change to the file, a yellow starburst
>> appears on the disk image in the save button. It's not as obvious as a
>> greyed out icon, but, once learned, it is noticeable.
>>
>> Virgil
>>
>> On 08/26/2016 02:19 PM, CLOSE Dave wrote:
>>
>>> In the past, when I saved a document and hadn't yet made additional
>>> changes, the "save" button was grayed out. This let me know that I had
>>> done the save and avoided doing so redundantly. With the most recent
>>> versions (I have 5.1.5.2-3 for Fedora 24), that doesn't seem to be true
>>> any more. Why not? Can this be fixed?
>>>
>>
​Om my 64-bit Linux Mint 18 system with the Cinnamon desktop, when running
LO Version: 5.2.1.1, I don't observe any changes to the save button after a
document has been saved.​

​But perhaps I'm looking in the wrong place ?...

Henri

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

Re: [libreoffice-users] Raised Caps Paragraph Style

[Ricardo]

El 2016-08-27 16:34, Dave escribió:

Hi Folks,

Does anyone know how to create a paragraph style with the first letter
in "Raised Caps". Not sure that "Raised Caps" is the correct
terminology, but it is essentially the opposite of "Drop Caps". eg. A
paragraph begins with the word "The" and the base line of the enlarged
letter "T" remains level with the base line of the letters "he" and the
rest of the words on the first line.

I know the work-around is to create a suitable character style and 
apply

that to the letter "T", but I am training a small group of authors to
use Writer styles and they want to know why it is so easy to have a
paragraph style with "Drop Caps", but requires a work-around for 
"Raised

Caps".

I might of missed it, but I can't find a RFE for this in Bugzilla.

TIA

Dave

--
Please address any reply to the mailing list only. All messages to this
noreply address are automatically deleted from the server and will 
never

be read.


AFAIK, the simplest way to obtain what you need is through the 
workaround you found. And the reason why this option does not exists 
(yet) is maybe that nobody thought about it, so go ahead and create a 
Bugzilla ticket! :)


Maybe the drop caps feature could be extended to accept a negative 
number of lines so the cap get raised?


Regards,
Ricardo

--
Il mio blog in italiano: https://ilpinguinoscrittore.wordpress.com/
Mi blog en español: https://elpinguinotolkiano.wordpress.com/

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

[libreoffice-users] Raised Caps Paragraph Style

[Dave]

Hi Folks,

Does anyone know how to create a paragraph style with the first letter
in "Raised Caps". Not sure that "Raised Caps" is the correct
terminology, but it is essentially the opposite of "Drop Caps". eg. A
paragraph begins with the word "The" and the base line of the enlarged
letter "T" remains level with the base line of the letters "he" and the
rest of the words on the first line.

I know the work-around is to create a suitable character style and apply
that to the letter "T", but I am training a small group of authors to
use Writer styles and they want to know why it is so easy to have a
paragraph style with "Drop Caps", but requires a work-around for "Raised
Caps".

I might of missed it, but I can't find a RFE for this in Bugzilla.

TIA

Dave

-- 
Please address any reply to the mailing list only. All messages to this
noreply address are automatically deleted from the server and will never
be read.

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

[libreoffice-users] Re: Overly aggressive autoformatting issues in LibreOffice

[william drescher]

On 8/26/2016 12:18 PM, M Henri Day wrote:

ttps://www.washingtonpost.com

/news/wonk/wp/2016/08/26/an-alarming-number-of-scientific-
papers-contain-excel-errors/


Unless things have changed a lot since I did research, the data 
in the spreadsheet was not typed by the researcher.  It was 
probably typed by an undergraduate work-study student or, at 
best, a harried departmental secretary.


Brian, love the umbrella metaphor.

-bill



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