OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Drop any arbitrary file into Calc cell ???

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
SailorFred
General User
General User


Joined: 16 May 2011
Posts: 6

PostPosted: Thu Feb 16, 2012 1:44 pm    Post subject: Drop any arbitrary file into Calc cell ??? Reply with quote

I'd like to drop a PDF file into a calc cell. Clicking the cell would launch your pdf viewer.

Kind of like an Inserted Hyperlink, except the file is in the cell, and gets saved with your ods. The file doesn't exist outside of your ods.


Here's an application: You have 3 sales guys. Every month, each sales guy submits to you a PDF sales report for the month. For a given year, you'd have a single Spreadsheet with Joe/Fred/Steve in 3 column headings, and Jan/Feb/Mar/etc down the left side. And in the resulting 36 cells there'd be 36 PDF files, ready for clicking if you want to view one. And if you need to send the spreadsheet to Head Office, you send them one single big fat ods, which has all 36 pdfs embedded.


Any ideas?

Ideally it would be for ANY filetype, not just pdfs.
Back to top
View user's profile Send private message
mgroenescheij
Super User
Super User


Joined: 20 Apr 2011
Posts: 870
Location: Australia

PostPosted: Thu Feb 16, 2012 1:51 pm    Post subject: Reply with quote

Hi,

Calc is a calculator not a cabinet.
What you want can be achieved in a database.

Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
SailorFred
General User
General User


Joined: 16 May 2011
Posts: 6

PostPosted: Thu Feb 16, 2012 2:17 pm    Post subject: Reply with quote

mgroenescheij wrote:
Hi,
Calc is a calculator not a cabinet.


Calc is already a cabinet for picture/sound/video files (mp3, etc): Insert -> Movie and Sound. And these files, once inserted, get saved with the ods.
Back to top
View user's profile Send private message
SailorFred
General User
General User


Joined: 16 May 2011
Posts: 6

PostPosted: Thu Feb 16, 2012 2:26 pm    Post subject: Reply with quote

Oooh Oooh! Getting somewhere:

Insert -> Object -> OLE Object -> Create new / Further objects -> Create New / Adobe Acrobat Document -> Pick your pdf

And there sits your PDF in a cell. The PDF is too big and spills over the edges of your cell in a very ugly manner, but it's there. Double clicking launches adobe reader. Except on my PC, PDF's are associated with PDF-Xchange viewer, not adobe reader. So calc is unhelpfully doing something more than just passing the file to the O/S and saying "Launch this!"
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group