Ask Your Question

How do I stop Calc saving all the data in a vlookup table thats located on another file when I close the document I'm working on? [closed]

asked 2015-06-28 17:52:32 +0200

ChuckW gravatar image

updated 2020-08-22 17:45:45 +0200

Alex Kemp gravatar image

I have a template setup in Calc that I use to create invoices. I use a table of data located on a separate file to generate the description and cost based on a unique number. When I save the invoice in ods format it saves all the data in the vlookup table with the file. How do I only save the imported data?

Thanks in advance for any assistance.

Best regards,

LibreOffice Ver., English, Calc.

MS Windows 7 Ultimate, English, 64-bit OS, AMD Phemon II X4 3.4 GHz, 12.0 GB

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-22 17:46:59.863680

2 Answers

Sort by » oldest newest most voted

answered 2015-06-28 23:06:21 +0200

Alex Kemp gravatar image

updated 2015-06-29 02:47:30 +0200

Are you certain that your 'template ' is actually correctly setup as a template? From your description it is actually acting as a standard file (it is possible to swap files & templates).

Added later:-

One obvious thing is to check that you have a template file setup for Calc. If you do:-

(menu):- File New Templates will get the Template Manager & should be able to see the templates available. I do not find any for Calc at all in my copy of LO.

It is certainly true that the idea is to have a Template file which in the background is copied on New-File-Open to become the actual file. However, if you are manually opening the Template file, then you are not actually creating a new file, are you?

Creating new Templates (PDF) (File Templates Save)

edit flag offensive delete link more

answered 2015-06-29 01:26:27 +0200

ChuckW gravatar image

Actually, no I'm not sure. I opened Calc and created what I wanted it to look like when sent to my customers and saved it with the ".ots" extension. I click to open it and fill in my data and when I save it, it automatically saves with a ".ods" extension. I thought when I selected "Save As" and choose "Template" it created the template.

Your assistance is appreciated. Thanks for taking the time to answer.

Best Regards

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-06-28 17:52:32 +0200

Seen: 96 times

Last updated: Jun 29 '15