[libreoffice-users] Shortcut change to display data source browser in Calc

2015-10-17 Thread Alexander Thurgood
Hi all Base users,

It seems the design team have taken it upon themselves to change the
shortcut for displaying the data source browser in Calc, you can read up
on the issue here :

https://bugs.documentfoundation.org/show_bug.cgi?id=59418

and comment on it as you deem fit.

Needless to say, this change makes Writer and Calc have two different
shortcuts.

Calc (quote from design irc) : "it has been changed already, it is now
CTRL+SHIFT+F4 in calc"

Writer : F4

so much for application suite consistency, and documentation, and what
the hell...
-- 
Alex Thurgood
Intellectual Property Attorney
IP GALORE
4 rue Durette
F-63500 BRENAT
FRANCE

Mobile : +33 6 40 59 99 16
Fax : +33 4 5680 9558
E-mail :
alex.thurg...@gmail.com
alex.thurg...@ipgalore.eu


CONFIDENTIAL & PRIVILEGED

The information in communications issued by the sender is confidential
and privileged. If you are not the intended recipient of the
communication, you are not authorised to visualise, display, save,
print, copy or otherwise reproduce, transfer or modify said
communication without express agreement from the sender. Any erroneous
reception should be indicated to the original sender and the original
communication subsequently destroyed.

-- 
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: How to.. sort a table in 3 columns

2015-10-17 Thread william drescher

On 10/16/2015 4:13 PM, Gary Dale wrote:

On 16/10/15 04:02 PM, william drescher wrote:

I have a list that has two fields: aisle and item.  I need to
maintain the list sorted by item, but print a pick list by
aisle.  This would be simple except, when I print the list for
marking I need to print it in item order, in 3 columns.  When I
print the pick list I again need to print it in 3 columns,
sorted by item,

Right now I am sorting the list by aisle and manually cutting
and pasting it into 3 columns.  I currently have the data in a
spreadsheet.

I tried using frames set for 3 columns, but when past the
sorted list into the frames it does not spill over onto the 2nd
and 3rd columns.

I would appreciate suggestions.

Thanks,

bill



1) Create a custom Writer document with the fields you want printed.
2) attach the spreadsheet to Base. Create a query that meets your
sort/selection requirements.
3) print the document as a form letter.




I have never used the form letter generator.  Will it allow 1..n 
rows?


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


[libreoffice-users] Re: Tooo many messages on this mailing list?? How to avoid being swamped ...

2015-10-17 Thread Andreas Säger
Am 16.10.2015 um 18:45 schrieb anne-ology:
>curiously wondering what gmane is ...
>   curiously wondering what else I'll be a-learnin' today ...
>  curiously wondering what the newest computer gadget'll be ...
> curiously wondering ... curiously wondering ... curiously
> wondering  ;-)
> 
>very interesting indeed;
>   and remember'g how file folders expanded to hold letters by same
> case ...
>  ah, times ... they've been a-changin'  ;-)
> 
> 
> 

Mailing lists and aggregators are tools of the 90ies. Almost forgotten
in the twitter age.



-- 
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: How to.. sort a table in 3 columns

2015-10-17 Thread Andreas Säger
Am 16.10.2015 um 22:02 schrieb william drescher:
> I have a list that has two fields: aisle and item.  I need to maintain
> the list sorted by item, but print a pick list by aisle.  This would be
> simple except, when I print the list for marking I need to print it in
> item order, in 3 columns.  When I print the pick list I again need to
> print it in 3 columns, sorted by item,
> 
> Right now I am sorting the list by aisle and manually cutting and
> pasting it into 3 columns.  I currently have the data in a spreadsheet.
> 
> I tried using frames set for 3 columns, but when past the sorted list
> into the frames it does not spill over onto the 2nd and 3rd columns.
> 
> I would appreciate suggestions.
> 
> Thanks,
> 
> bill
> 
> 

Operating system?
Office version?
Office component? Writer? Calc? Base?
File format? doc, docx, odt, ods, xls, odb?
I don't understand how you want to dump 2 fields into 3 columns?
The term "pick list" is unclear. Listbox? Writer field of type "input list"?

Let's try to rephrase:
Using LibreOffice 5.0.2, I have a spreadsheet (*.ods) with a 2-column
list of item names and aisles numbers.
How can I include a properly sorted version of that list with a 3rd
column of ... in a Writer document?



-- 
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] Shortcut changes

2015-10-17 Thread James E. Lang
Thank you Alex for bringing up the topic of shortcut changes.

I guess there is no gate keeper WRT shortcut assignments in LO.

I am not a user of Base but I am a frequent user of Calc. Shortcut changes are 
extremely disruptive for users. My least favorite (most detested!!) such change 
occurred in version 4.4 of Calc when Alt+E,I was assigned to a brand new menu 
item in place of "Fill."

PLEASE, developers, think about the impact your change will have on existing 
users. Then if you deem the change IMPORTANT enough to be warranted make 
certain that A) any replaced usage of the shortcut is assigned a new SUITABLE 
replacement, B) the changed shortcut is applied universally wherever the 
functionality exists in any module of LO, and most importantly C) the changed 
shortcut is PROMINENTLY advertised, preferably several months in advance, with 
comments solicited and carefully considered. The longer a shortcut has existed 
the more attention should be given should be given to the impact of changing it 
with shortcuts that have existed for more than one full major release being 
ALMOST cast in granite. Developers should not operate in a tyrannical manner. 
They are talented and greatly appreciated but they are not omniscient gods.

-- 
Jim

-Original Message-
From: Alexander Thurgood 
To: "users@global.libreoffice.org" 
Sent: Sat, 17 Oct 2015 10:09
Subject: [libreoffice-users] Shortcut change to display data source browser in 
Calc

Hi all Base users,

It seems the design team have taken it upon themselves to change the
shortcut for displaying the data source browser in Calc, you can read up
on the issue here :

https://bugs.documentfoundation.org/show_bug.cgi?id=59418

and comment on it as you deem fit.

Needless to say, this change makes Writer and Calc have two different
shortcuts.

Calc (quote from design irc) : "it has been changed already, it is now
CTRL+SHIFT+F4 in calc"

Writer : F4

so much for application suite consistency, and documentation, and what
the hell...
-- 
Alex Thurgood
Intellectual Property Attorney
IP GALORE
4 rue Durette
F-63500 BRENAT
FRANCE

Mobile : +33 6 40 59 99 16
Fax : +33 4 5680 9558
E-mail :
alex.thurg...@gmail.com
alex.thurg...@ipgalore.eu


CONFIDENTIAL & PRIVILEGED

The information in communications issued by the sender is confidential
and privileged. If you are not the intended recipient of the
communication, you are not authorised to visualise, display, save,
print, copy or otherwise reproduce, transfer or modify said
communication without express agreement from the sender. Any erroneous
reception should be indicated to the original sender and the original
communication subsequently destroyed.

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