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]
