Hi :) Ahah! I knew I was missing something! :) Is there any chance of sending the spreadsheet to me? If there is a confidentiality issue then just say no.
I'm not clear about the exact details but it sounds similar to something I've used for something completely different. In my case a cash-book to keep track of cash (weirdly) instead of number of words. If I am correct then you have some numbers typed in somewhere; either in hidden(?) columns or rows or in a hidden tab or in an external data-source. The formulas then display notes, figures, totals or whatnot based on those typed figures. If you just delete the hard-coded (typed in) figures then the formulae should remain. Since it's a spreadsheet, rather than a database, some individual cells might not be exactly what they were meant to be but looking at the cells around will hopefully help you mend them. Copy&paste or dragging the little black cross from a neighbouring cell often fixes things neatly and Ctrl Z undoes if it just made things worse (or Edit - Undo etc). Somewhere in the menus there's an option to "display formulae". I suspect it's somewhere in; Tools - Options - Calc ? Am I getting warmer or am I further off on a different wild tangent? The mailing-list strips attachments off emails before sending the email off to everyone so if you just "reply to all", or whatever you did last time, then only I will get your attached spreadsheet. Regards from a Tom :) On Sun, 24 Feb 2019 16:40 Sharon Kimble <boudic...@skimble.plus.com wrote: > Tom Davies <tomc...@gmail.com> writes: > > > Hi :) > > I just click on the save button or on; > > > > File - Save As > > > > Job done. > > To clarify ... > > I have a spreadsheet of 5 tabs called 'word-count-antonine.ods' which I > would like to use as > a word-count template for future books that I intend to write. WCA starts > at Saturday July 28 2018 > with initial word counts which are then updated manually whenever I do > more writing. > > I would like to have this as a template with blank cells except they have > kept the functions from > the original spreadsheet, so that I can start with a new date and work > onwards from there and show > exactly the same information as in my original spreadsheet, but the new > one is now named for another > project. > > I have saved the WCA spreadsheet as a template, but it is still showing > exactly the same information in each cell as the original one was, whereas > I was hoping that the functions would remain but the cells appear blank. > > Does my original question make sense now please? > > Thanks > Sharon. > > > I'm not sure what the problem is. Is it that someone using Microsoft > Office can't see the file you have created? Microsoft is usually blind and > unable to cope with standards, even 'standards' of it's own devising. > Using LibreOffice, > > Google-docs, OpenOffice or any other office program you should be able > to easily see the file you created. > > > > With the File - Save As route a dialogue box pops up. Near the bottom > of the dialogue-box, just above it's own Save button, there is an option to > choose format. By default it says "All formats" but actually just saves it > in native > > .Ods format. Amongst the other formats it offers are the unreliable, > ever changing Microsoft formats such as .Xlsx and their older format .Xls. > There is also a format specifically for proper Templates, and an equivalent > for Microsoft > > Office templates. > > > > My old boss used to talk about making a template but he really meant > just a normal file, in an MS format, that he would then overwrite and > forget to keep an unfilled copy of anywhere. Having an actual proper > template would confuse him > > and he'd delete it. > > > > In much the same way he kept using the term "double entry" to mean a > mistake where someone had entered the same thing twice instead of using it > the way accountants and bookkeepers have been using it for the last several > hundred years. > > Presumably he thought an advert for a "double-entry bookkeeper" was > because companies were really keen to employ someone who made a LOT of > mistakes! > > > > If you really mean a proper template then Chapter 3 of the "Getting > Started Guide"; > > https://wiki.documentfoundation.org/Documentation/Publications > > (or scroll down further to Chapter 4 of the "Calc Guide") might help. > > > https://wiki.documentfoundation.org/images/8/83/GS6003-StylesAndTemplates.pdf > > > https://wiki.documentfoundation.org/images/e/e8/CG4104-StylesAndTemplates.pdf > > > > There are pre-made templates at; > > https://extensions.libreoffice.org/templates > > which you can adapt and use, or just use as they are, for free. > > > > Here's an extremely brief bit of help about templates; > > https://help.libreoffice.org/Writer/Creating_a_Document_Template > > but it's probably better to go with one (or both) of the chapters above > because they have a lot more information to skim through. > > > > Good luck and many regards from > > a Tom :) > > > > On Wed, 20 Feb 2019 at 17:52, Sharon Kimble <boudic...@skimble.plus.com> > wrote: > > > > I have a question which I can't find an answer to, how can I save a > calc spreadsheet as a template with all cells being blank, but still > retaining the functions within it please? > > > > Thanks > > Sharon. > > -- > -- > A taste of linux = http://www.sharons.org.uk > TGmeds = http://www.tgmeds.org.uk > DrugFacts = https://www.drugfacts.org.uk > Debian 9.8, fluxbox 1.3.7, emacs 26.1.91, org 9.2.1 > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy