[opensuse] Simple OO question about combining a cover letter and a spreadsheet?
All, I want to create multi-format document. The first page or two would be cover letter. The later pages would be spreadsheets. Can that done in OO? Can it be exported into a MS Office supported combined doc? (Its been a while since I did this even in MS, but I assume MS still supports it.) Thanks Greg -- Greg Freemyer Litigation Triage Solutions Specialist http://www.linkedin.com/in/gregfreemyer First 99 Days Litigation White Paper - http://www.norcrossgroup.com/forms/whitepapers/99%20Days%20whitepaper.pdf The Norcross Group The Intersection of Evidence & Technology http://www.norcrossgroup.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Greg Freemyer wrote:
All,
I want to create multi-format document.
The first page or two would be cover letter. The later pages would be spreadsheets.
Can that done in OO?
I'm pretty certain it can, but I haven't tried it. -- /Per Jessen, Zürich -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Friday, 2009-01-02 at 12:18 -0500, Greg Freemyer wrote:
I want to create multi-format document.
The first page or two would be cover letter. The later pages would be spreadsheets.
Can that done in OO?
Perhaps... create a text document, then on the second page insert ole object. Or, same thing, but link to existing file.
Can it be exported into a MS Office supported combined doc?
No idea. - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (GNU/Linux) iEYEARECAAYFAklejOwACgkQtTMYHG2NR9UINQCeMJL5/lK52O+o6kqOAc5NwCFR zBoAnRt349Xbk9F5Kev1g1p+S6oLHa/B =k5Yk -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Greg Freemyer wrote:
All,
I want to create multi-format document.
The first page or two would be cover letter. The later pages would be spreadsheets.
Can that done in OO?
I have done this with OO by OLE linking to spreadsheets. However, there are a number of subtle gotchas (as in M$ but different ones exist in M$. I have a bugzilla still extant about a formatting issue in OO with such an import). The only environment which I have worked with that did this consistently with minimum grief was Lotus.... There are a number of ways of linking a spreadsheet to a document in OO some dynamic, some not, all have different pluses and minuses. I would suggest experiment to find the method that suits your requirements. If you are talking about M$ ability to include an embedded spreadsheet OO does have this capability. I have run into problems with this arranging largish spreadsheet layouts, so only make use of it for fairly trivial calculations.
Can it be exported into a MS Office supported combined doc?
Never tried this. I think the major issue here is if the documents are linked dynamically then not only would the main document need to be converted, but any linked spreadsheets. I would suspect this would would work if the spreadsheet was fairly basic. I would be intrigued to find out how well this works. The other problem was portability with dynamically linked documents, I seem to remember issues with paths of required dynamically linked documents causing problems on occasions.
(Its been a while since I did this even in MS, but I assume MS still supports it.)
Thanks Greg
- -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iEYEARECAAYFAklfNBoACgkQasN0sSnLmgJzfACfeqoZdHjlcUNbN3HeETmdg4TD WIUAn3pOMFKJfEu85ZJW8iF2giscALNl =VFW7 -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
2009/1/3 G T Smith <grahamsmith@gandalfsemporium.homelinux.com>:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Greg Freemyer wrote:
All,
I want to create multi-format document.
The first page or two would be cover letter. The later pages would be spreadsheets.
Can that done in OO?
I have done this with OO by OLE linking to spreadsheets.
However, there are a number of subtle gotchas (as in M$ but different ones exist in M$. I have a bugzilla still extant about a formatting issue in OO with such an import). The only environment which I have worked with that did this consistently with minimum grief was Lotus....
There are a number of ways of linking a spreadsheet to a document in OO some dynamic, some not, all have different pluses and minuses. I would suggest experiment to find the method that suits your requirements.
If you are talking about M$ ability to include an embedded spreadsheet OO does have this capability. I have run into problems with this arranging largish spreadsheet layouts, so only make use of it for fairly trivial calculations.
Can it be exported into a MS Office supported combined doc?
Never tried this. I think the major issue here is if the documents are linked dynamically then not only would the main document need to be converted, but any linked spreadsheets. I would suspect this would would work if the spreadsheet was fairly basic. I would be intrigued to find out how well this works.
The other problem was portability with dynamically linked documents, I seem to remember issues with paths of required dynamically linked documents causing problems on occasions.
I do not think M$ would support a combined document but to get around that, create the document in OO, convert to PDF and then send to the M4 folk. Portable Document Format to the rescue :) Regards Hylton -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Check out this website, Greg. http://www.linux.com/feature/36815 It talks about 3 diffferent tools to combine PDFs, including pdfsam. I personally used GhostScript last time I had to do it on Windows, since I have it installed already. But it seems as if pdfsam is easier... Allen Zhu allen.jaloola@gmail.com Eddie Izzard - "I grew up in Europe, where the history comes from." On Sat, Jan 3, 2009 at 11:41 AM, Hylton Conacher (ZR1HPC) <hyltonconacher@gmail.com> wrote:
2009/1/3 G T Smith <grahamsmith@gandalfsemporium.homelinux.com>:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Greg Freemyer wrote:
All,
I want to create multi-format document.
The first page or two would be cover letter. The later pages would be spreadsheets.
Can that done in OO?
I have done this with OO by OLE linking to spreadsheets.
However, there are a number of subtle gotchas (as in M$ but different ones exist in M$. I have a bugzilla still extant about a formatting issue in OO with such an import). The only environment which I have worked with that did this consistently with minimum grief was Lotus....
There are a number of ways of linking a spreadsheet to a document in OO some dynamic, some not, all have different pluses and minuses. I would suggest experiment to find the method that suits your requirements.
If you are talking about M$ ability to include an embedded spreadsheet OO does have this capability. I have run into problems with this arranging largish spreadsheet layouts, so only make use of it for fairly trivial calculations.
Can it be exported into a MS Office supported combined doc?
Never tried this. I think the major issue here is if the documents are linked dynamically then not only would the main document need to be converted, but any linked spreadsheets. I would suspect this would would work if the spreadsheet was fairly basic. I would be intrigued to find out how well this works.
The other problem was portability with dynamically linked documents, I seem to remember issues with paths of required dynamically linked documents causing problems on occasions.
I do not think M$ would support a combined document but to get around that, create the document in OO, convert to PDF and then send to the M4 folk. Portable Document Format to the rescue :)
Regards Hylton -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hylton Conacher (ZR1HPC) wrote:
2009/1/3 G T Smith <grahamsmith@gandalfsemporium.homelinux.com>:
I do not think M$ would support a combined document but to get around that, create the document in OO, convert to PDF and then send to the M4 folk. Portable Document Format to the rescue :)
Regards Hylton
Yep, that works if you want a static end product. However, in that case it is just as easy paste to spreadsheet contents as tables into document and send as a static word document. However, if the spreadsheet contents are expected to change, and be used in more than one document or location (and/or you want to collaborate on the numbers) this does not work well. - -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iEYEARECAAYFAklh3UQACgkQasN0sSnLmgKTZACgwOamhhYTW9Z9KvzTRPskN0cL 7GcAoOFOb83qq2tYLaSO5erZZ1ra/V/c =yMKI -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (6)
-
Allen Zhu -
Carlos E. R. -
G T Smith -
Greg Freemyer -
Hylton Conacher (ZR1HPC) -
Per Jessen