Thank you for the message!
I tried this approach some time ago. There were several problems with
DDE links. First of all links are stored as absolute paths, so I can't
move source file or I have to edit path every time. It could be nice if
writer would look for linked files in the directory, where the text file
is located, if it can't found linked file according to the absolute path
(this is implemented in autocad). Another problem is that DDE links
doesn't recognize source formatting and special characters are displayed
in wrong way. If I have m³ in every table, it's useless if I can't keep
them.
But, in general, I testing if those DDE links are working in good way
with every new ooo version, it's promising function :)
Sincerely,
Andis
Brian Barker wrote:
At 19:31 02/11/2008 +0200, Andis Noname wrote:
I have water supply feasibility study model in calc with about 40
reporting tables, which I have to copy to writer document, which is
actually feasibility study report. At the moment the only reasonable
way for me is to copy -> paste table by table from calc to writer
template with paste special -> rtf or html and to apply text and
table formatting elements to every table separately. It is very time
consuming.
Is there any way to copy content of cells in calc to existing tables
in writer, like in ms excel -> word, keeping formatting elements of
the writer tables?
No: I cannot see any easy way to do what you ask. But I can tell you
how to achieve what you need.
Instead of creating tables in your text document, simply copy the
relevant areas from your spreadsheet and then use Edit | Paste
Special... (or Ctrl+Shift+V) in Writer, selecting "DDE link" from the
available options. This will create the required tables for you.
Format the resulting tables in the text document only when you have
done this. Now, when you modify the spreadsheet, your report will
update appropriately, keeping the formatting that you have applied in
the report. If you have both documents open and the report happens
not to update, you can force it to by going to Tools | Update> |
Links. Creating reports from spreadsheets in this way is exactly what
linking documents is useful for.
If you wish to preserve a version of the report before you make
further changes to the spreadsheet, save a copy of the report and then
go to Edit | Links... and click Break Link for each relevant link *in
that saved copy*. This preserves the current values but breaks the
connection to the spreadsheet.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
