The last episode of the Calc series may answer your question. This was where I created a Template that had embedded styles, and it was called Billable Time. The idea was to have a sheet for each month, and each sheet had to have all of the same styles, fonts, and colors. So I created the first one the way I liked, then copied it 11 more times using the standard Ctrl+drag with the mouse.
Now, I know you are not happy with using a mouse for obvious reasons, so there is a series of keyboard commands to copy a sheet: Alt+E - This opens the Edit menu Alt+S Alt+S - You need to do this twice to get to the Sheet option Alt+M - This opens the Move/Copy dialog Alt+o - this selects Copy Alt+O - This says "OK" and creates your copy Now, so far I have not found a way to move a sheet using keyboard shortcuts, but I hope this is of some help to you. Regards, On 05/23/2015 10:12 AM, Mike Ray wrote: > Hello folks, > > My word it's quiet on here. > > Since I was all over Ahuka's tutorials like a rash a few weeks ago and > since I have developed a business imperative for using it, I have been > doing a lot of LibreOffice Calc. A great departure for me since any > mention of words like 'equity', 'percentage' or 'investment' usually > make my brain freeze over and shut up like a clam. > > I now have a question that either Kevin or somebody else might be able > to answer... > > I have a template for a spreadsheet which has one sheet with > pre-formatted heading and column headings, as well as pre-formatted > styles for a number of columns. I have taken the comments in the > tutorials about templates, which Kevin rightly hammers very hard into > our brains to heart. > > What I want to be able to do is add a sheet and have it created with the > same pre-formatted cells as the first and original sheet on the template. > > Is this possible and how do I do it? > > Mike > -- Kevin B. O'Brien [email protected] http://google.me/+kevinobrien There's a difference between tempting fate and giving it a lap dance. _______________________________________________ Hpr mailing list [email protected] http://hackerpublicradio.org/mailman/listinfo/hpr_hackerpublicradio.org
