On 3/26/2017 1:34 PM, Brian Barker wrote:
At 12:52 26/03/2017 -0400, Vince Bonly wrote:
AOO 4.1.3 (AOO413m1(Build:9783) - Rev. 1761381
2016-09-29 02:39:19) on Windows 10 desktop.
Whenever I already have a Calc file (.ods) opened, it seems that I am
not allowed to open an existing Calc template file (.odt).
Typo; should have entered "Calc template file (.ots). " as you have
indicated.
Hold on: .odt files are text document files; spreadsheet templates are
.ots.
You are correct, of course.
And I don't see this. If I have one spreadsheet document open and open
a spreadsheet template, I have two documents open: the original
spreadsheet and a new untitled, unsaved spreadsheet document based on
the template. That's what I'd expect.
OTOH, if a template is already opened, I am able to open a Calc file.
This, if anything, is the situation you might query. If you start a
new, empty document (of any type) and, before making any entries, open
an existing document, OpenOffice thinks you don't want the empty
document and abandons it. Exactly the same applies if you open a
template - which, after all, is just another way to start an unused,
unsaved document, albeit one with properties defined in the template.
If you start work on your new empty document (however little you do)
it will not be abandoned.
Hmm... It may very well be that I attempted to open a template prior
to making any entries/changes to the already opened Calc spreadsheet. I
will retry again with addition of a word or formula into a cell and see
if there is still an issue here.
Please advise how a template file can be opened while having a calc
spreadsheet already opened.
This is the sequence that you can do perfectly normally.
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.
I trust this helps.
Brian Barker
Brian:
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. 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.
VinceB.
