Re: [libreoffice-users] no access to styles in calc
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 &c 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), &c. >> >> 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
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
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
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
