Looking for expert help

Hi *,

I can't really help you (I'm "just" a developer, not a Libreoffice user), but
maybe someone on this list can ...

I would rather discourage usage of DDE though, but that's just my personal
opinion

You can EXPORT PDF directly from CALC. Then you have no need to copy/paste, just attach the pdf.

I am going to do something I really hate doing.

Have you seen RETScreen...

*RETScreen 4* is an Excel-based clean energy project analysis software tool that helps decision makers quickly and inexpensively determine the technical and financial viability of potential renewable energy, energy efficiency and cogeneration projects.

*RETScreen Plus* is a Windows-based energy management software tool that allows project owners to easily verify the ongoing energy performance of their facilities.

http://www.nrcan.gc.ca/energy/software-tools/7465

The Excel/Windows part bugs the heck out of me and I have not used it, but the people behind it are pretty serious.

It would be wonderful if there was a way to do this in LibreOffice Calc instead.

Hope it helps.

Also see https://sam.nrel.gov/