Re: [libreoffice-users] no access to styles in calc

[Bruce Hohl]

Format > Styles > Styles and Formatting (or F11 by default as mentioned)

If you do not want spreadsheet headers & footers by default you can create
a template without headers & footers and set that as your default template.

On Thu, Mar 16, 2017 at 4:21 PM, Steve Edmonds 
wrote:

> Header and footer are in Format>Page.
> What version of Libreoffice. My F11 works ok in 5.2 and has done all the
> way up to 5.2. Can't remember 5.3 as I went back because of a PDF
> generation bug.
> Steve
>
>
> On 2017-03-17 08:10, marianne-x wrote:
>
>> List Ahoy:
>>
>> This is mostly a low-priority enquiry, rather than one of serious
>> aggrevation.
>>
>> Gaining access to “Styles & Formatting” via F11, and the alternatives,
>> works as expected in Writer.
>>
>> But not so in Calc. F11 produces no visible result; alt-O/Y likewise;
>> mouse selection of Format/“Styles and Formatting” is equally inactive.
>>
>> Is there some control somewhere that I have missed, that blocks access to
>> this function?
>>
>> The reason for exploring these nether regions: in Calc, the apparent
>> default is to enable Headers and Footers. I have to say “apparently” since
>> I can't bring up the Styles  window to see what style is being applied.
>>
>> I want those two additions (header/footer) turned off by default, as they
>> are in Writer, and if I had access to the default Page style control I
>> would change the default page margins also.
>>
>> Curtains 7 — Version: 4.4.7.2
>>
>> Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600
>>
>> Locale: en_GB
>>
>> The above data was copied from “About — Libreoffice”, and that “en_GB”
>> gives a bit of pause. Everything seems to function as expected for a USA
>> locale, and we certainly never deliberately changed the locale.
>>
>> Indeed, “Options — Language Settings — Languages” shows:
>>
>> User interface: Default – English (USA)
>>
>> Locale setting: English (USA), 
>>
>> There is no apparent deleterious effect, but the appearance of “en_GB”
>> remains an unexplained oddity.
>>
>>
>> for: Miss Keating
>>
>>
>>
>
> --
> 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] Re: Wanted: KB shortcut to Calc Name Box

[Bruce Hohl]

Regina & Stuart,  Many thanks.  I did not expect the name of this function
to be "Sheet Area Input Field".  The ease and flexibility of creating LO
Keyboard shortcuts is an outstanding feature that enhances my
productivity.  BH

On Fri, Mar 17, 2017 at 10:19 AM, V Stuart Foote 
wrote:

> It already exists:
>
> +F5  or +T
>
> But if you want to use the F3 key it is available to be assigned from the
> Customize dialog, Keyboard tab
>
> Category -- Application
> Function -- Sheet Area Input Field
>
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/Wanted-
> KB-shortcut-to-Calc-Name-Box-tp4210407p4210412.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

[libreoffice-users] Re: Wanted: KB shortcut to Calc Name Box

[V Stuart Foote]

It already exists:

+F5  or +T

But if you want to use the F3 key it is available to be assigned from the
Customize dialog, Keyboard tab

Category -- Application
Function -- Sheet Area Input Field




--
View this message in context: 
http://nabble.documentfoundation.org/Wanted-KB-shortcut-to-Calc-Name-Box-tp4210407p4210412.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

[libreoffice-users] Wanted: KB shortcut to Calc Name Box

[Bruce Hohl]

In Calc I would like to set F3 as a KB shortcut which moves the focus to
the "Name Box" (1st control on formula bar).  This would provide navigation
equivalent to a 'go to cell' command which would be useful for my very
large spreadsheets (without having to reach for the mouse).  I don't see an
option for that under Tools > Customize > Keyboard.  Does anyone know if
such a KB shortcut can be set?

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