I want to be able to import small .jpgs to use as status flags in certain
cells. I think I know how to get a picture to display and size itself to
fit in a cell, but what I'm concerned about is the overhead of repeating the
same few pictures hundreds or thousands of times in a single sheet - both in
terms of sheet size and possible excel limitations.
HSSFWorksheet::addPicture takes a byte array of picture data, not a file
name or some pre-built record in the worksheet, so I assume it makes a copy
of the data in the line
blipRecord.setPictureData( pictureData );
So... does anybody think it's possible to point a picture to another
picture's data and so share it? Even if I were to do this, would POI just
write out the data multiple times with each picture record?
Is this whole 'status flag' cell thing just a bad idea in an XLS? I'm
trying to duplicate (as much as possible) reports I currently generate as
PDF's in XLS's, and the PDF version does this (sharing a single .jpg per
flag globally). This is the last feature I haven't yet copied (thanks, POI
folks - this library's been a huge help).
Oh, yeah. I'd like to be able to use pictures of checkboxes and
radiobuttons too (which my PDFs do). Or, does Excel somehow support native
checkboxes and/or radiobuttons in cells (don't see it anywhere)?
Thanks,
Rob
--
View this message in context:
http://www.nabble.com/multiple-copies-of-the-same-picture-in-a-sheet--tp20946143p20946143.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
