At 20:21 26/03/2017 -0400, Vince Bonly wrote:
On 3/26/2017 1:34 PM, Brian Barker wrote:
I wonder if you may be thinking that "opening a template" means
something different from starting a new document based on that template?
Well, yes. Usually, I open the existing template in the editing
mode, using File | Templates | Edit. I don't think of it initially
as being a "new document"; rather, as an opened template file, ready
for editing. Subsequent to making required revisions, the work is
saved as a filename.ods, i.e., a saved (new) CALC document.
Aha! Yes, indeed: opening a template that way for editing is indeed
different. But for what it's worth, I find that I can open an
existing spreadsheet document and a spreadsheet template for editing
in either order with any problem and without either disappearing.
I am looking at a spreadsheet file and at the very top of screen I
see the filename with an ".ods " extension followed by a hyphen and
then "OpenOffice Calc".
Often, I have an existing Calc.ods spreadsheet and decide that I
will need similar calculations in the future. So, I first
right-click in the cell(s) to "Delete Contents", as needed. I am in
the habit of filling those cells that require my manually inputted
data with, for example, Yellow to make them more noticeable. Then
save the result as a template, using File | Templates | Save.
So far, so good.
Then when I next need to do some work, I open the template (.ots)
file "/for editing/"; enter new data and save the work as a CALC
file with an appropriate filename.ods. This workflow works for me.
But you are rather missing the point of templates if you do this.
o You could just as easily use an ordinary document to have the same effect.
o If you Save the new data instead of remembering to Save As...
(we've all done it), you will modify the template, which you don't
want to do. If you close the document and respond to the challenge
that yes, you do want to keep your changes, again you will have
modified the template. If you instead open the template normally -
which is surely easier? - you are protected from these simple errors
by being obliged to use Save As... . I don't know why you would
choose to disable these protections.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
